Bug in Sequences [6.4.2]

Поиск
Список
Период
Сортировка
От Stefan Wehner
Тема Bug in Sequences [6.4.2]
Дата
Msg-id 36E6B655.936D2D4B@digital-security.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Maerten Gaetan
Дата:
Сообщение: ...
Следующее
От: "Wim Ceulemans"
Дата:
Сообщение: Is it possible to change a columns name