PostgreSQL No Longer Handles Mixed Case Sequences

Поиск
Список
Период
Сортировка
От Brian Harris
Тема PostgreSQL No Longer Handles Mixed Case Sequences
Дата
Msg-id 3DD24ABF.1010506@harris-piper.freeserve.co.uk
обсуждение исходный текст
Ответы Re: PostgreSQL No Longer Handles Mixed Case Sequences
Re: PostgreSQL No Longer Handles Mixed Case Sequences
Список pgsql-bugs
Hello,
I have just updated to PostgreSQL 7.2.2.  I am utilising tables with
mixed case table and field names.  I can now no longer insert data into
these tables as shown by the following psql interchange:

sharetrack=> \d "T_Joint"
                                  Table "T_Joint"

 Column  |         Type          |                    Modifiers
---------+-----------------------+--------------------------------------------------
 id      | integer               | not null default nextval('T_Joint_id_seq'::text)
 epic    | character(4)          |
 code    | character(1)          | not null
 number  | integer               | not null
 price   | double precision      | not null
 costs   | double precision      | not null
 condate | date                  | not null
 effdate | date                  | not null
 comment | character varying(40) |

Unique keys: T_Joint_id_key

Triggers: RI_ConstraintTrigger_17019

sharetrack=> \ds

         List of relations

      Name       |   Type   | Owner
-----------------+----------+-------
 T_Joint_id_seq  | sequence | brian
 T_Tester_id_seq | sequence | brian
 splits_id_seq   | sequence | brian
(3 rows)

sharetrack=> INSERT INTO "T_Tester" (epic,code,number,price,costs,condate,effdate,comment) VALUES
('37RL','B','1','36750','800','1984-12-01','1984-12-01','');

ERROR:  pg_aclcheck: class "t_tester_id_seq" not found

sharetrack=>

So although the sequence reference name is stored in mixed case in the
table, it gets converted to lower case when processing.

Please can you advise if there is a fix available or any circumvention
apart from redefining all affected tables.

Thanks,
Brian

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

Предыдущее
От: daniel alvarez
Дата:
Сообщение: createdb rejects both relative and absolute paths with -D
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: new journaling system in OSX