[ome-users] OMERO 4.1.1 to 4.2.0 upgrade error...

[Josh Moore]

Jerome,

What platform is this and what version of PostgreSQL? What's happening
is that the setting of the variable at the top of the upgrade script:

  http://trac.openmicroscopy.org.uk/omero/browser/branches/Beta4.2/sql/psql/OMERO4.2__0/OMERO4.1__0.sql#L18

is somehow losing its quotation marks on your platform and being
interpeted as: \set ACTION ABORT

It'd be good to fix this for others, but if you would like to move
forward you can change the use of ":ACTION" here:

  http://trac.openmicroscopy.org.uk/omero/browser/branches/Beta4.2/sql/psql/OMERO4.2__0/OMERO4.1__0.sql#L542

to say:

  select * from omero_41_check1(cast('ABORT' as text));

Cheers,
~Josh

On Mon, Jul 19, 2010 at 11:20 AM, Jerome Avondo <jeromeavondo at msn.com> wrote:
> This is the error I get on the command line:
>
> psql:OMERO4.1__0.sql:542: ERROR:  column "abort" does not exist at character
> 36
> psql:OMERO4.1__0.sql:542: LINE 1: select * from omero_41_check1(cast(ABORT
> as text));
> psql:OMERO4.1__0.sql:542:                                            ^
>
>
> Thanks,
>
> J.