On 7/14/06, Tom Lane <[EMAIL PROTECTED]> wrote:

[ problems with missing schema in dump ]

No, not one of these things can be blamed on pg_dump.

Ok, its not exactly bug but still a big annoyance that
instead dumping fully qualified names it juggles with
search path.  And I'm annoyed as a user looking at the dump:

* To see what schema the function/table/type is in, I need to
carefully look several pages back until there is schema change.

* I cannot copy-paste from dump.

* The function contents must still contain fully-qualified
names, so it cannot be said that the schema is not part of
function definition in some way.  Same goes for other objects.

* The name 'search_path' for picking storage is sick :)
I understand the backwards-compatibility angle, but the over-usage
in dumps makes it even more sick...


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

Reply via email to