Jeff <[EMAIL PROTECTED]> writes: > "PostgreSQL" <[EMAIL PROTECTED]> wrote: >> Why the result us CERO? the table have 1.400.000 rows!
> 1. did you remember to load data? > 2. did someone accidentally delete the data? > 3. are you connected to the correct db (I've panic'd before but realized > I was on dev, not production!)? > 4. sure that is the right table? I'm wondering about MVCC-related conditions, which adds a couple more questions: 5. Did you actually commit the transaction that loaded the rows? 6. Are you doing the SELECT COUNT(*) in a transaction that started before the data-loading transaction committed? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]