Re: pgadmin 3
От | Mike G |
---|---|
Тема | Re: pgadmin 3 |
Дата | |
Msg-id | 20040721050609.GA32649@localhost.localdomain обсуждение исходный текст |
Ответ на | pgadmin 3 ("raptor@tvskat.net" <raptor@tvskat.net>) |
Ответы |
Re: pgadmin 3
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: