| 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.
| 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 |