Re: [BUGS] 7.4: serial not working ?

2004-07-03 Thread Gaetano Mendola
vertigo wrote: Hello i upgraded postgresql from 7.3 to 7.4 and noticed that SERIAL exists but does not working. Example: My table: create table1( id SERIAL, name VARCHAR(100) ); insert into table1 (name) values('name1'); ERROR: duplicate key violates unique constraint "table1_pkey" Why ? I want to

Re: [BUGS] BUG #1186: Broken Index?

2004-07-03 Thread Gaetano Mendola
PostgreSQL Bugs List wrote: Hello All, We are using PostgreSQL 7.4.2 for our website that handles over 200,000 transactions a day. About a month ago, the responses from the SELECT queries on the database became terribly slow. We tried to anaylze the cause of the problem, searching throught the