Sorry for my bad English. The report in the attach
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 [EMAIL PROTECTED]
To report any other bug, fill out the form below and e-mail it to [EMAIL PROTECTED] If you not only found the problem but solved it and generated a patch then e-mail it to [EMAIL PROTECTED] 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 : [EMAIL PROTECTED] 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 :(
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
