X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CE0EFD1B199 for ; Wed, 9 Jun 2004 11:46:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44763-05 for ; Wed, 9 Jun 2004 14:46:10 +0000 (GMT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 29627D1B18A for ; Wed, 9 Jun 2004 11:46:05 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id AC1363586E; Wed, 9 Jun 2004 07:46:09 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id AA96234E8F; Wed, 9 Jun 2004 07:46:09 -0700 (PDT) Date: Wed, 9 Jun 2004 07:46:09 -0700 (PDT) From: Stephan Szabo To: Mauri Sahlberg Cc: pgsql-admin@postgresql.org Subject: Re: RHDB just sits and does nothing? In-Reply-To: <64169.195.197.242.66.1086764790.squirrel@www.claymountain.com> Message-ID: <20040609074425.C85049@megazone.bigpanda.com> References: <64169.195.197.242.66.1086764790.squirrel@www.claymountain.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/113 X-Sequence-Number: 13773 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.