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 по дате отправления: