Re: [GENERAL] deletion of records before commit doesn't work

Hello all, I just reproduced the same phenomenon on my installation (PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66) and it seems to me that maybe the index is not correctly actualized while inserting the record? It seems that any (!) update on blah (before executing the dele

[GENERAL] deletion of records before commit doesn't work

I've come up with this example and I want to know why it does what it does. -- snip -- You are now connected to database template1. CREATE DATABASE You are now connected to database testing. psql:test2.sql:11: NOTICE: CREATE TABLE/UNIQUE will create implicit index 'subdivs_name_key' for table 's