Skip site navigation (1) Skip section navigation (2)

Re: pgAdmin III No Trigger Functions available

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 (view raw or flat)
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


In response to

pgadmin-support by date

Next:From: Rizzo, Nicolas LeonardoDate: 2003-09-02 13:27:27
Subject: Error Message: La variable de tipo Object o la variable de?==?iso-8859-1?Q? bloque With no está establecida
Previous:From: Donald FraserDate: 2003-09-02 10:41:48
Subject: Re: pgAdmin III No Trigger Functions available

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group