Thread: Replacing Oracle 8i

For starters, check out http://techdocs.postgresql.org
If you are using ODBC (as this post implies), also
check out http://odbc.postgresql.org.
Someone was porting a bunch of Pro*C code not long
ago: if you search the archives for the pgsql-general
list, you should see plenty of references.  In brief,
that person was converting their Pro*C code into ECPG
code.  Look in the PostgreSQL documentation for ECPG.

For C++, search the archives/docs for references to
libpq++ and libpqxx (I don't know too much about this,
sorry).

I'm not knowledgable, but no-one else has replied so
far ;-)
HTH

--- Pablo Aranda <paranda@newton.cl> wrote:
> Dear All,
> please tell me about replacing Oracle 8i with
> PostgreSQL.
> We need to know the HOW TOs.
> We are working in Linux Red Hat 6.2, using C++ and
> the Pro*C tool.
> Thanks a lot !!!
> Pablo.
>
>
>


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

That is a tall order.

(1) What version or oracle?
(2) Are you used the ODBC interace or the OCI interface?
(3) Do you use stored procedures?
(4) Do you use inner and/or outer joins?
(5) Do you oracle's ROWID?

There are many more issues. If you use simple braindead SQL using ODBC, then it could simply be setup the system DSN. Depending how much Oracle is in your SQL, it could be a lot of work.

Pablo Aranda wrote:

Dear All,

please tell me about replacing Oracle 8i with PostgreSQL.

We need to know the HOW TOs.

We are working in Linux Red Hat 6.2, using C++ and the Pro*C tool.

Thanks a lot !!!

Pablo.