| 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: | Whole Thread | Raw Message | 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 |