`pg_ls_dir` can query some directories, but not others

2019-11-13 Thread Brennan Vincent
Copying here a question I asked on StackOverflow: https://stackoverflow.com/questions/58846076 === On my system, `/home` and `/etc` have exactly the same permissions: ``` $ ls -ld /home /etc drwxr-xr-x 67 root root 4096 Nov 13 15:59 /etc drwxr-xr-x 3 root roo

Re: `pg_ls_dir` can query some directories, but not others

2019-11-13 Thread Brennan Vincent
> On Nov 13, 2019, at 6:33 PM, Adrian Klaver wrote: > > On 11/13/19 2:32 PM, Brennan Vincent wrote: >> Copying here a question I asked on StackOverflow: >> https://stackoverflow.com/questions/58846076 >> === >> On my system

`DROP DATABASE RESTRICT` ?

2020-03-04 Thread Brennan Vincent
Hello all, I was wondering if there is some reason why Postgres doesn't support a `RESTRICT` option that would refuse to drop a database if it contains any schemas or objects, similarly to the semantics of `DROP SCHEMA [...] RESTRICT`. Is there a fundamental reason not to support it, or is it jus