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

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

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Nikhil S <nixmisc(at)gmail(dot)com>, Guillaume Lelarge <guillaume(at)lelarge(dot)info>, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: pgAdmin III: error while browsing schema of PG database
Date: 2011-02-08 21:13:26
Message-ID: AANLkTimaQ5R67VCoyL_1OOiGS3ohOB_TUyJafuGAJVhg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
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/

In response to

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2011-02-08 21:19:40
Subject: Re: pgAdmin III: error while browsing schema of PG database
Previous:From: Dave PageDate: 2011-02-08 21:09:29
Subject: Re: pgAdmin III: error while browsing schema of PG database

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