On Fri, 2011-12-09 at 09:42 +0200, Julius Tuskenis wrote:
> 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....
We don't set length of strings, so I don't see why a truncate would
happen. It could be a platform issue. I'll try on Windows (I checked on
Linux, and I suppose Dave checked on Mac OS X, but you both are using
Windows).
--
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com