Re: [SPAM] Re: [SPAM] Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-08-27 Thread Feng Chen
m length of identifiers:64 Maximum columns in an index: 32 Date/time type storage: floating-point numbers Maximum length of locale name:128 LC_COLLATE: C LC_CTYPE: C -Original Message- From: Feng Ch

Re: [SPAM] Re: [SPAM] Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-08-24 Thread Feng Chen
counter when it happens again. Thanks! -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 12:11 PM To: Stefan Kaltenbrunner Cc: Feng Chen; Alvaro Herrera; Gregory Stark; Marc Schablewski; Decibel!; pgsql-bugs@postgresql.org Subject: [SPAM] Re: [SPAM]

Re: [SPAM] Re: [SPAM] Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-08-24 Thread Feng Chen
Thanks for the replies! I guess it's time for 8.1.9 then. Will keep you informed afterwards! -Original Message- From: Andrew Sullivan [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 10:14 AM To: Andrew Sullivan Cc: Feng Chen; Alvaro Herrera; Gregory Stark; Marc Schabl

Re: [SPAM] Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-08-24 Thread Feng Chen
VERSION = PostgreSQL 8.1.2 -Original Message- From: Alvaro Herrera [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 10:02 AM To: Feng Chen Cc: Gregory Stark; Marc Schablewski; Decibel!; pgsql-bugs@postgresql.org Subject: [SPAM] Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt

Re: [BUGS] BUG #3484: Missing pg_clog file / corrupt index

2007-08-24 Thread Feng Chen
We also have the same exact problem - every 5 to 10 days when the data get to some size, PostgreSQL complains about missing pg_clog files, and invalid page headers during either vacuum or reindex operations. The problem happens on different customer sites with Linux 2.6.11. There is one particula

Re: [BUGS] pg_dump and truncate

2007-02-22 Thread Feng Chen
me-archive.gz contains data up to Data-0. However, the truncated database does not have Data-1, Data-2, and Data-3 in it! Why is that? I thought truncate supports transaction now - we use PostgreSQL 8.1.2. Thank you! Feng -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] S

[BUGS] pg_dump and truncate

2007-02-21 Thread Feng Chen
Hello there, I was trying to do a live db archive using the following steps: 1. Open a connection to the database; 2. With the connection, do the following: BEGIN; SET transaction ISOLATION level SERIALIZABLE; 3. Execute the following from the Linux shell: pg_dump dbname

[BUGS] Postgres Stored Procedure Call Function Return Type OID Caching Problem

2007-01-24 Thread Feng Chen
Hello, I'm wondering if anyone has experienced the same problem and is it fixed in the new Postgres release (We use Posgtgres 8.1.2, psqlodbc.so 7.2.5 (moving to 8.2.200), unixODBC 2.2.11 (moving to 2.2.12), running on Linux OS.): We have a recurring problem that the return type (a customer def

[BUGS] SP function return type id caching problem

2007-01-24 Thread Feng Chen
Hello, I'm wondering if anyone has experienced the same problem and is it fixed in the new Postgres release (We use Posgtgres 8.1.2, psqlodbc.so 7.2.5 (moving to 8.2.200), unixODBC 2.2.11 (moving to 2.2.12), running on Linux OS: We have a recurring problem that the return type (a customer defin