Hi, Jaime
thank you for your answer.
I understand it.
I turned synchronous_commit to local,
I get desirable behavior.
I've thought that if there are no standby,
the primary would behave like stand-alone...
sorry, this is my misunderstanding.
regards,
(2011/05/27 14:53), Jaime Casanova
On Fri, May 27, 2011 at 7:15 AM, Tomonari Katsumata
katsumata.tomon...@po.ntts.co.jp wrote:
I've thought that if there are no standby,
the primary would behave like stand-alone...
sorry, this is my misunderstanding.
It is a common misunderstanding. The programmed behaviour leads to the
most
The following bug has been logged online:
Bug reference: 6043
Logged by: Emanuel
Email address: postgres@gmail.com
PostgreSQL version: 9.1 beta
Operating system: Ubuntu 10.04 2.6.31
Description:Compilation PLpgsql Succesful but execution bad
Details:
postgres=#
On 27.05.2011 17:05, Emanuel wrote:
postgres=# CREATE OR REPLACE FUNCTION p_() RETURNS TABLE (i int) AS $$
DECLARE
BEGIN
SELECT * FROM p; here must ne RETURN QUERY ..
END;
$$ LANGUAGE plpgsql;
CREATE FUNCTION
postgres=# select p_();
ERROR: query has no destination for result data
HINT:
Hi,
I see the following error as found in pg.log:
UTC4115FATAL: the database system is in recovery mode
Actually that message was logged repeatedly for about 4 hours according to the
logs (I don't have access to the system itself, just the logs).
Leading up to that error were the following in
The following bug has been logged online:
Bug reference: 6044
Logged by: Christopher Dillard
Email address: csdill...@gmail.com
PostgreSQL version: 8.4.8
Operating system: Windows
Description:Access violation on XML decl with standalone
Details:
Hello,
In
On May 27, 2011, at 7:14 PM, Alex Hunsaker wrote:
On Mon, May 23, 2011 at 20:08, Greg Sabino Mullane g...@endpoint.com wrote:
On Mon, May 23, 2011 at 05:04:40PM -0600, Alex Hunsaker wrote:
...
Greg, can you confirm the attached fixes it for you?
Yes, seems to have done the job, thank you.
Christopher Dillard csdill...@gmail.com writes:
In PostgreSQL 8.4.8, the function xml_recv (in
src/backend/utils/adt/xml.c) calls the function parse_xml_decl, passing
NULL for the final standalone parameter. However, parse_xml_decl does
not check for standalone==NULL, and blindly sets
Excerpts from Alex Hunsaker's message of vie may 27 12:14:25 -0400 2011:
On Mon, May 23, 2011 at 20:08, Greg Sabino Mullane g...@endpoint.com wrote:
On Mon, May 23, 2011 at 05:04:40PM -0600, Alex Hunsaker wrote:
...
Greg, can you confirm the attached fixes it for you?
Yes, seems to have