SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 06:36 PM
| ||||
| ||||
 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 ---------------------------(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      |
|
04-17-2008, 06:36 PM
| |||
| |||
| Re: 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 |
|
04-17-2008, 06:36 PM
| |||
| |||
| Re: 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 |
|
04-17-2008, 06:36 PM
| |||
| |||
| Re: 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 |
|
04-17-2008, 06:36 PM
| ||||
| ||||
| Re: 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 |
 |
« SVN Commit by hiroshi: r5870 - in trunk/pgadmin3/pgadmin: dlg schema
|
SVN Commit by dpage: r5871 - branches/REL-1_6_0_PATCHES/pgadmin3/src/ui »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 11:44 AM.
