Re: relation ### modified while in use

I think this happens after I create/modify tables which reference this
table. This is spontaneous, and doesn't _always_ happen...

Anything I could do next time it craps up to help track the problem down?

-alex

----
CREATE TABLE "customers" (       "cust_id" int4 DEFAULT nextval('customers_cust_id_seq'::text) NOT 
NULL,       "phone_npa" character(3) NOT NULL,       "phone_nxx" character(3) NOT NULL,       "phone_rest" character(4)
NOTNULL,       "e_mail" character varying(30),       "daytime_npa" character(3),       "daytime_nxx" character(3),
"daytime_rest" character(4),       "is_business" bool DEFAULT 'f' NOT NULL,       PRIMARY KEY ("cust_id") );
 

CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "customers"  NOT
DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE
"RI_FKey_noaction_del" ('<unnamed>', 'cc_charges', 'customers',
'UNSPECIFIED', 'cust_id', 'cust_id');

CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "customers"  NOT
DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE
"RI_FKey_noaction_upd" ('<unnamed>', 'cc_charges', 'customers',
'UNSPECIFIED', 'cust_id', 'cust_id');


On Sun, 22 Oct 2000, Tom Lane wrote:

> Alex Pilosov <alex@pilosoft.com> writes:
> > I'm having the error 'relation <number> modified while in use' fairly
> > often. It is the same relation that's always giving a problem.
> 
> Hmm, could we see the full schema dump for that relation?
> (pg_dump -s -t tablename dbname will do)
> 
> If you are not actively modifying the schema, then in theory you should
> not see this message, but...
> 
>             regards, tom lane
> 
>