The upgrade script psql-1.3.12.sql contains:
ALTER TABLE plugin_wiki_page
ALTER COLUMN id TYPE SERIAL / PRIMARY KEY /,
that generates the error:
ERROR: type "serial" does not exist
Should be replaced by:
CREATE SEQUENCE plugin_wiki_page_id_seq
INCREMENT 1 MINVALUE 1 MAXVALUE 2147483648 START 1 CACHE 1;
SELECT setval('plugin_wiki_page_id_seq',max(id)) FROM plugin_wiki_page;
ALTER TABLE plugin_wiki_page ALTER COLUMN id
SET DEFAULT nextval('plugin_wiki_page_id_seq'::regclass);
ALTER TABLE plugin_wiki_page ADD PRIMARY KEY (id);
Any comment ?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This has nothing to do with the version of postgresql (I have 8.3). The syntax is ok in a CREATE TABLE syntax, but not in a ALTER TABLE one. Serial is not a real data type. This fix is only for the upgrade script.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The upgrade script psql-1.3.12.sql contains:
ALTER TABLE plugin_wiki_page
ALTER COLUMN id TYPE SERIAL / PRIMARY KEY /,
that generates the error:
ERROR: type "serial" does not exist
Should be replaced by:
CREATE SEQUENCE plugin_wiki_page_id_seq
INCREMENT 1 MINVALUE 1 MAXVALUE 2147483648 START 1 CACHE 1;
SELECT setval('plugin_wiki_page_id_seq',max(id)) FROM plugin_wiki_page;
ALTER TABLE plugin_wiki_page ALTER COLUMN id
SET DEFAULT nextval('plugin_wiki_page_id_seq'::regclass);
ALTER TABLE plugin_wiki_page ADD PRIMARY KEY (id);
Any comment ?
This has nothing to do with the version of postgresql (I have 8.3). The syntax is ok in a CREATE TABLE syntax, but not in a ALTER TABLE one. Serial is not a real data type. This fix is only for the upgrade script.
Thanks.
It's probably better to use this backwards compatible SQL
But I recommend to use newer postgresql versions, like 8.2 or 8.3, esp. for fulltext search.