[PATCH] Doc: improve documentation of oid columns that can be zero. (correct version)

Started by Joel Jacobsonabout 5 years ago6 messageshackers
Jump to latest
#1Joel Jacobson
joel@compiler.org

Please ignore previous email, the attached file was 0 bytes.
Here comes the patch again, now including data.

--

Doc: improve documentation of oid columns that can be zero.

pg_attribute.atttypid
Zero if column is dropped.

pg_class.relam
Can be zero, e.g. for views.

pg_depend.classid
Zero for pinned objects.

pg_language.lanplcallfoid
Zero for internal languages.

pg_operator.oprcode
Zero if none.

pg_operator.oprcom
Zero if none.

pg_operator.oprjoin
Zero if none.

pg_operator.oprnegate
Zero if none.

pg_operator.oprrest
Zero if none.

pg_operator.oprresult
Zero if none.

pg_policy.polroles
Array with a zero element if none.

pg_shdepend.classid
Zero for pinned objects (deptype='p'),
meaning there is no dependent object.

pg_shdepend.objid
Zero if none.

pg_trigger.tgconstrindid
Zero if none.

pg_trigger.tgconstrrelid
Zero if none.

Attachments:

document-all-zero-if-none-cases.patchapplication/octet-stream; name=document-all-zero-if-none-cases.patchDownload+18-16
#2Euler Taveira
euler@eulerto.com
In reply to: Joel Jacobson (#1)
Re: [PATCH] Doc: improve documentation of oid columns that can be zero. (correct version)

On Sun, Jan 31, 2021, at 10:27 AM, Joel Jacobson wrote:

Here comes the patch again, now including data.

Joel, register this patch into the next CF [1]https://commitfest.postgresql.org/32/ so we don't lose track of it.

[1]: https://commitfest.postgresql.org/32/

--
Euler Taveira
EDB https://www.enterprisedb.com/

#3Joel Jacobson
joel@compiler.org
In reply to: Euler Taveira (#2)
Re: [PATCH] Doc: improve documentation of oid columns that can be zero. (correct version)

Hi Euler,

I've tried to login to the CF interface a couple of times now, but seems to have lost my password.
I've tried to use the "Password reset" form [1]https://www.postgresql.org/account/reset/, but I don't get any email.
The email is correct, because when I try to re-register it says it's taken.

Not sure who I should ask for help. Anyone?

/Joel

[1]: https://www.postgresql.org/account/reset/

On Tue, Feb 2, 2021, at 03:10, Euler Taveira wrote:

On Sun, Jan 31, 2021, at 10:27 AM, Joel Jacobson wrote:

Here comes the patch again, now including data.

Joel, register this patch into the next CF [1] so we don't lose track of it.

[1] https://commitfest.postgresql.org/32/

--
Euler Taveira
EDB https://www.enterprisedb.com/

Kind regards,

Joel

#4Euler Taveira
euler@eulerto.com
In reply to: Joel Jacobson (#3)
Re: [PATCH] Doc: improve documentation of oid columns that can be zero. (correct version)

On Tue, Feb 2, 2021, at 5:13 AM, Joel Jacobson wrote:

I've tried to login to the CF interface a couple of times now, but seems to have lost my password.
I've tried to use the "Password reset" form [1], but I don't get any email.
The email is correct, because when I try to re-register it says it's taken.

Not sure who I should ask for help. Anyone?

You should probably email: webmaster (at) postgresql (dot) org

--
Euler Taveira
EDB https://www.enterprisedb.com/

#5Joel Jacobson
joel@compiler.org
In reply to: Euler Taveira (#4)
Re: [PATCH] Doc: improve documentation of oid columns that can be zero. (correct version)

On Tue, Feb 2, 2021, at 12:34, Euler Taveira wrote:

You should probably email: webmaster (at) postgresql (dot) org

Thanks, done.

/Joel

#6Tom Lane
tgl@sss.pgh.pa.us
In reply to: Joel Jacobson (#1)
Re: [PATCH] Doc: improve documentation of oid columns that can be zero. (correct version)

"Joel Jacobson" <joel@compiler.org> writes:

Doc: improve documentation of oid columns that can be zero.

Since this is pretty closely tied to the catalog-foreign-key work,
I went ahead and reviewed/pushed it. The zero notations now match
up with what we'd found in the other thread.

regards, tom lane