Skip site navigation (1) Skip section navigation (2)

Re: (Fwd) Re: Any Oracle 9 users? A test please...

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Dan Langille <dan(at)langille(dot)org>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>,drek(at)smashpow(dot)net
Subject: Re: (Fwd) Re: Any Oracle 9 users? A test please...
Date: 2002-09-30 17:17:00
Message-ID: 200209301717.g8UHH1Q09337@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
OK, I just received this answer from an Oracle 9 tester.  It shows
CURRENT_TIMESTAMP changing during the transaction.  Thanks, Dan.

Dan, it wasn't clear if this was in a transaction or not.  Does Oracle
have autocommit off by default so you are always in a transaction?

---------------------------------------------------------------------------

Dan Langille wrote:
> A very quick answer:
> 
> ------- Forwarded message follows -------
> Date: Mon, 30 Sep 2002 13:03:51 -0400 (EDT)
> From: Agent Drek <drek(at)smashpow(dot)net>
> To: "freebsd-database(at)freebsd(dot)org" <freebsd-database(at)freebsd(dot)org>
> Cc: "freebsd-chat(at)freebsd(dot)org" <freebsd-chat(at)freebsd(dot)org>
> Subject: Re: Any Oracle 9 users?  A test please...
> In-Reply-To: <3D984877(dot)19685(dot)801EEC30(at)localhost>
> Message-ID: <Pine.BSF.4.44.0209301303030.50384-
> 100000(at)bang(dot)smashpow(dot)net>
> MIME-Version: 1.0
> Content-Type: TEXT/PLAIN; charset=US-ASCII
> Sender: owner-freebsd-database(at)FreeBSD(dot)ORG
> 
> On Mon, 30 Sep 2002, Dan Langille wrote:
> 
> > Date: Mon, 30 Sep 2002 12:49:59 -0400
> > From: Dan Langille <dan(at)langille(dot)org>
> > Reply-To: "freebsd-database(at)freebsd(dot)org"
> > <freebsd-database(at)freebsd(dot)org> To: "freebsd-database(at)freebsd(dot)org"
> > <freebsd-database(at)freebsd(dot)org> Cc: "freebsd-chat(at)freebsd(dot)org"
> > <freebsd-chat(at)freebsd(dot)org> Subject: Any Oracle 9 users?  A test
> > please...
> >
> > Followups to freebsd-database(at)freebsd(dot)org please!
> >
> > Any Oracle 9 users out there?
> >
> > I need this run:
> >
> >         BEGIN;
> >         SELECT CURRENT_TIMESTAMP;
> >         -- wait 5 seconds
> >         SELECT CURRENT_TIMESTAMP;
> >
> > Are those two timestamps the same?
> >
> > Thanks
> >
> 
> Our DBA says:
> 
> <snip from irc>
> 
> <data> SQL> SELECT current_timestamp FROM DUAL;
> <data> CURRENT_TIMESTAMP
> <data>
> ----------------------------------------------------------------------
> 
> ----- <data> 30-SEP-02 01.06.42.660969 PM -04:00 <data> SQL> SELECT
> current_timestamp FROM DUAL; <data> CURRENT_TIMESTAMP <data>
> ----------------------------------------------------------------------
> 
> ----- <data> 30-SEP-02 01.06.48.837372 PM -04:00 <data> (you have to
> include 'from dual' for 'non-table' selects)
> 
> --
>    Derek Marshall
> 
> Smash and Pow Inc > 'digital plumber'
> http://www.smashpow.net
> 
> 
> To Unsubscribe: send mail to majordomo(at)FreeBSD(dot)org
> with "unsubscribe freebsd-database" in the body of the message
> 
> ------- End of forwarded message -------
> -- 
> Dan Langille
> I'm looking for a computer job:
> http://www.freebsddiary.org/dan_langille.php
> 
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Responses

pgsql-hackers by date

Next:From: Josh BerkusDate: 2002-09-30 17:18:48
Subject: Re: [GENERAL] arrays
Previous:From: Mike SostericDate: 2002-09-30 17:04:48
Subject: Re: [GENERAL] arrays

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group