pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Sabino Mullane <greg@turnstep.com>
To: pgsql-admin@postgresql.org
Cc: Stefan.Hortschitz@lfrz.at
Subject: Re: failed insert into serial-type row
Date: Sat, 18 Jun 2005 14:05:32 -0000
Message-ID: <e5a11b1c3eaf4ea91b2636e6764690e9@biglumber.com> (raw)
In-Reply-To: <D12153701D57FF45A1AD64DFB6571D7C79DCCD@svie0107.vie01.local>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> and sometimes if i'm adding new rows to the table with statements like
> this:
>  insert into (name,value) ('xy','xy');

Show us the actual SQL, not something "like" it. The above is not valid.

> CREATE SEQUENCE session.preferences_id_seq
>  START 2487

You haven't shown us how this sequence is attached to the table. Presumably
with:

ALTER TABLE preferences ALTER id SET DEFAULT nextval('preferences_id_seq');

That START qualifier is a red flag. If the sequence was not created when the table
was, one explanation is that there are existing values in the table that are higher
than the current sequence. Running
SELECT max(id) FROM preferences
and
SELECT * FROM preferences_id_seq;
should show that. The other possibility is that someone is inserting into the table
and specifying a value for the id field manually.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200506180957
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFCtCoLvJuQZxSWSsgRAkiVAKDG6eVWdCdqzbnQnqIOHyoZ/ijzOACfcgh+
9P9fUQbyJUXebzHvOf4F3Z8=
=QKrK
-----END PGP SIGNATURE-----






view thread (5+ messages)  latest in thread

Message-ID: <e5a11b1c3eaf4ea91b2636e6764690e9@biglumber.com>
Permalink:  ../e5a11b1c3eaf4ea91b2636e6764690e9@biglumber.com/
Also on:    postgresql.org/message-id/e5a11b1c3eaf4ea91b2636e6764690e9@biglumber.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: greg@turnstep.com, Stefan.Hortschitz@lfrz.at
  Subject: Re: failed insert into serial-type row
  In-Reply-To: <e5a11b1c3eaf4ea91b2636e6764690e9@biglumber.com>
  References: <D12153701D57FF45A1AD64DFB6571D7C79DCCD@svie0107.vie01.local> <e5a11b1c3eaf4ea91b2636e6764690e9@biglumber.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox