From: | Manuel Rigger <rigger(dot)manuel(at)gmail(dot)com> |
---|---|
To: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | ALTER TABLE results in "ERROR: could not open relation with OID 43707388" |
Date: | 2019-07-04 14:41:16 |
Message-ID: | CA+u7OA4hkFSV_Y=sW_vNcYgKFEoq0WL5GtrBWEHUZnCqSqjhAA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi everyone,
The test case below unexpectedly results in "ERROR: could not open
relation with OID 43707388" (or some other number).
CREATE TABLE t0(c0 INT);
CREATE UNIQUE INDEX i0 ON t0(c0);
ALTER TABLE t0 ADD PRIMARY KEY USING INDEX i0, ALTER c0 TYPE BIGINT;
-- unexpected: ERROR: could not open relation with OID 43707388
I would expect that the statements are equivalent to the following,
where the ALTER TABLE actions were split up, and which execute without
errors:
CREATE TABLE t0(c0 INT);
CREATE UNIQUE INDEX i0 ON t0(c0);
ALTER TABLE t0 ADD PRIMARY KEY USING INDEX i0;
ALTER TABLE t0 ALTER c0 TYPE BIGINT; -- no error
I'm using the following Postgres version: psql (11.4 (Ubuntu
11.4-1.pgdg19.04+1)).
Best,
Manuel
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2019-07-04 16:24:27 | Re: ALTER TABLE results in "ERROR: could not open relation with OID 43707388" |
Previous Message | PG Bug reporting form | 2019-07-04 14:00:01 | BUG #15894: postgresql 9.5 will not install |