From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: Removing pg_migrator limitations |
Date: | 2009-12-18 21:57:08 |
Message-ID: | 20091218215708.GS4055@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2009-12-18 22:02:14 | Re: Removing pg_migrator limitations |
Previous Message | Bruce Momjian | 2009-12-18 21:45:23 | Re: Removing pg_migrator limitations |