Bruce Momjian wrote: > Alvaro Herrera wrote: > > Bruce Momjian wrote: > > > Alvaro Herrera wrote:
> > > > To be more precise, the pg_enum.oid needs to be set for ENUM types; > > > > there's no need for setting the pg_type.oid (for ENUM types). I don't > > > > know about composites but I think the problem with user defined arrays > > > > is the OID of the element type, not the array itself. > > > > > > Yes, good point. I can see where the oids are assigned in our C code: > > > > > > oids[i] = GetNewOid(pg_enum); > > > > > > array_oid = GetNewOid(pg_type); > > > > > > I need a way of controlling that. > > > > You're (partly?) missing my point which is that the important OID to > > control is the one that actually gets stored on table files. > > Well, I thought the idea was to set the system table oid to match the > oids already in the user tables. I realize that is not all system oids. > What am I missing exactly? I think the OIDs for user-defined arrays stored in table data are element types, not the array type which is what you're pointing at with the line you quote: > > > array_oid = GetNewOid(pg_type); IMBFOS. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
