Mailing List Archive

[Bricolage-General] possible bug - posted to bugzilla
6-04 CVS image exhibts the following error on a new "install"

Michael

#####################################################################
########

Database error on statement:

ALTER TABLE keyword ADD
CONSTRAINT fk_keyword__grp FOREIGN KEY (synonym_grp_id)


Error was:

ERROR: ALTER TABLE: column "synonym_grp_id" referenced in foreign key
constraint does not exist

#############################################################################
Michael@Insulin-Pumpers.org

_______________________________________________________________

Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general
Re: [Bricolage-General] possible bug - posted to bugzilla [ In reply to ]
On Fri, 14 Jun 2002, Michael wrote:

> ERROR: ALTER TABLE: column "synonym_grp_id" referenced in foreign key
> constraint does not exist

That sounds like an artifact of the keyword system changes I commited last
week. Although, I did test creating a new database with the new SQL, so
I'm not sure why I wouldn't have seen this. Also, checking my working
copy of Bricolage shows no sign of synonym_grp_id:

$ grep -r synonym_grp_id .
$

Can you file a bug in Bugzilla under Installation? Please include all
relevent details - OS, verison of PostgreSQL, etc. Also, please verify
that this bug occurs with an up-to-date checkout from CVS.

Thanks,
-sam






_______________________________________________________________

Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general