RE: [INTERFACES] pgAdmin connection error on NT and W98

> -----Original Message-----
> From: Nicolas Huillard [mailto:nhuillard@ghs.fr]
> Sent: 27 October 1999 09:34
> To: 'Dave Page'
> Cc: 'pgsql-interfaces@postgresql.org'
> Subject: RE: [INTERFACES] pgAdmin connection error on NT and W98
> 
> The Migration error was about an OLE field in the Access 
> database (s_Lineage). Which is converted in a blank field 
> type. See the log file :
>  
I have tested pgAdmin with OLE fields in an Access MDB, and they seem to
work correctly on my system (that is, the table is created, but the
Migration Wizard cannot migrate blob data and will ignore it). My guess is
that you do not have the lo datatype configured on your PostgreSQL system.
If this is the case, you can create it with the following SQL:

CREATE TYPE "lo" ( internallength = 4,                   externallength = 10,                   input = int4in,
         output = int4out,                   send = int4out,                   receive = int4in,
default= '',                  passedbyvalue);
 

Regards,
Dave.
-- 
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!