On Tue, Nov 25, 2008 at 05:39:49PM +0930, Michael Hall wrote:
> On Tue, Nov 25, 2008 at 08:26:55AM +0100, A. Kretschmer wrote:
> > Set the sequence to the new value, 3636+9, via
> > setval('your_sequence', 3636+9)
>
> I'll re-import the data with DEFAULT in the id (SERIAL) column,
> hopefully new
> The 3636 INSERT-Statements contains a fix value for the ID-Column,
> right? Thats wrong, omit the id-column and value or use simply 'default' for
> it.
That's right. I thought that might be the case.
> > - how can I rectify the situation?
> Set the sequence to the new value, 3636+9, via
> s
am Tue, dem 25.11.2008, um 16:41:43 +0930 mailte Mike Hall folgendes:
> I have just imported 3636 rows into a PG database table (PG 8.1 on CentOS 5.2
> ... the default).
> The rows were imported using separate INSERT statements for each row. All OK
> so far.
>
> After having had a few attempts
I have just imported 3636 rows into a PG database table (PG 8.1 on CentOS 5.2
... the default).
The rows were imported using separate INSERT statements for each row. All OK so
far.
After having had a few attempts at inserting new test rows (which all inserted
OK), I notice that the last_value c
