pg newbie stumped on sequences!

Поиск
Список
Период
Сортировка
От Ben Joyce
Тема pg newbie stumped on sequences!
Дата
Msg-id DF1220D4F915D4119C6B00306E00103E02CD90C6@ids10004.idesk.plc
обсуждение исходный текст
Ответы Re: pg newbie stumped on sequences!  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: pg newbie stumped on sequences!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi. I'm from a MSSQL/mySQL background and am just poking about in PG.
I'm using phpPgAdmin 2.3 and PostgreSQL 7.1.3.

I'm a bit stumped why I'm getting an error when trying to create new
records.

I tried the following:

CREATE TABLE "test" (
"ID" SERIAL,
"Subject" varchar (255) ,
"Body" varchar (2000) ,
"DTS" timestamp NOT NULL,
"Archive" int2 NOT NULL );

and then:

INSERT INTO "test" ("ID", "Subject", "Body", "DTS", "Archive") VALUES
(NEXTVAL('""test_ID_seq""'::text), 'test', 'this is a test', '2003-05-20
16:30:42', '0')

and i got:

PostgreSQL said: ERROR: pg_aclcheck: class ""test_ID_seq"" not found
Your query:
INSERT INTO "test" ("ID", "Subject", "Body", "DTS", "Archive") VALUES
(NEXTVAL('""test_ID_seq""'::text), 'test', 'this is a test', '2003-05-20
16:30:42', '0')

This leads me to believe i have a sequence missing, but:

 test_ID_seq   1   1   2147483647   1   1   1   f  f

it's there!

It's been suggested that ('""test_ID_seq""'::text) might be the issue,
irregular quoting?  Odd, as this is what phpPgAdmin spewed out.

any ideas?

 .b(affled)

--
ben joyce


В списке pgsql-general по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: INSERT/UPDATE/DELETE Views
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: pg newbie stumped on sequences!