Adrian Klaver schrieb am 10.06.2022 um 16:58:
On 6/10/22 05:57, Thomas Kellerer wrote:
I am trying to write a stored procedure (Postgres 13) to enable
non-superusers to re-create a subscription.
However, the "drop subscription" part results in this error:
ERROR: DROP SUBSCRIPTION cannot
Hi Team.
*I have a use case to get the result as follows:*
1. asin_ymm is never null.
2. If there is more than 1 entry for an asin_ymm with both null and
non-null submodelId, I should return rows with non-null submodelId only,
otherwise if there is no submodelid present for a asin_ymm, then retur
On Fri, Jun 10, 2022 at 9:38 AM Rama Krishnan wrote:
> I am want to delete old records using function so my senior has function
> like below but I want to get response of this particular inside query
> wheter it is successful or failure
>
If it doesn't error, it was successful. That is basicall
On Fri, 10 Jun 2022 at 18:38, Rama Krishnan wrote:
>
> Hi All,
>
> I am want to delete old records using function so my senior has function like
> below but I want to get response of this particular inside query wheter it is
> successful or failure
> How to get response of the function status
On 6/10/22 09:37, Rama Krishnan wrote:
Hi All,
I am want to delete old records using function so my senior has function
like below but I want to get response of this particular inside query
wheter it is successful or failure
How to get response of the function status
create or replace fun
Hi All,
I am want to delete old records using function so my senior has function
like below but I want to get response of this particular inside query
wheter it is successful or failure
How to get response of the function status
create or replace function data_purge() returns void as$$
Declare
On 6/10/22 05:57, Thomas Kellerer wrote:
I am trying to write a stored procedure (Postgres 13) to enable
non-superusers to re-create a subscription.
However, the "drop subscription" part results in this error:
ERROR: DROP SUBSCRIPTION cannot be executed from a function
CONTEXT: S
I am trying to write a stored procedure (Postgres 13) to enable
non-superusers to re-create a subscription.
For that, I essentially want to drop and re-create the subscription.
In order to be able to do that, the tables need to be empty.
So the approach is:
Run a query to get all replicated t
