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

Re: DB restrict patch of connection

From: Dave Page <dpage(at)postgresql(dot)org>
To: Hiroshi Saito <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: DB restrict patch of connection
Date: 2007-01-16 09:16:44
Message-ID: 45AC97FC.6070003@postgresql.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
Hiroshi Saito wrote:
> Hi Dave.
> 
>> It works fine for me. You must enter something like:
> :-)
> 
>>
>> datname != 'template1'
>>
>> It's more to type, but it's much more flexible.
> 
> Um, sorry I don't understand it well. probably,  It is necessary to be
> able to select it at the display mode of the system object. The change
> in the option will be able to be selected though it doesn't appear at
> all when it is not the display mode. I think that it should not do a
> fixed restriction of logic. Is my point wrong?

Yes, please revert those changes. The code is correct as it was, because
it allows you to specify things like:

datname IN ('foo, baa')

or

datdba = (SELECT usesysid FROM pg_shadow WHERE usename = CURRENT_USER)

That doesn't work any more :-(

Regards, Dave.

In response to

Responses

pgadmin-hackers by date

Next:From: Harald Armin MassaDate: 2007-01-16 09:50:46
Subject: PgAdmin Wishlist: export to clipboard
Previous:From: Dave PageDate: 2007-01-16 08:39:11
Subject: Re: Enable/disable trigger path

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