Re: Conditional Tables Feature on PostGresSQL

[Aditya Toshniwal]

Hi Sanchari,

You can use the query tool to write anonymous blocks. Else, can you please
explain with an example what exactly is the requirement ?

On Fri, Oct 22, 2021 at 10:05 PM Sanchari Biswas (Shrina) <
sanchari.shr...@gmail.com> wrote:

> Hello,
>
> Is there any existing feature that enables the use of conditional tables
> on PostGreSQL, specifically the usage of variables, and implementing those
> variables in our (complex) queries?
>
> Thanks,
> Sanchari.
>
>

-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*

"Don't Complain about Heat, Plant a TREE"

Re: Conditional Tables Feature on PostGresSQL

[Sanchari Biswas]

Hi Aditya,

Can we use variables in any column and then have (Boolean) constraints over
the variables?
Eg. x as a variable value and then corresponding condition (x ≠ 5 || x ≠
10).
So that this condition is satisfied when queried with values of column
(with variable x) other than the above two and the condition converts to
actual constant values, and returns tuples with that actual value.

Thanks,
Sanchari.

On Mon, Oct 25, 2021, 12:11 AM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Sanchari,
>
> You can use the query tool to write anonymous blocks. Else, can you please
> explain with an example what exactly is the requirement ?
>
> On Fri, Oct 22, 2021 at 10:05 PM Sanchari Biswas (Shrina) <
> sanchari.shr...@gmail.com> wrote:
>
>> Hello,
>>
>> Is there any existing feature that enables the use of conditional tables
>> on PostGreSQL, specifically the usage of variables, and implementing those
>> variables in our (complex) queries?
>>
>> Thanks,
>> Sanchari.
>>
>>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> 
> "Don't Complain about Heat, Plant a TREE"
>

pgAdmin 4 commit: Ensure that dialog should be opened when clicking on

[Akshay Joshi]

Ensure that dialog should be opened when clicking on Reassign/Drop owned menu. 
Fixes #6949

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=8eb6f8061d9eec7986deebec8246896531ea1d80
Author: Rahul Shirsat 

Modified Files
--
docs/en_US/release_notes_6_2.rst  | 1 +
web/pgadmin/browser/server_groups/servers/roles/static/js/role.js | 4 ++--
2 files changed, 3 insertions(+), 2 deletions(-)

Re: [patch][pgAdmin] RM6949 When user Clicking on Reassign/Drop owned no dialog box opens

[Akshay Joshi]

Thanks, the patch applied.

On Fri, Oct 22, 2021 at 2:06 PM Rahul Shirsat <
rahul.shir...@enterprisedb.com> wrote:

> Hi Hackers,
>
> Please find the attached patch which resolves the issue of not opening a
> reassign/drop owned dialog box.
>
> --
> *Rahul Shirsat*
> Senior Software Engineer | EnterpriseDB Corporation.
>


-- 
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres *

*Mobile: +91 976-788-8246*