Re: how do you get there from here?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michael P(dot) Soulier" <michael_soulier(at)mitel(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how do you get there from here?
Date: 2009-04-27 15:27:54
Message-ID: 1696.1240846074@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Michael P. Soulier" <michael_soulier(at)mitel(dot)com> writes:
> This worked in 7.4 but fails now with
> cannot ALTER TABLE "instances" because it has pending trigger events

I think the problem is you're issuing all those commands in one
transaction. If you COMMIT the updates then the subsequent ALTERs
should go through.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Whit Armstrong 2009-04-27 15:34:43 find column OID types with information schema?
Previous Message Martijn van Oosterhout 2009-04-27 15:10:42 Re: Which header and lib files to use when compiling libpq-code?