Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] [Q] When should I use reg* types instead of oid in the system catalog? - Mailing list pgsql-hackers

From MauMau
Subject [HACKERS] [Q] When should I use reg* types instead of oid in the system catalog?
Date
Msg-id 7D4ECED3312448189CC80694BDB11D8D@tunaPC
Whole thread Raw
Responses Re: [HACKERS] [Q] When should I use reg* types instead of oid in the system catalog?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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 pg_trigger.tgfoid also have been changed to
regproc?

Regards
MauMau

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] proposal psql \gdesc
Next
From: Pavel Stehule
Date:
Subject: Re: [HACKERS] proposal psql \gdesc