Gossamer Forum
Home : Products : DBMan SQL : Discussion :

problem loading a Posgres table

Quote Reply
problem loading a Posgres table
Hi,

It seems DBMan does not recognize the column type numeric which is a standard Postgres column type. In GT/SQL/Creator.pm, could
Code:
/^(?:float|decimal)(?:\((\d+)(?:,(\d+))?\))?/
and do {
my ($size, $pre) = ($1, $2);
be changed in
Code:
/^(?:float|decimal|numeric)(?:\((\d+)(?:,(\d+))?\))?/
and do {
my ($size, $pre) = ($1, $2);

Thanks, Jasper

http://www.bookings.org