[BUGS] problem

2008-04-23 Thread Khobotko Oleg
Hello, help me please, I don't know how, but i got 2 postgres users. How can I delete the first one thx alot for your answers. /// select passwd,ctid,

[BUGS] BUG #4126: KRB5/GSSAPI authenication fails for multipart kerberos principals

2008-04-23 Thread Peter Koczan
The following bug has been logged online: Bug reference: 4126 Logged by: Peter Koczan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Red Hat Enterprise Linux 5 Description:KRB5/GSSAPI authenication fails for multipart kerberos principals

Re: [BUGS] HELP pls

2008-04-23 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: >> I don't know how, but i got 2 postgres users. > You've got transaction wraparound problems. Start here: Vacuuming isn't gonna help though. The tuple at (0,2) has been frozen, which means that vacuum has certainly been run

Re: [BUGS] BUG #4125: Strange ALTER TABLE behavior

2008-04-23 Thread Vladimir Kanazir
> > But, if I do this: > > alter table history add incoming_id bigint; > > alter table history alter incoming_id set default 0; > > update history set incoming_id=0; > > the table will be locked only during alter table execution, which > > is very short time. > > But this exposes the state where i

Re: [BUGS] HELP pls

2008-04-23 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: > Hello, help me please, > I don't know how, but i got 2 postgres users. > How can I delete the first one > thx alot for your answers. You've got transaction wraparound problems. Start here: http://search.postgresql.org/search?q=transaction+wraparound&m=1&l=&d=365&s

[BUGS] HELP pls

2008-04-23 Thread [EMAIL PROTECTED]
Hello, help me please, I don't know how, but i got 2 postgres users. How can I delete the first one thx alot for your answers. Oleg -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4125: Strange ALTER TABLE behavior

2008-04-23 Thread Tom Lane
"Vladimir Kanazir" <[EMAIL PROTECTED]> writes: > If I execute this query: > alter table history add incoming_id bigint default 0; > the table will be locked until operation finishes (checked by executing the > select query on the same table via another connection). Indeed, because it has to physi

[BUGS] BUG #4125: Strange ALTER TABLE behavior

2008-04-23 Thread Vladimir Kanazir
The following bug has been logged online: Bug reference: 4125 Logged by: Vladimir Kanazir Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: Fedora 7 Description:Strange ALTER TABLE behavior Details: If I execute this query: alter table his

Re: [BUGS]

2008-04-23 Thread Harald Armin Massa
Adiel, > Can someone please send me the url to download the latest PostGreSQL > database for windows. > > I would like a windows installer to do it. http://www.postgresql.org/ftp/binary/v8.3.1/win32/ That is exactly 2 klicks away from www.postgresql.org. And the links are headlined with "latest

Re: [BUGS]

2008-04-23 Thread Bill Moran
In response to "Adiel Davids" <[EMAIL PROTECTED]>: > Hi there, > > Can someone please send me the url to download the latest PostGreSQL > database for windows. > > I would like a windows installer to do it. http://www.postgresql.org/ftp/binary/v8.3.1/win32/ Or you could follow the download lin

[BUGS]

2008-04-23 Thread Adiel Davids
Hi there, Can someone please send me the url to download the latest PostGreSQL database for windows. I would like a windows installer to do it. Thanks.

Re: [BUGS] BUG #4124: Error message: "You local administrators group contains 'Service users' this is a common configurat

2008-04-23 Thread Gregory Stark
"Blake Lovely" <[EMAIL PROTECTED]> writes: > PostgreSQL version: 8.2 > Operating system: Vista home premium 8.2 was not supported on Vista as it came out long before Vista did. Try 8.3. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 P

[BUGS] Re: BUG #4123: Statement.setQueryTimeout does not work with Postgres Java Driver

2008-04-23 Thread valgog
On Apr 22, 5:53 pm, [EMAIL PROTECTED] (Kris Jurka) wrote: > On Tue, 22 Apr 2008, Amit Mujawar wrote: > > > The following bug has been logged online: > > > Bug reference:      4123 > > PostgreSQL version: 8.1 > > Description:        Statement.setQueryTimeout does not work with Postgres > > Java Driv

[BUGS] Re: BUG #4123: Statement.setQueryTimeout does not work with Postgres Java Driver

2008-04-23 Thread valgog
On Apr 22, 12:05 pm, [EMAIL PROTECTED] ("Amit Mujawar") wrote: > The following bug has been logged online: > > Bug reference:      4123 > Logged by:          Amit Mujawar > Email address:     [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system:   Windows XP > Description:        Statemen

[BUGS] help me please

2008-04-23 Thread s...@mail.ru
Hello, help me please, I don't know how, but i got 2 postgres users. How can I delete the first one thx alot for your answers. /// select passwd,ctid,xmi

Re: [BUGS] Patch for LISTEN/NOTIFY race condition?

2008-04-23 Thread Meetesh Karia
Thanks all ... I'm going to do some more digging and see if I can isolate the problem. Meetesh Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: Meetesh Karia wrote: After upgrading to 8.3 and Slony 1.2.13, one of our import processes started constantly failing because of d

[BUGS] BUG #4124: Error message: "You local administrators group contains 'Service users' this is a common configurat

2008-04-23 Thread Blake Lovely
The following bug has been logged online: Bug reference: 4124 Logged by: Blake Lovely Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Vista home premium Description:Error message: "You local administrators group contains 'Service users' this