Re: [BUGS] BUG #4321: 8.3 installer shortens allowable BASE_DIR path length?

2008-08-11 Thread Bruce Momjian
Dave, Magnus, did you see this report? --- Bob Kuhfahl wrote: > > The following bug has been logged online: > > Bug reference: 4321 > Logged by: Bob Kuhfahl > Email address: [EMAIL PROTECTED] > PostgreSQ

Re: [BUGS] return query with set-returning functions

2008-08-11 Thread Robert Treat
On Monday 11 August 2008 21:38:38 Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > > the second function takes a uuid, looks up an integer representation, and > > then calls the first function. whenever I run it, I get the following > > error: > > > > reconnoiter=# select * from > > str

Re: [BUGS] BUG #4350: 'select' acess given to views containing "union all" even though user has no grants

2008-08-11 Thread Tom Lane
I wrote: > That's one heck of a scary patch: nowhere in list_union's API is there > any guarantee that it preserves list ordering, but we *must not* change > the positions of the existing rtable entries. Actually there's a more fundamental problem, namely that pulled-up subqueries aren't necessari

Re: [BUGS] BUG #4350: 'select' acess given to views containing "union all" even though user has no grants

2008-08-11 Thread Tom Lane
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > + root->parse->rtable = list_union(root->parse->rtable, subquery->rtable); That's one heck of a scary patch: nowhere in list_union's API is there any guarantee that it preserves list ordering, but we *must not* change the positions of the exis

Re: [BUGS] return query with set-returning functions

2008-08-11 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: > the second function takes a uuid, looks up an integer representation, and > then > calls the first function. whenever I run it, I get the following error: > reconnoiter=# select * from > stratcon.fetch_dataset('cfe2aad7-71e5-400b-8418-a6d5834a0386'::uu

Re: [BUGS] BUG #4351: Full text search performance

2008-08-11 Thread Tom Lane
"Lawrence Cohan" <[EMAIL PROTECTED]> writes: > -- Is there anything wrong in the sequence below? Sory but I couldn't figure > it out by myself from FAQ or from the internet. > --Added FT indexes as documented for product_name and long_description > CREATE INDEX idx_ft_products_long_description ON

[BUGS] return query with set-returning functions

2008-08-11 Thread Robert Treat
we might have found a bug in postgres... first draft of bug report looks like so using 8.3.3, i have the following 2 plpgsql functions reconnoiter=# \df stratcon.fetch_dataset List of functions Schema | Name |

[BUGS] BUG #4351: Full text search performance

2008-08-11 Thread Lawrence Cohan
The following bug has been logged online: Bug reference: 4351 Logged by: Lawrence Cohan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Linux Red Hat 5.1 Description:Full text search performance Details: -- We are about to use full text

Re: [BUGS] BUG #4350: 'select' acess given to views containing "union all" even though user has no grants

2008-08-11 Thread Heikki Linnakangas
Heikki Linnakangas wrote: Brendan O'Shea wrote: There appears to be a bug in the way that permissions are determined for views that contain "UNION ALL" in their definition. There is a simple test case to reproduce the bug. 1) As a superuser create the following objects: CREATE ROLE test_perm

Re: [BUGS] BUG #4350: 'select' acess given to views containing "union all" even though user has no grants

2008-08-11 Thread Heikki Linnakangas
Brendan O'Shea wrote: There appears to be a bug in the way that permissions are determined for views that contain "UNION ALL" in their definition. There is a simple test case to reproduce the bug. 1) As a superuser create the following objects: CREATE ROLE test_perm LOGIN PASSWORD 'test_per

Re: [BUGS] BUG #3818: Cross compilation problems

2008-08-11 Thread Richard Evans
> Am Saturday, 9. August 2008 schrieb Richard Evans: >> I've made a couple of patches, for 8.3.3 and 8.2.9, which enable cross >> compilation for windows (mingw32) from a unix platform. > > This looks good, with a couple of tweaks. I don't think we are going to be > making these kinds of change

[BUGS] BUG #4350: 'select' acess given to views containing "union all" even though user has no grants

2008-08-11 Thread Brendan O'Shea
The following bug has been logged online: Bug reference: 4350 Logged by: Brendan O'Shea Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.9 Operating system: linux-2.4 and windows XP Description:'select' acess given to views containing "union all" even though u

Re: [BUGS] ALTER TABLE name RENAME TO new_name; does not work immediately

2008-08-11 Thread megous
On 9 Srp, 19:38, [EMAIL PROTECTED] (Gregory Stark) wrote: > <[EMAIL PROTECTED]> writes: > > ALTER TABLE name RENAME TO new_name; > > ALTER TABLE new_name > >   RENAME COLUMN x TO y; > > ... > > I think the issue might be reproducible by creating table with a lot > > of rows, setting high work_mem a

Re: [BUGS] BUG #3818: Cross compilation problems

2008-08-11 Thread Peter Eisentraut
Am Saturday, 9. August 2008 schrieb Richard Evans: > I've made a couple of patches, for 8.3.3 and 8.2.9, which enable cross > compilation for windows (mingw32) from a unix platform. This looks good, with a couple of tweaks. I don't think we are going to be making these kinds of changes in the 8.

Re: [BUGS] BUG #4344: initdb -L timezone directory

2008-08-11 Thread Peter Eisentraut
Am Thursday, 7. August 2008 schrieb Tom Lane: > I rather wonder whether -L has any reason to live at all. initdb's > default is to locate PGSHAREDIR relative to where it finds the backend > executable, which is consistent with what the backend itself is going > to do. Is there any scenario where