Thread: Possible move away from PG

I work for a college and we use PG currently as our main backend.  We
are currently developing with Java.  We are considering moving away from
postgres for the reasons I am going to list below.  I would appreciate
some thoughts from the Postgres community on way we should or shouldn't
leave postgres.

1. Our dev plan involves alot of stored procedures to be used and we
have found the way this is done in PG to be painful. (ie.  To return
multiple record from different tables you have to define a type.  This
is a pain to maintain because if you ever have to change what it returns
it cannot be dropped because of dependencies etc.. In some other
databases you can simpley write a stored proc to return whatever the
query inside returns and this is handled dynamically)

2. Also with stored procs it is painful to return mulitple records. The
syntax is more complicated than some other databases.  (We are currently
using PL/SQL)

3. The tools.  PgAdmin does some things well but it is lacking the
features of some of the other gui tools.  This is not a big deal as we
do also have PgManage which is acceptable except I personally don't like
it cause it doesn't run in Linux and the Linux version is pretty bad.

Thank you for any input and help,
Jason Tesser

On Thu, 30 Jun 2005, Jason Tesser wrote:

> 1. Our dev plan involves alot of stored procedures to be used and we
> have found the way this is done in PG to be painful. (ie.  To return
> multiple record from different tables you have to define a type.  This
> is a pain to maintain because if you ever have to change what it returns
> it cannot be dropped because of dependencies etc.. In some other
> databases you can simpley write a stored proc to return whatever the
> query inside returns and this is handled dynamically)

Have you considered returing refcursors instead of setof some type.

Kris Jurka

I am not familar with how to do this.  Could you give me an example of how
this could help?

<snip>
>
> Have you considered returing refcursors instead of setof some type.
>
> Kris Jurka

--
Jason Tesser
Developer for NMI
jtesser@nbbc.edu
Eph 2:8-10