Bug in Sequences [6.4.2]

From: wehner(at)digital-security(dot)com (Stefan Wehner)
To: pgsql-general(at)postgresql(dot)org
Subject: Bug in Sequences [6.4.2]
Date: 1999-03-11 12:39:05
Message-ID: 19990311123905.EFE6315183@miraculix.shw.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,
there seems to be a slight bug in the parsing of the
nextval function, tested under 6.4.2.
It affects also the SERIAL type.

Symptom :

CREATE SEQUENCE "AA";
-- Correct, quoted identifier is allowed;
SELECT NEXTVAL('AA');
--Produces Error
--aa.nextval: sequence does not exist

Probable source of problem, the Argument to nextval is
not handled correctly as an Table Identifier.

E.g. nextval('"AA"') is generates
"aa".nextval: sequence does not exist

Note the lowercase between the quotes.

I quickly browsed the sources, but have not found the
place where the conversion to lowercase occurs.

Please check this against 6.5 and 6.4.3 too.

With Regards,
Stefan Wehner

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Wehner 1999-03-11 13:22:12 Bug with sequences in 6.4.2
Previous Message David O'Farrell 1999-03-11 12:30:38 threads and libpq