lo type

Started by Dagoberto Torresover 21 years ago2 messagesbugs
Jump to latest
#1Dagoberto Torres
support@info-plus.org

Hello.

In postgresql 7.3.1 I created

create domain lo as oid;
CREATE TABLE fotograph(code varchar(10) not null, foto lo);

It worked perfectly

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

I'm using visual basic 6 odbc 7.03.02

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Dagoberto Torres (#1)
Re: lo type

"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