| From: | Enrico Pirozzi <sscotty71(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Records Number |
| Date: | 2009-03-17 14:09:02 |
| Message-ID: | 5d038c780903170709s18793918g1b82e06996951d1a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> If you want an accurate, up-to-date count then you'll need to use
> count(*) or have a trigger keep a summary-count for you. A simple
> implementation will reduce concurrency to writes on that table however.
Yes I solved by a trigger....
> Lots of discussion in the mailing-list archives on this.
Thank you for your time
Enrico
--
That's one small step for man; one giant leap for mankind
Enrico Pirozzi
Tel. +39 0861 1855771
Mob.+39 328 4164437
Fax +39 0861 1850310
www.enricopirozzi.info
info(at)enricopirozzi(dot)info
Skype sscotty71
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Colombo | 2009-03-17 14:10:53 | Re: Maximum transaction rate |
| Previous Message | Stephen Frost | 2009-03-17 14:04:09 | Re: Uploading data to postgresql database |