On Wed, 2011-11-30 at 20:10 -0500, Tom Lane wrote:
> I believe what is happening in the second case is that the query is
> getting re-parse-analyzed, from scratch, and since now datestyle is
> different (DMY not MDY), the date literal gets interpreted differently.
> You could argue it either way as
Josh Kupershmidt writes:
> On Wed, Nov 30, 2011 at 9:17 PM, Tom Lane wrote:
>> Can you try that on 9.1 branch tip to see if it's already fixed?
> Hrm, don't think that helped - I get the same error in the logs using
> a checkout of branch REL9_1_STABLE.
Well, was worth a try, although the stack
On Wed, Nov 30, 2011 at 9:17 PM, Tom Lane wrote:
> Can you try that on 9.1 branch tip to see if it's already fixed?
Hrm, don't think that helped - I get the same error in the logs using
a checkout of branch REL9_1_STABLE.
Josh
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To
Josh Kupershmidt writes:
> I have a new 9.1.1 hot standby machine (VM). It consistently starts
> up, goes through recovery through these same WAL segments, and then
> gets a "Bus error":
Can you try that on 9.1 branch tip to see if it's already fixed?
regards, tom lane
-
Hi all,
I have a new 9.1.1 hot standby machine (VM). It consistently starts
up, goes through recovery through these same WAL segments, and then
gets a "Bus error":
2011-11-30 20:57:37 EST LOG: database system was interrupted while in
recovery at log time 2011-11-30 09:37:11 EST
2011-11-30 20:57:
Jeff Davis writes:
> SQL:
> set datestyle to postgres,us;
> prepare stmt as select '02-01-2011'::date::text;
> execute stmt;
> set datestyle to postgres,euro;
> execute stmt;
> deallocate stmt;
> The results I get with normal debug compilation are:
> SET
> PREPARE
> text
>
SQL:
set datestyle to postgres,us;
prepare stmt as select '02-01-2011'::date::text;
execute stmt;
set datestyle to postgres,euro;
execute stmt;
deallocate stmt;
The results I get with normal debug compilation are:
SET
PREPARE
text
02-01-2011
(1 row)
S
On Tue, Nov 29, 2011 at 9:32 PM, Bruce Momjian wrote:
> Tom Lane wrote:
>> "David Fetter" writes:
>> > IF EXISTS (SELECT 1 INTO STRICT i) THEN
>> > RAISE NOTICE '%', a;
>> > END IF;
>>
>> Umm ... are you just complaining that the error message isn't very
>> helpful, or are you act
