On 07/26/2018 07:11 PM, Adrian Klaver wrote:
> On 07/26/2018 04:48 PM, Dimitri Maziuk wrote:
...
>> The publication foopub is at this point fubar I take it? And needs to be
>> re-created on the publisher and reconnected on the subscriber? Complete
>> with with inital resync?
>
> Not sure.
On 07/27/2018 08:17 AM, vardenis pavardenis wrote:
Hello.
I am trying install postgresql 10.4 on Ubuntu 14.05 server (x64).
On Ubuntu i installed only ssh service for remote access.
I am trying install it via Apt Repository
(https://www.postgresql.org/download/linux/ubuntu/
Hello.
I am trying install postgresql 10.4 on Ubuntu 14.05 server (x64).
On Ubuntu i installed only ssh service for remote access.
I am trying install it via Apt Repository (https://www.postgresql.org/
download/linux/ubuntu/).
I did:
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/
Hi
2018-07-27 11:24 GMT+02:00 Brahmam Eswar :
> Hi ,
>
> Returning multiple rows from store functions using "RETURNS TABLE" and
> RETURN QUERY. The results set may have more than 50k records. Does it give
> any performance issues related to memory? if yes how to avoid it
>
>
This command uses
Hi ,
Returning multiple rows from store functions using "RETURNS TABLE" and
RETURN QUERY. The results set may have more than 50k records. Does it give
any performance issues related to memory? if yes how to avoid it
CREATE OR REPLACE FUNCTION funcq(COL1 character varying)
)
RETURNS TABLE
( a