On 2011.12.08 12:37, Dave Page wrote:
> Hi
>
> On Thu, Dec 8, 2011 at 3:37 PM, Vjacheslav Vjacheslav
> <eferalgan@gmail.com> wrote:
>> Hello,
>>
>> pgAdmin version: Version 1.14.0 (Sep 12 2011, rev: REL-1_14_0)
>> OS: Windows XP Pro RUS SP3
>> PostgreSQL: 9.1.1. (compiled without any options)
>>
>> bug description:
>> create a table (creation SQL below), then right click on it, and select
>> 'Properties', then write some comment and click Ok, and you receive an error
>> (see in attachment). Bug is beacasue of long contraint 'ck_pos_documents_1'.
>>
>> Table creation SQL:
> It works fine for me. Can anyone else reproduce the issue?
>
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.
--
Julius Tuskenis
Head of the programming department
UAB nSoft
mob. +37068233050