pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedwhat does ONLY do
3+ messages / 2 participants
[nested] [flat]
* what does ONLY do
@ 2005-02-19 01:59 Bret Hughes <bhughes@elevating.com>
0 siblings, 1 reply; 3+ messages in thread
From: Bret Hughes @ 2005-02-19 01:59 UTC (permalink / raw)
To: pgsql-sql
I can't seem to find an explanation of what adding ONLY does for an sql
statement for instance :
ALTER TABLE [ONLY] ADD COLUMN ...
or what ever. Does anyone have a pointer to docs on this. I am simply
curious since there is obviously something I am missing.
Bret
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: what does ONLY do
@ 2005-02-19 03:15 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: Bret Hughes <bhughes@elevating.com>
0 siblings, 1 reply; 3+ messages in thread
From: Stephan Szabo @ 2005-02-19 03:15 UTC (permalink / raw)
To: Bret Hughes <bhughes@elevating.com>; +Cc: pgsql-sql
On Fri, 18 Feb 2005, Bret Hughes wrote:
> I can't seem to find an explanation of what adding ONLY does for an sql
> statement for instance :
>
> ALTER TABLE [ONLY] ADD COLUMN ...
>
> or what ever. Does anyone have a pointer to docs on this. I am simply
> curious since there is obviously something I am missing.
Using the ALTER TABLE page as an example...
name
The name (possibly schema-qualified) of an existing table to alter. If
ONLY is specified, only that table is altered. If ONLY is not specified,
the table and all its descendant tables (if any) are updated. * can be
appended to the table name to indicate that descendant tables are to be
altered, but in the current version, this is the default behavior. (In
releases before 7.1, ONLY was the default behavior. The default can be
altered by changing the configuration parameter sql_inheritance.)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: what does ONLY do
@ 2005-02-19 04:08 Bret Hughes <bhughes@elevating.com>
parent: Stephan Szabo <sszabo@megazone.bigpanda.com>
0 siblings, 0 replies; 3+ messages in thread
From: Bret Hughes @ 2005-02-19 04:08 UTC (permalink / raw)
To: Stephan Szabo <sszabo@megazone.bigpanda.com>; +Cc: pgsql-sql
On Fri, 2005-02-18 at 21:15, Stephan Szabo wrote:
> On Fri, 18 Feb 2005, Bret Hughes wrote:
>
> > I can't seem to find an explanation of what adding ONLY does for an sql
> > statement for instance :
> >
> > ALTER TABLE [ONLY] ADD COLUMN ...
> >
> > or what ever. Does anyone have a pointer to docs on this. I am simply
> > curious since there is obviously something I am missing.
>
> Using the ALTER TABLE page as an example...
>
> name
>
> The name (possibly schema-qualified) of an existing table to alter. If
> ONLY is specified, only that table is altered. If ONLY is not specified,
> the table and all its descendant tables (if any) are updated. * can be
> appended to the table name to indicate that descendant tables are to be
> altered, but in the current version, this is the default behavior. (In
> releases before 7.1, ONLY was the default behavior. The default can be
> altered by changing the configuration parameter sql_inheritance.)
>
Well, (*&^$%. I have read that very page, parts if it several times. B
I was adding a column to a table, thought about it again and rather
than look again I decided to ask. I hate that. I pride myself on not
asking questions that can be easily answered but blew it this time.
Thanks for the pointer. And for doing so without making me feel stupider
than necessary.
Bret
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-02-19 04:08 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-19 01:59 what does ONLY do Bret Hughes <bhughes@elevating.com>
2005-02-19 03:15 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
2005-02-19 04:08 ` Bret Hughes <bhughes@elevating.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox