Re: [BUGS] BUG #4825: Before installation the server not running

2009-05-28 Thread Craig Ringer
Herbert Bonaffini wrote: > The following bug has been logged online: > > Bug reference: 4825 > Logged by: Herbert Bonaffini > Email address: hgsystem.m...@gmail.com > PostgreSQL version: 8.3.7-1 > Operating system: Windows > Description:Before installation the server n

Re: [BUGS] BUG #4822: xmlattributes encodes '&' twice

2009-05-28 Thread Itagaki Takahiro
Tom Lane wrote: > > =# SELECT xmlelement(name a, xmlattributes('./qa?a=1&b=2' as href), 'Q&A'); > > xmlelement > > > > Q&A > > > '&' in xmlattributes seems to be encoded twice. > > This was apparently broken by Peter's patch here:

Re: [BUGS] BUG #4824: KRB5/GSSAPI authentication fails when user != principal

2009-05-28 Thread Peter Koczan
On Wed, May 27, 2009 at 5:16 PM, Tom Lane wrote: > What this still leaves us with is whether that change is a bad idea or > not.  I still think it's OK, but maybe Peter can point to something > else. I recompiled postgres with the auth.c patch. This is only an issue if you are trying to connect

Re: [BUGS] BUG #4824: KRB5/GSSAPI authentication fails when user != principal

2009-05-28 Thread Tom Lane
Peter Koczan writes: > I should also point out that old clients still exhibit the old behavior. Sure, because this is a libpq change. > It was rather convenient to know that whatever Kerberos principal was > used was going to be the database user. Isn't that still true? (Modulo the auth.c bug

[BUGS] BUG #4827: install

2009-05-28 Thread Silvano de Souza
The following bug has been logged online: Bug reference: 4827 Logged by: Silvano de Souza Email address: silvano.so...@ionics.com.br PostgreSQL version: 8.1.4 Operating system: windows xp sp2 Description:install Details: error: Failed to get System metrics for termi

Re: [BUGS] BUG #4824: KRB5/GSSAPI authentication fails when user != principal

2009-05-28 Thread Peter Koczan
On Thu, May 28, 2009 at 1:30 PM, Tom Lane wrote: > Peter Koczan writes: >> It was rather convenient to know that whatever Kerberos principal was >> used was going to be the database user. > > Isn't that still true?  (Modulo the auth.c bug fix of course.)  The only > issue here is where the defaul

Re: [BUGS] BUG #4824: KRB5/GSSAPI authentication fails when user != principal

2009-05-28 Thread Peter Koczan
On Thu, May 28, 2009 at 2:07 PM, Peter Koczan wrote: > On Thu, May 28, 2009 at 1:30 PM, Tom Lane wrote: >> Peter Koczan writes: >>> It was rather convenient to know that whatever Kerberos principal was >>> used was going to be the database user. >> >> Isn't that still true?  (Modulo the auth.c b

[BUGS] BUG #4828: Fault a foreign key

2009-05-28 Thread alex
The following bug has been logged online: Bug reference: 4828 Logged by: alex Email address: alexafanas...@yandex.ru PostgreSQL version: PostgreSQL8.3.7 Operating system: Windows XP 2002 SP2 Description:Fault a foreign key Details: Run in psql: --DROP DATABASE test

Re: [BUGS] BUG #4828: Fault a foreign key

2009-05-28 Thread Tom Lane
"alex" writes: > Description:Fault a foreign key This is not a bug. If you're going to create triggers that suppress deletes then it's on your head whether that behavior is sane or not. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresq

[BUGS] BUG #4829: nth_value does not allow window frame

2009-05-28 Thread lily li
The following bug has been logged online: Bug reference: 4829 Logged by: lily li Email address: l...@sybase.com PostgreSQL version: 8.4.0-lb2-windo Operating system: window 2000 Description:nth_value does not allow window frame Details: I type in query select c1, c2

Re: [BUGS] BUG #4829: nth_value does not allow window frame

2009-05-28 Thread Tom Lane
"lily li" writes: > It looks like postgreSQl 8.4 does not allow window frame clause inside OVER > clause. What it allows is spelled out in the fine manual: http://www.postgresql.org/docs/8.4/static/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS Future versions of PG might support more, but this is

Re: [BUGS] BUG #4827: install

2009-05-28 Thread Euler Taveira de Oliveira
Silvano de Souza escreveu: > Failed to get System metrics for terminal services:87 > 8.1 is *not* supported on Windows platform anymore. Consider using the latest stable release which is 8.3.7. If you can't, at least you should be using the latest 8.1.X version (which is 8.1.17); have in mind that

Re: [BUGS] BUG #4826: Cannot install Postgresql

2009-05-28 Thread Craig Ringer
Tobias Storm wrote: > The following bug has been logged online: > > Bug reference: 4826 > Logged by: Tobias Storm > Email address: tobias_st...@ofir.dk > PostgreSQL version: postgresql-8.3 > Operating system: Windows XP Home Edition > Description:Cannot install Postgre