pgsql: Allow partitioned tables to be dropped without CASCADE

Allow partitioned tables to be dropped without CASCADE

Record partitioned table dependencies as DEPENDENCY_AUTO
rather than DEPENDENCY_NORMAL, so that DROP TABLE just works.

Remove all the tests for partitioned tables where earlier
work had deliberately avoided using CASCADE.

Amit Langote, reviewed by Ashutosh Bapat and myself

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/8b4d582d279d784616c228be58af1e39aa430402

Modified Files
--------------
src/backend/commands/tablecmds.c | 30 ++++++++++++++++++++++--------
src/test/regress/expected/alter_table.out | 10 ++++------
src/test/regress/expected/create_table.out | 9 ++-------
src/test/regress/expected/inherit.out | 22 ++--------------------
src/test/regress/expected/insert.out | 7 ++-----
src/test/regress/expected/update.out | 7 +------
src/test/regress/sql/alter_table.sql | 10 ++++------
src/test/regress/sql/create_table.sql | 9 ++-------
src/test/regress/sql/inherit.sql | 4 ++--
src/test/regress/sql/insert.sql | 7 ++-----
src/test/regress/sql/update.sql | 2 +-
11 files changed, 44 insertions(+), 73 deletions(-)