Re: Oversight?

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Rod Taylor" <rbt(at)rbt(dot)ca>, "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 01:16:20
Message-ID: 191001c3606f$578c6180$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > rbt=3D# ALTER USER rbt SET CONSTRAINTS ALL DEFERRED;
> > ERROR: syntax error at or near "ALL" at character 32
> > rbt=3D# ALTER USER rbt SET CONSTRAINTS =3D 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.

I assume his point is "how do we set all of a user's constraints deferred by
default"?

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-08-12 01:26:42 Re: Change Request: \pset pager off in pg_dumpall
Previous Message Christopher Kings-Lynne 2003-08-12 01:09:52 Re: dropping a user causes pain (#2)