ALTER TABLE ADD COLUMN column SERIAL -- unexpected results

From: "Rod Taylor" <rbt(at)barchord(dot)com>
To: "Hackers List" <pgsql-hackers(at)postgresql(dot)org>
Subject: ALTER TABLE ADD COLUMN column SERIAL -- unexpected results
Date: 2001-07-16 16:48:11
Message-ID: 004601c10e17$1a5be030$2205010a@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Running:

ALTER TABLE table ADD COLUMN column SERIAL;

Defines a column as int4 but does not create the sequence or attempt
to set the default value.

Not a big deal, but I was surprised when the column values were null.

--
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.

Attachment Content-Type Size
Taylor, Rod B.vcf text/x-vcard 445 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Víctor Romero 2001-07-16 18:10:43 Re: [HACKERS] Translators wanted
Previous Message Huong Chia Hiang 2001-07-16 16:38:03 PostgreSQL : First impressions