EXEC SQL type RDBBLOB is bytea; ecpg ERROR: invalid datatype 'bytea'

From: "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: EXEC SQL type RDBBLOB is bytea; ecpg ERROR: invalid datatype 'bytea'
Date: 2002-11-07 22:26:58
Message-ID: 64AE3D5B518E3648ACC823FBCB0B7375ADF043@sr002-2kexc.ateb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does ecpg not recognize bytea as a datatype?

using ecpg v 2.9, POSTGRESQL v 7.2.3

the line

EXEC SQL type RDBBLOB is bytea;

results in the error

ERROR: invalid datatype 'bytea'

I've amended my code to

EXEC SQL type RDBBLOB is struct {
int len;
char buf[1];
};

to get around the error message.

Reid Thompson (919)872-1275 ext.4960
ateb, Inc. www.ateb.com

Browse pgsql-general by date

  From Date Subject
Next Message snpe 2002-11-07 22:30:43 Re: Database design software
Previous Message Miles Elam 2002-11-07 22:17:47 Re: two table foreign keys