pgObject *pgTriggerFunctionFactory::CreateObjects(pgCollection *collection, ctlTree *browser, const wxString &restr)
{
wxString funcRestriction = wxT(
" WHERE proisagg = FALSE AND pronamespace = ") + NumToStr(collection->GetSchema()->GetOid())
+ wxT("::oid\n AND typname = 'trigger'\n")
+ wxT(" AND lanname != 'edbspl'\n");
// Get the Functions
return AppendFunctions(collection, collection->GetSchema(), browser, funcRestriction);
}
pgObject *edbPackageProcedureFactory::CreateObjects(pgCollection *collection, ctlTree *browser, const wxString &restriction)
{
wxString restr;
if (collection->GetDatabase()->GetConnection()->EdbMinimumVersion(8, 2))
restr = wxT(" WHERE format_type(prorettype, NULL) = 'void' AND pronamespace = ");
else
restr = wxT(" WHERE eltclass = 'P' AND packageoid = ");
restr += ((edbPackageObjCollection *)collection)->GetPackage()->GetOidStr();
restr += restriction;
return AppendFunctions(collection, ((edbPackageObjCollection *)collection)->GetPackage(), browser, restr);
}
pgObject *pgProcedureFactory::CreateObjects(pgCollection *collection, ctlTree *browser, const wxString &restr)
{
wxString funcRestriction = wxT(
" WHERE proisagg = FALSE AND pronamespace = ") + NumToStr(collection->GetSchema()->GetOid())
+ wxT("::oid AND lanname = 'edbspl'\n");
if (collection->GetConnection()->EdbMinimumVersion(8, 1))
funcRestriction += wxT(" AND protype = '1'\n");
else
funcRestriction += wxT(" AND typname = 'void'\n");
// Get the Functions
return AppendFunctions(collection, collection->GetSchema(), browser, funcRestriction);
}
