| From: | "Stewart Fritts" <stewart(dot)fritts(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #6084: When Updating Tables with Select Into |
| Date: | 2011-06-29 14:19:37 |
| Message-ID: | 201106291419.p5TEJbEZ034136@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 6084
Logged by: Stewart Fritts
Email address: stewart(dot)fritts(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Olivier LEVESQUE | 2011-06-29 15:00:40 | BUG #6085: pg_upgrade fails when unix_socket_directory != /tmp |
| Previous Message | Steve Haslam | 2011-06-29 13:38:25 | BUG #6083: psql script line numbers incorrectly count \copy data |