public inbox for [email protected]
help / color / mirror / Atom feedFrom: Dave Page <[email protected]>
To: Murtuza Zabuawala <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Subject: Re: PATCH: To fix the issue in exclusion constraint (pgAdmin4)
Date: Mon, 9 Jan 2017 15:05:59 +0530
Message-ID: <CA+OCxozQytOyj7HBYsXAZunMie8Xh-B0-FCd-AOuC4MbTjOJCg@mail.gmail.com> (raw)
In-Reply-To: <CA+OCxoxRTEN2L=mF2m0zgKQYVdpFSQ=-ixO0j-3dwKA=SNvO9Q@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>
<CA+OCxoxRTEN2L=mF2m0zgKQYVdpFSQ=-ixO0j-3dwKA=SNvO9Q@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgadmin-hackers>
Patch applied (once Murtuza showed me how to recreate the problem).
Thanks!
On Mon, Jan 9, 2017 at 2:42 PM, Dave Page <[email protected]> wrote:
> Hi
>
> On Mon, Jan 9, 2017 at 10:46 AM, Murtuza Zabuawala
> <[email protected]> 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
--
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: PATCH: To fix the issue in exclusion constraint (pgAdmin4)
In-Reply-To: <CA+OCxozQytOyj7HBYsXAZunMie8Xh-B0-FCd-AOuC4MbTjOJCg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox