MIME-Version: 1.0
In-Reply-To: 
 <CAKKotZRYUBMT10WTeZ_F7nB0QsUiBXK654YVn+=u178t5a9uKw@mail.gmail.com>
References: 
 <CAKKotZQ63rD_KTCXRhXJrOk2PHUbBEdzg3wi9_YPffZS+a+BZg@mail.gmail.com>
 <CA+OCxow1ge+nvaMA6RB6XoJb2RL-Txnm5AMmsSb4Y8bYMRYa_Q@mail.gmail.com>
 <CAKKotZQA_UPEB+Nu2Y7JsZgP-sxXPhQVenxTw9UTJ3Yx+MCNmA@mail.gmail.com>
 <CA+OCxow1q0F89j2FUavSmbBsV19FOnAQsxsQr17fDmYFJz10BQ@mail.gmail.com>
 <CAKKotZRYUBMT10WTeZ_F7nB0QsUiBXK654YVn+=u178t5a9uKw@mail.gmail.com>
From: Dave Page <dpage@pgadmin.org>
Date: Mon, 9 Jan 2017 14:42:27 +0530
Message-ID: 
 <CA+OCxoxRTEN2L=mF2m0zgKQYVdpFSQ=-ixO0j-3dwKA=SNvO9Q@mail.gmail.com>
Subject: Re: PATCH: To fix the issue in exclusion constraint (pgAdmin4)
To: Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>
Cc: pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: text/plain; charset=UTF-8
Precedence: bulk
Sender: pgadmin-hackers-owner@postgresql.org

Hi

On Mon, Jan 9, 2017 at 10:46 AM, Murtuza Zabuawala
<murtuza.zabuawala@enterprisedb.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


-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers