BUG #14239: Array of array type reporting

From: yrashk(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14239: Array of array type reporting
Date: 2016-07-09 16:57:36
Message-ID: 20160709165736.1410.71728@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14239
Logged by: Yurii Rashkovskii
Email address: yrashk(at)gmail(dot)com
PostgreSQL version: 9.5.3
Operating system: Mac OS X
Description:

Hi,

Ran:

db=# CREATE TABLE sal_emp (
db(# name text,
db(# pay_by_quarter integer[],
db(# schedule text[][]
db(# );
CREATE TABLE
db=# \d sal_emp;

Expected:

Table "eventsourcing.sal_emp"
Column | Type | Modifiers
----------------+-----------+-----------
name | text |
pay_by_quarter | integer[] |
schedule | text[][] |

Got:

Table "eventsourcing.sal_emp"
Column | Type | Modifiers
----------------+-----------+-----------
name | text |
pay_by_quarter | integer[] |
schedule | text[] |

Is there any reason why schedule text[][] is reported as text[]? I think my
JDBC driver (pgjdbc-ng) picks that up and fails to do proper coercion
because it things it's simply a text[].

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2016-07-09 19:03:34 Re: BUG #14239: Array of array type reporting
Previous Message Magnus Hagander 2016-07-09 16:54:39 Re: BUG #14230: Wrong timeline returned by pg_stop_backup on a standby