From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> |
Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, zedaardv(at)drizzle(dot)com |
Subject: | Re: BUG #15998: query to return a table column list gives error on a missing foreign data wrapper library |
Date: | 2019-09-10 13:59:30 |
Message-ID: | 28184.1568123970@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> writes:
> On Tue, Sep 10, 2019 at 6:46 PM PG Bug reporting form
> <noreply(at)postgresql(dot)org> wrote:
>> Take a postgres database with foreign servers and foreign tables.
>> remove the fdw library.
>> [ Then a query on information_schema.columns ]
>> throws error
>> ERROR: could not access file "$libdir/postgres_fdw": No such file or
>> directory
>>
>> commenting out the case statement
>> CASE WHEN col.is_updatable = 'YES' THEN true ELSE false END AS
>> is_updatable,
>> causes the query to run without error.
> Seems reasonable to me; the is_updatable reference would cause the
> IsForeignRelUpdatable() call for postgres_fdw foreign tables IIUC, so
> removing that would be a workaround for this issue if that works for
> you.
Yeah. Seems like not-a-bug to me: if you inquire about the updatability
of a foreign table, we really can't answer that without consulting
the relevant FDW.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-09-10 14:38:01 | Re: BUG #15999: jsonb_populate_record fails with array column |
Previous Message | Sandeep Thakkar | 2019-09-10 11:49:16 | Re: BUG #15996: Unable to install any PosgresSQL version |