ALTER TABLE can NOT use set (OIDS=true)

From: 自己 <zoulx1982(at)163(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: ALTER TABLE can NOT use set (OIDS=true)
Date: 2016-05-19 06:47:38
Message-ID: cbbab09.6f14.154c7c5069d.Coremail.zoulx1982@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,
I create a table, and then i want to add oid column, but only can use "set with oids", not use "set (oids = true)"
while create table support both. Is this a problem?

Here is is my testcase, thank you.
postgres=# create table x(a int) with(oids = false);
CREATE TABLE
postgres=# alter table x set(fillfactor = 90);
ALTER TABLE
postgres=# alter table x set (oids = true);
ERROR: unrecognized parameter "oids"
postgres=#
postgres=# alter table x set with oids;
ALTER TABLE
postgres=#

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message turon.david 2016-05-19 09:06:09 BUG #14149: when use LATERAL functions with IMMUTABLE called multiple times
Previous Message Ziyun Audrey Wang 2016-05-18 18:37:39 Re: BUG #14148: postgres does not support GST timezone