-
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.
2009-01-21 14:21:19 UTC in PhpWiki
-
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...
2009-01-16 18:08:31 UTC in PhpWiki
-
music_dev committed patchset 906 of module eo to the Evolving Objects CVS repository, changing 1 files.
2002-12-14 02:51:53 UTC in Evolving Objects
-
music_dev committed patchset 438 of module apcstudio to the aPcStudio CVS repository, changing 1 files.
2002-12-14 02:07:23 UTC in aPcStudio
-
music_dev committed patchset 437 of module apcstudio to the aPcStudio CVS repository, changing 7 files.
2002-12-14 01:56:38 UTC in aPcStudio
-
music_dev committed patchset 436 of module apcstudio to the aPcStudio CVS repository, changing 1 files.
2002-12-14 01:53:59 UTC in aPcStudio
-
music_dev committed patchset 435 of module apcstudio to the aPcStudio CVS repository, changing 1 files.
2002-12-14 01:51:18 UTC in aPcStudio
-
music_dev committed patchset 434 of module apcstudio to the aPcStudio CVS repository, changing 1 files.
2002-12-14 01:44:43 UTC in aPcStudio
-
music_dev committed patchset 433 of module apcstudio to the aPcStudio CVS repository, changing 1 files.
2002-12-14 01:44:15 UTC in aPcStudio
-
music_dev committed patchset 893 of module eo to the Evolving Objects CVS repository, changing 5 files.
2002-10-14 16:15:58 UTC in Evolving Objects
