Postgres Pro
Downloads
Home   >   mailing lists

Re: foreign key creation problem - Mailing list pgsql-general

From Stephan Szabo
Subject Re: foreign key creation problem
Date
Msg-id 20011213151638.L4867-100000@megazone23.bigpanda.com
Whole thread Raw
In response to foreign key creation problem  ("Adam Fisher" <black@cia.com.au>)
List pgsql-general
Tree view 
On Fri, 14 Dec 2001, adam fisher wrote:

> Hi Again,
> Scratch that. I was running two seperate proceedures on one of the tables,
> so the alter table command was blocked. Once I ran it properly, it only took
> about 5 minutes. Sorry about that...

No problem.  The implementation of doing the check is not the best (see
recent conversation in hackers if you're interested) and can be a bit
slow.

pgsql-general by date:

Previous
From: "Dominic J. Eidson"
Date:
Subject: Re: How to increase shared mem for PostgreSQL on FreeBSD
Next
From: Philip Hallstrom
Date:
Subject: Re: storing intermediate results from recursive plpgsql