Re: [GENERAL] Oid problem

2004-04-08 Thread Sky
Richard Huxton írta: 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? W

Re: [GENERAL] Oid problem

2004-04-08 Thread Richard Huxton
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? > Question: > The oi

[GENERAL] Oid problem

2004-04-08 Thread Sky
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 var

Re: [GENERAL] OID problem

2004-03-23 Thread Tom Lane
Patrick Hess <[EMAIL PROTECTED]> writes: > The only problem I have is related to this OID stuff -- I read a bit > about this and found a way to solve my initial problems by creating my > tables with "WITHOUT OIDS" -- works fine and CMS runs like on the > original plattform (even faster but that'

[GENERAL] OID problem

2004-03-23 Thread Patrick Hess
Hi there, I'm currently in the process of "porting" an enterprise CMS system which is targeting Weblogic/Oracle plattform to Tomcat/pgsql. As expected, pgsql does a great job in replacing Oracle esp. compared to mysql... The only problem I have is related to this OID stuff -- I read a bit abou