Re: Postgresql feature - Mailing list pgsql-general

If you use it enough, I think it is inevitable that something,
sometime, somewhere will really honk you
off about Oracle. With the feature bloat they're into these days, very
likely it will be something
you care nothing about that does it, too.

On Aug 18, 2004, at 2:08 PM, Ben wrote:

> Is it just me, or has there been a rash of "I'm thinking about postgres
> and coming from an oracle background" questions recently? Was there
> some
> writeup of postgres in a db rag in the last month or so?
>
> On Wed, 18 Aug 2004, John Sidney-Woollett wrote:
>
>> Bit more info (from my own findings migrating from Oracle -> Postgres)
>>
>> Sequences - YES
>> Packages - NO (concept doesn't exist in PG)
>> Functions - YES, Procedures - NO (also no INOUT or OUT parameters)
>> Full-text - YES, tSearch2
>> Triggers - YES
>> Jobs - NO, (but scheduled tasks can be implemented in other ways)
>> Synonyms - NO (can be frigged using search_paths and schemas)
>> Replication - more than one option depending on requirement
>>
>> You will miss certain Oracle features, but once you get into the swing
>> of postgres you'll not look back. Also consider how much money you'll
>> save in license fees!
>>
>> John Sidney-Woollett
>>
>> 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 1: subscribe and unsubscribe commands go to
>> majordomo@postgresql.org
>>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>
--------------------

Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com