Re: Include access method in listTables output

2020-09-02 Thread Michael Paquier
On Tue, Sep 01, 2020 at 10:27:31AM +, Georgios wrote: > On Tuesday, 1 September 2020 07:41, Michael Paquier > wrote: >> Adding \dE as there are no foreign tables does not make much sense, >> and also I wondered why \dt+ was not added. >> >> Does the attached look correct to you? > > You

Re: Include access method in listTables output

2020-09-01 Thread Georgios
‐‐‐ Original Message ‐‐‐ On Tuesday, 1 September 2020 07:41, Michael Paquier wrote: > On Thu, Aug 20, 2020 at 08:16:19AM +, Georgios wrote: > > > Please find version 7 attached which hopefully addresses the error along > > with a proper > > expansion of the test coverage and

Re: Include access method in listTables output

2020-08-31 Thread Michael Paquier
On Thu, Aug 20, 2020 at 08:16:19AM +, Georgios wrote: > Please find version 7 attached which hopefully addresses the error along with > a proper > expansion of the test coverage and removal of recently introduced > whitespace warnings. +CREATE ROLEconditional_tableam_display_role; As a

Re: Include access method in listTables output

2020-08-20 Thread Georgios
/georgios-kokolatos.html Thank you for pointing it out! Please find version 7 attached which hopefully addresses the error along with a proper expansion of the test coverage and removal of recently introduced whitespace warnings. > > ------------------ > > Justin 0001-Include-access-method-in-listTables-output-v7.patch Description: Binary data

Re: Include access method in listTables output

2020-08-19 Thread Justin Pryzby
On Mon, Aug 17, 2020 at 11:10:05PM +0530, vignesh C wrote: > On Sat, Aug 1, 2020 at 8:12 AM vignesh C wrote: > > > > > > > > +-- access method column should not be displayed for sequences > > > > +\ds+ > > > > > > > > - List of relations > > > > > > > > > > > > - Schema

Re: Include access method in listTables output

2020-08-17 Thread vignesh C
a new patch for the same. I felt patch is in shape for committer to have a look at this. Regards, Vignesh From 59d102e21c0261c7349fc5ad55026d0125972836 Mon Sep 17 00:00:00 2001 From: Georgios Date: Mon, 17 Aug 2020 22:51:17 +0530 Subject: [PATCH v6] Incl

Re: Include access method in listTables output

2020-07-31 Thread vignesh C
On Wed, Jul 29, 2020 at 7:30 PM Georgios wrote: > > > I'm having issues understanding where you are going with the reviews, can you > fully describe > what is it that you wish to be done? > I'm happy with the patch, that was the last of the comments that I had from my side. Only idea here is to

Re: Include access method in listTables output

2020-07-29 Thread Georgios
‐‐‐ Original Message ‐‐‐ On Saturday, July 25, 2020 2:41 AM, vignesh C wrote: > On Thu, Jul 16, 2020 at 7:35 PM Georgios gkokola...@protonmail.com wrote: > > > ‐‐‐ Original Message ‐‐‐ > > On Saturday, July 11, 2020 3:16 PM, vignesh C vignes...@gmail.com wrote: > > > > > On

Re: Include access method in listTables output

2020-07-24 Thread vignesh C
On Thu, Jul 16, 2020 at 7:35 PM Georgios wrote: > > > > ‐‐‐ Original Message ‐‐‐ > On Saturday, July 11, 2020 3:16 PM, vignesh C wrote: > > > On Mon, Jul 6, 2020 at 1:24 PM Georgios gkokola...@protonmail.com wrote: > > > > > ‐‐‐ Original Message ‐‐‐ > > > On Monday, July 6, 2020

Re: Include access method in listTables output

2020-07-16 Thread Georgios
‐‐‐ Original Message ‐‐‐ On Saturday, July 11, 2020 3:16 PM, vignesh C wrote: > On Mon, Jul 6, 2020 at 1:24 PM Georgios gkokola...@protonmail.com wrote: > > > ‐‐‐ Original Message ‐‐‐ > > On Monday, July 6, 2020 3:12 AM, Michael Paquier mich...@paquier.xyz wrote: > > > > > On

Re: Include access method in listTables output

