Error for insert large object
am 18.09.2006 23:14:49 von Lemaire VincentThis is a multi-part message in MIME format.
------=_NextPart_000_001A_01C6DB78.3D8D59B0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hello all world,
I work on a project c# with a postgresql database. The communication is made
by the odbc driver. The select command is OK but I have a problem for insert
an Image in my table.
The script of creation of my table is as follows:
CREATE TABLE images
(
id_image int4 NOT NULL,
image bytea,
CONSTRAINT id_image PRIMARY KEY (id_image)
)
WITH OIDS;
ALTER TABLE images OWNER TO postgres;
When I want insert data, I have an error how is generate by de odbc driver.
This error is "type "lo" does not exist >
How create a large object with odbc driver in C# ?
Can you help me please? It's very important for my project actually.
Sorry, I'm French and my English is not perfectly, I hope that you think.
Vincent Lemaire
------=_NextPart_000_001A_01C6DB78.3D8D59B0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
xmlns=3D"http://www.w3.org/TR/REC-html40">
charset=3Dus-ascii">
style=3D'font-size:10.0pt;
font-family:Arial'>Hello all world,
style=3D'font-size:10.0pt;
font-family:Arial'>
style=3D'font-size:
10.0pt;font-family:Arial'>I work on a project c# with a postgresql =
database. The
communication is made by the odbc driver. The select command is OK but I =
have a
problem for insert an Image in my table.
style=3D'font-size:
10.0pt;font-family:Arial'>
The script of creation of my table is as =
follows:
style=3D'font-size:
10.0pt;font-family:Arial'>
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>CREATE =
TABLE images
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>(
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '> =
id_image
int4 NOT NULL,
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '> =
image bytea,
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '> =
CONSTRAINT
id_image PRIMARY KEY (id_image)
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>) =
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>WITH =
OIDS;
style=3D'font-size:10.0pt;font-family:Arial;font-weight:bold '>ALTER =
TABLE images
OWNER TO postgres;
style=3D'font-size:
10.0pt;font-family:Arial'>
style=3D'font-size:
10.0pt;font-family:Arial'>When I want insert data, I have an error how =
is
generate by de odbc driver. This error is “
size=3D2
face=3DArial>type =
"lo"
does
style=3D'font-size:10.0pt;
font-family:Arial'> not exist »
style=3D'font-size:10.0pt;
font-family:Arial'>
style=3D'font-size:
10.0pt;font-family:Arial'>How create a large object with odbc driver in =
C# ?
style=3D'font-size:
10.0pt;font-family:Arial'>
style=3D'font-size:
10.0pt;font-family:Arial'>Can you help me please? It’s very =
important for
my project actually.
style=3D'font-size:
10.0pt;font-family:Arial'>
style=3D'font-size:
10.0pt;font-family:Arial'>Sorry, I’m French and my English is not
perfectly, I hope that you think.
lang=3DEN-GB
style=3D'font-size:10.0pt'>
lang=3DEN-GB
style=3D'font-size:10.0pt'>Vincent Lemaire
style=3D'font-size:
10.0pt;font-family:Arial'>
------=_NextPart_000_001A_01C6DB78.3D8D59B0--