| From: | Sky <sky(at)sylvio(dot)hu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Oid problem |
| Date: | 2004-04-08 14:21:33 |
| Message-ID: | 40755FED.9010003@sylvio.hu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Problem:
pg_loopen() unable to open PostgreSQL large object in...
Solution from another mailing list:
My blob oid was very big.
I had to cast to (float) the oid parameter of pg_loopen.
Question:
The oid is a type, isn't it?
I tried to use the oid in a function:
CREATE FUNCTION addfoto(character varying, oid)
RETURNS INTEGER
AS
'
BEGIN;
INSERT INTO foto(filename, image) VALUES ( $1, $2 );
COMMIT;
SELECT 1 AS RESULT;
'
LANGUAGE 'sql';
So, What can I do, and how, how can I "CAST" ??
--
Sky
sky AT sylvio .hu
Debian Group - Association of Hungarian Linux Users
Accessibility Project leader
gpg --keyserver hkp://pgp.mit.edu --recv-keys 314D1B0C
fingerprint = B211 E8C7 C6C2 18B2 9F30 ADF6 EDD9 A7FA 314D 1B0C
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2004-04-08 14:28:04 | Re: eval in plpgsl |
| Previous Message | Jeff Eckermann | 2004-04-08 14:03:18 | Re: eval in plpgsl |