[BioSQL-l] Re: biosql schema

[Hilmar Lapp]

On Tuesday, April 8, 2003, at 05:51  AM, Aaron J Mackey wrote:

>
> 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??)

Yes. I just haven't committed this yet. Sorry about that. -hilmar

>
> -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
>
>
> _______________________________________________
> BioSQL-l mailing list
> BioSQL-l at open-bio.org
> http://open-bio.org/mailman/listinfo/biosql-l
>
-- 
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------