Re: [pgadmin-hackers] DB restrict patch of connection
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
---(end of broadcast)---
TIP 6: explain analyze is your friend
Re: [pgadmin-hackers] DB restrict patch of connection
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.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Re: [pgadmin-hackers] DB restrict patch of connection
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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-hackers] DB restrict patch of connection
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. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-hackers] DB restrict patch of connection
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 DbRestriction_patch Description: Binary data ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
