If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to pgsql-ports@postgresql.org.

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs@postgresql.org.

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches@postgresql.org instead.  Please use the
command "diff -c" to generate the patch.

You may also enter a bug report at http://www.postgresql.org/ instead of
e-mail-ing this form.

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		:	Roman
Your email address	:	rigalkin@luch.podolsk.ru


System Configuration
---------------------
  Architecture (example: Intel Pentium)  	: Intel Celeron 667

  Operating System (example: Linux 2.0.26 ELF) 	: Linux 2.4.18 (Red Hat 7.3)

  PostgreSQL version (example: PostgreSQL-7.4):   PostgreSQL-7.4

  Compiler used (example:  gcc 2.95.2)		: gcc 2.97


Please enter a FULL description of your problem:
------------------------------------------------
Sorry, my English very bad, but i try write it
The pg_dump not save changes as ALTER TABLE DROP CONSTRAINT in case with inheritans table


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
----------------------------------------------------------------------
#little example
create table a (d int check (d<5));
create table b () inherits (a);
alter table b drop constraint "a_d";
#after it, table b not have any constraint. Try save and restore the structure of database
#in shell:
pg_dump -s -f ~/dbtest -U postgres test
#in psql:
drop database test;
create database test;
#in shell:
psql test postgres < ~/dbtest
#Now, table b have constraint "a_d" :(



If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
I don't know :(