Re: [SQL] NOTICE: generated by sequence nextval()

2002-10-11 Thread Thrasher
ect anything. MikeA - -Original Message- From: John Duffy [mailto:jbduffy@;ntlworld.com] Sent: 10 October 2002 16:18 To: [EMAIL PROTECTED] Subject: [SQL] NOTICE: generated by sequence nextval() Postgresql 7.1.3-2 Red Hat 7.2 I've noticed that if I create a sequence, and then do a s

Re: [SQL] NOTICE: generated by sequence nextval()

2002-10-11 Thread Michael Ansley (UK)
Title: RE: [SQL] NOTICE: generated by sequence nextval() -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I would hope that this is normal, and I can see it being particularly useful.  We frequently run into problems where databases ahve been reloaded, and the sequences have not been reset

[SQL] NOTICE: generated by sequence nextval()

2002-10-10 Thread John Duffy
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.