The last patch of mine you committed just made it all DROP TABLE public.tab; That at least makes it work.

Chris

Bruce Momjian wrote:

Where are we on this?

---------------------------------------------------------------------------

Kris Jurka wrote:

When running pg_dump --clean against a server that doesn't have schemas the namespace is blank and ends up producing a dump full off things like:

DROP TABLE "".tab;

The attached patch only includes a schema if one exists.  There are
numerous comments about the DROPs needing to be fully qualified to avoid
conflicting with pg_catalog, but this should be mostly safe because it
would require a user defined object to be present in a later server
version with the same name, and it is difficult to impossible to drop
system objects anyway.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to