Re: [BUGS] BUG #2710: Intermittent hangs on sequence generation

2006-10-20 Thread Tom Lane
"Jason Palmer" <[EMAIL PROTECTED]> writes: > ... What we experience is bizarre. We can always > create tables with no sequences. But occasionally the database will hang > when we attempt to create a table with a sequence or foreign key. Yup, that's pretty bizarre. Is the backend consuming CPU

[BUGS] BUG #2710: Intermittent hangs on sequence generation

2006-10-20 Thread Jason Palmer
The following bug has been logged online: Bug reference: 2710 Logged by: Jason Palmer Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Redhat enterprise 4 Description:Intermittent hangs on sequence generation Details: We can't exactly pinpo

[BUGS] BUG #2709: how to start postgresql at startup

2006-10-20 Thread manoj
The following bug has been logged online: Bug reference: 2709 Logged by: manoj Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: redhat 9 Description:how to start postgresql at startup Details: how to start postgresql at startup -

Re: [BUGS] BUG #2698: Update table alias not supported

2006-10-20 Thread Lachhman Dass
Most of the relational database support that like : Oracle, DB2, MS SQL Server, Cloudscape, Derby ... and many more. Lachhman Dass -Original Message- From: Peter Eisentraut [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 12:32 PM To: pgsql-bugs@postgresql.org Cc: Lachhman Dass

[BUGS] BUG #2708: Saving '\0' to bpchar by jdbc driver 8.1-407.jdbc3

2006-10-20 Thread Shutra
The following bug has been logged online: Bug reference: 2708 Logged by: Shutra Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5-1 Operating system: Windows or Linux Description:Saving '\0' to bpchar by jdbc driver 8.1-407.jdbc3 Details: Refer: http://open

Re: [BUGS] Bug in 8.1.5: cannot add literal timestamp value and a interval.

2006-10-20 Thread Tom Lane
"j.random.programmer" <[EMAIL PROTECTED]> writes: > This is a regression bug between 8.1.4 and 8.1.5 > '2006-10-20 00:00:00' + interval '5' second No, I don't think so. Every PG release back to the beginning of time will think that is an interval + interval addition. That's one of the system'

[BUGS] Bug in 8.1.5: cannot add literal timestamp value and a interval.

2006-10-20 Thread j.random.programmer
Hi: This is a regression bug between 8.1.4 and 8.1.5 '2006-10-20 00:00:00' + interval '5' second With 8.1.4, the following worked fine. However with 8.1.5, this gives the following error. test=# select ('2006-10-20 00:00:00' + interval '5' second) ; ERROR: invalid input syntax for type inter

Re: [BUGS] backup + restore fails

2006-10-20 Thread Andreas Seltenreich
Holger Schoenen writes: > ERROR: invalid byte sequence for encoding "UTF8": 0xe46973 > Command was: -- [...] > -- Started on 2006-09-15 14:56:51 Westeuropäische Normalzeit The same problem was recently reported on the pgsql-de-allgemein list. Would just avoiding %Z in Win32's strftime be an

Re: [BUGS] Freezing is not WAL-logged

2006-10-20 Thread Alvaro Herrera
Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > My idea was to move relminxid to a new pg_class_nt non-transactional > > catalog in 8.3, but we certainly need to give a solution for the problem > > in 8.2. > > Didn't we pretty much shoot down the idea of a nontransactional > exten

Re: [BUGS] Freezing is not WAL-logged

2006-10-20 Thread Jim C. Nasby
On Fri, Oct 20, 2006 at 09:49:47AM +0100, Heikki Linnakangas wrote: > Alvaro Herrera wrote: > >Tom Lane wrote: > >>"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > >>>I just noticed that freezing a tuple (in vacuumlazy.c) is not > >>>WAL-logged. > >>The theory is that this doesn't matter because

Re: [BUGS] Freezing is not WAL-logged

2006-10-20 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > My idea was to move relminxid to a new pg_class_nt non-transactional > catalog in 8.3, but we certainly need to give a solution for the problem > in 8.2. Didn't we pretty much shoot down the idea of a nontransactional extension catalog as being not wort

Re: [BUGS] Freezing is not WAL-logged

2006-10-20 Thread Alvaro Herrera
Heikki Linnakangas wrote: > Alvaro Herrera wrote: > >Tom Lane wrote: > >>"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > >>>I just noticed that freezing a tuple (in vacuumlazy.c) is not > >>>WAL-logged. > >>The theory is that this doesn't matter because the tuple is committed > >>either way ...

Re: [BUGS] Freezing is not WAL-logged

2006-10-20 Thread Heikki Linnakangas
Alvaro Herrera wrote: Tom Lane wrote: "Heikki Linnakangas" <[EMAIL PROTECTED]> writes: I just noticed that freezing a tuple (in vacuumlazy.c) is not WAL-logged. The theory is that this doesn't matter because the tuple is committed either way ... it's equivalent to a hint-bit update which we do

Re: [BUGS] BUG #2698: Update table alias not supported

2006-10-20 Thread Peter Eisentraut
Lachhman Dass wrote: > In the Update statement alias must be supported Says who? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster