Re: detecting serials in 8.1

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