| From: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Asim R P <apraveen(at)pivotal(dot)io>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Ashwin Agrawal <aagrawal(at)pivotal(dot)io>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru> |
| Subject: | Re: Pluggable Storage - Andres's take |
| Date: | 2019-03-21 05:17:34 |
| Message-ID: | CAJrrPGfzfwG7pE0Ja=8y5TCGvXwk+E7+M5SiWnYY-s8FzFNRqQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
The psql \dA commands currently doesn't show the type of the access methods
of
type 'Table'.
postgres=# \dA heap
List of access methods
Name | Type
------+-------
heap |
(1 row)
Attached a simple patch that fixes the problem and outputs as follows.
postgres=# \dA heap
List of access methods
Name | Type
------+-------
heap | Table
(1 row)
The attached patch directly modifies the query that is sent to the server.
Servers < 12 doesn't support of type 'Table', so the same query can work,
because of the case addition as follows.
SELECT amname AS "Name",
CASE amtype WHEN 'i' THEN 'Index' WHEN 't' THEN 'Table' END AS
"Type"
FROM pg_catalog.pg_am ...
Anyone feels that it requires a separate query for servers < 12?
Regards,
Haribabu Kommi
Fujitsu Australia
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-dA-to-show-Table-type-access-method.patch | application/octet-stream | 823 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2019-03-21 05:48:35 | Re: [HACKERS] WAL logging problem in 9.4.3? |
| Previous Message | Haribabu Kommi | 2019-03-21 04:07:04 | Re: Pluggable Storage - Andres's take |