Jaime Casanova wrote:
I knew that we create an entry in pg_type for every table we create,
what i didn't know is that we actually create 2 entries.
for example CREATE TABLE foo (i int); will create types foo and _foo.
so, any reason to create 2 entries?
I don't know offhand; maybe its the corresponding row/tuple type and
table/relation type?
anyway, what really kept my attention is that CREATE SEQUENCE also
create an entry in pg_type. there is any reason for that?
This I'm fairly sure, is due to a sequence generator being implemented as a
table/relation-typed variable, so it has a corresponding type like the regular
table/relation-typed variables in the database.
-- Darren Duncan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers