| From: | Christoph Berg <myon(at)debian(dot)org> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pgsql: Remove WITH OIDS support, change oid catalog column visibility. |
| Date: | 2018-11-21 08:20:43 |
| Message-ID: | 20181121082042.GA15795@msg.df7cb.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
Re: Andres Freund 2018-11-21 <E1gPG3j-0003cy-03(at)gemulon(dot)postgresql(dot)org>
> The biggest user of WITH OID columns was postgres' catalog. This
> commit changes all 'magic' oid columns to be columns that are normally
> declared and stored.
postgres=# \d+ pg_class
[...]
Indexe:
"pg_class_oid_index" UNIQUE, btree (oid)
Now that oid is a proper column, shouldn't that be a PRIMARY KEY?
(Just for the looks.)
Christoph
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Flower | 2018-11-21 08:25:32 | Re: pgsql: Remove WITH OIDS support, change oid catalog column visibility. |
| Previous Message | Andres Freund | 2018-11-21 05:03:46 | pgsql: Blind attempt at fixing sepgsql output for 578b22. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Flower | 2018-11-21 08:25:32 | Re: pgsql: Remove WITH OIDS support, change oid catalog column visibility. |
| Previous Message | Adrien Nayrat | 2018-11-21 08:09:36 | Re: ALTER INDEX ... ALTER COLUMN not present in dump |