The following bug has been logged online:
Bug reference: 6084
Logged by: Stewart Fritts
Email address: stewart.fritts@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.
