makecat and sql data types

[Holm Tiffe <holm@freibergnet.de>]

Hi,
today I've got the following problem:

I'm in the process to convert an catalog on 3.14 to
use SQL tables on postgres only.
I whish to use some fields with the new numeric data type on psql6.5
to get the price with 2 decimals.
In the catalog.cfg I've put the following:

....
Database products COLUMN_DEF code=varchar
Database products COLUMN_DEF price=numeric(30,2)
...

the problem is now, that makecat is splitting the fields
on the comma, there is no way to escape this and minivend
try's tho create tables like this:

table products created: create table products ( 
code varchar,
price numeric(30,
title varchar,
...
)

and I run in an syntax error on the database.

Has anyone a solution for this problem ?


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/