Re: [HACKERS] Strange error dropping foreign key

2007-10-22 Thread John Parnefjord
> 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

Re: [HACKERS] Strange error dropping foreign key

2007-10-20 Thread Magnus Hagander
> Ü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

Re: [HACKERS] Strange error dropping foreign key

2007-10-19 Thread Hannu Krosing
Ü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

Re: [HACKERS] Strange error dropping foreign key

2007-10-19 Thread 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 > > Context please? Yeah, I had that one coming, didn't it... That's what I g

Re: [HACKERS] Strange error dropping foreign key

2007-10-18 Thread Tom Lane
"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