Skip site navigation (1) Skip section navigation (2)

SEQUENCES and COPY FROM

From: Mike Embry <membry(at)nserv(dot)sps(dot)mot(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SEQUENCES and COPY FROM
Date: 1998-07-14 20:37:31
Message-ID: 35ABC18A.E0F85AB0@nserv.sps.mot.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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 (
    gid                   INTEGER,
    state                 TEXT,
    dtin                  DATETIME,
    dtout                DATETIME,
    seqno               INTEGER DEFAULT nextval('history_seq') NOT NULL
);

MikE



Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 1998-07-14 21:31:36
Subject: "internal error" triggered by EXISTS()
Previous:From: Tom LaneDate: 1998-07-14 17:48:41
Subject: EXPLAIN doesn't explain operations on inheritance trees

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group