I have a user defined type implemented in C and SPI which has been
crashing a lot. I found a small enough case to trace the whole thing
with gdb and found that while connected to SPI I was doing a get_value
on a type T implemented in C and SPI. SPI_getvalue led to a call to T's
output routine whi
"Gregor" <[EMAIL PROTECTED]> writes:
> API funtions lo_open, lo_write, lo_import don't work.
You need to do lo_open/lo_write/etc inside a transaction block, because
the LO handle returned by lo_open is only good until end of transaction.
(And yes, zero is a valid handle.) See the example program
Prischepa Vladimir написа:
> PostgreSQL 8.2 / WIN XP
>
> When I execute sql with GRANT RULE statement.
> In sistem table "pg_class", field "relacl" don't change. Statament 'R' is
> not introduce in Access privileges. Another privileges work god.
>
> P.S. In 8.0 version all good !
Please,
On Sun, Dec 10, 2006 at 03:20:50PM -0500, Tom Lane wrote:
> "Edwin Groothuis" <[EMAIL PROTECTED]> writes:
> > This statement is part of a longer one, which we used on 8.0
> > to determine the status of the locks on the database:
>
> > select relation,transaction::bigint,count(*) as waiting
The following bug has been logged online:
Bug reference: 2823
Logged by: Gregor
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2, 8.1
Operating system: Windows
Description:API largeobject calls
Details:
Hello,
API funtions lo_open, lo_write, lo_import don't
On Sun, Dec 10, 2006 at 05:47:16PM -0500, Tom Lane wrote:
> > Except that there isn't a custom cast...
> Better look harder; there's *something* nonstandard about your 8.0
> database.
Thanks for the push, I found it: It is part of slony which isn't
on the new databases:
mail=> select oid,* from p
PostgreSQL 8.2 / WIN XP
When I execute sql with GRANT RULE statement.
In sistem table "pg_class", field "relacl" don't change. Statament 'R' is not
introduce in Access privileges. Another privileges work god.
P.S. In 8.0 version all good !
Filip Hrbek wrote:
We needed to run a client in IBM852 code page, but this one is unsupported
by PostgreSQL. We added this feature to pgs and we would like to give it
back to postgresql-devel (we have prepared a patch), because we think it
might be useful for many PostgreSQL users.
Thank you.
The following bug has been logged online:
Bug reference: 2822
Logged by: Filip Hrbek
Email address: [EMAIL PROTECTED]
PostgreSQL version: All
Operating system: All
Description:Missing support for IBM852
Details:
This is more feature request than a bug report, if it
