[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