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

From: Dave Caughey <caugheyd(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Wrong db/table listed in "View/Edit Data" | "Filter Rows..." tabs
Date: 2017-12-10 18:26:53
Message-ID: CAAj2gHw2E+sQyt67c3srLo8-ya46DfKM8rU9JrQe0yPJHNh9cQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Murtuza Zabuawala 2017-12-11 05:29:13 Re: Wrong db/table listed in "View/Edit Data" | "Filter Rows..." tabs
Previous Message Khushboo Vashi 2017-12-09 06:36:38 Re: Enums printout - possible bug