Bug#470413: mdb-schema: postgres produces invalid sql
Package: mdbtools
Version: 0.5.99.0.6pre1.0.20051109-4
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 0.5.99.0.6pre1.0.20051109-4 mdbtools libraries
ii libreadline5 5.2-3 GNU readline and history libraries
mdbtools recommends no packages.
-- no debconf information
Reply to: