In the process of upgrading from 6.1 to 6.3.2+patches at long last.
Just bumped into an interesting
problem with sequences. With 6.1, you could use sequences with COPY
FROM. This no longer
seems to be true with 6.3.2+patches. INSERT and UPDATE still work fine
but when using COPY FROM
all sequence fields are either 0 or NULL.
Can live without but curious if it's a bug or feature? Maybe fixed in
6.4? Wasn't COPY FROM changed
at the time pg_shadow was added?
Here's the affected schema:
CREATE SEQUENCE history_seq;
CREATE TABLE history (
seqno INTEGER DEFAULT nextval('history_seq') NOT NULL
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 1998-07-14 21:31:36|
|Subject: "internal error" triggered by EXISTS()|
|Previous:||From: Tom Lane||Date: 1998-07-14 17:48:41|
|Subject: EXPLAIN doesn't explain operations on inheritance trees|