Re: PostgreSQL x Oracle - Mailing list pgsql-general
From | Terry Yapt |
---|---|
Subject | Re: PostgreSQL x Oracle |
Date | |
Msg-id | 3E48D370.C33DA077@technovell.com Whole thread Raw |
In response to | PostgreSQL x Oracle (Marcelo Pereira <gandalf@sum.desktop.com.br>) |
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
pgsql-general by date: