Re: [GENERAL] ERROR: concurrent insert in progress

2008-06-28 Thread Ganbold
hanks, Ganbold Lennin Caro wrote: use REINDEX REINDEX ip_dst_idx OR REINDEX table_name http://www.postgresql.org/docs/8.3/static/sql-reindex.html tell us the result thank --- On *Fri, 6/27/08, Ganbold /<[EMAIL PROTECTED]>/* wrote: From: Ganbold <[EMAIL PROTECTED]> Subject

[GENERAL] ERROR: concurrent insert in progress

2008-06-26 Thread Ganbold
1921693 row versions HINT: Rebuild the index with REINDEX. ERROR: could not read block 988 of relation 1663/16384/16472: Input/output error snort=# reindex index ip_src_idx; ERROR: concurrent insert in progress How to solve this problem? Is there any other method fixing the index? thanks

Re: [GENERAL] postgresql books and convertion utilities

2006-10-30 Thread Ganbold
Hi, David Fetter wrote: On Mon, Oct 30, 2006 at 09:10:36AM -0500, Chander Ganesan wrote: Ganbold wrote: Hi, I'm new to postgresql and I'm looking for references and books. We are usually coding in php/C. Can somebody recommend me good books wh

[GENERAL] postgresql books and convertion utilities

2006-10-29 Thread Ganbold
least DB (tables, indexes, queries)? Are there any tools that can convert php functions and database from mysql to postgresql? thanks in advance, Ganbold ---(end of broadcast)--- TIP 6: explain analyze is your friend