On Fri, 4 Aug 2006, Luiz Henrique wrote: > Hi, could you tell me how postgresql look for a referenced key? It looks in > table index? Maybe only the index is corrupted?
It basically runs a query like: SELECT * FROM parenttable WHERE keycol1 = ? [AND keycol2 = ? ...] FOR SHARE It should act like a prepared statement would (which might be different than it would with the ?s replaced by the actual values). ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
