> 2) The constraint doesn't exist on the master, only the slave, so I don't
> beleive EXECUTE SCRIPT will work, no?
No, it does not work. I've tried.
// John
_
John Parnefjord
Samordnare UBIT Utveckling / Coordinator UBIT Development
> Ühel kenal päeval, R, 2007-10-19 kell 15:29, kirjutas Magnus Hagander:
> > On Thu, Oct 18, 2007 at 10:48:02AM -0400, Tom Lane wrote:
> > > "Magnus Hagander" <[EMAIL PROTECTED]> writes:
> > > > db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
> > > > ERROR: "items_pkey" is
Ühel kenal päeval, R, 2007-10-19 kell 15:29, kirjutas Magnus Hagander:
> On Thu, Oct 18, 2007 at 10:48:02AM -0400, Tom Lane wrote:
> > "Magnus Hagander" <[EMAIL PROTECTED]> writes:
> > > db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
> > > ERROR: "items_pkey" is an index
On Thu, Oct 18, 2007 at 10:48:02AM -0400, Tom Lane wrote:
> "Magnus Hagander" <[EMAIL PROTECTED]> writes:
> > db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
> > ERROR: "items_pkey" is an index
>
> Context please?
Yeah, I had that one coming, didn't it... That's what I g
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
> db=# alter table isi.items_stat drop constraint items_stat_item_id_fkey;
> ERROR: "items_pkey" is an index
Context please?
regards, tom lane
---(end of broadcast)---
TIP 4: Ha