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 08:50:53
Message-ID: 3F5459ED.3090906@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
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.

Regards,
Andreas



In response to

Responses

pgadmin-support by date

Next:From: Donald FraserDate: 2003-09-02 10:41:48
Subject: Re: pgAdmin III No Trigger Functions available
Previous:From: Raphaƫl EnriciDate: 2003-09-01 22:34:42
Subject: Re: src/generic/grid.cpp(531): assert "m_control"

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