Thank to all I was in the WRONG database. Sorry, and thanks!
-----Original Message----- From: Tom Lane <[EMAIL PROTECTED]> To: Jeff <[EMAIL PROTECTED]> Cc: "PostgreSQL" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Date: Fri, 31 Oct 2003 16:27:31 -0500 Subject: Re: [ADMIN] SELECT COUNT(*)... returns 0 ROWS > 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] ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
