Re: should I worry?
От | ohp@pyrenet.fr |
---|---|
Тема | Re: should I worry? |
Дата | |
Msg-id | Pine.UW2.4.53.0711061544100.29245@sun.pyrenet обсуждение исходный текст |
Ответ на | Re: should I worry? (Heikki Linnakangas <heikki@enterprisedb.com>) |
Ответы |
Re: should I worry?
|
Список | pgsql-hackers |
On Tue, 6 Nov 2007, Heikki Linnakangas wrote: > Date: Tue, 06 Nov 2007 13:07:23 +0000 > 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 > Subject: Re: [HACKERS] should I worry? > > 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_%'; > > Thanks! GREAT! IIUC, I have drop every trigger like this : SELECT t.tgname, c.relname, tgconstrname FROM pg_trigger t, pg_class c WHERE t.tgrelid = c.oid AND tgname like 'RI_ConstraintTrigger_%'AND tgconstrname = '<unnamed>'; and I delete all those ancient foreign key WITHOUT disturbing any others Is that right? Regards -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 15, Chemin des Monges +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)
В списке pgsql-hackers по дате отправления: