[drupal-devel] [bug] database.pgsql menu_mid_seq problems

[danielc]

Issue status update for http://drupal.org/node/19852

 Project:      Drupal
 Version:      cvs
 Component:    base system
 Category:     bug reports
 Priority:     critical
 Assigned to:  Anonymous
 Reported by:  danielc
 Updated by:   danielc
-Status:       patch
+Status:       by design

Now that I look closer at the situation, the "menu_mid_seq" sequence
gets automatically created because the "mid" column in the "menu" table
is defined as "serial."
Please disregard this patch.


danielc



Previous comments:
------------------------------------------------------------------------

April 1, 2005 - 20:50 : danielc

Attachment: http://drupal.org/files/issues/database.pgsql.menuseq.diff (364 bytes)

Revision 1.84 of database.pgsql added the following query
    ALTER SEQUENCE menu_mid_seq RESTART 2;
in response to issue 10349 (http://drupal.org/node/10349). 
Unfortunately, this causes an error due to the fact that the SQL script
hasn't created that sequence yet.
This patch adds a CREATE SEQUENCE query with the right info in it and
removes the bogus ALTER SEQUENCE query.


------------------------------------------------------------------------

April 1, 2005 - 20:53 : danielc

Attachment: http://drupal.org/files/issues/database.pgsql.menuseq2.diff (721 bytes)

Ugh.  Forgot -u.  New patch attached.