David Buch

Hi Thanks for that. I have managed to install successfully on my development server (postgres 15), however on my production server I have both Postgres 15 and 16. We are...

We already have postgres installed and running. This is a production server, so I cannot just reinstall stuff. we have the exact same installation on our development server apart from...

ok, so I have resolved the issue by completely removing and purging postgres 16. Once I did that, then the makefile ran perfectly, so there seems to be a problem...

Hi have resolved the issue - I need to create the triggers as postgres with super user permissions and then it works.

I spoke to soon. The triggers fire when I do an insert from within postgres, but they do not fire when an insert is done on the Mysql table. I...

Hi. no it doesnt help really. I need to have the trigger in postgres do extra processing when a new record appears in Mysql. Its no use for me to...

I think we are misunderstanding each other. There is a trigger created on the foreign table in postgres. but it does not get fired when a new record is added...

They are inserted into Mysql from a seperate application. Postgres will not be inserting into mysql, just reading from it

hi. Yes.. looks similar to my issue, but I cant see how to get past it. note, we are running on ubuntu 22.04, so this is not a windows or...

Hi Sure: SHOW GLOBAL VARIABLES LIKE 'lower_case_table_names'; value 0 setting in conf files [mysqld] lower_case_table_names=2 Mysql/Mariadb tables CREATE TABLE `debugLog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `routine` varchar(255) DEFAULT NULL,...