1. Are there dynasets in PG (like in Access)?
2. I tried to export tables from Access95 to PG7.0.3-2 using ODBC Driver on
the Win machine (PG is on a RH7.0). It worked fine with a simple table I
created myself. Once I tried something real (many columns), I got errors -
see log below:
conn=58261624, SQLDriverConnect( in)='DRIVER={PostgreSQL};',
fDriverCompletion=1
Global Options: Version='06.50.0000', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=1
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=0
extra_systable_prefixes='dd_;pg_', conn_settings=''
conn=58261624, query=' '
conn=58261624, query='set DateStyle to 'ISO''
conn=58261624, query='set geqo to 'OFF''
conn=58261624, query='set ksqo to 'ON''
conn=58261624, query='BEGIN'
conn=58261624, query='declare SQL_CUR03793938 cursor for select oid from
pg_type where typname='lo''
conn=58261624, query='fetch 100 in SQL_CUR03793938'
[ fetched 0 rows ]
conn=58261624, query='close SQL_CUR03793938'
conn=58261624, query='END'
conn=58261624,
SQLDriverConnect(out)='DRIVER={PostgreSQL};DATABASE=test;SERVER=100.100.100.
100;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX
=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=58261624, query='BEGIN'
conn=58261624, query='declare SQL_CUR03793938 cursor for SELECT Config,
nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR: Relation 'msysconf' does not
exist'
conn=58261624, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query'
The message on screen appears later: "Unable to locate type name 'lo' in
catalog".
Thanks everybody,
Mihai Gheorghiu
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
