| From: | Mike Mascari <mascarm(at)mascari(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Yury Bokhoncovich <byg(at)center-f1(dot)ru>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Dan Langille <dan(at)langille(dot)org>, Roland Roberts <roland(at)astrofoto(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: (Fwd) Re: Any Oracle 9 users? A test please... |
| Date: | 2002-10-02 14:08:34 |
| Message-ID: | 3D9AFDE2.7070305@mascari.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Yury Bokhoncovich <byg(at)center-f1(dot)ru> writes:
>
>>As reported by my friend:
>>Oracle 8.1.7 (ver.9 behaves the same way):
>>[ to_char(sysdate) advances in a transaction ]
>
>
> Now I'm really confused; this directly contradicts the report of Oracle
> 8's behavior that we had earlier from Roland Roberts. Can someone
> explain why the different results?
Roland used an anonymous PL/SQL procedure:
SQL> begin
2 insert into rbr_foo select sysdate from dual;
[...wait about 10 seconds...]
3 insert into rbr_foo select sysdate from dual;
4 end;
5 /
PL/SQL procedure successfully completed.
SQL> select * from rbr_foo;
Oracle isn't processing those statements interactively. SQL*Plus
is waiting on the "/" to send the PL/SQL block to the database.
I suspect its not going to take Oracle more than a second to
insert a row...
Mike Mascari
mascarm(at)mascari(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2002-10-02 14:14:55 | Oracle beats up on Open Source Database(s) ... and gets beat back ... |
| Previous Message | Philip Warner | 2002-10-02 14:07:16 | Re: pg_dump and large files - is this a problem? |