Re: [GENERAL] sequences and currval()

2008-06-02 Thread Martijn van Oosterhout
On Mon, Jun 02, 2008 at 11:55:14AM -0400, Michael P. Soulier wrote: > Hello, > > I'm migrating a db schema in an automated fashion, using this > > UPDATE clients_client > SET icp_id = null > WHERE icp_id = 1; > UPDATE icps_icp > SET id = nextval('public.icps_icp_id_seq') > WHERE i

[GENERAL] sequences and currval()

2008-06-02 Thread Michael P. Soulier
Hello, I'm migrating a db schema in an automated fashion, using this UPDATE clients_client SET icp_id = null WHERE icp_id = 1; UPDATE icps_icp SET id = nextval('public.icps_icp_id_seq') WHERE id = 1; UPDATE clients_client SET icp_id = currval('public.icps_icp_id_seq') WHE