From: Shoaib Mir <shoaibmir@gmail.com>
To: Kashmira Patel (kupatel) <kupatel@cisco.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Unable to drop table, error mentions "reltriggers"
Date: Thu, 28 Dec 2006 01:09:35 +0500
Message-ID: <bf54be870612271209v4e408e52y6b072b5b353664b@mail.gmail.com> (raw)
In-Reply-To: <18AE59788A3FC640A367E5652E664D800361DCF7@xmb-sjc-237.amer.cisco.com>
References: <18AE59788A3FC640A367E5652E664D800361DCF7@xmb-sjc-237.amer.cisco.com>
Run the following:
update pg_class set reltriggers = count(*) from pg_trigger where
pg_class.oid=tgrelid and relname='vm_message';
It should solve the problem....
------------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/28/06, Kashmira Patel (kupatel) <kupatel@cisco.com> wrote:
>
> Hello,
> I have two tables as follows:
>
> create table vm_message
> (
> MessageId varchar(128) not null,
> MessageType integer not null default 1,
> UseCount integer not null default 1,
> Sender varchar(256) not null,
> Urgent boolean not null default false,
> Private boolean not null default false,
> MessageLength integer ,
> MessageSize integer ,
> MessageTime bigint ,
> AttachedMsgId varchar(128) ,
> MessageOid OID ,
> UTCTime varchar(32) ,
> EndTime bigint not null default
> 9223372036854775807,
> ReceiveTime bigint not null default 0,
> NdrReason integer ,
> StartTime bigint default 0,
> MWIOn boolean not null default false,
> TotalMessageLength integer not null default 0,
> uid serial not null UNIQUE,
> CallerPhoneNumber varchar(15) not null default '',
> foreign key (AttachedMsgId) references vm_message on delete cascade on
> update cascade,
> primary key (MessageId)
> );
> create table vm_future_msg_job
> (
> MessageId varchar(128) not null,
> Recipients varchar(1024) not null,
> StartTime bigint not null,
> JobType int default 0,
> foreign key (MessageId) references vm_message on delete cascade on
> update cascade,
> primary key (MessageId,Recipients)
> );
>
> When I try to drop either one of these tables, I get the following error:
> ERROR: relation "vm_message" has reltriggers = 0
> and the table does not get dropped.
>
> What does this error mean???
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: shoaibmir@gmail.com, kupatel@cisco.com
Subject: Re: Unable to drop table, error mentions "reltriggers"
In-Reply-To: <bf54be870612271209v4e408e52y6b072b5b353664b@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox