Thread: DB restrict patch of connection

DB restrict patch of connection

From
"Hiroshi Saito"
Date:
Hi Dave.

I think correct the behavior of the DB connection
restriction. The function is dead now. this is 1.6.2..
moreover current-svn too. this corrects the problem.
please review.

Regards,
Hiroshi Saito

Attachment

Re: DB restrict patch of connection

From
Dave Page
Date:
Hiroshi Saito wrote:
> Hi Dave.
>
> I think correct the behavior of the DB connection restriction. The
> function is dead now. this is 1.6.2..
> moreover current-svn too. this corrects the problem.
> please review.

It works fine for me. You must enter something like:

datname != 'template1'

It's more to type, but it's much more flexible.

Regards, Dave.

Re: DB restrict patch of connection

From
"Hiroshi Saito"
Date:
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?

Regards,
Hiroshi Saito



Re: DB restrict patch of connection

From
Dave Page
Date:
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.

Re: DB restrict patch of connection

From
"Hiroshi Saito"
Date:
Hi Dave.

> 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 :-(

Oh  sorry, I arrange an idea again.

Regards,
Hiroshi Saito