[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#470413: mdb-schema: postgres produces invalid sql

Package: mdbtools
Severity: normal

mdb-schema produces invalid DDL for postgres unless -S is specified

Table-names and column-names must be enclosed in 
double quotes ( " 0x22 )  where case is significant or spaces or other
special characters are used.

if MDBs are not case sensitive for names (I'm no Access expert) then 
the names should probably be lowercased as postgresql is case 
sensitive when quotes are used (and lowercases when they aren't)

Actually it doesn't work even with -S specified if someone uses a name that
starts with a digit! 

Also I note that single character mdb columns are being converted to char(2);

Also I note that postgres constraints appear to follow a similar syntax to the 
oracle ones.

Also mdb-tables doesn't seem to support -S (not that it would likely be a useful feature)
so here the man page is incorrect.

-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (500, 'testing'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.22-3-686 (SMP w/2 CPU cores)
Locale: LANG=en_NZ.UTF-8, LC_CTYPE=en_NZ.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mdbtools depends on:
ii  libc6        2.7-6                       GNU C Library: Shared libraries
ii  libglib2.0-0 2.14.6-1                    The GLib library of C routines
ii  libmdbtools mdbtools libraries
ii  libreadline5 5.2-3                       GNU readline and history libraries

mdbtools recommends no packages.

-- no debconf information

Reply to: