pgadmin 3

From: "raptor(at)tvskat(dot)net" <raptor(at)tvskat(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: pgadmin 3
Date: 2004-07-20 13:20:25
Message-ID: 20040720162025.2801b600@bugs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In pgadmin3 I'm tring to add auto_inc column like this

ALTER TABLE public.modems ADD COLUMN id serial;

But get this error :

NOTICE: ALTER TABLE will create implicit sequence "modems_id_seq" for "serial" column "modems.id"

ERROR: adding columns with defaults is not implemented
HINT: Add the column, then use ALTER TABLE SET DEFAULT.

How to add auto_inc fields... thanx

PS. Can I use OID column for primary/foreign functionality, or it
has some restriction ...i mean i may not use auto_inc field ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lars Erik Thorsplass 2004-07-20 13:34:20 Stored procedures and "pseudo" fields..
Previous Message Tom Lane 2004-07-20 13:17:16 Re: DIfferent ORDER BY behaviour in 7.4.2