PostgreSQL and Minimate and Vend/Table/DBI.pm

[Holm Tiffe <holm@freibergnet.de>]

Hi,

I'am in the process to get Minimate (latest) running in conjunction with my
PostgreSQL(6.5) based testshop (3.14).
Minimate is almost working, but I get an error when I try to insert
a new product in my products database.

Minimate tried to create the column as follows:

insert into products values( '06-001','','','','','',,'','','',,,'','');

and I get an error from postgres in the catalogs error.log:

194.123.255.9 3xDTms9J:194 - [22/Juli/1999:13:40:37 +0200] fgnet /cgi-bin/fgnet/
process Runtime error: ERROR:  parser: parse error at or near ","

The concrete column names are not relevant here, relevant is, that
minivend doesn't quote numeric columns. (see line 525 on Vend/Table/DBI.pm
[minivend 3.14])

....
 for(@fields) {
        $_ = $s->[$DBI]->quote($_)
          unless exists $s->[$CONFIG]->{NUMERIC}->{$cols[$i++]};
    }
...

Commenting out the line "unless exists..." solved my problem,
but where should I report this ?

some experiments whith my postgres:

holm=> create table test (aa int4,bb float8);
CREATE
holm=> insert into test values(4,5.2);
INSERT 752570 1
holm=> insert into test values(4,);
ERROR:  parser: parse error at or near ")"
holm=> insert into test values(,5.2);
ERROR:  parser: parse error at or near ","
holm=> insert into test values('',5.2);
INSERT 752571 1
holm=> insert into test values(null,5.2);
INSERT 752572 1
holm=> insert into test values(4,null);
INSERT 752573 1
holm=> insert into test values(4,'');
INSERT 752574 1
holm=>  select * from test;
aa| bb
--+---
 4|5.2
 0|5.2
  |5.2
 4|   
 4|  0
(5 rows)

holm=> 

How are other databases working ?

Holm
-- 
FreibergNet Systemhaus GbR      Holm Tiffe  * Administration, Development
Systemhaus für Daten- und Netzwerktechnik           phone +49 3731 781279
Unternehmensgruppe Liebscher & Partner                fax +49 3731 781377
D-09599 Freiberg * Am St. Niclas Schacht 13    http://www.freibergnet.de/