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