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
Thanks 10 1662
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/i...ive/index.html
Regards
Gaetano Mendola
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/i...ive/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 ma*******@postgresql.org
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/i...ive/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 ma*******@postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
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/i...ive/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 ma*******@postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
--------------------
Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114 www.ravensfield.com
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
On Wed, 18 Aug 2004 14:29:03 -0400 Andrew Rawnsley <ro**@ravensfield.com> wrote: 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.
the size of the frigging download is enough to honk nearly
anyone off.
the thing is what, two orders of magnitude bigger than all of
PostgreSQL?
richard
--
Richard Welty rw****@averillpark.net
Averill Park Networking 518-573-7592
Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
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)
You can create a schema to put all your functions/procedures in it and provide
access control to it.
I think it is good enough emulation of packages barring compiling them to detect
errors in pl/sql code.
This has been mentioned before and few people reported it to be good enough
workaround..
HTH
Shridhar
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly
Amen to that. I have to use Oracle at work, but I use PostgreSQL for
all my side stuff. Man do I ever miss psql when I'm in SQL*Plus...
On Aug 18, 2004, at 12:29 PM, Andrew Rawnsley wrote: 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/i...ive/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 ma*******@postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to ma*******@postgresql.org) --------------------
Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives? http://archives.postgresql.org
On Wed, 2004-08-18 at 13:53, John Sidney-Woollett wrote: Bit more info (from my own findings migrating from Oracle -> Postgres) Jobs - NO, (but scheduled tasks can be implemented in other ways)
There is a project on gborg (or maybe pgfoundry) called pgjobs which
aims to create an oracle like task schedular in postgresql. not sure how
mature it is but might be worth a look for those interested in this.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly
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/i...ive/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
On Wed, 2004-08-18 at 05:06, 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
Might want to check the postgresql documentation. ;-)
-Robby
--
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | ro***@planetargon.com
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
****************************************/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
iD8DBQBBJUpB0QaQZBaqXgwRAgleAJ4+DysACPCqH8IX675qQe TcSVLhNACguDQF
ov4mJ5BcnWexqeGar10FG04=
=nyiG
-----END PGP SIGNATURE----- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Google Mike |
last post by:
I had a problem today where I had an editor page (edit2.php) that
posted data to PostgreSQL, and then a view page (view.php) that read
it in and displayed it. At first I thought this was an MVCC...
|
by: David Simpson |
last post by:
..com Solutions Inc. has released FmPro Migrator 1.97 Enterprise Edition with
a new FileMaker to PostgreSQL migration feature. Images within FileMaker
container fields are automatically migrated to...
|
by: Mateusz [PEYN] Adamus |
last post by:
Hi
I'm a developer currently wondering which DB choose for my next project.
I looked on the net found ofcourse Oracle but also came up with
PostgreSQL. I heard quite few things about it, all...
|
by: Sarah Tanembaum |
last post by:
Beside its an opensource and supported by community, what's the fundamental
differences between PostgreSQL and those high-price commercial database (and
some are bloated such as Oracle) from...
|
by: John Wells |
last post by:
Yes, I know you've seen the above subject before, so please be gentle with
the flamethrowers.
I'm preparing to enter a discussion with management at my company
regarding going forward as either...
| |
by: Alex Page |
last post by:
I haven't used PostgreSQL for nearly a year now, and when I was last
using it there was some discussion on versioning control being
introduced as a feature. Basically, for some data, I'd like to...
|
by: Jeff Bowden |
last post by:
For ease of configuration and other reasons, I would like for my
single-user GUI app to be able to use postgresql in-process as a library
accessing a database created in the users home directory. ...
|
by: nd02tsk |
last post by:
Hello
MySQL has information about several storage engines. MEMORY to handle
temporary tables, InnoDB to handle transactions and which also can split
its table data over several files/partitions....
|
by: Mike Cox |
last post by:
Obviously, there cannot be 21 postgresql groups in the comp.* hierarchy.
Many of the 21 are not used that often, and would not be of much popularity
to those on usenet.
I did a check on...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |