From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | Donald Fraser <demolish(at)cwgsy(dot)net> |
Cc: | "[pgADMIN]" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pgAdmin III No Trigger Functions available |
Date: | 2003-09-02 11:56:31 |
Message-ID: | 3F54856F.3030801@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Donald Fraser wrote:
>----- Original Message -----
>Subject: Re: [pgadmin-support] pgAdmin III No Trigger Functions available
>
>
>
>
>>Donald Fraser wrote:
>>
>>
>>
>>>
>>>
>>>>the builtin functions (RI_FKey_check_ins etc) if you enable system objects?
>>>>
>>>>
>>>>
>>>>
>>>Yes - when I enable system objects I get all of the trigger functions
>>>available - system ones (RI_FKey_..) and my own.
>>>When it is not enalbed I get nothing.
>>>
>>>
>>>
>>>
>>>
>>>>SELECT proname FROM pg_proc WHERE prorettype=2279 is used to fill the
>>>>combobox. 2279 should be the oid of the "trigger" type. Check if this is
>>>>true for your procs.
>>>>
>>>>
>>>>
>>>>
>>>Executing the above query produces the exact list that appears in the combox
>>>box when I have system obejects enabled.
>>>
>>>
>>>
>>>
>>So your obviously functions are recognized as system trigger functions.
>>
>>SELECT c.oid, c.relname , nspname
>> FROM pg_class c
>> JOIN pg_namespace n ON n.oid=c.relnamespace
>> WHERE relkind='r'
>> AND (n.oid = 2200 OR n.oid >= 17137)
>> AND n.nspname NOT LIKE 'pg\_temp\_%'
>> ORDER BY relnamespace, c.relname
>>
>>is the query to retrieve non-system trigger functions. 2200 is public's
>>oid, and 17137 is the last system oid on my system, might be different
>>for yours. Please check which restriction doesn't fit.
>>
>>
>
>I adjusted it for the last system oid (16974) on my system and ran it.
>The result set was simply all of the table objects in my database. No trigger
>functions or any other kind of object.
>
>
>
Umpf, was the wrong entry.
Anyway, I found the problem, the public namespace wasn't included for
the combobox.
I commited an update to dlgTrigger.cpp.
Regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Rizzo, Nicolas Leonardo | 2003-09-02 13:27:27 | Error Message: La variable de tipo Object o la variable de bloque With no está establecida |
Previous Message | Donald Fraser | 2003-09-02 10:41:48 | Re: pgAdmin III No Trigger Functions available |