Tag Info

New answers tagged

3

The documentation about ALTER DEFAULT PRIVILEGES tells you a possible reason - it is not that clearly described, though. Let's see, what is said: You can change default privileges only for objects that will be created by yourself or by roles that you are a member of. This means that the default privileges defined by this statement applies only to ...


1

I'm not sure what you are saying here. Assume the following: CREATE TABLE PARENT ( a int not null primary key ); CREATE TABLE CHILD ( b int not null primary key , a int not null , constraint fk foreign key (a) references PARENT (a) ); insert into PARENT (a) values (1),(2); -- What should the default value of a be? insert into CHILD (b) ...



Top 50 recent answers are included