Re: almost there on a design
От | Dennis Gearon |
---|---|
Тема | Re: almost there on a design |
Дата | |
Msg-id | A8642A703Z82UP5YQPDPJ64C7ZUMK.3e63ed33@cal-lab обсуждение исходный текст |
Ответ на | Re: almost there on a design (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: almost there on a design
|
Список | pgsql-general |
Is it possible to do 'cross constraints' between two tables using a transaction and: SET�CONSTRAINTS�ALL�DEFERRED; Or making both tables INITIALLY DEFERRED? 3/3/2003 12:54:17 PM, Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote: > >On Mon, 3 Mar 2003, Dennis Gearon wrote: > >> 3/3/2003 10:25:12 AM, Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote: >> >> If I create the necessary fields first in this order, no deferrment seems necessary: >> >> I'm thinking about trying to create a user which only has access to selects and stored >> procedures, so the web interface can ONLY use functions which take place in a transaction and >> take care of it that way. >> >> create an email, >> create a usr >> create a usr email. > >That'll work from a function (currently), but from straight commands, >if you make it such that there must be a usremailaddrs row to make a usr, >then the second will fail. If you try to make the usremailaddrs row >first, it fails due to the foreign key. > >
В списке pgsql-general по дате отправления: