Re: [BUGS] BUG #2929: Error opening 5432 port

2007-01-26 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Jan 25, 2007 at 09:33:14AM -0500, James Becerra wrote: > Good Morning, [...] > What happened with my server, time ago the Postgres 8.1 had worked perfect, > and 2 days ago it leaves. > I used the command “net stat –a” to see the ports and I c

Re: [BUGS] BUG #2933: PL/Python-functions don't work any more

2007-01-26 Thread Tom Lane
"Michael Eschweiler" <[EMAIL PROTECTED]> writes: > After having migrated my database with some PL/Python-functions, which > worked fine under opensuse 10.1/Postgresql 8.1.3/Python 2.4, to oss > 10.2/Postgresql 8.1.5/Python 2.5 the functions don't work any more. I won't promise that PG 8.2 works 10

Re: [BUGS] btree_delete_page_redo: lost target page

2007-01-26 Thread Tom Lane
Chris Dunlop <[EMAIL PROTECTED]> writes: > Trying to start the postmaster again failed, with what looks > like the relevent message being: > PANIC: btree_delete_page_redo: lost target page This is a known possibility if the VACUUM FULL got as far as shortening the index before crashing --- xlog

Re: [BUGS] BUG #2930: Hash join abyssmal with many null fields.

2007-01-26 Thread Maciej Babinski
Tom Lane wrote: Maciej Babinski <[EMAIL PROTECTED]> writes: Tom Lane wrote: I see no bug here. AFAICT your "much faster" query gets that way by having eliminated all the candidate join rows on the B side. The additional clause eliminates no rows beyond what the existing clause would. Any r

Re: [BUGS] BUG #2930: Hash join abyssmal with many null fields.

2007-01-26 Thread Maciej Babinski
Tom Lane wrote: "Maciej Babinski" <[EMAIL PROTECTED]> writes: Hash join of columns with many null fields is very slow unless the null fields are commented out. I see no bug here. AFAICT your "much faster" query gets that way by having eliminated all the candidate join rows on the B side.

[BUGS] BUG #2934: INSTALL FAILURE - failed to set permissions on the installed files

2007-01-26 Thread inifinity
The following bug has been logged online: Bug reference: 2934 Logged by: inifinity Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:INSTALL FAILURE - failed to set permissions on the installed files Details: I've been

[BUGS] BUG #2933: PL/Python-functions don't work any more

2007-01-26 Thread Michael Eschweiler
The following bug has been logged online: Bug reference: 2933 Logged by: Michael Eschweiler Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: opensuse 10.2 / Python 2.5 Description:PL/Python-functions don't work any more Details: After hav

Re: [BUGS] BUG #2893: Non-standard theme explodes the installer.

2007-01-26 Thread Ilya Kogan
Magnus Hagander wrote: > To me this sounds like the theme is broken. Especially since we only use it > to look for terminal services stuff iirc. it'd be interesting to see if this > can be > reproduced on a different non standard > theme. > > /Magnus > > > --- Original message --- > Fr

Re: [BUGS] BUG #2929: Error opening 5432 port

2007-01-26 Thread James Becerra
Good Morning, I suppose it was the problem, but to solve this, I have disabled the windows firewall. I am worried because I have a server with windows 2003 server running and sql server 2005 and IIS and PHP and Postgres 8.1, I tried to connect locally but the problem is the same, I installed the

Re: [BUGS] Troubles in Initializing Postgres Database 8.2

2007-01-26 Thread Maarten van der Heijden
Hi, Still no luck initializing the Database Cluster. I'm wondering which commands/files InitDb uses...it says something is missing, I would like to know what, is there a way or does someone know which programs\commands InitDb uses? Regards, Maarten -Oorspronkelijk bericht- Van: Magnus

[BUGS] btree_delete_page_redo: lost target page

2007-01-26 Thread Chris Dunlop
G'day all, PG version: 7.4.7(debian 7.4.7-6sarge2) OS: Linux (debian sarge) I started a 'vacuum full analyze' using pgsql, then, after about 10 minutes, I issued a control-c in pgsql. This hadn't returned my prompt after another 10 minutes or so. A glance at the backend showed other process

[BUGS] BUG #2931: Can't capture pg_dump Password prompt

2007-01-26 Thread Michael Schmidt
The following bug has been logged online: Bug reference: 2931 Logged by: Michael Schmidt Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Pro Description:Can't capture pg_dump Password prompt Details: I have a Java user app that

Re: [BUGS] BUG #2930: Hash join abyssmal with many null fields.

2007-01-26 Thread Tom Lane
Maciej Babinski <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I see no bug here. AFAICT your "much faster" query gets that way by >> having eliminated all the candidate join rows on the B side. > The additional clause eliminates no rows beyond what the existing > clause would. Any row elimina