Postgres Pro
Downloads
Home   >   mailing lists

Re: Added variable macro for generic db objects - Mailing list pgadmin-hackers

From Murtuza Zabuawala
Subject Re: Added variable macro for generic db objects
Date
Msg-id CAKKotZRk_unRbmGPzAbmbsBXDKO9_CUh_emeeaACRPi4y3-+cw@mail.gmail.com
Whole thread Raw
In response to Re: Added variable macro for generic db objects  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
Responses Re: Added variable macro for generic db objects
List pgadmin-hackers
Tree view
Hi Ashesh,

PFA updated patch for generic variable macro as per Neel's suggestion, now it will take collection instead of single key/value pair.

For example,

options_collection = [
{name: 'Option-1', value: 'Value-1'},
{name: 'Option-2', value: 'Value-2'},
{name: 'Option-3', value: 'Value-3'},
]

Way to use in template:

VARIABLE.SET(conn, object_type, object_name, options_collection)
VARIABLE.UNSET(conn, object_type, object_name, options_collection)


Result:
ALTER DB_OBJ TEST
    SET (Option-1=Value-1, Option-2=Value-2, Option-3=Value-3);

ALTER DB_OBJ TEST
    RESET (Option-1,Option-2,Option-3);


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Tue, Feb 2, 2016 at 7:46 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Thanks - checked in!

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


On Tue, Feb 2, 2016 at 6:31 PM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
Hi,

PFA updated patch, I missed adding parentheses in previous patch for UNSET macro .

Thanks.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Tue, Feb 2, 2016 at 5:49 PM, Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
Hi,

PFA patch to add another generic macro for variable control, previously written macro was specific to database node and not usable with other db objects.

How to use:
VARIABLE.SET(conn, object_type, object_name, variable_name, value)
VARIABLE.UNSET(conn, object_type, object_name, variable_name)


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



 --
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers



Attachment

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: pgAdmin 4 commit: Update the runtime to properly support Windows.
Next
From: Murtuza Zabuawala
Date:
Subject: Re: PATCH: Tablespace Node [pgAdmin4]