[BUGS] BUG #2658: Query not using index

2006-09-30 Thread Graham Davis
The following bug has been logged online: Bug reference: 2658 Logged by: Graham Davis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Linux Description:Query not using index Details: I know that in version 8 you guys added support so tha

[BUGS] BUG #2661: select time with time zone not converting

2006-09-30 Thread Harry Hehl
The following bug has been logged online: Bug reference: 2661 Logged by: Harry Hehl Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Linux Description:select time with time zone not converting Details: The "select timestamp with time zone

[BUGS] BUG #2664: date_trunc('quarter', ...)

2006-09-30 Thread Yoshihisa Nakano
The following bug has been logged online: Bug reference: 2664 Logged by: Yoshihisa Nakano Email address: [EMAIL PROTECTED] PostgreSQL version: All Operating system: All Description:date_trunc('quarter', ...) Details: 'quarter' is not mentioned in the doc as valid fi

[BUGS] BUG #2660: Cannot install ISN extension when charset=UTF88

2006-09-30 Thread Tim N. van der Leeuw
The following bug has been logged online: Bug reference: 2660 Logged by: Tim N. van der Leeuw Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2beta1 Operating system: WinXP Pro, SP2 Description:Cannot install ISN extension when charset=UTF88 Details: When ins

[BUGS] BUG #2663: backup with oids don't save table oids

2006-09-30 Thread Cemin Giovanni
The following bug has been logged online: Bug reference: 2663 Logged by: Cemin Giovanni Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: linux Description:backup with oids don't save table oids Details: I have a database that uses table oid

[BUGS] BUG #2665: VC++ 8 (Visual Studio 2005)

2006-09-30 Thread Oliver Artelt
The following bug has been logged online: Bug reference: 2665 Logged by: Oliver Artelt Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 beta 1 Operating system: WinXP + SP2 Description:VC++ 8 (Visual Studio 2005) Details: ... the libpq doesn't compile becaus

[BUGS] BUG #2667: vacuuming a 70GB table causes a "crash"

2006-09-30 Thread Stephen R. van den Berg
The following bug has been logged online: Bug reference: 2667 Logged by: Stephen R. van den Berg Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Linux 2.6.16.20 Debian (pg: 8.1.4-6) Description:vacuuming a 70GB table causes a "crash" Detai

[BUGS] BUG #2666: how do cluster with 7.4.13 ?

2006-09-30 Thread how to cluster
The following bug has been logged online: Bug reference: 2666 Logged by: how to cluster Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.13 Operating system: i586 Description:how do cluster with 7.4.13 ? Details: how do cluster with 7.4.13 ? ---

Re: [BUGS] BUG #2667: vacuuming a 70GB table causes a "crash"

2006-09-30 Thread Tom Lane
"Stephen R. van den Berg" <[EMAIL PROTECTED]> writes: > datalog=# vacuum verbose fnetsense; > INFO: vacuuming "public.fnetsense" > PANIC: right sibling is not next child in "fnetsense_utstamp_key" > server closed the connection unexpectedly Were you running with full_page_writes off during some

Re: [BUGS] BUG #2660: Cannot install ISN extension when charset=UTF88

2006-09-30 Thread Tom Lane
"Tim N. van der Leeuw" <[EMAIL PROTECTED]> writes: > a database command error occurred whilst executing 'C:\Program > Files\PostgreSQL\8.2beta1\share\contrib\isn.sql': > ERROR: Invalid byte sequence for encoding "UTF8": 0xe1620 Good catch ... we're going to have to remove the non-ASCII characters