Microsoft Project and PostgreSQL?

[Klaus Harbo]

Does anyone have experiences using PostgreSQL for storing Microsoft
Project data? MS Access, SQL Server and Oracle are supported
according to the manual. A simple test with PostgreSQL results in an
error something like 'Unknown data type "lo"'.

I have been unable to find any useful info on this issue on
www.google.com.

Any help much appreciated.

-K.

[Daniel Schuchardt]

Klaus Harbo schrieb:

according to the manual. A simple test with PostgreSQL results in an
error something like 'Unknown data type "lo"'.

It seems that you try to access binary data fields. In postgresql the
type lo (BLOB) is implemented as oid or bytea. Read in the archives.

Try

CREATE DOMAIN lo AS oid;

Daniel

[Klaus Harbo]

That, in fact, kind of worked, in the sense that I got past the error
message. It looks like MS Project 2000 actually created all the
tables it needs, but - alas - it crashed, and all the tables were left
empty.

Thanks for your suggestion.

best,

-Klaus.