From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [RFC] Removing "magic" oids |
Date: | 2018-11-20 09:52:27 |
Message-ID: | 20181120095227.tgc5edxjqegobtkg@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
On 2018-11-14 17:48:07 -0800, Andres Freund wrote:
> While clearly not ready yet, I don't think it's that far off.
>
> Missing:
> - docs polish
> - pg_upgrade early error
> - discussion of the pg_dump/restore behaviour when encountering tables
> or archives with oids. It currently warns. If we want to keep it that
> way - which I think is reasonable - a bit more code can be excised.
Attached is an updated version. It fixes all the FIXMEs/XXXs that were
left over. Most of these weren't particularly interesting, except for
the fact that GetSysCacheOid[1-4]? now has a new AttrNumber parameter
indicating the oid attribute.
I also:
- re-added printing of oids via pageinspect. As we can encounter tuples
with oids via pg_upgrade (even though the oid column must have been
removed), that seems appropriate
- merged John Naylor's genbki/reformat fixes
- performed docs polishing
- made the objectaddress.c changes more consistent
- corrected lots of formatting issues (too long lines)
- added necessary casts (mostly using ObjectIdGetDatum for oids)
- re-added AT_DropOids, so we can have a proper WITHOUT OIDS ALTER TABLE
option to ignore. I also considered supporting empty elements in the
AlterTableStmt->cmds, but that seemed uglier.
- removed #ifdefed out code
- improved error messages
- other small stuff
- re-added a few tests
- lots of small comment fixes
I'm pretty happy with the new state. Unless somebody announces they want
to do a review soon-ish, I'm planning to commit this soon. It's a
painful set to keep up2date, and it's blocking a few other patches. I'm
sure we'll find some things to adapt around the margins, but imo the
patch as a whole looks pretty reasonable.
Missing:
- nice and long commit message
- another detailed line-by-line read of the patch (last round took like
3h :()
341 files changed, 2263 insertions(+), 4249 deletions(-)
Greetings,
Andres Freund
Attachment | Content-Type | Size |
---|---|---|
v4-0001-Remove-WITH-OIDs-support.patch | text/x-diff | 699.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | 066ce286 | 2018-11-20 10:09:31 | mysql_fdw crash |
Previous Message | John Naylor | 2018-11-20 09:39:17 | Re: Sync ECPG scanner with core |