Kris Jurka wrote:
Andreas Pflug wrote:
Kris Jurka wrote:
Actually it turns out that whether the schema gets in there or not
depends on the search path when the table is created.
That's what pgSchema::GetPrefix does too.
That's fine as long as you assume that the search path never changes and
as long as you only have one schema in your search path. I don't think
these are assumptions we can make.
It's _always_ fine, because GetSchema obeys the search path and the
reengineered SQL is meant to be used in a search path situation as it
was at the time of reengineering. There are plenty of other situations
where the reduced form (omitting search-pathed schema) won't work.
Regards,
Andreas
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq