Re: [mv] MV4 beta 1: bug when creating multiple SQL tables with sequences

[Mike Heins <mike@minivend.com>]

******    message to minivend-users from Mike Heins <mike@minivend.com>     ******

Quoting Mark Stosberg (mark@summersault.com):
> 
>   I'm using Minivend 4 beta 1 to create several empty SQL based tables.
> I'm using Postgres and am using the type "serial" to cause Postgres to
> create a sequence for the primary key. 
>   Minivend appears to create a table called "mv_test_create" before it
> creates each real table. The bug is that the sequence
> 'mv_test_create_id_seq'; does not get deleted when the test table gets
> deleted. When creating multiple tables, Minivend fails on the second
> table because this sequence already exists. 
> 
> This bug may be specific to Postgres (I'm using 6.5.3). When the serial
> field is used, Postgres creates a sequence named '<table>_<col>_seq'

I don't consider this a bug in MiniVend at all -- it is an example of
why I don't spend much time trying to acommodate PostGres.(That and its
speed problems.) There are MANY, MANY problems with PostGres and MiniVend,
most having to do with its lack of tolerance of fairly sane thigs. For
instance, it will not let you define a timestamp field with a preloaded
blank value -- you must put the string "current" instead. Ugh.

I don't want the list flodded with all of them -- there are quite a few
more you have probably not yet run across. I think I am going to take
out the demo support for PostGres because there are probably a hundred
more waiting to happen.

However, in the next beta I expect to have some new parameters
in MiniVend DBI land including:

	DEFAULT_TYPE -- type to replace char(128) as default 
	type if not defined.
	CREATE_SQL -- stop MiniVend from doing the SQL to create
	a table, use your own


-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
I have a cop friend who thinks      131 Willow Lane, Floor 2  | ||  _ \
he ought be able to give a new      Oxford, OH  45056         | || |_) |
ticket; "too dumb for conditions".  <mikeh@minivend.com>     |___|  _ <
                                    513.523.7621 FAX 7501        |_| \_\
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list