Horton

Re: should I worry?

Heikki Linnakangas <heikki@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki@enterprisedb.com>
To: ohp@pyrenet.fr
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Rick Gigger <rick@alpinenetworking.com>, pgsql-hackers@postgresql.org
Date: 2007-11-06T13:07:23Z
Lists: pgsql-hackers 
ohp@pyrenet.fr wrote:
> I'd love to find a  query against pg_triggers giving the table name for
> each RI_ConstraintTrigger_xxx.

SELECT t.tgname, c.relname, tgconstrname FROM pg_trigger t, pg_class c 
WHERE t.tgrelid = c.oid AND tgname like 'RI_ConstraintTrigger_%';

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com