Re: pgAdmin III: error while browsing schema of PG database

On Tue, Feb 8, 2011 at 22:09, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> On Tue, Feb 8, 2011 at 7:14 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> On Tue, Feb 8, 2011 at 11:10, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>> On 2/8/11, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>>>> On Tue, Feb 8, 2011 at 11:01, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>>> On 2/8/11, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>>>>>> On Tue, Feb 8, 2011 at 08:22, Nikhil S <nixmisc(at)gmail(dot)com> wrote:
>>>>>>>
>>>>>>>
>>>>>>>>
>>>>>>>> Well, the SQL does get fired against a PG database in the EDBAS mode
>>>>>>>> for
>>>>>>>> me. I too was puzzled about the minimum version check being EDBAS
>>>>>>>> specific.
>>>>>>>>
>>>>>>>
>>>>>>> Just checked. The version checker function checks for the version number
>>>>>>> and
>>>>>>> also for a bool which is set to true in EDBAS mode. So yeah, this will
>>>>>>> not
>>>>>>> be repro in pure Postgresql mode operations. Sorry for indicating so.
>>>>>>> But
>>>>>>> the issue defo comes if you try to browse a PG database in EDBAS mode.
>>>>>>
>>>>>> Why would you browse a PG database in EDBAS mode? Isn't there a whole
>>>>>> lot of other things that would break in that case as well?
>>>>>>
>>>>>> Or maybe I'm misunderstanding what you mean with "EDBAS mode"?
>>>>>>
>>>>>
>>>>> He means when edbas is running in PG mode instead of Oracle mode.
>>>>
>>>> Ah, that makes more sense.
>>>>
>>>> And pgadmin incorrectly identifies that as an oracle-mode ebas server?
>>>> In that case, isn't the actual problem that it's identified as edbas
>>>> and not pg?
>>>>
>>>
>>> It doesn't actually care.
>>
>> Pre this report doesn't it sound like it should?
>
> It *shouldn't*. PG/Oracle mode in PPAS is really just about whether
> certain oracle compatibility functions and packages are installed, and
> I think the date/time defaults. Oh, and possibly the default casts.
> But not the catalog schema.

Forgive me if I'm being dense... but doesn't this error indicate that
it *isn't* just that?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/