Re: Unable To Modify Table
От
Steve Crawford
Тема
Re: Unable To Modify Table
Дата
Msg-id
4F0F101B.5050105@pinpointresearch.com
Ответ на
Unable To Modify Table (Carlos Mennens)
Список
Дерево обсуждения
Unable To Modify Table Carlos Mennens <carlos.mennens@gmail.com>
Re: Unable To Modify Table "David Johnston" <polobo@yahoo.com>
Re: Unable To Modify Table Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Unable To Modify Table Adrian Klaver <adrian.klaver@gmail.com>
Re: Unable To Modify Table "David Johnston" <polobo@yahoo.com>
Re: Unable To Modify Table Adrian Klaver <adrian.klaver@gmail.com>
Re: Unable To Modify Table Steve Crawford <scrawford@pinpointresearch.com>
On 01/12/2012 08:42 AM, Carlos Mennens wrote: > I seem to have an issue where I can't modify a table due to another > tables foreign key association: > > ... > > How does one accomplish my goal? Is this difficult to change or once > that foreign key is created, are you stuck with that particular > constraint? > Try updating the values in both tables within a transaction with constraints set to deferred: http://www.postgresql.org/docs/current/static/sql-set-constraints.html Cheers, Steve
В списке pgsql-sql по дате отправления
