Re: [HACKERS] relation complex types

2012-06-02 Thread Tom Lane
Darren Duncan writes: > 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

Re: [HACKERS] relation complex types

2012-06-02 Thread Darren Duncan
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 corr

[HACKERS] relation complex types

2012-06-01 Thread Jaime Casanova
Hi, 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? anyway, what really kept my attention is that CREATE SEQUENCE