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: (view raw or whole 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')


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

That doesn't work any more :-(

Regards, Dave.

In response to


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-2015 The PostgreSQL Global Development Group