Re: should I worry?

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: ohp(at)pyrenet(dot)fr
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Rick Gigger <rick(at)alpinenetworking(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: should I worry?
Date: 2007-11-06 13:07:23
Message-ID: 4730670B.7040804@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ohp(at)pyrenet(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-11-06 13:14:49 Re: Visibility map thoughts
Previous Message Mark Mielke 2007-11-06 13:01:16 Re: Visibility map thoughts