Re: [BUGS] BUG #2042: Installation failed

Please don't remove the list from the recipients. Added back. > This was on my Windows XP. I never installed Postgresql > before on this computer. I do not know which account it was, since > > > >> Internal account lookup failure: No mapping between > > accound names and > > >> security IDs wa

Re: [BUGS] VERIFIED FIXED: Huge query stalls at PARSE/BIND stage

Patch applied to version 8.1. Large query now runs in seconds. Thanks Tom. Regards, Matt Carter

Re: [BUGS] BUG #2052: Federal Agency Tech Hub Refuses to Accept

Tom Lane wrote: "Ferindo Middleton" <[EMAIL PROTECTED]> writes: This bug report involves more than one proposed bug. I work at a federal government agency. The information technology division at this agency refuses to allow the database version 8.0.4 on their network because of several securi

[BUGS] BUG #2063: Unsupported frontend protocol

The following bug has been logged online: Bug reference: 2063 Logged by: neeraj chaudhari Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.4 Operating system: Red Hat linux 9.0 Description:Unsupported frontend protocol Details: Hi, i have recently installed

Re: [BUGS] BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice

TODO has: o Add ON COMMIT capability to CREATE TABLE AS ... SELECT --- David Fetter wrote: > On Thu, Nov 17, 2005 at 05:32:43PM -0500, Tom Lane wrote: > > David Fetter <[EMAIL PROTECTED]> writes: > > > On Thu, Nov 1

Re: [BUGS] BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP

On Tue, Nov 22, 2005 at 06:20:37PM -0500, Bruce Momjian wrote: > > TODO has: > > o Add ON COMMIT capability to CREATE TABLE AS ... SELECT Great :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! ---(end o

Re: [BUGS] strange disappearence of postgres file

"Harald Armin Massa" <[EMAIL PROTECTED]> wrote > > 2005-11-21 09:45:50 ERROR: could not open relation 1663/17253/43471: No > such > file or directory > > My checking showed that... within directory data/base/17253 there is > indeed > no file named 43471; but ones named 43470,43472,43473 . >

Re: [BUGS] BUG #2063: Unsupported frontend protocol

""neeraj chaudhari"" <[EMAIL PROTECTED]> wrote > > FATAL: unsupported frontend protocol > FATAL: unsupported frontend protocol > FATAL: unsupported frontend protocol > > Then to i am able to connect to the database & access & modify the > records. > It looks like your client guesses out the r

[BUGS] Patch to allow contrib/pgbench files to have blank lines

Folks, Having blank lines in -f scripts was causing silent failures. This fixes it, for some value of "fixes." If it's OK, please apply to 8.1 CURRENT and CVS TIP :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! Index: contrib/pgbench/

[BUGS] BUG #2066: installer error: code 2755.

The following bug has been logged online: Bug reference: 2066 Logged by: apco Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows XP with sp2 Description:installer error: code 2755. Details: Postgresql MUI wrapper: can't find specified

[BUGS] BUG #2065: Problem with language conversion in pg_dump

The following bug has been logged online: Bug reference: 2065 Logged by: Wim Audenaert Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0.2 Operating system: Windows XP Description:Problem with language conversion in pg_dump Details: I have a database create

[BUGS] BUG #2064: retrieving more the 6 columns from a table via c#

The following bug has been logged online: Bug reference: 2064 Logged by: tr Email address: [EMAIL PROTECTED] PostgreSQL version: 1.2.1 Operating system: windows Description:retrieving more the 6 columns from a table via c# Details: I'm trying to run a simple select

Re: [BUGS] BUG #2065: Problem with language conversion in pg_dump

"Wim Audenaert" <[EMAIL PROTECTED]> writes: > When I try to do a pg_dump of my database, I get the following error > message: > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR: cache lookup failed for function > 17039 I'm not sure how you managed that, but I'm sure that i

Re: [BUGS] BUG #2065: Problem with language conversion in pg_dump

"Wim Audenaert" <[EMAIL PROTECTED]> writes: > When I create a new database, this function (oid 17039 and used for utf8 > translation) is not defined in the pg_proc table. I tried to create a new > database. The pg_proc table contains several functions, but not this one. Hmm, I see that utf8_to_t

[BUGS] Incorrect column identifer using AS in SELECT statement on a VIEW.

If I create a normal table and a normal view that queries that table I get incorrect results when I query the view using the AS alias in the select statement.  For example, if I create the following objects: CREATE TABLE Test1( col1 VARCHAR(200) ); CREATE VIEW Test2 AS SELECT col1 FROM Test1 ORDER

Re: [BUGS] strange disappearence of postgres file

Quingqing, no, it is definitely NOT a temp table. I know which table it is, because: that "could not open relation ..." error message was exactly provokable with "select * from repofeld", which is one of my tables in that database. (And that was the way it was passed on to me: my application put

Re: [BUGS] Incorrect column identifer using AS in SELECT statement on a VIEW.

Also forgot to mention that this only started occuring in PostgreSQL 8.1. Here is my SELECT version() output:     version ---  PostgreSQL 8.1.0 on i686-r