[plug] SQL Servers

[John Breen]

(Removes nether appendage from mouth)

Yes, I should have mentioned that in the first place.  Also doesn't help
that the Oracle tools I'm using aren't by Oracle and do an automatic commit.
In fact, that's quite dangerous come to look at it.  Especially if, like me,
you're working on a production environment.

Cheers,


John

John Breen
Programmer
United Construction Pty Ltd

(08) 9499-0472
0413-462-818
john.breen at unitedconstruction.com.au




-----Original Message-----
From:	John Summerfield [SMTP:summer at os2.ami.com.au]
Sent:	Sunday, September 12, 1999 5:15 AM
To:	plug at linux.org.au
Subject:	[plug] SQL Servers


> >FWIW, Oracle will happily return uncommited data to a query...

Snip 
> 
> Just to clarify that - it only returns uncommitted data that was altered
> within the same session as the query.  Queries running in other sessions
> won't see the data until it is committed.

I'm glad to hear that. Unfortunately, PG has no such compunction; it 
returns uncommitted data to anyone.


-- 
Cheers
John Summerfield
http://os2.ami.com.au/os2/ for OS/2 support.
Configuration, networking, combined IBM ftpsites index.