2020-07-11 Thread vignesh C
On Mon, Jul 6, 2020 at 1:24 PM Georgios wrote: > > > > ‐‐‐ Original Message ‐‐‐ > On Monday, July 6, 2020 3:12 AM, Michael Paquier wrote: > > > On Sun, Jul 05, 2020 at 07:13:10AM +0530, vignesh C wrote: > > > > > I'm not sure if we should include showViews, I had seen that the > > >

Re: Include access method in listTables output

2020-07-06 Thread Georgios
‐‐‐ Original Message ‐‐‐ On Monday, July 6, 2020 3:12 AM, Michael Paquier wrote: > On Sun, Jul 05, 2020 at 07:13:10AM +0530, vignesh C wrote: > > > I'm not sure if we should include showViews, I had seen that the > > access method was not getting selected for view. > > +1. These have

Re: Include access method in listTables output

2020-07-05 Thread Michael Paquier
On Sun, Jul 05, 2020 at 07:13:10AM +0530, vignesh C wrote: > I'm not sure if we should include showViews, I had seen that the > access method was not getting selected for view. +1. These have no physical storage, so you are looking here for relkinds that satisfy RELKIND_HAS_STORAGE(). -- Michael

Re: Include access method in listTables output

2020-07-04 Thread vignesh C
On Tue, Jun 30, 2020 at 2:53 PM Georgios wrote: > > > As promised, I gladly ament upon your request. Also included a fix for > a minor oversight in tests, they should now be stable. Finally in this > version, I extended a bit the logic to only include the access method column > if the relations

Re: Include access method in listTables output

2020-06-30 Thread Georgios
‐‐‐ Original Message ‐‐‐ On Saturday, June 20, 2020 3:15 PM, vignesh C wrote: > On Tue, Jun 16, 2020 at 6:13 PM Georgios gkokola...@protonmail.com wrote: > > > > Few comments: > > > > > > - if (pset.sversion >= 12) > > > > > > - appendPQExpBufferStr(, > > > > > > - "\n LEFT

Re: Include access method in listTables output

2020-06-20 Thread vignesh C
On Tue, Jun 16, 2020 at 6:13 PM Georgios wrote: > > Few comments: > > > > - if (pset.sversion >= 12) > > > > - appendPQExpBufferStr(, > > > > - "\n LEFT JOIN pg_catalog.pg_am am ON am.oid = c.relam"); > > > > Should we include pset.hide_tableam check along with the version check? >

Re: Include access method in listTables output

2020-06-16 Thread Georgios
‐‐‐ Original Message ‐‐‐ On Monday, June 15, 2020 3:20 AM, vignesh C wrote: > On Tue, Jun 9, 2020 at 6:45 PM Georgios gkokola...@protonmail.com wrote: > > > > > > > Please add it to the commitfest at https://commitfest.postgresql.org/28/ > > > > Thank you very much for your time. Added

Re: Include access method in listTables output

2020-06-14 Thread vignesh C
On Tue, Jun 9, 2020 at 6:45 PM Georgios wrote: > > > Please add it to the commitfest at https://commitfest.postgresql.org/28/ > > Thank you very much for your time. Added to the commitfest as suggested. Patch applies cleanly, make check & make check-world passes. Few comments: + if

Re: Include access method in listTables output

2020-06-09 Thread Georgios
‐‐‐ Original Message ‐‐‐ On Tuesday, June 9, 2020 1:34 PM, David Rowley wrote: > On Tue, 9 Jun 2020 at 23:03, Georgios gkokola...@protonmail.com wrote: > > > A small patch is attached [1] to see if you think it makes sense. I have > > not included any > > differences in the tests

Re: Include access method in listTables output

2020-06-09 Thread David Rowley
On Tue, 9 Jun 2020 at 23:03, Georgios wrote: > A small patch is attached [1] to see if you think it makes sense. I have not > included any > differences in the tests output yet, as the idea might get discarded. However > if the patch is > found useful. I shall ament the test results as needed.

Include access method in listTables output

2020-06-09 Thread Georgios
Hi, Postgres 12 introduced TableAm api. Although as far as I can see, currently only heap is included as access method, it is fair to imagine that users will start adding their own methods and more methods to be included in Postgres core. With that in mind, it might be desirable for a user to