name truncation problem in 7.0.0

Поиск
Список
Период
Сортировка
От Ed Loehr
Тема name truncation problem in 7.0.0
Дата
Msg-id 3AFC242C.63A7D2CB@austin.rr.com
обсуждение исходный текст
Ответы Re: name truncation problem in 7.0.0  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Maybe someone can confirm what looks like a long-name-truncation bug in
7.0.0?  I haven't tested it on newer releases, nor have I dug into the
code.  The problem appears to be that a different truncation algorithm is
used for creating the truncated sequence name than the algorithm used
when doing the 'drop sequence', e.g.,

    'process_state_subscripti_id_seq'
    'process_state_subscription_id_s'

Here's my test case:

% createdb testdb
CREATE DATABASE

% psql -e -d testdb -f ~ed/pgbug
CREATE TABLE process_state_subscription (
    id                          SERIAL,
    process_id                  INTEGER,
    process_state_id            INTEGER,
    person_id                   INTEGER NOT NULL
);
psql:/home/ed/pgbug:8: NOTICE:  CREATE TABLE will create implicit
sequence 'process_state_subscripti_id_seq' for SERIAL column
'process_state_subscription.id'
psql:/home/ed/pgbug:8: NOTICE:  CREATE TABLE/UNIQUE will create implicit
index 'process_state_subscripti_id_key' for table
'process_state_subscription'
CREATE
DROP SEQUENCE process_state_subscription_id_seq;
psql:/home/ed/pgbug:10: NOTICE:  identifier
"process_state_subscription_id_seq" will be truncated to
"process_state_subscription_id_s"
psql:/home/ed/pgbug:10: ERROR:  Relation
'process_state_subscription_id_s' does not exist


Regards,
Ed Loehr

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Ian Lance Taylor
Дата:
Сообщение: Re: PL/Perl without shared libperl.a
Следующее
От: "Mitch Vincent"
Дата:
Сообщение: Re: Index on a function(field)