From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: PATCH: To fix the issue in exclusion constraint (pgAdmin4) |
Date: | 2017-01-09 09:35:59 |
Message-ID: | CA+OCxozQytOyj7HBYsXAZunMie8Xh-B0-FCd-AOuC4MbTjOJCg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Patch applied (once Murtuza showed me how to recreate the problem).
Thanks!
On Mon, Jan 9, 2017 at 2:42 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> Hi
>
> On Mon, Jan 9, 2017 at 10:46 AM, Murtuza Zabuawala
> <murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>> Hi Dave,
>>
>> I followed,
>>
>> 1) First click on main properties panel.
>>
>> 2) Sample definition,
>>
>> CREATE TABLE public.test_table
>> (
>> id character varying(3) COLLATE pg_catalog."default" NOT NULL,
>> col1 bigint,
>> CONSTRAINT test_pkey PRIMARY KEY (id)
>> )
>> WITH (
>> OIDS = FALSE
>> )
>> TABLESPACE pg_default;
>>
>> With above created table, create exclusion constraint with following options
>> using GUI,
>>
>> ALTER TABLE public.test_table
>> ADD CONSTRAINT test_exclu EXCLUDE USING btree (
>> col1 DESC NULLS LAST WITH =);
>>
>> Click on Save, Exclusion constraint will be created successfully but you
>> will get error as wrong OID was sent while generating node info.
>
> Nope - it works fine for me. I wonder what's different...
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Surinder Kumar | 2017-01-09 10:12:53 | Re: [pgAdmin4][Patch]: RM1938 - Backgrid sorting not working for Integer/Number types |
Previous Message | Dave Page | 2017-01-09 09:35:29 | pgAdmin 4 commit: Use the correct OID for retrieving properties of fres |