RE: finding and removing a constraint...
От | chris markiewicz |
---|---|
Тема | RE: finding and removing a constraint... |
Дата | |
Msg-id | 00c501c0b183$7b8a57b0$dbb846c6@cmarkiewicz обсуждение исходный текст |
Ответ на | finding and removing a constraint... ("chris markiewicz" <cmarkiew@commnav.com>) |
Ответы |
Re: RE: finding and removing a constraint...
Re: RE: finding and removing a constraint... |
Список | pgsql-general |
okay, i screwed up. i dropped some triggers from a table. now that table is not accessible to me. can't drop it...can't select...can't pg_dump. message is error: RelationBuildTriggers: 2 record(s) not found for rel accessor_group or a pg_dump results in: getTables(): relation 'accessor_group': 6 Triggers were expected, but got 4. is there any way that i can re-insert them? if i'm screwed, then how do i drop this table? i really appreciate your help. chris -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of chris markiewicz Sent: Tuesday, March 20, 2001 3:16 PM To: 'PostgreSQL-general' Subject: finding and removing a constraint... hello i am trying to remove a foreign key that i placed on a database. what is the easiest way to find/delete the constraint? thanks chris ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
В списке pgsql-general по дате отправления: