diff options
| -rw-r--r-- | httemplate/docs/upgrade10.html | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index 44f11953f..7a16d49a1 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -106,7 +106,7 @@ CREATE INDEX part_pkg1 ON part_pkg(disabled); On modern Pg: ALTER TABLE part_pkg DROP CONSTRAINT part_pkg_temp_pkey; ALTER TABLE part_pkg ADD PRIMARY KEY (pkgpart); -select setval('public.part_pkg_temp_pkgpart_seq', ( select max(pkgpart) from part_pkg) ); #? +select setval('public.part_pkg_temp_pkgpart_seq', ( select max(pkgpart) from part_pkg) ); Or on Pg versions that don't support DROP CONSTRAINT and ADD PRIMARY KEY (tested on 7.1 so far): DROP INDEX part_pkg_temp_pkey; |