Re: pgsql: docs: fist draft version of the PG 12 release notes

On Wed, May 8, 2019 at 04:20:40PM -0400, Alvaro Herrera wrote:
> On 2019-May-06, Bruce Momjian wrote:
>
> > docs: fist draft version of the PG 12 release notes
>
> Hello, thanks for doing this work once again.
>
> Typo in surname: "Golgov" is Dolgov.

Yes, it was "Golgov" in one commint and "Dolgov" in another; I change
it to "Dolgov".

> This entry:
> Allow foreign keys to reference partitioned tables (Alvaro Herrera)
> says "LIMITATIONS?" but I don't think there are any of significance.
> You can now reference unique/PKs that appear in partitioned tables,
> period. Just remove the LIMITATIONS should do it ;-)

Done.

> This is a bit misleading:
>
> Remove the special behavior of OID columns (Andres Freund, John Naylor)
>
> Previously, a normally-invisible OID column could be specified
> during table creation using WITH OIDS; that ability has been
> removed. Columns can still be explicitly specified as type OID.
> pg_dump and pg_upgrade operations on databases using WITH OIDS will
> need adjustment. Many system tables now have an 'oid' column that
> will be expanded with SELECT * by default.
>
> "databases using WITH OIDS will need adjustment". In reality, many
> databases carried over by pg_upgrade from old versions will need
> adjustment, since old tables had oids by default. This could be more
> troublesome than the current wording suggest. Maybe use something like
> "... operations on databases containing tables with the oid system
> column will need adjustment", so that users have to research whether
> they have them or not. If we only say WITH OIDS then people will think
> they've never used that clause so they must not worry.

Yes, I reworded it:

http://momjian.us/pgsql_docs/release-12.html
>
> Specify a range of oids (9000-9999) to be used for external
> extensions (Andres Freund)
>
> I'm not sure that "specify" is the right verb to use for this one.
> Nothing better comes to mind ATM ...

I used "Reserve".

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +