On Thursday 08 April 2004 15:21, Sky wrote:
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.
Sorry, bigger than what? Why float?
Watch these links: http://archives.postgresql.org/pgsql-php/2003-09/msg00077.php http://archives.postgresql.org/pgsql-php/2003-09/msg00079.php I found it by google.
This error message is my problem: pg_loopen() unable to open large object / PHP4 /
Watch the links above.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';
Assuming the definition of "foto" is OK, looks fine from here.
So, What can I do, and how, how can I "CAST" ??
Sorry - dont understand, but you can cast by:
SELECT foo::int8 ... SELECT CAST(foo as int8) ...
Is the problem that you want to handle oid's (0 .. 4 billion) and you are using int4 (-2 billion .. +2 billion). In which case int8 might be a better choice than int4.
Sorry but I don't understand, where do I use int4 ?? Here is my table definition too:
CREATE TABLE foto( filename CHARACTER VARYING, image OID );
HTH
Many thanks!
-- 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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
