relation complex types

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: relation complex types
Date: 2012-06-02 05:49:25
Message-ID: CAJKUy5iVdjfTW5a7Lf_zbNSeaedfkEPFUujAmsDMR6bEF2nTeQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 also
create an entry in pg_type. there is any reason for that?

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2012-06-02 13:35:24 Re: No, pg_size_pretty(numeric) was not such a hot idea
Previous Message Kohei KaiGai 2012-06-02 04:58:36 Re: [RFC] Interface of Row Level Security