Well.. it seems I have to rethink about my application design. Anyway,
thank you all for your insights and suggestions.
On 12/18/2019 10:46 PM, Justin wrote:
I agree completely,
I do not think Postgresql is a good fit for Shalini based on the
conversation so far
tracking Concurrency is goi
thanks Adrian, what about the
postmaster.opts file, this file was also skipped in backup.
We have single cluster running on the VM.
Thanks.
On 22-Dec-2019 11:19 PM, Adrian Klaver wrote:
On 12/22/19 1:56 AM, Daulat Ram wrote:
> Hello,
>
> I am taking pg_basebackup of primary db (docker containe
Tom, hi:
1. actual use case has to do with:
BUG #16177: pg_event_trigger_ddl_commands() returns empty set for
ddl_command_start and "drop table"
https://www.postgresql.org/message-id/16177-053a34714817c3e1%40postgresql.org
2. I was merely hoping to re-implement pg_event_trigger_ddl_commands as
Jeff, hi:
1. my concern is global "event_trigger" for DDL, not per-table "trigger"
for DML
2. regardless - thank you for the link, I found it helpful
3. Tom Lane says event_trigger is just not implemented in plpython
Andrei.
On 2019-12-22 17:20, Jeff Ross wrote:
On 2019-12-22 16:07, Jeff R
On 12/22/19 4:02 PM, Boylan, Ross wrote:
5) At this point it seems your data is going to live in two worlds and
in the end it will fall on you to maintain the integrity between the worlds.
That's what I'm afraid of.
The data itself lives only on the backend, but information about it lives in
1. Timelines
> The long term solution is?
I just meant I'm hoping to switch to Postgres soonish.
> So at some point you will switch the link from being Access native to a
ODBC DSN pointing at a Postgres database, correct?
The switch will be to ODBC but no DSN. You can specify the connection
pr
Andrei Pozolotin writes:
> 1. any attempt to define python function as an event_trigger, i.e.:
AFAICS, there's not really any event trigger support in plpython.
That feature has only been built out in the other three PLs.
Somebody oughta fix this sometime, I guess, but it evidently hasn't
been
On 2019-12-22 16:07, Jeff Ross wrote:
On 2019-12-22 15:27, Andrei Pozolotin wrote:
Hello.
Problem:
1. any attempt to define python function as an event_trigger, i.e.:
CREATE FUNCTION public.verify()
RETURNS event_trigger
LANGUAGE 'plpython3u'
AS $$ print("hello-kitty") $$;
2. fails with mes
On 2019-12-22 15:27, Andrei Pozolotin wrote:
Hello.
Problem:
1. any attempt to define python function as an event_trigger, i.e.:
CREATE FUNCTION public.verify()
RETURNS event_trigger
LANGUAGE 'plpython3u'
AS $$ print("hello-kitty") $$;
2. fails with message:
ERROR: trigger functions can onl
Hello.
Problem:
1. any attempt to define python function as an event_trigger, i.e.:
CREATE FUNCTION public.verify()
RETURNS event_trigger
LANGUAGE 'plpython3u'
AS $$ print("hello-kitty") $$;
2. fails with message:
ERROR: trigger functions can only be called as triggers
SQL state: 0A000
On 12/22/19 11:59 AM, Boylan, Ross wrote:
From: Adrian Klaver
> Sent: Sunday, December 22, 2019 10:35 AM
.
Alright this is the part where I got confused. I think what is going on is:
1) The immediate change is going to be to Access 2016 on Windows 10 64
keeping the data in Access fil
> From: Adrian Klaver
> Sent: Sunday, December 22, 2019 10:35 AM
.
> Alright this is the part where I got confused. I think what is going on is:
>1) The immediate change is going to be to Access 2016 on Windows 10 64
keeping the data in Access files(.accdb)
> 2) The long term plan is to mov
I did a manual ANALYZE of a foreign table, to see if it would make a
troublesome query better. It did, but it also made some other queries that
were previously fine to become far worse. Is there a way to undo the
analyze? I can muck around in the catalogs like below, but seems really
grotty.
de
On 12/21/19 6:40 PM, Boylan, Ross wrote:
From: Adrian Klaver
Sent: Saturday, December 21, 2019 3:37 PM
This might be easier to figure out if you outline what is going on:
Since I seem to have gone on in my responses, let me do one-line answers before
the fuller ones.
1) The purpose of th
On 12/22/19 1:56 AM, Daulat Ram wrote:
Hello,
I am taking pg_basebackup of primary db (docker container env.) using
the below command :
pg_basebackup -x -h vmzti -U replication -D
/etc/postgresql/9.5/main/pg_basebkp/basekp1224 -Ft -z -P
Password:
WARNING: skipping special file "./postgre
Hello,
I am taking pg_basebackup of primary db (docker container env.) using the below
command :
pg_basebackup -x -h vmzti -U replication -D
/etc/postgresql/9.5/main/pg_basebkp/basekp1224 -Ft -z -P
Password:
WARNING: skipping special file "./postgresql.conf"
WARNING: skipping special file "./
Samuel Teixeira Santos schrieb am 20.12.2019 um 16:15:
BigSQL still allow to install Postgres and others resources as like a
portable install.
But today, it's only offer your tool (pgc) for newer Postgresql
versions.
I would like to install as portable option because it's more easy to
config an
17 matches
Mail list logo
