Re: Constants in the foreighn key constraints

2019-11-24 Thread Mimiko
As a workaround, create a table with only one column and one value = `false` and foreign to it. On 22.11.2019 16:32, aleksey ksenzov wrote: Latest time we faced several issues which wouldn't arise provided we have possibility to use constants in foreign key constraints. brief example where it

Re: Partition, inheritance for storing syslog records.

2019-11-18 Thread Mimiko
Any one can give some advice? On 11.11.2019 13:45, Mimiko wrote: Hello. I beg for the community ideas on how to do in the best way. I use centrally storing syslog messages in Postgres. All devices send syslog messages to a server (or could be several in fault tolerance) which use rsyslog to

Partition, inheritance for storing syslog records.

2019-11-11 Thread Mimiko
Hello. I beg for the community ideas on how to do in the best way. I use centrally storing syslog messages in Postgres. All devices send syslog messages to a server (or could be several in fault tolerance) which use rsyslog to store the logs in the DB (currently I'm using mysql and postgre stor