lannings at who
Mar 3, 2009, 8:31 AM
Views: 1880
Permalink
|
I'm running
perl inst/upgrade/1.11.0/change_aggregate_name_Pg.pl
and it gives an error:
######################################################################
ERROR: DATABASE UPDATE FAILED!
The database was not affected. Please address this issue before continuing.
The error encountered was:
DBD::Pg::st execute failed: ERROR: aggregate id_list(integer) does not exist
[for Statement "DROP AGGREGATE id_list (INTEGER)"] at
/usr/lib/perl5/site_perl/5.8.0/Bric/Util/DBI.pm line 1030.
Unable to execute SQL statement: DBD::Pg::st execute failed: ERROR: aggregate
id_list(integer) does not exist [for Statement "DROP AGGREGATE id_list
(INTEGER)"] at /usr/lib/perl5/site_perl/5.8.0/Bric/Util/DBI.pm line 1030.
[/usr/lib/perl5/site_perl/5.8.0/Bric/Util/DBI.pm:1031]
[/services/webit/trunk-r8432/inst/upgrade/1.11.0/../lib/bric_upgrade.pm:320]
[inst/upgrade/1.11.0/change_aggregate_name_Pg.pl:11]
In fact, this is NUMERIC, not INTEGER:
# \da id_list
List of aggregate functions
Schema | Name | Argument data types | Description
--------+---------+---------------------+-------------
public | id_list | numeric |
It seems to've been set that way in 1.7.3/id_list_aggregate.pl :
q{CREATE AGGREGATE id_list (
SFUNC = append_id,
BASETYPE = NUMERIC(10, 0),
STYPE = TEXT,
INITCOND = ''
)},
No comprendo.
|
aggregate id_list
