Skip site navigation (1) Skip section navigation (2)

Re: Error when dropping table

From: "Chris White (cjwhite)" <cjwhite(at)cisco(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Error when dropping table
Date: 2004-06-23 21:00:43
Message-ID: 029b01c45965$261de980$0200a8c0@amer.cisco.com (view raw or flat)
Thread:
Lists: pgsql-admin
ERROR:  XX000: relation "vm_message" has rel_triggers = 0
LOCATION:  RemoveTriggerById, commands/trigger.c:581


-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Wednesday, June 23, 2004 1:32 PM
To: cjwhite(at)cisco(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Error when dropping table 


"Chris White (cjwhite)" <cjwhite(at)cisco(dot)com> writes:
> On 7.4.2, I am trying to drop a table using the command
> drop table vm_message cascade;
> and I get the error message
> relation "vm_message" has rel_triggers = 0

I can't find any such error message in the 7.4 sources.  Could we see
the exact error display with "\set VERBOSITY verbose"?

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)


In response to

pgsql-admin by date

Next:From: Chris White (cjwhite)Date: 2004-06-23 21:01:01
Subject: Re: Error when dropping table
Previous:From: Tom LaneDate: 2004-06-23 20:38:17
Subject: Re: Error when dropping table

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