[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Postgresql feature
From:       snpe <snpe () snpe ! co ! yu>
Date:       2004-08-19 22:06:54
Message-ID: 200408200019.56244.snpe () snpe ! co ! yu
[Download RAW message or body]

Main features which Oracle have and postgresql no (for me):
- object dependency - when I change any object (view, function ..) in postgresql I have to delete all dependencies 
objects - Oracle auto compile all dependencies
- distributed databases - all dml, ddl, connect etc work in distributed systems
- true cursor managment - all oracle command are cursor (parse, bind, fetch arbitary numebr of rows)
- select out of transaction managment (select withoout mutable functions - don't update in database)

regards
On Wednesday 18 August 2004 02:41 pm, Gaetano Mendola wrote:
> Laimis K wrote:
> 
> > Hi,
> > I'm oracle man.
> > 
> > So, how about features in postgesql which exists in oracle db (order is
> > casual) ?
> > 1. Sequences
> > 2. Packages
> > 3. Functions/procedures
> > 4. Full-text
> > 5. Triggers
> > 6. Jobs
> > 7. Synonyms
> > 8. Replication
> 
> 1) Serial, but I don't know the Oracle one...
> 2) Schema ?
> 3) Yes, functions
> 4) tsearch2
> 5) Yes
> 6) ??
> 7) ??
> 8) A couple of solutions
> 
> 
> http://www.postgresql.org/docs/7.4/interactive/index.html
> 
> 
> Regards
> Gaetano Mendola
> 
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
[prev in list] [next in list] [prev in thread] [next in thread]