Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Bricolage: devel
aggregate id_list
 

Index | Next | Previous | View Flat


lannings at who

Mar 3, 2009, 8:31 AM


Views: 2324
Permalink
aggregate id_list

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.

Subject User Time
aggregate id_list lannings at who Mar 3, 2009, 8:31 AM
    Re: aggregate id_list lannings at who Mar 3, 2009, 8:43 AM
    Re: aggregate id_list david at kineticode Mar 3, 2009, 11:09 AM
    Re: aggregate id_list lannings at who Mar 4, 2009, 1:08 AM
        Re: aggregate id_list david at kineticode Mar 4, 2009, 9:02 AM
    Re: aggregate id_list lannings at who Mar 5, 2009, 1:50 AM
        Re: aggregate id_list david at kineticode Mar 5, 2009, 5:12 PM

  Index | Next | Previous | View Flat
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.