Re: Oversight?

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Oversight?
Date: 2003-08-12 00:38:31
Message-ID: 1060648711.82433.1.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 2003-08-11 at 19:16, Tom Lane wrote:
> Rod Taylor <rbt(at)rbt(dot)ca> writes:
> > rbt=# ALTER USER rbt SET CONSTRAINTS ALL DEFERRED;
> > ERROR: syntax error at or near "ALL" at character 32
> > rbt=# ALTER USER rbt SET CONSTRAINTS = DEFERRED;
> > ERROR: "constraints" is not a recognized option
>
> "SET CONSTRAINTS ALL DEFERRED" is a SQL-spec-mandated command syntax.
> Any similarity to Postgres' "SET var = value" syntax ends with the
> initial keyword.

Yes, but we don't support 'SET constraints = deferred' either.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Sherry 2003-08-12 01:05:34 pgstats_initstats() cost
Previous Message Tom Lane 2003-08-12 00:36:11 Re: Change Request: \pset pager off in pg_dumpall