The Interesting Installation Integer Problem

[Max Kanat-Alexander]

On Mon, 2005-03-07 at 20:28 +0000, Gervase Markham wrote:
> I may be mistaken, but isn't this what the SQL standard does - i.e. 
> define a set of types with names that all databases understand?

	I wish that all databases understood them. And that we could then get
those exact field names back with DBI's type_info. Unfortunately,
neither of those things are true.

> It's also duplication of information. What if the two get out of sync?

	It's not a duplication of information, really -- the schema holds
information that the database itself loses.

	The two won't get out-of-sync -- the "ChangeField" subs will only
change the stored schema after a successful ALTER TABLE call. Since
those things always happen atomically (we never call ALTER TABLE outside
of a "ChangeField" call), there's almost no risk of them getting out-of-
sync.

	-Max
-- 
Max Kanat-Alexander
Technical Support Manager, USA
Kerio Technologies, Inc.
2350 Mission College Blvd., Suite 400
Santa Clara, CA 95054
Phone: (408) 496-4500
Fax: (408) 496-6902
http://www.kerio.com/support.html