Re: Wrong db/table listed in "View/Edit Data" | "Filter Rows..." tabs

From: Dave Caughey <caugheyd(at)gmail(dot)com>
To: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: Wrong db/table listed in "View/Edit Data" | "Filter Rows..." tabs
Date: 2017-12-11 14:20:02
Message-ID: CAAj2gHwNw2mRGeiO4vnRJYxu6iRojR02HcVonG+NdnGG_5Yzmg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Murtuza...

What DEV machine? Is there specific support DB you'd like us to use? If
so, what its hostname and credentials?

Cheers,
Dave

On Mon, Dec 11, 2017 at 12:29 AM, Murtuza Zabuawala <
murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:

> Hi Dave,
>
> Thank you for reporting, Logged https://redmine.postgresql.org/issues/2943
> Could you please add exact steps to re-produce the issue on DEV machine in
> the ticket?
>
> --
> Regards,
> Murtuza Zabuawala
>
> On Sun, Dec 10, 2017 at 11:56 PM, Dave Caughey <caugheyd(at)gmail(dot)com> wrote:
>
>> I have a server with multiple database shards. One of those shards is
>> called 'finance', and has a table called 'transaction'.
>>
>> But when doing a "View/Edit Data" | "Filter Rows..." on a completely
>> different shard (we'll call it 'myothershard') on a different table
>> ('section'), I end up with a tab in pgAdmin that has a label claiming it is
>> from "-finance-public.transaction" when it really should be
>> "-myothershard-public.section". The header for the query's SQL is also
>> incorrectly identified as being for "-finance-public.transaction".
>>
>> And, you'll note the that the SQL for the query clearly indicates it's
>> using "public.section".
>>
>> This creates a lot of confusion when I can't reliably tell which tab
>> relates to which table.
>>
>> [image: Inline image 1]
>>
>> Cheers,
>> Dave
>>
>
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Duffey, Blake 2017-12-12 21:34:08 pre-populate pgadmin4 configuration (server, for example)
Previous Message Harshal Dhumal 2017-12-11 11:54:34 Re: Enums printout - possible bug