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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
