[BUGS] xmlAgg not found..

2008-08-14 Thread Tariq Aziz
Hi What I am reporttin here is probably not a bug but I found no way other than getting a support form this mailing address. I have installed PostGRESql 8.3 and try in to retrieve data in xml format for which I need to use function "xmlAgg". but that's not supported in the instance I have conf

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

2008-08-14 Thread Heikki Linnakangas
Tom Lane wrote: "Heikki Linnakangas" <[EMAIL PROTECTED]> writes: We should use range_table_walker, which knows how to descend into all kinds of RTEs... Yeah, I had been thinking of that but didn't see an easy way to apply it; of course the answer is to use IncrementVarSublevelsUp_walker direct

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

2008-08-14 Thread Tom Lane
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes: > We should use range_table_walker, which knows how to descend into all > kinds of RTEs... Yeah, I had been thinking of that but didn't see an easy way to apply it; of course the answer is to use IncrementVarSublevelsUp_walker directly as you have

Re: [BUGS] BUG #4355: TOKMAXLEN=10 to short for token strings

2008-08-14 Thread Tom Lane
"Gerhard Leykam" <[EMAIL PROTECTED]> writes: > On HP-UX using aCC this gives startup errors as: > 2008-09-04 07:13:41 GMT LOG: ordering error in deltatktbl table: "#mil" >> = "{llennia" > 2008-09-04 07:13:41 GMT LOG: ordering error in deltatktbl table: > "{millenniu" >= "p{millisec" Since n

[BUGS] BUG #4355: TOKMAXLEN=10 to short for token strings

2008-08-14 Thread Gerhard Leykam
The following bug has been logged online: Bug reference: 4355 Logged by: Gerhard Leykam Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: HP-UX 11 64bit Description:TOKMAXLEN=10 to short for token strings Details: Hi! Structure datetkn in

Re: [BUGS] BUG #4354: Text Type converted to Memo

2008-08-14 Thread David Fetter
On Thu, Aug 14, 2008 at 12:31:34PM +, Abuzar wrote: > > The following bug has been logged online: > > Bug reference: 4354 > Logged by: Abuzar > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3.1 > Operating system: Windows xp SP2 > Description:Text Type

Re: [BUGS] BUG #4354: Text Type converted to Memo

2008-08-14 Thread Bill Moran
In response to "Abuzar" <[EMAIL PROTECTED]>: > > The following bug has been logged online: > > Bug reference: 4354 > Logged by: Abuzar > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3.1 > Operating system: Windows xp SP2 > Description:Text Type converted t

[BUGS] BUG #4354: Text Type converted to Memo

2008-08-14 Thread Abuzar
The following bug has been logged online: Bug reference: 4354 Logged by: Abuzar Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Windows xp SP2 Description:Text Type converted to Memo Details: I used text, character varying type in my bas

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

2008-08-14 Thread Heikki Linnakangas
Tom Lane wrote: Probably not. But it strikes me that there's another sin of omission here: function and values RTEs need to be tweaked too, because they contain expressions thst could have uplevel Vars in them. I'm not certain such RTEs could appear at top level in a UNION query, but I'm not su