[Rt-devel] minor bug in PG upgrade schema

Palle Girgensohn girgen at pingpong.net
Mon Jul 26 10:54:17 EDT 2004


Hi,

In rt-devel etc/upgrade/3.1.0/schema.Pg, a hash (#) is used as a comment. 
Hashes are not used for SQL comments, so postgresql barfs

diff -c rt-3.2.1/etc/upgrade/3.1.0/schema.Pg~ 
rt-3.2.1/etc/upgrade/3.1.0/schema.Pg
*** rt-3.2.1/etc/upgrade/3.1.0/schema.Pg~	Mon Jul 26 16:53:20 2004
--- rt-3.2.1/etc/upgrade/3.1.0/schema.Pg	Mon Jul 26 16:53:20 2004
***************
*** 9,15 ****
    Content text,
    ContentType varchar(16),
    ObjectType varchar(64),
!   ObjectId integer, # foreign key to anything
    Creator integer NOT NULL DEFAULT 0  ,
    Created TIMESTAMP NULL  ,
    LastUpdatedBy integer NOT NULL DEFAULT 0  ,
--- 9,15 ----
    Content text,
    ContentType varchar(16),
    ObjectType varchar(64),
!   ObjectId integer, -- foreign key to anything
    Creator integer NOT NULL DEFAULT 0  ,
    Created TIMESTAMP NULL  ,
    LastUpdatedBy integer NOT NULL DEFAULT 0  ,


Regards,
Palle



More information about the Rt-devel mailing list