Subject: libmdbtools: postgres backend should export Memo type as Text
Package: libmdbtools
Version: 0.5.99.0.6pre1.0.20051109-4
Severity: normal
Tags: patch
Using "mdb-schema db1.mdb postgres", generated output is something like:
CREATE TABLE my_table
(
id Int8,
foo Postgres_Unknown 0x0c
);
which is of course invalid.
Output should be
CREATE TABLE my_table
(
id Int8,
foo Text
);
-- System Information:
Debian Release: 5.0.3
APT prefers proposed-updates
APT policy: (500, 'proposed-updates'), (500, 'stable')
Architecture: i386 (i686)
Kernel: Linux 2.6.26-2-686 (SMP w/1 CPU core)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages libmdbtools depends on:
ii libc6 2.7-18lenny1 GNU C Library: Shared libraries
ii libglib2.0-0 2.16.6-3 The GLib library of C routines
libmdbtools recommends no packages.
libmdbtools suggests no packages.
diff -Naur mdbtools-0.5.99.0.6pre1.0.20051109.orig/src/libmdb/backend.c mdbtools-0.5.99.0.6pre1.0.20051109/src/libmdb/backend.c
--- mdbtools-0.5.99.0.6pre1.0.20051109.orig/src/libmdb/backend.c 2006-01-31 11:21:11.000000000 +0100
+++ mdbtools-0.5.99.0.6pre1.0.20051109/src/libmdb/backend.c 2010-01-13 16:03:27.000000000 +0100
@@ -114,7 +114,7 @@
MdbBackendType_STRUCT_ELEMENT("Postgres_Unknown 0x09",0,0,0),
MdbBackendType_STRUCT_ELEMENT("Char",1,0,1),
MdbBackendType_STRUCT_ELEMENT("Postgres_Unknown 0x0b",0,0,0),
- MdbBackendType_STRUCT_ELEMENT("Postgres_Unknown 0x0c",0,0,0),
+ MdbBackendType_STRUCT_ELEMENT("Text",0,0,0),
MdbBackendType_STRUCT_ELEMENT("Postgres_Unknown 0x0d",0,0,0),
MdbBackendType_STRUCT_ELEMENT("Postgres_Unknown 0x0e",0,0,0),
MdbBackendType_STRUCT_ELEMENT("Serial",0,0,0),
