agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedOracle PL/SQL to pg/PSQL conversion documentation.
5+ messages / 3 participants
[nested] [flat]
* Oracle PL/SQL to pg/PSQL conversion documentation.
@ 2015-12-02 20:44 Michael Moore <michaeljmoore@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Michael Moore @ 2015-12-02 20:44 UTC (permalink / raw)
To: pgsql-sql
Ideally I would like to see some template/example documentation of common
feature conversion solutions. For example, "If you have a pl/sql TABLE
function, you can do the same thing in postgres this way ..." I can
generally Google specific problems and after enough time weeding out the
garbage, I can usually find what I want, but maybe somebody has it all in
one nice neat document and I just don't know about it.
Any links to such a resource would be greatly appreciated as well as any
other links which you think I might find useful.
Thanks,Mike
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle PL/SQL to pg/PSQL conversion documentation.
@ 2015-12-02 20:47 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Michael Moore <michaeljmoore@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Adrian Klaver @ 2015-12-02 20:47 UTC (permalink / raw)
To: Michael Moore <michaeljmoore@gmail.com>; pgsql-sql
On 12/02/2015 12:44 PM, Michael Moore wrote:
> Ideally I would like to see some template/example documentation of
> common feature conversion solutions. For example, "If you have a pl/sql
> TABLE function, you can do the same thing in postgres this way ..." I
> can generally Google specific problems and after enough time weeding out
> the garbage, I can usually find what I want, but maybe somebody has it
> all in one nice neat document and I just don't know about it.
> Any links to such a resource would be greatly appreciated as well as any
> other links which you think I might find useful.
http://www.postgresql.org/docs/9.4/interactive/plpgsql-porting.html
> Thanks,Mike
>
--
Adrian Klaver
adrian.klaver@aklaver.com
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle PL/SQL to pg/PSQL conversion documentation.
@ 2015-12-02 21:02 Michael Moore <michaeljmoore@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 0 replies; 5+ messages in thread
From: Michael Moore @ 2015-12-02 21:02 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-sql
Thanks Adrian. I've seen that one before, and it is indeed very useful.
Unfortunately it does not address many of the features that need
converting. For example, how to deal with a BULK COLLECT, TABLE functions,
context variables. Maybe I am hoping for too much. Again, thanks, Mike
On Wed, Dec 2, 2015 at 12:47 PM, Adrian Klaver <adrian.klaver@aklaver.com>
wrote:
> On 12/02/2015 12:44 PM, Michael Moore wrote:
>
>> Ideally I would like to see some template/example documentation of
>> common feature conversion solutions. For example, "If you have a pl/sql
>> TABLE function, you can do the same thing in postgres this way ..." I
>> can generally Google specific problems and after enough time weeding out
>> the garbage, I can usually find what I want, but maybe somebody has it
>> all in one nice neat document and I just don't know about it.
>> Any links to such a resource would be greatly appreciated as well as any
>> other links which you think I might find useful.
>>
>
> http://www.postgresql.org/docs/9.4/interactive/plpgsql-porting.html
>
> Thanks,Mike
>>
>>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle PL/SQL to pg/PSQL conversion documentation.
@ 2015-12-02 21:24 Pavel Stehule <pavel.stehule@gmail.com>
parent: Michael Moore <michaeljmoore@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Pavel Stehule @ 2015-12-02 21:24 UTC (permalink / raw)
To: Michael Moore <michaeljmoore@gmail.com>; +Cc: pgsql-sql
2015-12-02 21:44 GMT+01:00 Michael Moore <michaeljmoore@gmail.com>:
> Ideally I would like to see some template/example documentation of common
> feature conversion solutions. For example, "If you have a pl/sql TABLE
> function, you can do the same thing in postgres this way ..." I can
> generally Google specific problems and after enough time weeding out the
> garbage, I can usually find what I want, but maybe somebody has it all in
> one nice neat document and I just don't know about it.
> Any links to such a resource would be greatly appreciated as well as any
> other links which you think I might find useful.
> Thanks,Mike
>
>
some presentations can be touched on net
https://wiki.postgresql.org/images/a/a7/Oracle_migration_pgconf2012.pdf
https://pgconf.ru/media/2015c/darold.pdf
Regards
Pavel
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle PL/SQL to pg/PSQL conversion documentation.
@ 2015-12-02 22:38 Michael Moore <michaeljmoore@gmail.com>
parent: Pavel Stehule <pavel.stehule@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Michael Moore @ 2015-12-02 22:38 UTC (permalink / raw)
To: Pavel Stehule <pavel.stehule@gmail.com>; +Cc: pgsql-sql
Two VERY good links, Thanks Pavel.
On Wed, Dec 2, 2015 at 1:24 PM, Pavel Stehule <pavel.stehule@gmail.com>
wrote:
>
>
> 2015-12-02 21:44 GMT+01:00 Michael Moore <michaeljmoore@gmail.com>:
>
>> Ideally I would like to see some template/example documentation of common
>> feature conversion solutions. For example, "If you have a pl/sql TABLE
>> function, you can do the same thing in postgres this way ..." I can
>> generally Google specific problems and after enough time weeding out the
>> garbage, I can usually find what I want, but maybe somebody has it all in
>> one nice neat document and I just don't know about it.
>> Any links to such a resource would be greatly appreciated as well as any
>> other links which you think I might find useful.
>> Thanks,Mike
>>
>>
> some presentations can be touched on net
>
> https://wiki.postgresql.org/images/a/a7/Oracle_migration_pgconf2012.pdf
> https://pgconf.ru/media/2015c/darold.pdf
>
> Regards
>
> Pavel
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2015-12-02 22:38 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-12-02 20:44 Oracle PL/SQL to pg/PSQL conversion documentation. Michael Moore <michaeljmoore@gmail.com>
2015-12-02 20:47 ` Adrian Klaver <adrian.klaver@aklaver.com>
2015-12-02 21:02 ` Michael Moore <michaeljmoore@gmail.com>
2015-12-02 21:24 ` Pavel Stehule <pavel.stehule@gmail.com>
2015-12-02 22:38 ` Michael Moore <michaeljmoore@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox