pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedOracle Porting, Compiere
9+ messages / 5 participants
[nested] [flat]
* Oracle Porting, Compiere
@ 2003-03-31 22:16 John Huttley <john@mwk.co.nz>
0 siblings, 2 replies; 9+ messages in thread
From: John Huttley @ 2003-03-31 22:16 UTC (permalink / raw)
To: pgsql-interfaces
For those interested in porting from Oracle to PG, refer
http://www.compiere.org/technology/pg/index.html
Compiere is an Open Source accounting system designed around Oracle.
It uses Oracle features extensively. The desire to port this to
PG shows some of the present limitations in PG.
I seem to recall that someone has a patch for hierarchal Queries.
For your interest,
john
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Oracle Porting, Compiere
@ 2003-03-31 22:45 Bruce Momjian <pgman@candle.pha.pa.us>
parent: John Huttley <john@mwk.co.nz>
1 sibling, 1 reply; 9+ messages in thread
From: Bruce Momjian @ 2003-03-31 22:45 UTC (permalink / raw)
To: John Huttley <john@mwk.co.nz>; +Cc: pgsql-interfaces
Yes, we do. It is in my mailbox and we are hoping someone will make it
standards-compliant via SQL99 recursive queries.
---------------------------------------------------------------------------
John Huttley wrote:
> For those interested in porting from Oracle to PG, refer
>
> http://www.compiere.org/technology/pg/index.html
>
> Compiere is an Open Source accounting system designed around Oracle.
> It uses Oracle features extensively. The desire to port this to
> PG shows some of the present limitations in PG.
>
> I seem to recall that someone has a patch for hierarchal Queries.
>
> For your interest,
>
> john
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Oracle Porting, Compiere
@ 2003-03-31 23:06 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 9+ messages in thread
From: Tom Lane @ 2003-03-31 23:06 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: John Huttley <john@mwk.co.nz>; pgsql-interfaces
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Yes, we do. It is in my mailbox and we are hoping someone will make it
> standards-compliant via SQL99 recursive queries.
Andrew Overholt of Red Hat is in fact looking at SQL99 recursive
queries. I will not promise that he'll have it done in time for 7.4,
but something should emerge by and by.
regards, tom lane
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Oracle Porting, Compiere
@ 2003-04-01 03:48 Tom Lane <tgl@sss.pgh.pa.us>
parent: John Huttley <john@mwk.co.nz>
1 sibling, 1 reply; 9+ messages in thread
From: Tom Lane @ 2003-04-01 03:48 UTC (permalink / raw)
To: John Huttley <john@mwk.co.nz>; +Cc: pgsql-interfaces
John Huttley <john@mwk.co.nz> writes:
> For those interested in porting from Oracle to PG, refer
> http://www.compiere.org/technology/pg/index.html
I can't see any indication of the date this was written --- but I get
the feeling it dates back a bit. At least some of the issues mentioned
have been solved in recent PG releases.
regards, tom lane
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Oracle Porting, Compiere
@ 2003-04-01 04:55 John Huttley <john@mwk.co.nz>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 9+ messages in thread
From: John Huttley @ 2003-04-01 04:55 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-interfaces
This isn't more that a month or two old.
The previous version worried about nested transactions.
I know Bruce has been thinking about that for a while now, so possibly
that was crossed off as 'fixed'. The 7.4 Docs cover the unlimited
precision "NUMERIC" type, so perhaps that also should be crossed off.
The use of 'out' parameters sounds hairy though.
Regards
john
On Tue, 2003-04-01 at 15:48, Tom Lane wrote:
> John Huttley <john@mwk.co.nz> writes:
> > For those interested in porting from Oracle to PG, refer
> > http://www.compiere.org/technology/pg/index.html
>
> I can't see any indication of the date this was written --- but I get
> the feeling it dates back a bit. At least some of the issues mentioned
> have been solved in recent PG releases.
>
> regards, tom lane
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Oracle Porting, Compiere
@ 2003-04-01 05:13 Tom Lane <tgl@sss.pgh.pa.us>
parent: John Huttley <john@mwk.co.nz>
0 siblings, 1 reply; 9+ messages in thread
From: Tom Lane @ 2003-04-01 05:13 UTC (permalink / raw)
To: John Huttley <john@mwk.co.nz>; +Cc: pgsql-interfaces
John Huttley <john@mwk.co.nz> writes:
> This isn't more that a month or two old.
Okay, it wasn't real clear...
> The previous version worried about nested transactions.
It still should. I see no prospect that nested xacts will be in 7.4,
and I wouldn't care to bet they'll be in the release or two after ...
On a more positive note:
* NUMERIC does indeed do the unspecified-precision thing.
* If you can't be bothered to rename datatypes, CREATE DOMAIN would
serve to provide Oracle-compatible names for Postgres datatypes.
There is some parse-time overhead associated though.
* CREATE OR REPLACE does exist for some object types now --- views and
functions for sure, don't recall anything else.
* Postgres *does* do sub-SELECT-in-FROM, which is what I think is meant
by the references to embedded views.
* On the outer join syntax issue: PG supports the SQL-standard syntax,
which I believe is also supported by recent Oracle releases. Consider
migrating away from Oracle's proprietary syntax.
regards, tom lane
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Oracle Porting, Compiere
@ 2003-04-01 05:33 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 9+ messages in thread
From: Bruce Momjian @ 2003-04-01 05:33 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: John Huttley <john@mwk.co.nz>; pgsql-interfaces; alvherre@dcc.uchile.cl
Tom Lane wrote:
> John Huttley <john@mwk.co.nz> writes:
> > This isn't more that a month or two old.
>
> Okay, it wasn't real clear...
>
> > The previous version worried about nested transactions.
>
> It still should. I see no prospect that nested xacts will be in 7.4,
> and I wouldn't care to bet they'll be in the release or two after ...
Actually, Alvaro Herrera is working on it as a college project. I don't
know the completion date, but I am sure it will be in 7.5, if not in
7.4. I am CC'ing him for a comment.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Oracle Porting, Compiere
@ 2003-04-01 19:25 Alvaro Herrera <alvherre@dcc.uchile.cl>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 9+ messages in thread
From: Alvaro Herrera @ 2003-04-01 19:25 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; John Huttley <john@mwk.co.nz>; pgsql-interfaces; Manfred Koizar <mkoi-pg@aon.at>
On Tue, Apr 01, 2003 at 12:33:52AM -0500, Bruce Momjian wrote:
> Tom Lane wrote:
> > It still should. I see no prospect that nested xacts will be in 7.4,
> > and I wouldn't care to bet they'll be in the release or two after ...
>
> Actually, Alvaro Herrera is working on it as a college project. I don't
> know the completion date, but I am sure it will be in 7.5, if not in
> 7.4. I am CC'ing him for a comment.
Yes, there's some progress in my private tree. As soon as I can make it
bootstrap I'll post a patch for comment. I expect to have it for 7.4,
althought I'm not sure if I will be able to do the pg_clog and
pg_subtrans stuff. Manfred Koizar said he wanted to work on that, but I
dunno if he is.
I am CC'ing him for a comment :-)
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No hay ausente sin culpa ni presente sin disculpa" (Prov. frances)
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Oracle Porting, Compiere
@ 2003-04-02 12:51 Manfred Koizar <mkoi-pg@aon.at>
parent: Alvaro Herrera <alvherre@dcc.uchile.cl>
0 siblings, 0 replies; 9+ messages in thread
From: Manfred Koizar @ 2003-04-02 12:51 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@dcc.uchile.cl>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; Tom Lane <tgl@sss.pgh.pa.us>; John Huttley <john@mwk.co.nz>; pgsql-interfaces
On Tue, 1 Apr 2003 15:25:52 -0400, Alvaro Herrera
<alvherre@dcc.uchile.cl> wrote:
> pg_clog and
>pg_subtrans stuff. Manfred Koizar said he wanted to work on that, but I
>dunno if he is.
Yes, he is. Although there's some discussion whether my proposal is
the best way to do it ...
Servus
Manfred
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2003-04-02 12:51 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-31 22:16 Oracle Porting, Compiere John Huttley <john@mwk.co.nz>
2003-03-31 22:45 ` Bruce Momjian <pgman@candle.pha.pa.us>
2003-03-31 23:06 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-04-01 03:48 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-04-01 04:55 ` John Huttley <john@mwk.co.nz>
2003-04-01 05:13 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-04-01 05:33 ` Bruce Momjian <pgman@candle.pha.pa.us>
2003-04-01 19:25 ` Alvaro Herrera <alvherre@dcc.uchile.cl>
2003-04-02 12:51 ` Manfred Koizar <mkoi-pg@aon.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox