[drupal-devel] [bug] database.pgsql menu_mid_seq problems
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 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. 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 Attachment: http://drupal.org/files/issues/database.pgsql.menuseq2.diff (721 bytes) Ugh. Forgot -u. New patch attached. 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.
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.
participants (1)
-
danielc