Hello,
try alter table modems add column id serial set default
Set default tells postgres to automatically fill in the column data using a sequence on your behalf.
OID could be used for primary key I suppose. To use as a foreign key you would manually have to somehow copy the value
intable A and insert into B. AFAIK system generated OIDS are unique to each table.
HTH
mike
> 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 ?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster