The following bug has been logged online: Bug reference: 6084 Logged by: Stewart Fritts Email address: stewart.fri...@gmail.com PostgreSQL version: 8.4 Operating system: Windows Server 2003 Description: When Updating Tables with Select Into Details:
First, I love your database. I have been using it for a few years now and it rarely lets me down while regularly surprising me with how powerful it truly is. I recently migrated some data from one set of tables to another within a single schema. I did this by using a select...into query. Everything moved perfectly. However; I noticed that the sequence for the receiving table did not increment with the newly added data. It was an easy enough fix, I just changed the current value of the sequence causing the issue. But I thought it was worth mentioning that this happened. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs