Re: Loading sql/upgrade/3538-asset-menu-fix.sql -- error

[Chris Travers <..hidden..>]

On Tue, Jul 19, 2011 at 12:06 PM, Erik Huelsmann <..hidden..> wrote:
> Hi Chris,
> I'm updating my company to the latest trunk version; however, I'm having
> this issue:
> techinc=# \i ./sql/upgrade/3538-asset-menu-fix.sql
> UPDATE 1
> psql:./sql/upgrade/3538-asset-menu-fix.sql:6: ERROR:  duplicate key value
> violates unique constraint "menu_node_pkey"
> CONTEXT:  SQL statement "INSERT INTO menu_node (parent, position, label)
> VALUES ( $1 ,  $2 ,  $3 )"
> PL/pgSQL function "menu_insert" line 9 at SQL statement
>
Checking the database, it looks like the menu_node_id may be out of sync.

Try

select setval('menu_node_id_seq', max(id)) from menu_node;
select setval('menu_attribute_id_seq', max(id)) from menu_attribute;

If this is the case, it suggests a problem with some of the
Pg-database files.  I will get a patch in place right away.

Best Wishes,
Chris Travers