| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Josh Kupershmidt <schmiddy(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: psql: bogus descriptions displayed by \d+ |
| Date: | 2011-08-13 17:56:15 |
| Message-ID: | 1313258175.9614.3.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On fre, 2011-08-12 at 16:14 -0400, Robert Haas wrote:
> On Fri, Aug 12, 2011 at 4:11 PM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> > "A table is either a base table, a derived table, a transient table, or
> > a viewed table." (SQL/MED adds "foreign table".)
> >
> > Just FYI.
>
> Base table seems clear enough, and a transient table sounds like a
> temporary table, but what is a derived table? Is a viewed table a
> view?
A base table is either a permanent base table or (one of various kinds
of) a temporary base table. A derived table is the result of a table
expression, so this is more of a notional syntactic term. A transient
table is, roughly speaking, OLD or NEW in a trigger. A viewed table is
a view.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2011-08-13 19:27:50 | Re: VACUUM FULL versus system catalog cache invalidation |
| Previous Message | Tom Lane | 2011-08-13 16:18:02 | Re: VACUUM FULL versus system catalog cache invalidation |