Skip site navigation (1) Skip section navigation (2)

Re: detecting serials in 8.1

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: detecting serials in 8.1
Date: 2006-02-20 10:31:44
Message-ID: 43F99A90.9080609@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-hackers
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

In response to

Responses

pgadmin-hackers by date

Next:From: Andreas PflugDate: 2006-02-20 10:40:25
Subject: Re: Query tool results in grid
Previous:From: edigeronimoDate: 2006-02-20 03:52:43
Subject: Query tool results in grid

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group