Re: [HACKERS] [Q] When should I use reg* types instead of oid in the system catalog?

From: Tom Lane It's probably mostly historical accident :-(. There have been suggestions before to convert more system catalog columns to regfoo types, but there's serious stumbling blocks in the way: Thank you so much for concise detailed explanation of the history and current situation. I

Re: [HACKERS] [Q] When should I use reg* types instead of oid in the system catalog?

"MauMau" writes: > Both pg_aggregate.aggfnoid and pg_trigger.tgfoid references > pg_proc.oid, but the data types of them are regproc and oid > respectively. Is there any criterion on when to which in the system > catalog? Is the regproc choice just for readability of the

[HACKERS] [Q] When should I use reg* types instead of oid in the system catalog?

Hello, Both pg_aggregate.aggfnoid and pg_trigger.tgfoid references pg_proc.oid, but the data types of them are regproc and oid respectively. Is there any criterion on when to which in the system catalog? Is the regproc choice just for readability of the catalog query output? Should