On Thursday 21 April 2005 15:57, Tom Lane wrote:
> I don't think it's a new bug, seeing that I didn't change the code
> for the ISO case.
>
> I see the imprecise result only in the non-integer-datetime case; is
> it acting differently for you?
You're right - it has nothing to do with your patch. I
> I've applied this patch.
It removed the bug, but also added a new one (hopefully only one ;-))
...now with ISO DateStyle -
select '2005 years 4 mons 20 days 15 hours 57 mins 12.1 secs ago'::interval;
Before your patch:
interval
---
Hi Tom,
On Wednesday 20 April 2005 17:57, Tom Lane wrote:
> "Oliver Siegmar" <[EMAIL PROTECTED]> writes:
> > select '10.10 secs ago'::interval;
> >
> > interval
> > ---
> > @ 10.-10 secs ago
> > (1 row)
>
&
The following bug has been logged online:
Bug reference: 1609
Logged by: Oliver Siegmar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.2
Operating system: Linux
Description:Bug in interval datatype for 64 Bit timestamps
Details:
Postgres compiled with
On Friday 18 March 2005 14:29, Stephan Szabo wrote:
> Given the error message, this seems to be the whole plpgsql caches query
> plans but we don't invalidate those plans when there are schema changes.
I already tried to execute the 'CREATE TEMP TABLE' statement using EXECUTE to
avoid cache probl
On Friday 18 March 2005 18:08, Bruce Momjian wrote:
> Uh, have you read the FAQ item about plpgsql and temporary tables?
Doesn't seems like, eh? ;-)
...sorry for the not rtfm.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to c
Hello,
I've probably found a temp table bug in PostgreSQL (tested with 7.4.7 and
8.0.1 on Linux x86).
Here's a demonstration of the bug:
CREATE FUNCTION testfunction()
RETURNS void
AS '
BEGIN
CREATE TEMP TABLE testtable (field int4) ON COMMIT DROP;
INSERT INTO test
The following bug has been logged online:
Bug reference: 1546
Logged by: Oliver Siegmar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.7 / 8.0.1
Operating system: Linux x86
Description:Temp table isn't deleted at the end of a transaction /
ON COMMIT
POSTGRESQL BUG REPORT TEMPLATE
Your name : Oliver Siegmar
Your email address : [EMAIL PROTECTED
