Re: problem

2019-02-01 Thread Moreno Andreo
Check in your %temp% directory, there should be some bitrock* or bitrock_installer* file, these are setup logs and can point you to the problem. If initdb failed, you can try running something like this initdb -D "C:\My\Postgres\Setup\

FK Constraint with ON DELETE SET DEFAULT cascading as table owner

2019-02-01 Thread Brad Leupen
Hello, We are using RLS on Postgres 11 to implement multi tenancy in our application. We have a tenant table whose id matches the tenant’s user role. Each table has a tenant_id FKA that defaults to “current_user”. All of our foreign key constraints are multipart (tenant_id + row_id). So far thi

Re: pgexpress 4.60 vita voom

2019-02-01 Thread ceuro
Thank you everybody, for all the suggestions. I'm using postgres 8.2 and with with that driver I can upgrade to 9.2 basically without changes on the software, this is the only reason why I'm looking for that driver. I've understand from your answers the postgresql 9.2 is also an old unsupported rel

Re: FK Constraint with ON DELETE SET DEFAULT cascading as table owner

2019-02-01 Thread rob stone
Hello, On Fri, 2019-02-01 at 14:01 +, Brad Leupen wrote: > Hello, > > We are using RLS on Postgres 11 to implement multi tenancy in our > application. We have a tenant table whose id matches the tenant’s > user role. Each table has a tenant_id FKA that defaults to > “current_user”. All of ou

FK Constraint with ON DELETE SET DEFAULT cascading as table owner

2019-02-01 Thread David G. Johnston
On Friday, February 1, 2019, rob stone wrote: > Hello, > > On Fri, 2019-02-01 at 14:01 +, Brad Leupen wrote: > > CREATE TABLE foo ( > > tenant TEXT REFERENCES tenant NOT NULL DEFAULT user, > > > This script winds up failing because the “user” default value on > > foo.tenant evaluates to t