projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (from parent 1:
5f2d53a
)
remove comment
author
ivan
<ivan>
Fri, 12 Mar 2004 05:49:18 +0000
(
05:49
+0000)
committer
ivan
<ivan>
Fri, 12 Mar 2004 05:49:18 +0000
(
05:49
+0000)
httemplate/docs/upgrade10.html
patch
|
blob
|
history
diff --git
a/httemplate/docs/upgrade10.html
b/httemplate/docs/upgrade10.html
index
44f1195
..
7a16d49
100644
(file)
--- 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);
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;
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;