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

Reply via email to