pg newbie stumped on sequences!

Поиск
Список
Период
Сортировка
Искать
От
Ben Joyce
Тема
pg newbie stumped on sequences!
Дата
в 18:30:37
Msg-id
DF1220D4F915D4119C6B00306E00103E02CD90C0@ids10004.idesk.plc
Список
Дерево обсуждения
pg newbie stumped on sequences! "Ben Joyce" <ben@babelfish.co.uk>
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 по дате отправления
От: google@itrex.de (Simon Heinrich)
Дата:
От: nelma
Дата:
Сообщение: cursor
FAQ