Thread: Somewhat happier alter table add

Somewhat happier alter table add

From
Stephan Szabo
Date:
This should be a slighly more complete patch for commands/command.c
AlterTableAddConstraint.  The major changes from the last patch
are that it should hopefully check for references to temp tables
(not in the shadow case, but at defination time) from permanent tables in
foreign keys and refuse them and that it doesn't allow the table(s)
being constrained to be views (because those cases don't currently
work).

Stephan Szabo
sszabo@bigpanda.com

Attachment

Re: Somewhat happier alter table add

From
Bruce Momjian
Date:
Would you resumit this as a context diff, diff -c.  Thanks.   I will
apply it as soon as I receive it.


>
> This should be a slighly more complete patch for commands/command.c
> AlterTableAddConstraint.  The major changes from the last patch
> are that it should hopefully check for references to temp tables
> (not in the shadow case, but at defination time) from permanent tables in
> foreign keys and refuse them and that it doesn't allow the table(s)
> being constrained to be views (because those cases don't currently
> work).
>
> Stephan Szabo
> sszabo@bigpanda.com
Content-Description:

[ Attachment, skipping... ]


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026