Re: [BUGS] PostgreSQL No Longer Handles Mixed Case Sequences

2002-11-19 Thread Brian Harris
. Regards, Brian Tom Lane wrote: Brian Harris <[EMAIL PROTECTED]> writes: id | integer | not null default nextval('T_Joint_id_seq'::text) This default is wrong --- it should be nextval('"T_Joint_id_seq"'::text) Note the quotes. regards, tom lane

[BUGS] PostgreSQL No Longer Handles Mixed Case Sequences

2002-11-15 Thread Brian Harris
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 |