"Mathew Frank" <[EMAIL PROTECTED]> writes:
> CREATE FUNCTION insert_record_return_oid(text) RETURNS int4 AS
> ' DECLARE
> s_query ALIAS FOR $1;
> oid int4;
> BEGIN
> EXECUTE s_query;
> GET DIAGNOSTICS oid = RESULT_OID;
> RETURN oid;
> END;
> ' LANGUAGE 'plpgsql' with (
Is this a bug or is this how it is supposed to work?
postgresql 7.3 (release)
mac osx 10.2.2
select for update
I have two terminal sessions open with psql running
and talking to the same db.
in window 1 : begin;
in window 1 : select column1 from table where column1
= 'text' for update;
in wind
[ Will be backpatched.]
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---
Neil Conway wrot
> after I upgrade my postgresql from 7.2 to 7.3, one query always makes server
> terminated
This is caused by the vacuum of a temp table.
Tom fixed it already about a week ago and provided the patch here:
*** src/backend/storage/buffer/localbuf.c.orig Wed Sep 4 16:31:25 2002
--- src/backend/
Ok, I think I've gotten this figured out now. I saw this comment in pqcomm.c,
switched the ERROR logs to COMMERROR logs and it all works. I've attached a
patch to be-secure.c that fixes all my problems. Hopefully this is the right fix.
--Nate
/*
* Careful: an elog() that tri
On Thu, Dec 12, 2002 at 04:49:30PM -0500, Bruce Momjian wrote:
> I applied the attached patch. Your version looked like it would have
> doubled the double-quotes.
Oops - yes, I got that wrong.
> As you mentioned, you couldn't get bison to
> work, so you weren't able to test it. Please look over
OK, patch applied. Thanks.
---
Roland Karch wrote:
> On Thu, Dec 12, 2002 at 04:49:30PM -0500, Bruce Momjian wrote:
> > I applied the attached patch. Your version looked like it would have
> > doubled the double-quotes.
>
>
> -Original Message-
> From: Ocke Janssen
>
> The call looks like
>
> SQLRETURN nRetcode = N3SQLForeignKeys(m_aStatementHandle,
> (SDB_ODBC_CHAR *) pPKQ, (catalog.hasValue()
> && aPKQ.getLength()) ? SQL_NTS : 0,
> (SDB_ODBC_CHAR *)
Murthy Kambhampaty <[EMAIL PROTECTED]> writes:
> "/home/postgres/postgresql-7.3/src/test/regress/./tmp_check/install//usr/loc
> al/pgsql/bin/pg_encoding: relocation error:
> /home/postgres/postgresql-7.3/src/test/regress/./tmp_check/install//usr/loca
> l/pgsql/bin/pg_encoding: undefined symbol: pg_
Jie Liang <[EMAIL PROTECTED]> writes:
> however, after
> I upgrade my postgresql from 7.2 to 7.3, one query always makes server
> terminated, could
> you give me a solution for it?
I cannot reproduce this with the information you gave.
regards, tom lane
--
10 matches
Mail list logo
