Bug with sequences in 6.4.2
| От | wehner@digital-security.com (Stefan Wehner) |
|---|---|
| Тема | Bug with sequences in 6.4.2 |
| Дата | |
| Msg-id | 19990311132212.EDB3815186@miraculix.shw.com обсуждение исходный текст |
| Ответы |
Re: [GENERAL] Bug with sequences in 6.4.2
|
| Список | 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
В списке pgsql-general по дате отправления: