pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: John Duffy <jbduffy@ntlworld.com>
To: pgsql-sql@postgresql.org
Subject: NOTICE: generated by sequence nextval()
Date: Thu, 10 Oct 2002 16:17:40 +0100
Message-ID: <001101c27070$3060bf10$9d88fc3e@desktop> (raw)

Postgresql 7.1.3-2
Red Hat 7.2

I've noticed that if I create a sequence, and then do a select on it using nextval() everything works fine. However, if I drop the sequence and then create it again, the same select statement generates a NOTICE.

Is this normal behaviour or a bug? See below.

test=> create sequence serial;
CREATE
test=> select nextval('serial');
 nextval
---------
       1
(1 row)

test=> drop sequence serial;
DROP
test=> create sequence serial;
CREATE
test=> select nextval('serial');
NOTICE:  serial.nextval: sequence was re-created
 nextval
---------
       1
(1 row) 

view thread (3+ messages)  latest in thread

Message-ID: <001101c27070$3060bf10$9d88fc3e@desktop>
Permalink:  ../001101c27070$3060bf10$9d88fc3e@desktop/
Also on:    postgresql.org/message-id/001101c27070$3060bf10$9d88fc3e@desktop

copy link · copy postgr.es

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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jbduffy@ntlworld.com
  Subject: Re: NOTICE: generated by sequence nextval()
  In-Reply-To: <001101c27070$3060bf10$9d88fc3e@desktop>

* 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