Re: foreign key creation problem

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: adam fisher <adam(at)redeye(dot)net(dot)au>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: foreign key creation problem
Date: 2001-12-13 23:18:13
Message-ID: 20011213151638.L4867-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message colm ennis 2001-12-13 23:58:32 Re: slow queries on large syslog table
Previous Message Dominic J. Eidson 2001-12-13 23:17:55 Re: How to increase shared mem for PostgreSQL on FreeBSD