Re: RHDB just sits and does nothing? - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: RHDB just sits and does nothing?
Date
Msg-id 20040609074425.C85049@megazone.bigpanda.com
Whole thread Raw
In response to RHDB just sits and does nothing?  ("Mauri Sahlberg" <Mauri.Sahlberg@claymountain.com>)
List 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.

pgsql-admin by date:

Previous
From: Honza Pazdziora
Date:
Subject: Re: [HACKERS] Refined LC_COLLATE or multiple database clusters?
Next
From: "Milosz Miecznik"
Date:
Subject: PostgreSQL Performance