Re: PostgreSQL x Oracle

Hi Marcelo,

I am starting with PostGreSQL and I have several installations on Oracle
8i and 9i running under Netware or linux platforms.

Things I would like to see on PostGreSQL that I have on Oracle 8i and 9i
(Perhaps already on PostGreSQL but I haven't could to find it):

-*- Much better transaction control.
===============================
I can do this on my oracle pl/sql procedures/functions, for example, but
not in my PostgreSQL (I think so):

BEGIN
INSERT INTO TABLE-A......
EXCEPTION
WHEN DUP_VAL_ON_INDEX THEN
BEGIN
UPDATE TABLE-A
INSERT INTO LOG-ERROR 'PARCIAL ERROR'...
EXCEPTION
INSERT INTO LOG-ERROR 'SEVERE ERROR'...
END
WHEN OTHERS THEN
BEGIN
INSERT INTO LOG-ERROR 'ERROR NUMBER:||SQLCODE||' ERROR MESSAGE:'||SQLERRM.....
EXCEPTION
NULL; -- Do nothing, but continue working...
END
END

-*- SavePoints.
==========
BEGIN
SAVEPOINT my_point;
UPDATE emp SET ... WHERE empno = emp_id;
...
SAVEPOINT my_point; -- move my_point to current point
INSERT INTO emp VALUES (emp_id, ...);
EXCEPTION
WHEN OTHERS THEN
ROLLBACK TO my_point;
END;

-*- Packages.
========
I can live whitout it but are pretty to maintain organized all my
procedures and functions.

-*- Default values on procedures and functions and FIELD NAMES on
DECLARATION. Ala Oracle:
==========================================================
CREATE OR REPLACE PROCEDURE MY_PROC(MY_FIRST SCHEMA.TABLE1.FIELDNAME%TYPE) AS
BEGIN
......
......
END MY_PROC.

-*- When I have object-2 (procedure, view, function, etc) and it use
object-1 (another procedure, function, view) and I modified object-1..
I'd like to PostGreSQL mark all dependent objects with "must compile" or
something similar to quickly be able to find all affected objects.

-*- Be able to put indexes on a disk and tables on another disk. I
think, perhaps, this may improve performance (but I am happy with
PostGreSQL performance).

How I said I am starting with PostgreSQL.. perhaps all of this may be
done already but I cannot to find it.

Greetings...

Marcelo Pereira wrote:
>
> Hi all,
>
> I have been using PostgreSQL to do everything I need, but people always
> ask me ``why PostgreSQL''.
>
> I use to tell that PostgreSQL is powerfull, but when they ask me to
> compare PostgreSQL with Oracle I get myself in troubles.
>
> I don't use Oracle!
>
> What does Oracle have that Postgresql doesn't have? Why does people
> continue thinking that Oracle is better than PostgreSQL?
>
> How can I compare it??
>
> See ya,
>
> Marcelo Pereira
>
> -- Remember that only God and ^[:w saves.
> __
> (_.\ © Marcelo Pereira |
> / / ___ marcelo(at)pereira(dot)com |
> / (_/ _ \__ [Math|99]-IMECC |
> _______\____/_\___)___Unicamp_______________/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org