On 2011.12.08 23:50, Guillaume Lelarge wrote:
I can confirm the problem.
WinXP SP3, pgAdmin 1.14.0, PostgreSQL 8.3.4 on i686-pc-linux-gnu,
compiled by GCC gcc (Gentoo 4.3.2-r3 p1.6, pie-10.1.5) 4.3.2
What I noticed is the check constraint is beeing updated even if nothing
was done to it. I only added a comment ant thats the SQL that was generated:
ALTER TABLE pos_documents DROP CONSTRAINT ck_pos_documents_1;
ALTER TABLE pos_documents ADD CONSTRAINT ck_pos_documents_1 CHECK
entry_type::text = 'Z-report open'::text OR entry_type::text =
'Return'::text OR entry_type::text = 'Inkasso'::text OR entry_type::text
= 'Sale'::text OR entry_type::text = 'X-report'::text OR
entry_type::text = 'Cash Withdrawal'::text OR entry_type::text =
'Z-report closed'::text OR entry_type::text = 'Open drawer'::text OR
entry_type::text = 'Service'::text OR entry_type::text = 'Z-report
Z1'::text OR entry_type::text = 'Z-report Z2'::text OR entry_type::text
= 'Z-report Z3'::text OR entry_type::text = ';
COMMENT ON TABLE pos_documents
IS 'test';
You can see that the constraint text got truncated and left quotes open.
Works fine for me. Dave also. I guess we both use 1.14.1, and you both
use 1.14.0. Update to 1.14.1 might fix your issue.
Updated the pgAdmin to 1.14.1 yet the error is the same... Nothing has
changed concerning the issue - I still get the SQL I have sent before
when editing the comment. I think the problem.
I have checked and there is no problem with short check rules. You can
see, from the SQL I have sent that the constraint text is truncated to
512 char (when counting from "entry_type"). That could indicate a
problem in table properties dialog window....
Actually, that reminds me that we, once again, forgot to spread the
news... will do.
Thank You.
--
Julius Tuskenis
Head of the programming department
UAB nSoft
mob. +37068233050
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
