Re: [SQL] Inquiry From Form [pgsql]

2003-07-03 Thread scott.marlowe
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

Re: [SQL] Inquiry From Form [pgsql]

2003-07-03 Thread Bruno Wolff III
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

Re: [SQL] SEQUENCE and PRIMARY KEY

2003-07-03 Thread Rod Taylor
> >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

Re: [SQL] need some help with a delete statement

2003-07-03 Thread scott.marlowe
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