Login | Register
My pages Projects Community openCollabNet

Discussions > dev > Re: MySQL and other sql patch

Project highlights: Stable Version: 1.6.1, Development Version: 1.7.6

current
Discussion topic

Back to topic list

Re: MySQL and other sql patch

Reply

Author hunterm
Full name Hunter Matthews
Date 2003-07-23 13:49:08 PDT
Message Frank,
   We've not applied your patch - we just couldn't. The backend was (and
really still is) changing too quickly to have to update two.

However, I *think* most of the noise (the capitalization part) are
checked in now.

It also appears that the "on(something)" syntax that caused so many
duplicate SQL strings is not required. Let me test that tonight, and if
postgres is happy with it we should be able to share all the SQL strings
between databases.



On Tue, 2003-07-08 at 13:28, Frank Sweetser wrote:
> On Tue, Jul 08, 2003 at 12:26:44PM -0400, Hunter Matthews wrote:
> > One thing I'm curious about (I'm new to SQL programming, unfortunately)
> > is - is it at all possible to share the schema definitions between
> > databases? From what I've seen, the answer is "not at all".
>
> In theory - I believe so, yes. In reality, only with the most trivial table
> definitions. CREATE statements seem to be one of the areas in which each
> database engine varies the most, probably because they get used so infrequently
> and hardly ever in day to day operations.
--
Hunter Matthews Unix / Network Administrator
Office: BioScience 145/244 Duke Univ. Biology Department
Key: F0F88438 / FFB5 34C0 B350 99A4 BB02 9779 A5DB 8B09 F0F8 8438
Never take candy from strangers. Especially on the internet.


--------------------​--------------------​--------------------​---------
To unsubscribe, e-mail: dev-unsubscribe@curr​ent.tigris.org
For additional commands, e-mail: dev-help at current dot tigris dot org

« Previous message in topic | 9 of 11 | Next message in topic »

Messages

Show all messages in topic

MySQL and other sql patch Frank Sweetser <fs at wpi dot edu> Frank Sweetser <fs at wpi dot edu> 2003-07-07 16:03:24 PDT
     Re: MySQL and other sql patch jwbernin John Berninger 2003-07-07 17:32:38 PDT
         Re: MySQL and other sql patch Frank Sweetser <fs at wpi dot edu> Frank Sweetser <fs at wpi dot edu> 2003-07-08 05:50:35 PDT
             Re: MySQL and other sql patch jwbernin John Berninger 2003-07-08 06:04:49 PDT
                 Re: MySQL and other sql patch Frank Sweetser <fs at wpi dot edu> Frank Sweetser <fs at wpi dot edu> 2003-07-08 06:12:06 PDT
                     Re: MySQL and other sql patch jwbernin John Berninger 2003-07-08 06:46:05 PDT
                     Re: MySQL and other sql patch hunterm Hunter Matthews 2003-07-08 09:26:44 PDT
                         Re: MySQL and other sql patch Frank Sweetser <fs at wpi dot edu> Frank Sweetser <fs at wpi dot edu> 2003-07-08 10:28:41 PDT
                             Re: MySQL and other sql patch hunterm Hunter Matthews 2003-07-23 13:49:08 PDT
                                 Re: MySQL and other sql patch Frank Sweetser <fs at WPI dot EDU> Frank Sweetser <fs at WPI dot EDU> 2003-07-23 13:51:48 PDT
             Re: MySQL and other sql patch Hunter Matthews <thm at duke dot edu> Hunter Matthews <thm at duke dot edu> 2003-07-08 09:23:08 PDT
Messages per page: