Hi team,
is it possible to return Multiple results set from procedure/function on
single execution. Please advise me on this. we are planning to migrate
things from sqlserver to postgresql where my existing sql stored procs will
return multiple result set. so we need achieve same thing in postgres
Hi team,
is it possible to return Multiple results set from procedure/function on
single execution. Please advise me on this. I have written sample code
below and when i execute it i dont get any result set
CREATE OR REPLACE FUNCTION multiResultset(
ref1 refcursor,
Hi Team,
I have created function in postgre sql 13 which will return two result.
But when execute i can able to see the last cursor (query result set of
last select )result set in Data output window of Pgadmin4. i tried
executing the cursor inside the transaction as well (BEING.COMMIT).
but
we need
to achieve Same multiple result set in postgreSql.. Kindly advise me..
Regards
Muthukumar.GK
On Mon, Nov 23, 2020, 8:49 PM Adrian Klaver
wrote:
> On 11/22/20 8:53 PM, Muthukumar.GK wrote:
> > Hi Team,
> >
> > I have created function in postgre sql 13 which will retur
HiTeam,
We need to migrate tables,Records,Procedure and function from SQL server to
Postgresql. Kindly let me know, Is there any tool or easiest way
available to migrate from SQL Server to Postgresql. Please let me know if
there are any limitations in *postgresql *compared to SQL server.
Regards
dynamic
procedure in SQL server, On execution of this Procedure, another two
procedures will be Created dynamically.
Regards
Muthu
On Mon, Nov 30, 2020 at 11:02 AM Pavel Stehule
wrote:
>
>
> po 30. 11. 2020 v 6:12 odesÃlatel Muthukumar.GK
> napsal:
>
>> HiTeam,
>>
&
Hi team,
I need to call the procedure(not function) and insert the records into a
temporary table from another procedure in postgres. When executing the
procedure 'Sampleproc2',I got some below syntax error. Kindly let me know
whether postgres supports this functionality or any other way of call
Hi Team,
I have created Database in postgresqlv13 . My Office colleague needs to
access my postgres server and database from his machine. There is a config
file called 'Postgresql.conf.sample' in program files folder. Even if I
changed the connection settings of listen address from localhost to *(
No.I did not restart postgres.Please let me know the steps to restart
postgres using pgadmin4 tool.
On Fri, Dec 4, 2020 at 5:26 PM Hemil Ruparel
wrote:
> Are you sure you restarted postgres after the change in configuration?
>
> On Fri, Dec 4, 2020 at 3:58 PM Muthukumar.GK
> wr
Hi Nicklas,
I have added a line "host all all 0.0.0.0/0 md5" in Pg_hba_conf.sample
file and restarted postgres server. porstgres port has been added in
windows firewall (Windows10)as well. But my colleague is still facing the
below error when connecting my postgres server from .net appplicat
sql@1;Database=Training;");
Regards
Muthu
On Sat, Dec 5, 2020 at 12:21 PM Hemil Ruparel
wrote:
> Did you restart postgres after changing pg_hba.conf?
>
> On Sat, Dec 5, 2020 at 11:56 AM Muthukumar.GK
> wrote:
>
>> Hi Nicklas,
>>
>> I have added a line &q
--
ERROR: syntax error at or near "OPEN"
LINE 1: OPEN C1 FOR SELECT * FROM public."Los_BankInfo" ^
QUERY: OPEN C1 FOR SELECT * FROM public."Los_BankInfo"
CONTEXT: PL/pgSQL function dynamicproc() line 9 at EXECUTE SQL state: 42601
Regards
Muthukumar.gk
Hi David,
As I am not bit Clea, let me know what I have to do. If possible, please
re- write my program.
Regards
Muthu
On Mon, Dec 14, 2020, 11:43 AM David G. Johnston
wrote:
> On Sunday, December 13, 2020, Muthukumar.GK wrote:
>
>>
>> v_query := ' OPEN C1 F
namic_sql(10);
Regards
Muthu
On Mon, Dec 14, 2020, 8:54 PM Adrian Klaver
wrote:
> On 12/13/20 9:59 PM, Muthukumar.GK wrote:
> > Hi team,
> >
> > When I am trying to implement belwo dynamic concept in postgreSql,
> > getting some error. Kindly find the below att
14 matches
Mail list logo
