| From: | Doug McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: *sigh* |
| Date: | 2003-11-30 03:37:06 |
| Message-ID: | 8765h2y1b1.fsf@asmodeus.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
> Doug McNaught wrote:
>> Because different sessions have a (validly) different concept of what
>> that number should be, due to MVCC.
>
> The count(*) information can be revisioned too, am I wrong ? I'm able to
> create a trigger that store the count(*) information in a special table,
> why not implement the same in a way "builded in" ?
This has been discussed extensively before (last time was a few months
ago); please search the archives if you're curious.
-Doug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2003-11-30 04:01:14 | Using Views |
| Previous Message | Doug McNaught | 2003-11-30 03:28:39 | Re: Was: Triggers, Stored Procedures, PHP |