[drupal-devel] [bug] Multiple Error IN DATABASE.PGSQL

[Cvbge]

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

 Project:      Drupal
 Version:      cvs
 Component:    postgresql database
 Category:     bug reports
 Priority:     critical
 Assigned to:  Anonymous
 Reported by:  kinai
 Updated by:   Cvbge
-Status:       active
+Status:       patch
 Attachment:   http://drupal.org/files/issues/database.pgsql.diff (1010 bytes)

Attached patch should fix all errors.




Cvbge



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

May 15, 2005 - 15:33 : kinai

Hello,


Since my last post, i've updated my installation. database.pgsql
contain multiple error :


psql:database.pgsql:206: ERROR:  the type «longtext» does not exist


psql:database.pgsql:512: ERROR:  syntax error on or near «CREATE» at
character 46
psql:database.pgsql:513: ERROR:  the relation «permission» does not
exist


psql:database.pgsql:703: ERROR:  The column «changed» does not exist
psql:database.pgsql:797: ERROR:  The relation «permission» does not
exist


psql:database.pgsql:800: ERROR:  The relation «permission» does not
exist


Someone could fix this error ???
Thanks,
Kinaï




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

May 15, 2005 - 15:35 : kinai

a ";" missing line 503 in database.pgsql


Change


CREATE INDEX url_alias_src ON url_alias(src)


to


CREATE INDEX url_alias_src ON url_alias(src);


kinaï




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

May 15, 2005 - 15:47 : kinai

To fix this problem, I think change below is needed :


line 703 :
CREATE INDEX users_changed_idx ON users(changed);
to
CREATE INDEX users_access_idx ON users(access);


because no column changed exist in users table. In database.mysql,
Index is created on access column


--
-- Table structre for table 'contact'
--


CREATE TABLE contact (
  subject varchar(255) NOT NULL default '',
  recipients longtext NOT NULL default '',
  reply longtext NOT NULL default ''
);


to 


CREATE TABLE contact (
  subject varchar(255) NOT NULL default '',
  recipients text NOT NULL default '',
  reply text NOT NULL default ''
);


because le longtext format don't exist on postgresql.


This change is right ?