Dave Page wrote:
I'm still not convinced we need to do anything. Renaming public is
highly irregular, and finally showing system objects will make it
reappear. The schema restriction allows individual filters
who likes it.
Renaming public is irregular, but if we can allow it without breaking
anything else, then I see no reason why we shouldn't do it.
So for god's sake do implement it, but in general I'm less than inclined
to implement workarounds for people doing weird things to the db. I'm
waiting for the guy who claims that his "was-public" schema suddenly
reapperars in pgadmin, while he just renamed it to have it hidden from
the users.... There *are* admins that deliberately rename pg objects to
hide them from pgadmin's sight.
Regards,
Andreas
---------------------------(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
match
