Re: [BUGS] Bug related with permissions - VIEWS and RULES

2004-07-09 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > On Tue, Jul 06, 2004 at 09:33:17AM +0100, Luis Sousa wrote: >> Can anyone tell me if the bug reported on >> http://www.mail-archive.com/[EMAIL PROTECTED]/msg07755.html is >> already fixed? > 7.3.6 is the latest for the 7.3 series and I believe that bu

Re: [BUGS] Fwd: postgresql-autodoc - missinterprets "version"

2004-07-09 Thread Tom Lane
Martin Pitt <[EMAIL PROTECTED]> writes: > On 2004-07-08 7:10 -0700, Stephan Szabo wrote: >> It doesn't appear to be necessary to quote the identifier, however version >> and "version" refer to the same identifier in this case so I wouldn't call >> it an error, either. > This makes sense, thank yo

Re: [BUGS] Improper processing of random values in sub-queries

2004-07-09 Thread Tom Lane
David Newall <[EMAIL PROTECTED]> writes: > NOW CONSIDER the following query, executed using psql: > SELECT i, j from ( > SELECT i, ((i + 18 * random())::integer % 20 + 1) AS j FROM data > ) foo WHERE j = 15; Hmph. Evidently the planner should refuse to flatten subselects that have volatile fun

Re: [BUGS] BUG #1188: evaluation order of select seems to be wrong

2004-07-09 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Wed, 7 Jul 2004, Peter Eisentraut wrote: >> Am Mittwoch, 7. Juli 2004 14:58 schrieb PostgreSQL Bugs List: > Description:evaluation order of select seems to be wrong >> >> Please read this: >> http://www.postgresql.org/docs/7.4/static/sql-expre

Re: [BUGS] BUG #1187: Problem in SQL Functions on Composite Types

2004-07-09 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > ERROR: query-specified return row and actual function return row do not > match > What is wrong? Dunno, your example works perfectly for me. How up to date is your copy of 7.5devel? regards, tom lane --

Re: [BUGS] compile error in contrib/xml2

2004-07-09 Thread John Gray
On Fri, 09 Jul 2004 16:04:30 +0200, Markus Bertheau wrote: > Hi, > > I'm trying to compile the CVS version of contrib/xml2 for > postgresql-7.4.2. I'm hitting that error: > > [EMAIL PROTECTED] pgxml2]$ gcc -fpic -c xpath.c -I`pg_config --includedir-server` > `pkg-config libxml-2.0 --cflags` > x

Re: [BUGS] Bug related with permissions - VIEWS and RULES

2004-07-09 Thread Alvaro Herrera
On Tue, Jul 06, 2004 at 09:33:17AM +0100, Luis Sousa wrote: > Can anyone tell me if the bug reported on > http://www.mail-archive.com/[EMAIL PROTECTED]/msg07755.html is > already fixed? > I'm using PostgreSQL 7.3.3 on i386-pc-linux-gnu, compiled by GCC gcc > (GCC) 3.3 (Debian), and I have the s

[BUGS] ecpg -D SYMBOL

2004-07-09 Thread Luke McFarlane
Hi I'm running postgresql 7.4.1 and ecpg 3.1.0. When defining a symbol on the command line with ecpg -D SYMBOL the ecpg preprocessor will replace that symbol with empty space in 'C' program space rather than limiting it to 'SQL' program space. For example: EXEC SQL IFDEF SYMBOL; EXEC SQL ... EXE

[BUGS] Bug related with permissions - VIEWS and RULES

2004-07-09 Thread Luis Sousa
Hi all, Can anyone tell me if the bug reported on http://www.mail-archive.com/[EMAIL PROTECTED]/msg07755.html is already fixed? I'm using PostgreSQL 7.3.3 on i386-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3 (Debian), and I have the same problem described for 7.3.4 and 7.4.1. This bug can b

Re: [BUGS] BUG #1118: Misleading Commit message

2004-07-09 Thread Bruce Momjian
Do we want to add this to TODO: * Issue an extra message when COMMIT completes an failed transaction --- elein wrote: > > > > On Sun, Mar 28, 2004 at 10:23:26AM -0500, Tom Lane wrote: > > Bruce Momjian <[EMAIL P

[BUGS] compile error in contrib/xml2

2004-07-09 Thread Markus Bertheau
Hi, I'm trying to compile the CVS version of contrib/xml2 for postgresql-7.4.2. I'm hitting that error: [EMAIL PROTECTED] pgxml2]$ gcc -fpic -c xpath.c -I`pg_config --includedir-server` `pkg-config libxml-2.0 --cflags` xpath.c: In function `xpath_table': xpath.c:653: error: `work_mem' undeclared