Re: [Firebird-devel] RFC: non-expandable fields

2013-04-05 Thread Doug Chamberlin
On Fri, Apr 5, 2013 at 10:52 AM, Alexandre Benson Smith ibl...@thorsoftware.com.br wrote: I don't think trowing an error is the best, the select could be performed but no value returned for that column. The engine should provide mechanisms to treat it as a whole like select * from MyTable

Re: [Firebird-devel] RFC: non-expandable fields

2013-04-04 Thread Doug Chamberlin
On Thu, Apr 4, 2013 at 3:18 PM, Mark Rotteveel m...@lawinegevaar.nl wrote: On the other hand: using select * for anything other than ad-hoc queries is bad. Should we support that? Isn't it bad ONLY because the expanded list is unmanagable and unpredictable? This proposal is a step toward

Re: [Firebird-devel] RFC: non-expandable fields

2013-04-04 Thread Doug Chamberlin
On Thu, Apr 4, 2013 at 3:36 PM, Mark Rotteveel m...@lawinegevaar.nl wrote: I would say the expanded list would remain unmanageable and unpredictable even if SELECT privileges would limit the expansion of *. I didn't say it solved the whole problem. I said it was a step toward solving the

Re: [Firebird-devel] RFC: non-expandable fields

2013-04-04 Thread Doug Chamberlin
So forget the previous discussion for a moment. Especially any parts about the best ways to implement replication and SELECT * problems. Without getting into the details of the use case, essentially the OP asked for a way to suppress the presence of selected fields in tables. Seems to me the

Re: [Firebird-devel] Firebird new release is needed

2013-03-15 Thread Doug Chamberlin
Ok, I'll bite. What is LO? -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_marFirebird-Devel mailing list, web

Re: [Firebird-devel] Firebird 3, time to rename conflict names ?

2012-11-16 Thread Doug Chamberlin
Why not use underlines? On 11/16/12 6:34 PM, Adriano dos Santos Fernandes wrote: Why do use underlines when fb alone is a good prefix (that don't mess with the next word)? -- Monitor your physical, virtual and cloud

Re: [Firebird-devel] Firebird Transaction ID limit solution

2012-01-17 Thread Doug Chamberlin
It seems Oracle has a related issue with their SCN values: http://www.infoworld.com/d/security/revealed-fundamental-oracle-flaw-184163?source=IFWNLE_nlt_daily_2012-01-17 -- Keep Your Developer Skills Current with

Re: [Firebird-devel] Initializing security database for first use

2012-01-01 Thread Doug Chamberlin
Why limit it to so little? Make the limit 1KB or 2KB to encourage pass phrases instead of passwords. Full sentences that are meaningful to the person are WAY better protection than complex passwords. On 12/21/11 4:19 PM, W O wrote: Just 8 letters for a password seems to me very short. It is