Re: [BUGS] BUG #1434: ERROR: type "bigserial" does not exist

2005-01-29 Thread Bruce Momjian
Alvaro Herrera wrote: > On Sat, Jan 22, 2005 at 10:28:16PM +, Brad Snobar wrote: > > > The column was a primary key bigint. > > > > ALTER TABLE "public"."CategoryBuildingRankSchemas" > > ALTER COLUMN "IDCategoryBuildingRankSchema" TYPE BIGSERIAL; > > > > ERROR: type "bigserial" does not e

[BUGS] BUG #1442: No connection to Server

2005-01-29 Thread Dennis Hübner
The following bug has been logged online: Bug reference: 1442 Logged by: Dennis Hübner Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Professional Description:No connection to Server Details: Hi there, I have trouble with new

[BUGS] Error messages

2005-01-29 Thread Mario Reis
Hi, There a while that i've bean reporting this: perhaps not to thr right place! Sql errormassegas allways returns "Code:(1)" when it's suposed to return the real return code in orde to be porocessed acording the end-user needs. I Wonder why? Can you help? Thanks Mário

[BUGS] BUG #1443: Can't start service of Postgres

2005-01-29 Thread phucle
The following bug has been logged online: Bug reference: 1443 Logged by: phucle Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows XP Pro japanese Description:Can't start service of Postgres Details: Dear, I installed Postgres 8.

[BUGS] No connection to Server

2005-01-29 Thread Dennis Hübner
  Name:      Dennis Hübner Email:       [EMAIL PROTECTED] PostgreSQL version:  8.0 Operation system: Windows XP Professional Short description:  No connection to Server     Hi there,   I have trouble with newer versions o

[BUGS] BUG #1441: casting problem when lower limit, ERROR out of range

2005-01-29 Thread Koei Kim
The following bug has been logged online: Bug reference: 1441 Logged by: Koei Kim Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6, 8.0 Operating system: Linux Description:casting problem when lower limit, ERROR out of range Details: when casting numeric t

[BUGS] help: MemoryContextAlloc problem

2005-01-29 Thread paolo avalazzi
I have a problem in my postgres production db. Today pg_dump is failed with the error : MemoryContextAlloc . I find the row that caused the problem making same query "SELECT * FROM TABLE LIMIT n" . The row in fact seemed have a varchar very strange. But few minutes later I have done a select

[BUGS] BUG #1445: Installation failed during "Activating Procedural Languages" - "Failed to connect to the database"

2005-01-29 Thread John Anson
The following bug has been logged online: Bug reference: 1445 Logged by: John Anson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0.5017 Operating system: Windows XP SP2 Description:Installation failed during "Activating Procedural Languages" - "Failed to c

[BUGS] BUG #1444: ::int2 parser bug

2005-01-29 Thread Ioseph Kim
The following bug has been logged online: Bug reference: 1444 Logged by: Ioseph Kim Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4x ~ Operating system: ALL Description:::int2 parser bug Details: > select int2(-32768); int2 -32768 -

[BUGS] BUG #1446: MSI installion fails if the postgres database password contains an apostrophe

2005-01-29 Thread John Anson
The following bug has been logged online: Bug reference: 1446 Logged by: John Anson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0.5017 Operating system: Windows XP SP2 Description:MSI installion fails if the postgres database password contains an apostrop

[BUGS] BUG #1450: unknown symbols

2005-01-29 Thread Dirk
The following bug has been logged online: Bug reference: 1450 Logged by: Dirk Email address: [EMAIL PROTECTED] PostgreSQL version: ? Operating system: Qnx Description:unknown symbols Details: Hi, I try to resolv some test on an qnx based system, but there is with

[BUGS] wcwidth

2005-01-29 Thread Dirk Cap
Hi,   I try to resolv some test on an qnx based system, but there is with every command I use an unknown symbol : wcwidth The postgresql system could not resolv all symbols. The installation is made from the standard repository used on qnx.   greetings  

[BUGS] BUG #1447: Sometimes rules don't work

2005-01-29 Thread Olleg Samoylov
The following bug has been logged online: Bug reference: 1447 Logged by: Olleg Samoylov Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6, 8.0.0 Operating system: x86_64-pc-linux-gnu, compiled by GCC x86_64-linux-gcc (GCC) 3.3.5 (Debian 1:3.3.5-6) Description:

Re: [BUGS] [GENERAL] My postmaster just crashed !

2005-01-29 Thread PFC
I'm sorry, I forgot to say I had the bug with 8rc3, then installed 8.0.0 and it is still crashing. On Thu, 27 Jan 2005 10:52:37 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote: [I've Cc'ed pgsql-bugs and set the Reply-To header to that list.] On Thu, Jan 27, 2005 at 05:26:26PM +0100, PFC wrote:

[BUGS] BUG #1449: JDBC client driver bug waiting to happen

2005-01-29 Thread Michael Robinton
The following bug has been logged online: Bug reference: 1449 Logged by: Michael Robinton Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: linux Description:JDBC client driver bug waiting to happen Details: if "int size" is set to 8, ther

