Re: PostgreSQL x Oracle - Mailing list pgsql-general

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@pereira.com   |
>        / (_/ _ \__    [Math|99]-IMECC       |
> _______\____/_\___)___Unicamp_______________/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org