Re: ERROR: null value in column "id" violates not-null constraint
| От | Dmitriy Igrishin |
|---|---|
| Тема | Re: ERROR: null value in column "id" violates not-null constraint |
| Дата | |
| Msg-id | b4399d110910110132q58e7f211v9ba204cb47239d3c@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: ERROR: null value in column "id" violates not-null constraint (Robert Paulsen <robert@paulsenonline.net>) |
| Ответы |
Re: ERROR: null value in column "id" violates not-null constraint
|
| Список | pgsql-sql |
Hello.
Note, that you may use SERIAL data type and PostgreSQL will implicitly create sequence for you column, for example,
CREATE table test (
id SERIAL NOT NULL PRIMARY KEY, -- PostgreSQL will implicitly create 'test_id_seq'
dat text
);
Regards,
Dmitiy Igrishin
Note, that you may use SERIAL data type and PostgreSQL will implicitly create sequence for you column, for example,
CREATE table test (
id SERIAL NOT NULL PRIMARY KEY, -- PostgreSQL will implicitly create 'test_id_seq'
dat text
);
Regards,
Dmitiy Igrishin
2009/10/11 Robert Paulsen <robert@paulsenonline.net>
On Saturday 10 October 2009 4:12 pm, Tom Lane wrote:Thanks!
> Robert Paulsen <robert@paulsenonline.net> writes:
> > I do have a question, though, I fixed things as indicated above:
> > id integer DEFAULT nextval('vault_id_seq') NOT NULL,
> > Dump gave back
> > id integer DEFAULT nextval('vault_id_seq'::text) NOT NULL,
> > That "text" seems odd. Should I change it?
>
> That's all there is in 8.0 ...
>
> regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
В списке pgsql-sql по дате отправления: