Re: Sequences - problem - Mailing list pgsql-general

From Ludwig Meyerhoff
Subject Re: Sequences - problem
Date
Msg-id Pine.LNX.4.21.0105052131260.21925-100000@ludwig
Whole thread Raw
In response to Re: Sequences - problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Hallo!

> In addition, the sequence value is not a good representation of number
> of rows anyway, since you may have deleted rows or non-committed rows
> (errors, rollback).  If you want number of rows in table, you want
> select count(*) from table.
thx! Seems to work fine!



Saluti!

Ludwig


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Sequences - problem
Next
From: Chris Rasch
Date:
Subject: Re: Web-based Problem/Project tracking system ...