On Thu, 3 Jul 2003, Bruno Wolff III wrote:
> On Wed, Jul 02, 2003 at 16:26:09 -0300,
> Chris Schneider <[EMAIL PROTECTED]> wrote:
> > I know this is basic, but couldn\'t find and in a hurry to know the answer. When
> > interfacing with PostgreSQL through PSQL, it appears that DML statements ar
On Wed, Jul 02, 2003 at 16:26:09 -0300,
Chris Schneider <[EMAIL PROTECTED]> wrote:
> I know this is basic, but couldn\'t find and in a hurry to know the answer. When
> interfacing with PostgreSQL through PSQL, it appears that DML statements are
> auto-commited, that is, a change I make in one
> >A trigger (maybe a rule) is the way to go about this.
> >
> >The alternative is to teach the bad clients to use DEFAULT rather than
> >NULL when they expect the GENERATOR to create the value for them.
> >
> Hmm, Rod, there really seems a demand for the GENERATOR feature :-)
> Do you see any perf
On Wed, 2 Jul 2003, Matthew Hixson wrote:
> Thanks for all your help, Scott. A friend of mine whipped out this
> script which runs a lot faster than trying to use the original query I
> posted.
>-M@
>
> begin;
> create temporary table cart_temp as select distinct a.cart_id,
> a.cart_cookie