[BioSQL-l] Re: biosql schema

[Aaron J Mackey]

You're correct; DEFERABLE is a PostgreSQL-only syntax.  It should only
exist in the biosqldb-pg.sql file, not in the mysql file (Hilmar, we did
agree that these two were now going to live separate lives??)

-Aaron

On Tue, 8 Apr 2003, Qiang TU wrote:

> Hello, dear Aaron Jon Mackey,
>
> I downloaded the biosqldb-mysql.sql from the CVS today and try to load
> it into my local MySQL. But there is a error message:
>
> ERROR 1064 at line 562: You have an error in your SQL syntax near 'DEFERRABLE' at line 4
>
> If I remark this line, it works. I am not famillar with the foreign key constrain.
> Could  you tell me is this error important?
>
> Sorry to trouble you and many thanks.
>
> Best,
>
> Qiang Tu
> Institute of Biochemistry and Cell Biology
> Chinese Academy of Sciences
> Email: tuqiang at mail.shcnc.ac.cn, tuqiang_cn at yahoo.com
>

-- 
 Aaron J Mackey
 Pearson Laboratory
 University of Virginia
 (434) 924-2821
 amackey at virginia.edu