Thread: lo type

lo type

From
"Dagoberto Torres"
Date:
Hello.=0D
=0D
In postgresql 7.3.1   I created =0D
=0D
create domain lo as oid;=0D
CREATE TABLE fotograph(code varchar(10) not null, foto lo);=0D
=0D
It worked perfectly=0D
=0D
=0D
Recently I upgrade for beta 2 and I can't retrieve anymore the pictures I
save=0D
=0D
I'm using visual basic 6   odbc 7.03.02=

Re: lo type

From
Tom Lane
Date:
"Dagoberto Torres" <support@info-plus.org> writes:
> create domain lo as oid;
> CREATE TABLE fotograph(code varchar(10) not null, foto lo);

> Recently I upgrade for beta 2 and I can't retrieve anymore the pictures I
> save

Sounds like you forgot to include large objects while dumping your older
database.

            regards, tom lane