This is a multi-part message in MIME format.
--------------000901040808050900000405
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit

Hi.

I was trying to upgrade PostgreSQL from 7.2.8 to 8.1.2.
Dump and restore work well. But adddepend was failed.

To fix it, this regexp
$seq =~ s|^nextval\(["']+([^'"\)]+)["']+.*\)$|$1|g;
need to change
$seq =~ s|^nextval\(\(["']+([^'"\)]+)["']+.*\)$|$1|g;
or
$seq =~ s|^nextval\(\(?["']+([^'"\)]+)["']+.*\)$|$1|g;


----
[ishida@localhost adddepend]$ ./adddepend -Y -d ishida


Upgrade the Unique Constraint style via:

DROP INDEX t_i_key RESTRICT;
ALTER TABLE t ADD CONSTRAINT t_i_key UNIQUE (i);

NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "t_i_key"
for table "t"
Do you wish to upgrade Sequence 'nextval(('"t_i_seq"'::text)::regclass)'
to SERIAL?
Found on column t.i
DBD::Pg::st execute failed: ERROR: syntax error at or near ""t_i_seq""
at character 790 at ./adddepend line 539.
----


---- logfile
ERROR: syntax error at or near ""t_i_seq"" at character 790
STATEMENT:
INSERT INTO pg_catalog.pg_depend
( classid
, objid
, objsubid
, refclassid
, refobjid
, refobjsubid
, deptype
) VALUES ( (SELECT c.oid -- classid
FROM pg_class as c
JOIN pg_namespace as n
ON (n.oid = c.relnamespace)
WHERE n.nspname = 'pg_catalog'
AND c.relname = 'pg_class')

, (SELECT c.oid -- objid
FROM pg_class as c
JOIN pg_namespace as n
ON (n.oid = c.relnamespace)
WHERE n.nspname = 'public'
AND c.relname =
'nextval(('"t_i_seq"'::text)::regclass)')

, 0 -- objsubid

, (SELECT c.oid -- refclassid
FROM pg_class as c
JOIN pg_namespace as n
ON (n.oid = c.relnamespace)
WHERE n.nspname = 'pg_catalog'
AND c.relname = 'pg_class')

, (SELECT c.oid -- refobjid
FROM pg_class as c
JOIN pg_namespace as n
ON (n.oid = c.relnamespace)
WHERE n.nspname = 'public'
AND c.relname = 't')

, (SELECT a.attnum -- refobjsubid
FROM pg_class as c
JOIN pg_namespace as n
ON (n.oid = c.relnamespace)
JOIN pg_attribute as a
ON (a.attrelid = c.oid)
WHERE n.nspname = 'public'
AND c.relname = 't'
AND a.attname = 'i')

, 'i' -- deptype
);


--
ISHIDA Akio <iakio (AT) mono-space (DOT) net / ishida (AT) cycleof5th (DOT) com>

--------------000901040808050900000405
Content-Type: text/plain;
name="adddepend.patch"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename="adddepend.patch"

KioqIC4vY29udHJpYi9hZGRkZXBlbmQvYWRkZGVwZW5kLm9yaW cJMjAwMy0x
MS0zMCAwNzozOToxNi4wMDAwMDAwMDAgKzA5MDAKLS0tIC4vY2 9udHJpYi9h
ZGRkZXBlbmQvYWRkZGVwZW5kCTIwMDYtMDEtMTggMDA6NDY6Mz IuMDAwMDAw
MDAwICswOTAwCioqKioqKioqKioqKioqKgoqKiogNDY5LDQ3NS AqKioqCiAg
CQlteSAkc2VxID0gJHJvdy0+eydhZHNyYyd9OwogIAogIAkJIy BFeHRyYWN0
IHRoZSBzZXF1ZW5jZSBuYW1lIGZyb20gdGhlIGRlZmF1bHQKIS AJCSRzZXEg
PX4gc3xebmV4dHZhbFwoWyInXSsoW14nIlwpXSspWyInXSsuKl wpJHwkMXxn
OwogIAogIAkJIyBEb2VzIHRoZSB1c2VyIHdhbnQgdG8gdXBncm FkZSB0aGlz
IHNlcXVlbmNlPwogIAkJcHJpbnQgPDxNU0cKLS0tIDQ2OSw0Nz UgLS0tLQog
IAkJbXkgJHNlcSA9ICRyb3ctPnsnYWRzcmMnfTsKICAKICAJCS MgRXh0cmFj
dCB0aGUgc2VxdWVuY2UgbmFtZSBmcm9tIHRoZSBkZWZhdWx0Ci EgCQkkc2Vx
ID1+IHN8Xm5leHR2YWxcKFwoWyInXSsoW14nIlwpXSspWyInXS suKlwpJHwk
MXxnOwogIAogIAkJIyBEb2VzIHRoZSB1c2VyIHdhbnQgdG8gdX BncmFkZSB0
aGlzIHNlcXVlbmNlPwogIAkJcHJpbnQgPDxNU0cK

--------------000901040808050900000405
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

--------------000901040808050900000405--