[BUGS] Erro na instalação

2005-08-31 Thread Osni Souza
Prezado Senhor   Estou tentando instalar o Postgresql 8.0 em um Pc com Windows 2000. Qdo chega na parte de definir usuario( conta), dominio e senha, aparece os seguintes erros:   1) conta já existe   OU   2) conflito de mapeamento entre as contas     O que devo fazer? Qdo tento instalar não optando

[BUGS] BUG #1857: Problem with driver ODBC

2005-08-31 Thread Cleber Nardelli
The following bug has been logged online: Bug reference: 1857 Logged by: Cleber Nardelli Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows XP Professional (Client) RedHat 9 Linux (Server) Description:Problem with driver ODBC Details:

Re: [BUGS] BUG #1857: Problem with driver ODBC

2005-08-31 Thread Alvaro Herrera
On Tue, Aug 30, 2005 at 08:53:24PM +0100, Cleber Nardelli wrote: > BEGIN TRANSACTION; > DELETE FROM TABL1 WHERE ID = 1; > INSERT INTO TABL1 VALUES (1,1); > SAVEPOINT SVPT; > INSERT INTO TABL1 VALUES (1,1); > ROLLBACK TO SAVEPOINT SPVT; > COMMIT; > > When I try to insert as register it a

Re: [BUGS] PSQL commands not backwards-compatible

2005-08-31 Thread Josh Berkus
Tom, > Can you point to any single one of the past five major releases in which > psql's backslash commands *WERE* completely backwards-compatible with > previous versions of PostgreSQL? This is not breaking news. Because this is the first time I can remember where *none* of the \ commands work

Re: [BUGS] PSQL commands not backwards-compatible

2005-08-31 Thread Tom Lane
Josh Berkus writes: > Hmmm ... how difficult would it be to give a useful error message instead of > a > SQL error? Something like: > "I'm sorry, that PSQL command did not work. Most likely, you are connecting > to a different version of PostgreSQL." Well, "useful" is in the eye of the beho

Re: [BUGS] PSQL commands not backwards-compatible

2005-08-31 Thread Jim C. Nasby
On Wed, Aug 31, 2005 at 02:05:13PM -0400, Tom Lane wrote: > I like this better than Bruce's recent proposal to print a warning at > psql startup, because it emits the info when you actually need it. > How many people pay attention to psql's startup banner at all? Aren't there other compatability i

Re: [BUGS] PSQL commands not backwards-compatible

2005-08-31 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Wed, Aug 31, 2005 at 02:05:13PM -0400, Tom Lane wrote: >> I like this better than Bruce's recent proposal to print a warning at >> psql startup, because it emits the info when you actually need it. >> How many people pay attention to psql's startup ba

Re: [BUGS] BUG #1856: chinese sort error

2005-08-31 Thread Qingqing Zhou
""tk"" <[EMAIL PROTECTED]> wrote > > The following bug has been logged online: > > Bug reference: 1856 > Logged by: tk > Email address: [EMAIL PROTECTED] > PostgreSQL version: 7.0.3 > Operating system: linux > Description:chinese sort error > Details: > > chinese sort e

[BUGS] plpgsql TEMP table issue not fixed in 8.1?

2005-08-31 Thread Josh Berkus
Folks, I'd swear somebody committed a fix for the issue with temp tables inside plpgsql functions, like, months ago. Yet I still get: ERROR: relation with OID 16607 does not exist CONTEXT: SQL statement "INSERT INTO tmp_runs ( run_id, batch, machine ) VALUES ( NEXTVAL('runs_run_id_seq'), $1

Re: [BUGS] plpgsql TEMP table issue not fixed in 8.1?

2005-08-31 Thread Tom Lane
Josh Berkus writes: > I'd swear somebody committed a fix for the issue with temp tables inside > plpgsql functions, like, months ago. Nope. regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your fr