From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: ladayaroslav@yandex.ru
Subject: BUG #15835: Errors altering data type of the column used in partial exclusion constraint
Date: Wed, 05 Jun 2019 18:18:42 +0000
Message-ID: <15835-32d9b7a76c06a7a9@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 15835
Logged by: Yaroslav Schekin
Email address: ladayaroslav@yandex.ru
PostgreSQL version: 11.3
Operating system: Any
Description:
Executing the below code:
CREATE TABLE t(some_id int);
ALTER TABLE t ADD EXCLUDE USING btree(some_id WITH =) WHERE (some_id IS NOT
NULL);
ALTER TABLE t ALTER COLUMN some_id TYPE bigint;
Produces the following errors (per PostgreSQL version):
9.4.19, 9.5.15, 9.6.13: ERROR: could not open relation with OID 195837
10.8: ERROR: cache lookup failed for relation 630589
11.3, 12beta1: ERROR: relation "t_some_id_excl" already exists
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: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, ladayaroslav@yandex.ru
Subject: Re: BUG #15835: Errors altering data type of the column used in partial exclusion constraint
In-Reply-To: <15835-32d9b7a76c06a7a9@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox