Postgres Pro
Downloads
Home   >   mailing lists

Live records and number of records are differents... - Mailing list pgsql-general

From F T
Subject Live records and number of records are differents...
Date
Msg-id BANLkTi=t3QcRb5ag8x267Civh8i8TnHPiw@mail.gmail.com
Whole thread Raw
Responses Re: Live records and number of records are differents...
Re: Live records and number of records are differents...
List pgsql-general
Tree view
Hello list,

I use PostgreSQL 8.4 and Postgis 1.4.

I use FME to insert 772185 records in a table (multipolygons that represent parcels).

Everything seems fine but...
If I type select count(*), I get the right number of records : 772185 records.

But If I use pgAdmin and have a look in the stats :
- row inserted = 772185 OK fine,
- but the number of live rows is 772308...

I don't understand why the number of live rows and the number of rows is différent...
Any explaination would be very appreciated !
Thanks you

Fabrice



Attachment

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: to_timestamp() and timestamp without time zone
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Live records and number of records are differents...