Re: pgAdmin 1.14 bug

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Julius Tuskenis <julius(at)nsoft(dot)lt>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: pgAdmin 1.14 bug
Date: 2011-12-09 08:41:50
Message-ID: 1323420110.2289.11.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message bdmytrak@eranet.pl 2011-12-09 09:57:21 TRUNCATE privilages visibility in pgAdmin
Previous Message Vjacheslav A. 2011-12-09 08:37:16 Re: pgAdmin 1.14 bug