Re: RHDB just sits and does nothing?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Mauri Sahlberg <Mauri(dot)Sahlberg(at)claymountain(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: RHDB just sits and does nothing?
Date: 2004-06-09 14:46:09
Message-ID: 20040609074425.C85049@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Wed, 9 Jun 2004, Mauri Sahlberg wrote:

> rahaks=# begin foo
> rahaks-# ;
> ERROR: parser: parse error at or near "foo" at character 7
> rahaks=# begin;
> BEGIN
> rahaks=# set constraints all deferred;
> SET CONSTRAINTS

In addition to the other messages, the above only defers deferrable
constraints. If you didn't specify initially deferred or deferrable when
creating the fk constraint, the above will not affect it.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-06-09 14:48:09 Re: PostgreSQL 7.4.2 on SunOS 4.1.4
Previous Message Honza Pazdziora 2004-06-09 14:43:38 Re: [HACKERS] Refined LC_COLLATE or multiple database clusters?