Re: PostgreSQL clustering VS MySQL clustering

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: 2005-01-21 16:08:41
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A75CD@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Uhmmm no :) There is no such thing as a select trigger. The closest
you
> would get
> is a function that is called via select which could be detected by
> making sure
> you are prepending with a BEGIN or START Transaction. Thus yes pgPool
> can be made
> to do this.

Technically, you can also set up a rule to do things on a select with DO
ALSO. However putting update statements in there would be considered (at
least by me) very bad form. Note that this is not a trigger because it
does not operate at the row level [I know you knew that already :-)].

Merlin

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2005-01-21 16:14:12 Re: inheritance performance
Previous Message Yann Michel 2005-01-21 16:05:39 Re: