Re: [GENERAL] Functions in CHECK constraint not getting dumped before

2004-02-05 Thread Tom Lane
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes: > The only issue that i noticed now with pg_dump version 7.5dev > is that create schemas are not dumped before user definations. > which have their search_path set by ALTER USER command. "dev" how far back? I thought we fixed that a little while ag

Re: [GENERAL] Functions in CHECK constraint not getting dumped before

2004-02-05 Thread Rajesh Kumar Mallah
Greetings! The only issue that i noticed now with pg_dump version 7.5dev is that create schemas are not dumped before user definations. which have their search_path set by ALTER USER command. eg ALTER USER arvind SET search_path TO 'erp'; ERROR: schema "erp" does not exist This is relatively ha

Re: [GENERAL] Functions in CHECK constraint not getting dumped before

2004-02-05 Thread Rajesh Kumar Mallah
Rajesh Kumar Mallah wrote: Tom Lane wrote: It is found that pg_dump does not dump function referred in CHECK constraint definations before dumping the table defination . As a result the tables do not get restored due to lack of defined functions. Is it something that will be worked upon

Re: [GENERAL] Functions in CHECK constraint not getting dumped before tables.

2004-02-01 Thread Tom Lane
> It is found that pg_dump does not dump function referred in CHECK > constraint definations before dumping the table defination . As a result > the tables > do not get restored due to lack of defined functions. > Is it something that will be worked upon in future ? This is fixed in CVS tip.

[GENERAL] Functions in CHECK constraint not getting dumped before tables.

2004-02-01 Thread Rajesh Kumar Mallah
Greetings! It is found that pg_dump does not dump function referred in CHECK constraint definations before dumping the table defination . As a result the tables do not get restored due to lack of defined functions. Is it something that will be worked upon in future ? regds mallah. -