Re: [BUGS] HELP

2005-09-27 Thread Chris Travers
Vaccaro wrote: I never download your product i don't even know what it is. When i started my computer up i saw 2 new accounts created. User Accounts. The accounts names were postgres services. It was password protected and limited account. I am running on windows XP. I Did delete the account

Re: [BUGS] BUG #1916: selection criteria from one outer join on clause applied to other joins

2005-09-27 Thread Klint Gore
On Wed, 28 Sep 2005 00:34:37 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > "Kevin Grittner" <[EMAIL PROTECTED]> writes: > > Obviously, adding an outer join to a query which is already returning rows > > should never reduce the number of rows returned. > > I think this is a case of overenthusiastic

Re: [BUGS] BUG #1916: selection criteria from one outer join on clause applied to other joins

2005-09-27 Thread Tom Lane
"Kevin Grittner" <[EMAIL PROTECTED]> writes: > Obviously, adding an outer join to a query which is already returning rows > should never reduce the number of rows returned. I think this is a case of overenthusiastic propagation of implied equalities. Do you know offhand if it fails in 8.0.* or ea

[BUGS] BUG #1916: selection criteria from one outer join on clause applied to other joins

2005-09-27 Thread Kevin Grittner
The following bug has been logged online: Bug reference: 1916 Logged by: Kevin Grittner Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1beta2 Operating system: Linux and Windows Description:selection criteria from one outer join on clause applied to other join

Re: [HACKERS] [BUGS] BUG #1883: Renaming a schema leaves inconsistent

2005-09-27 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > With the following errors caused by ALTER SCHEMA RENAME, I recommend we > > remove this feature for 8.1 and revisit it for 8.2. > > It's a mistake to blame ALTER SCHEMA RENAME for this problem, as you can > cause it equally well by renaming the sequence

Re: [BUGS] BUG #1913: select into a table missing a row part 2

2005-09-27 Thread Alvaro Herrera
On Tue, Sep 27, 2005 at 10:37:06AM -0400, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > It may be related to the latest outer join bug, which Tom Lane fixed > > yesterday or the day before. I'll recompile and retest. > > That was my first thought also. Does the plan for the se

Re: [HACKERS] [BUGS] BUG #1883: Renaming a schema leaves inconsistent

2005-09-27 Thread Tom Lane
Bruce Momjian writes: > With the following errors caused by ALTER SCHEMA RENAME, I recommend we > remove this feature for 8.1 and revisit it for 8.2. It's a mistake to blame ALTER SCHEMA RENAME for this problem, as you can cause it equally well by renaming the sequence itself, or by moving it int

Re: [HACKERS] [BUGS] BUG #1883: Renaming a schema leaves inconsistent

2005-09-27 Thread Bruce Momjian
With the following errors caused by ALTER SCHEMA RENAME, I recommend we remove this feature for 8.1 and revisit it for 8.2. I would just remove the grammar construct for it and the documentation. To fix this, we would need to redesign the way we store DEFAULT sequence assignments, and I don't th

Re: [BUGS] BUG #1913: select into a table missing a row part 2

2005-09-27 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > It may be related to the latest outer join bug, which Tom Lane fixed > yesterday or the day before. I'll recompile and retest. That was my first thought also. Does the plan for the select-from-view involve a hash join? Have you finished testing with

Re: [BUGS] BUG #1913: select into a table missing a row part 2

2005-09-27 Thread Alvaro Herrera
On Tue, Sep 27, 2005 at 09:17:18AM +0100, Keith Randall wrote: > I'm missing a row when I generate a table off a view. > > select count(*) from foo; > > 20811 > > select * into temp from foo; > select count(*) from temp; > > 20810 Interesting. I can duplicate this behavior here. Howe

[BUGS] BUG #1914: Corrupted Table

2005-09-27 Thread Cris Gamboa
The following bug has been logged online: Bug reference: 1914 Logged by: Cris Gamboa Email address: [EMAIL PROTECTED] PostgreSQL version: not sure Operating system: Redhat Linux 9 Description:Corrupted Table Details: Hi, we are newly using PostGre and after a few mo

[BUGS] BUG #1912: select into a table missing a row

2005-09-27 Thread Keith Randall
The following bug has been logged online: Bug reference: 1912 Logged by: Keith Randall Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1beta2 Operating system: Linux 2.4.21-15 Redhat enterprise Description:select into a table missing a row Details: I'm missin

[BUGS] BUG #1913: select into a table missing a row part 2

2005-09-27 Thread Keith Randall
The following bug has been logged online: Bug reference: 1913 Logged by: Keith Randall Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1beta2 Operating system: Linux 2.4.21-15 Redhat enterprise Description:select into a table missing a row part 2 Details: I'm

Re: [BUGS] Can not build libpq.dll with BCC

2005-09-27 Thread Magnus Hagander
> Error E2451 ..\..\port\getaddrinfo.c 245: Undefined symbol > 'WSA_NOT_ENOUGH_MEMORY' in function pg_getaddrinfo Error > E2451 ..\..\port\getaddrinfo.c 335: Undefined symbol > 'WSA_NOT_ENOUGH_MEMORY' in function pg_gai_strerror Error > E2451 ..\..\port\getaddrinfo.c 404: Undefined symbol > 'W

[BUGS] Can not build libpq.dll with BCC

2005-09-27 Thread CN
Hi! I filled out the bug form but I don't see my report appear in bug archive. Hence I am resorting to pgsql-bug list. Regards, CN OS: Win98 on top of win4lin on top of Linux Compiler BC++ 5.6.4 Possible bug 1: Unless lines 142 and 143 in ~/interfaces/libpq/bcc32.mak are changed to