Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-11 Thread Dimitri Fontaine
'Bruce Momjian' writes: > Well, we can't walk the function tree to know all called functions, and > those they call, so we don't even try. Inter function dependencies is a hard topic indeed. I still would like to see some kind of progress being made someday. The general case is turing complete th

Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-11 Thread Terje Elde
On Oct 11, 2013, at 9:21 AM, Dimitri Fontaine wrote: > Inter function dependencies is a hard topic indeed. I still would like > to see some kind of progress being made someday. The general case is > turing complete tho, because you can use EXECUTE against programatically > generated SQL. > > You

Re: [BUGS] Bit String expand bug

2013-10-11 Thread Tom Lane
Gabriel Ciubotaru writes: > There's a problem with expanding Bit String data types, it make > right padding with 0 instead of left padding , making the bit mask > almost useless. You need to show an example of the problem; this report has no details that would let us fix anything.

Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-11 Thread Tom Lane
Terje Elde writes: > Would it be possible (and make sense) to solve this in a completely different > way, not walking the function tree or doing static analysis, but simply > setting and checking a bit during execution? While it's possible that we could do something like that, I think it's fair

[BUGS] BUG #8518: FreeBSD usage in 9.3.1

2013-10-11 Thread david . kumar
The following bug has been logged on the website: Bug reference: 8518 Logged by: david Email address: david.ku...@vsoftcorp.com PostgreSQL version: 9.3.1 Operating system: Windows 7 Description: Hi All, I had tried using FreeBSD disk encryption but unable to find to

Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-11 Thread Dwayne Towell
> According to the documentation, f() should be marked VOLATILE also, since > calling f() produces side effects. PostgreSQL does not give a warning (or > better yet, an error); I think it should. I think the answer is that function authors are required to prevent functions they mark as STABLE from

[BUGS] Feature request - Information Schema enhancement

2013-10-11 Thread Joe Love
I know the Information Schema is a SQL standard, but it's somewhat lacking. I was trying to write a web page that showed a db table,it's columns and foreign keys. All went well and I was able to get this tool working great using the information_schema, problem is that some of the information_sche