Help with version/behavior quirks.

Поиск
Список
Период
Сортировка
Искать
От
Jon V
Тема
Help with version/behavior quirks.
Дата
Msg-id
3E36F4DD.8050401@cecorp.com
Список
Дерево обсуждения
Help with version/behavior quirks. Jon V <jon@cecorp.com>
Re: Help with version/behavior quirks. Tom Lane <tgl@sss.pgh.pa.us>
Re: Help with version/behavior quirks. Jon V <jon@cecorp.com>
Re: Help with version/behavior quirks. Tom Lane <tgl@sss.pgh.pa.us>
Here's the story....

We have a product that was developed using MsSQL server. We recently 
changed over to PostgreSQL in an ongoing effort to get away from MS 
products. We have one workstation that this port was done on, and we are 
now trying to deploy on other machines.

Environment is pg under cygwin, odbc, and pgadmin II.

On the development/test machine (pg 7.2.3, odbc 7.1.9, pgadmin 1.2.0), 
you can put a query inside begin/end statements and get the results. e.g.

 begin;
 select * from table_name;
 end;

returns the table contents.

We have several other machines, running various combinations, e.g.
 pg 7.3.1, odbc 7.2.5, pgadmin 1.4.12
 pg 7.2.1, odbv 7.2.3, pgadmin 1.2.0

and with those we just get a "query OK" message. It obviously does the 
query, but it doesn't display the results.

Which behavior is "right", and is there something we can do to see the 
results?

Our application has a function that returns a cursor with a result set. 
This works with the first system (the development system this was coded 
on) but we can't get a similar behavior to work on the platform we want 
to deploy/develop on now.

Alternatively, is there another way to return a set of rows/columns from 
a function? We are converting from an MsSQL app that had a stored 
procedure that returned several results all at once. This was no problem 
in MsSQL, but seems to require explicit cursor use in postgresql?

Thanks in advance!

-Jon

В списке pgsql-novice по дате отправления
От: Alain Gougeon
Дата:
Сообщение: New and investigating
От: David Nicely
Дата:
Сообщение: Re: New and investigating
FAQ