Re: Can we go beyond the standard to make Postgres radically better?

2022-02-12 Thread Mladen Gogala
On 2/12/22 19:11, Andreas 'ads' Scherbaum wrote: The complaint is not about complex queries, or CTEs, or Joins. This is about simple queries where a user wants to discover - surf - the database and look into specific tables, but exclude certain columns. More specifically, this is when the user t

Re: Can we go beyond the standard to make Postgres radically better?

2022-02-12 Thread Andreas 'ads' Scherbaum
On 12/02/2022 22:34, Peter J. Holzer wrote: On 2022-02-12 22:09:25 +0100, Andreas 'ads' Scherbaum wrote: On 12/02/2022 20:50, Peter J. Holzer wrote: On 2022-02-12 01:18:04 +0100, Andreas 'ads' Scherbaum wrote: On 10/02/2022 18:22, Peter J. Holzer wrote: On 2022-02-09 21:14:39 -0800, Guyren Ho

Re: Can we go beyond the standard to make Postgres radically better?

2022-02-12 Thread Peter J. Holzer
On 2022-02-12 13:23:39 -0800, Adrian Klaver wrote: > On 2/12/22 13:17, Peter J. Holzer wrote: > > A shell could also provide an "expand select list" function using > > explain. > > > > In fact, you can sort of do that manually: > > > > 1) Prefix your query with explain(verbose) > > 2) Copy the "O

Re: Can we go beyond the standard to make Postgres radically better?

2022-02-12 Thread Peter J. Holzer
On 2022-02-12 22:09:25 +0100, Andreas 'ads' Scherbaum wrote: > On 12/02/2022 20:50, Peter J. Holzer wrote: > > On 2022-02-12 01:18:04 +0100, Andreas 'ads' Scherbaum wrote: > > > On 10/02/2022 18:22, Peter J. Holzer wrote: > > > > On 2022-02-09 21:14:39 -0800, Guyren Howe wrote: > > > > > Examples o

Re: Can we go beyond the standard to make Postgres radically better?

2022-02-12 Thread Adrian Klaver
On 2/12/22 13:17, Peter J. Holzer wrote: On 2022-02-12 20:50:57 +0100, Peter J. Holzer wrote: On 2022-02-12 01:18:04 +0100, Andreas 'ads' Scherbaum wrote: On 10/02/2022 18:22, Peter J. Holzer wrote: On 2022-02-09 21:14:39 -0800, Guyren Howe wrote: Examples of small things Postgres could have:

Re: Can we go beyond the standard to make Postgres radically better?

2022-02-12 Thread Peter J. Holzer
On 2022-02-12 20:50:57 +0100, Peter J. Holzer wrote: > On 2022-02-12 01:18:04 +0100, Andreas 'ads' Scherbaum wrote: > > On 10/02/2022 18:22, Peter J. Holzer wrote: > > > On 2022-02-09 21:14:39 -0800, Guyren Howe wrote: > > > > Examples of small things Postgres could have: > > > > > > > >• SELE

Re: Can we go beyond the standard to make Postgres radically better?

2022-02-12 Thread Andreas 'ads' Scherbaum
On 12/02/2022 20:50, Peter J. Holzer wrote: On 2022-02-12 01:18:04 +0100, Andreas 'ads' Scherbaum wrote: On 10/02/2022 18:22, Peter J. Holzer wrote: On 2022-02-09 21:14:39 -0800, Guyren Howe wrote: Examples of small things Postgres could have: • SELECT * - b.a_id from a natural join b My

Babelfish for PostgreSQL

2022-02-12 Thread Mladen Gogala
Hi! There is a method of simulating SQL Server by using PostgreSQL. The extension is called "Babelfish": https://babelfishpg.org/ However, this extension requires modifications to the PostgreSQL source and building the PostgreSQL with Babelfish modifications from source. While it is a rather

Re: Can we go beyond the standard to make Postgres radically better?

2022-02-12 Thread Peter J. Holzer
On 2022-02-12 01:18:04 +0100, Andreas 'ads' Scherbaum wrote: > On 10/02/2022 18:22, Peter J. Holzer wrote: > > On 2022-02-09 21:14:39 -0800, Guyren Howe wrote: > > > Examples of small things Postgres could have: > > > > > >• SELECT * - b.a_id from a natural join b > > > > My use case for such

Re: "grant usage on schema" confers the ability to execute all user-defined functions in that schema, with needing to grant "execute"

2022-02-12 Thread Bryn Llewellyn
> rjuju...@gmail.com wrote: > >> adrian.kla...@aklaver.com wrote: >> >>> b...@yugabyte.com wrote: >>> >>> I s'pose that I can interpret this output in the light of the "miriam" >>> example by guessing than an empty LHS means "public" and that the initial >>> "X" means "execute". It looks like