[BUGS] BUG #1448: pgAdmin III crashes on insert/update/delete

2005-01-29 Thread Nikola Ivanov
The following bug has been logged online: Bug reference: 1448 Logged by: Nikola Ivanov Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.0 Operating system: Windows XP Pro, Windows 2000 Pro Description:pgAdmin III crashes on insert/update/delete Details: I am

Re: [BUGS] BUG #1449: JDBC client driver bug waiting to happen

2005-01-29 Thread Kris Jurka
On Fri, 28 Jan 2005, Michael Robinton wrote: > The following bug has been logged online: > > Bug reference: 1449 > PostgreSQL version: 7.4.6 > Description:JDBC client driver bug waiting to happen > Details: > > if "int size" is set to 8, there is insufficient storage in "int n" t

Re: [BUGS] BUG #1443: Can't start service of Postgres

2005-01-29 Thread Magnus Hagander
>The following bug has been logged online: > >Bug reference: 1443 >Logged by: phucle >Email address: [EMAIL PROTECTED] >PostgreSQL version: 8.0 >Operating system: Windows XP Pro japanese >Description:Can't start service of Postgres >Details: > >Dear, > > I installed

Re: [BUGS] BUG #1442: No connection to Server

2005-01-29 Thread Magnus Hagander
>The following bug has been logged online: > >Bug reference: 1442 >Logged by: Dennis Hübner >Email address: [EMAIL PROTECTED] >PostgreSQL version: 8.0 >Operating system: Windows XP Professional >Description:No connection to Server >Details: > >Hi there, > >I have trou

Re: [BUGS] BUG #1445: Installation failed during "Activating Procedural Languages" - "Failed to connect to the database"

2005-01-29 Thread Magnus Hagander
>The following bug has been logged online: > >Bug reference: 1445 >Logged by: John Anson >Email address: [EMAIL PROTECTED] >PostgreSQL version: 8.0.0.5017 >Operating system: Windows XP SP2 >Description:Installation failed during "Activating Procedural >Languages" - "Fai

Re: [BUGS] BUG #1444: ::int2 parser bug

2005-01-29 Thread Tom Lane
"Ioseph Kim" <[EMAIL PROTECTED]> writes: > select -32768::int2; > ERROR: integer out of range This is not a bug, because the interpretation is -(32768::int2) which indeed is out of range. regards, tom lane ---(end of broadcast)

Re: [BUGS] No connection to Server

2005-01-29 Thread Harald Armin Massa
Dennis, > Operation system: Windows XP Professional > Short description: No connection to Server > - 'could not send SSL negotiation packet: The system cannot find the path > specified' > - 'server closed the connection unexpectedly. This probably means the server > terminated

Re: [BUGS] Error messages

2005-01-29 Thread Michael Fuhr
On Thu, Jan 27, 2005 at 10:08:57AM -0100, Mario Reis wrote: > Sql errormassegas allways returns "Code:(1)" when it's suposed to return the > real return code in orde to be porocessed acording > the end-user needs. I Wonder why? Could you provide more information about what you're doing? What's

Re: [BUGS] BUG #1447: Sometimes rules don't work

2005-01-29 Thread Tom Lane
"Olleg Samoylov" <[EMAIL PROTECTED]> writes: > create rule history_i as on insert to history do (update abonent set > money=money+new.money where abonent=new.abonent); > insert into history (abonent,money) select abonent,-(money.money+5) as pay > from > ( select abonent,sum(money) as money fro

[BUGS] Bug in create operator and/or initdb

2005-01-29 Thread John Hansen
The following seems to me a bug in either initdb or create operator: CREATE FUNCTION my_func (inet, inet) as '$libdir/my_func.so' LANGUAGE 'C' IMMUTABLE STRICT; CREATE OPERATOR <<< ( PROCEDURE = my_func, LEFTARG = cidr, RIGHTARG = cidr, RESTRICT = contsel,

Re: [BUGS] Bug in create operator and/or initdb

2005-01-29 Thread Tom Lane
"John Hansen" <[EMAIL PROTECTED]> writes: > CREATE FUNCTION my_func (inet, inet) as '$libdir/my_func.so' LANGUAGE 'C' > IMMUTABLE STRICT; > CREATE OPERATOR <<< ( > PROCEDURE = my_func, > LEFTARG = cidr, > RIGHTARG = cidr, > RESTRICT = contsel, > JOIN = contjoinsel > )

Re: [BUGS] Bug in create operator and/or initdb

2005-01-29 Thread John Hansen
> My opinion is that this is a very bogus shortcut in the > network datatype code. There are no cases outside the > inet/cidr group where an operator doesn't exactly match its > underlying function. (The whole business of inet and cidr > being almost but not quite the same type is maldesigned

Re: [BUGS] Bug in create operator and/or initdb

2005-01-29 Thread Tom Lane
"John Hansen" <[EMAIL PROTECTED]> writes: > In that case may I suggest fixing the catalog so network_* functions exists > for both datatypes! Redesigning the inet/cidr distinction is on the to-do list (though I'm afraid not very high on the list). ISTM it should either be one type with a disting