On Tue, Jul 19, 2011 at 9:51 PM, Chris Travers <[email protected]>wrote:
> On Tue, Jul 19, 2011 at 12:06 PM, Erik Huelsmann <[email protected]> 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.
>
>
Ok. That worked. The file loads now.
Bye,
Erik.
------------------------------------------------------------------------------
Magic Quadrant for Content-Aware Data Loss Prevention
Research study explores the data loss prevention market. Includes in-depth
analysis on the changes within the DLP market, and the criteria used to
evaluate the strengths and weaknesses of these DLP solutions.
http://www.accelacomm.com/jaw/sfnl/114/51385063/
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
