pg_type defaults

From: "Rod Taylor" <rbt(at)zort(dot)ca>
To: "Hackers List" <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_type defaults
Date: 2002-02-20 15:07:11
Message-ID: 059601c1ba20$8d826f60$8001a8c0@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

According to the system table documentation
http://developer.postgresql.org/docs/postgres/catalog-pg-type.html the
typdefault information is to be copied from the pg_type value to the
table value when the default specified is NULL or a default is not
specified.

The below shows that it's not to be true.

junk=# update pg_type set typdefault = 3 where typname = 'int2';
UPDATE 1
junk=# create table example (col1 int2);
CREATE
junk=# \d example
Table "example"
Column | Type | Modifiers
--------+----------+-----------
col1 | smallint |

--
Rod Taylor

Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. You cannot imagine why you ever felt
otherwise.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-02-20 15:13:00 Re: [ODBC] UTF-8 data migration problem in Postgresql 7.2
Previous Message Tom Lane 2002-02-20 14:59:06 Re: Trouble with pg_dumpall import with 7.2