Re: SQL/MED - file_fdw - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SQL/MED - file_fdw
Date
Msg-id 15159.1298306212@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL/MED - file_fdw  (Thom Brown <thom@linux.com>)
List pgsql-hackers
Thom Brown <thom@linux.com> writes:
> Is this right?
> postgres=# \d+ agg_text
>             Foreign table "public.agg_text"
>  Column |   Type   | Modifiers | Storage  | Description
> --------+----------+-----------+----------+-------------
>  a      | smallint |           | plain    |
>  b      | text     |           | extended |
> Server: file_server
> Has OIDs: no


> It says the agg_text foreign table is using extended storage for the
> text field.  If it's in-file, how can it be classified as potentially
> TOASTed?

It's meaningless, but I don't think it's worth trying to suppress the
meaningless column(s) ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: FDW API: don't like the EXPLAIN mechanism
Next
From: Andrew Dunstan
Date:
Subject: Re: FDW API: don't like the EXPLAIN mechanism