Re: Oversight?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Oversight?
Дата
Msg-id 191001c3606f$578c6180$2800a8c0@mars
обсуждение исходный текст
Ответ на Oversight?  (Rod Taylor <rbt@rbt.ca>)
Ответы Re: Oversight?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Oversight?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Oversight?  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Gavin Sherry
Дата:
Сообщение: pgstats_initstats() cost
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Change Request: \pset pager off in pg_dumpall