Re: SET CONSTRAINTS not schema-aware

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: SET CONSTRAINTS not schema-aware
Дата
Msg-id 200306042149.h54LnsB15903@candle.pha.pa.us
обсуждение исходный текст
Ответ на SET CONSTRAINTS not schema-aware  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut wrote:
> Bruce Momjian writes:
> 
> > Peter, I assume SET CONSTRAINTS can't control a domain's constraints ---
> > it isn't actually a data object in the transaction.  Am I right?
> 
> No.  SET CONSTRAINTS on a domain constraint should affect all constraints
> on columns that use the domain.

Oh, wow.  That is interesting.  Does it effect only the current
transaction?  Current manual page text is:
      SET CONSTRAINTS sets the behavior of constraint evaluation      in the current transaction. In IMMEDIATE mode,
constraints     ...
 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: default locale considered harmful? (was Re: [GENERAL]
Следующее
От: Carlos Guzman Alvarez
Дата:
Сообщение: Re: Problem trying to implement version 3.0 of the PostgreSQL