The following bug has been logged online:
Bug reference: 3817
Logged by: Avanttec Medical System
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8
Operating system: windows xp
Description:about service
Details:
i am using number of database on the postgresql ,o
"Geert Bijloos" <[EMAIL PROTECTED]> writes:
> The following bug has been logged online:
> PostgreSQL version: 8.1.3 and 8.2.4
> Description:Timezone bug
Without actually checking whether the results are wrong I'll note that several
of the changes in the bug-fix releases post 8.1.3 and 8.
alex wrote:
WARNING: relation "transaktion" TID 1240631/12: OID is invalid
ERROR: invalid page header in block 1240632 of relation "transaktion"
7. 2007/12/10 : We started the export of the data ( which runs every
morning ) for the last days again. These exports use the same
SQL-Commands as
"Geert Bijloos" <[EMAIL PROTECTED]> writes:
> Try this
> SET TIMEZONE TO 'CET';
> SELECT (timestamp with time zone '2000-01-01 UT' + interval '86 days 0 hours
> 5 min 0 sec') at time zone 'UT';
> "2000-03-26 23:05:00" -> WRONG
On what grounds do you claim that that's wrong?
alex <[EMAIL PROTECTED]> writes:
> Given that the problem occurred on two different machines we are very
> sure that it is *not* a hardware problem.
I wouldn't be so sure, especially not when the behavior looks like a
hardware problem in every other respect. You've heard of common-mode
failures,
The following bug has been logged online:
Bug reference: 3816
Logged by: Geert Bijloos
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3 and 8.2.4
Operating system: Linux
Description:Timezone bug
Details:
Try this
SET TIMEZONE TO 'CET';
SELECT (timestamp w
Hi folks,
we had reported about various database problems some weeks ago.
Since then we have updated the database to release 8.2.4 und the
linux kernel to 2.6.22.6-smp. Now we got an error again:
IN SHORT:
- data is inserted
- the same data is read and exported successfully
- after a nightly va
Simon Riggs wrote:
> On Fri, 2007-12-14 at 10:47 +0100, Adriaan van Os wrote:
> > Simon Riggs wrote:
> > > Sounds interesting but needs to be on pgsql-hackers, please.
> >
> > I posted a message to pgsql-hackers three times but it gets stalled (and
> > the owner of the list
> > doesn't reply).
On Fri, 2007-12-14 at 10:47 +0100, Adriaan van Os wrote:
> Simon Riggs wrote:
> > On Mon, 2007-12-10 at 12:31 +0100, hubert depesz lubaczewski wrote:
> >> On Sun, Dec 09, 2007 at 03:32:17PM +, Simon Riggs wrote:
> >>> ALTER SEQUENCE blah INCREMENT BY val;
> >> this has the sideeffect that all c
