Re: Sequences - problem

From: Ludwig Meyerhoff <ludwig(at)antar(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sequences - problem
Date: 2001-05-05 19:31:52
Message-ID: Pine.LNX.4.21.0105052131260.21925-100000@ludwig
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Rasch 2001-05-05 20:05:18 Re: Web-based Problem/Project tracking system ...
Previous Message Stephan Szabo 2001-05-05 19:26:46 Re: Sequences - problem