[BUGS] server restart when connections thread over 155 in PostgreSQL 8.03

2005-06-30 Thread easyjava
PostgreSQL version: 8.03Operating system: windows xpIn my config file:max_connections = 300My test program just creates 200 threads to perform some simple query task. I findserver often restart when the 155th connection thread startup.==console

Re: [BUGS] BUG #1741: %i missing in snprintf implementation

2005-06-30 Thread Tom Lane
"Tim Mauch" <[EMAIL PROTECTED]> writes: > The implementation of snprintf/vsnprintf in src/port/snprintf.c does not > allow the use of %i ( %d equivalent ). This likely isn't a problem for > postgres itself, but when a program compiles with -lpq and the standard c > libraries are not previously inc

[BUGS] BUG #1741: %i missing in snprintf implementation

2005-06-30 Thread Tim Mauch
The following bug has been logged online: Bug reference: 1741 Logged by: Tim Mauch Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 - 8.0.3 Operating system: Redhat linux 8.0 Description:%i missing in snprintf implementation Details: The implementation of

Re: [BUGS] BUG #1740: Deferred foreign key constraint isn't deferred

2005-06-30 Thread Daniel Cristian Cruz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Big, big mistake... Thanks for the help, sorry about the post... Michael Fuhr wrote: > On Thu, Jun 30, 2005 at 02:01:39PM +0100, Daniel Cristian Cruz wrote: > >>ALTER TABLE ONLY mat_comissao_itens >>ADD CONSTRAINT mat_nf_saida_itens_pa_mat_comiss

Re: [BUGS] BUG #1740: Deferred foreign key constraint isn't deferred

2005-06-30 Thread Stephan Szabo
On Thu, 30 Jun 2005, Daniel Cristian Cruz wrote: > ALTER TABLE ONLY mat_comissao_itens > ADD CONSTRAINT mat_nf_saida_itens_pa_mat_comissao_itens FOREIGN KEY > (mat_nfs_diretorio, mat_nfs_in_codigo, mat_nsi_in_ordem) REFERENCES > mat_nf_saida_itens(mat_nfs_diretorio, mat_nfs_in_codigo, mat_nsi

Re: [BUGS] BUG #1735: row number -1 is out of range 0..-1 error

2005-06-30 Thread Bobi Ivanov
OK, but check this thing out: (I did my best to replicate this example on another pgSQL server running on different platform) CREATE TABLE billingplans ( id int NOT NULL, reseller_id integer NOT NULL, base_tariff_id integer NOT NULL, discount smallint NOT NULL, freetalktime smalli

Re: [BUGS] async. query processing

2005-06-30 Thread Tom Lane
Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes: > How to distinguish is PQgetResult(pgConn) return NULL when just no more > data to process > OR when hard error occur during fetching data from DB? An error will give you back an error PGresult object, not null. regards, to

[BUGS] async. query processing

2005-06-30 Thread Ruslan A Dautkhanov
Hello ! How to distinguish is PQgetResult(pgConn) return NULL when just no more data to process OR when hard error occur during fetching data from DB? In the docs for PQsendQuery I not see any reference that PQgetResult can indicate that error raised. What changed since PG 7? I have a code in

Re: [BUGS] BUG #1739: memory leak in pl/perl with spi_exec_query

2005-06-30 Thread Jean-Max Reymond
Jean-Max Reymond a écrit : The following bug has been logged online: Bug reference: 1739 Logged by: Jean-Max Reymond Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux Ubuntu Description:memory leak in pl/perl with spi_exec_query Deta

Re: [BUGS] BUG #1740: Deferred foreign key constraint isn't deferred

2005-06-30 Thread Michael Fuhr
On Thu, Jun 30, 2005 at 02:01:39PM +0100, Daniel Cristian Cruz wrote: > > ALTER TABLE ONLY mat_comissao_itens > ADD CONSTRAINT mat_nf_saida_itens_pa_mat_comissao_itens FOREIGN KEY > (mat_nfs_diretorio, mat_nfs_in_codigo, mat_nsi_in_ordem) REFERENCES > mat_nf_saida_itens(mat_nfs_diretorio, mat_n

Re: [BUGS] BUG #1736: endless loop in PQconnectdb

2005-06-30 Thread Karsten Desler
* Karsten Desler wrote: > * Bruce Momjian wrote: > > Yes, please --- the patch is at: > > > > http://archives.postgresql.org/pgsql-patches/2005-06/msg00486.php > > Thanks. > I've applied the patch now, and I'll keep you posted. It doesn't seem to have helped, and while poking around a little

[BUGS] Bugs

2005-06-30 Thread [EMAIL PROTECTED]
pgsql-bugs,     when i install src pg ,must mkdir data1 frist,then, ./bin/initdb -D ./data can be successful,why?        [EMAIL PROTECTED]    2005-06-30

[BUGS] Bug report regarding reconcilliation

2005-06-30 Thread Chris Travers
Summary: Under certain circumstances, the reconcilliation routine will clear more transactions than expected. Severity: Moderately Severe, not a showstopper, but impacts the consistancy of the accounting data. Frequency: Always Details: When a customer purchases an item with a split payment

[BUGS] BUG #1740: Deferred foreign key constraint isn't deferred

2005-06-30 Thread Daniel Cristian Cruz
The following bug has been logged online: Bug reference: 1740 Logged by: Daniel Cristian Cruz Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows XP Professional Description:Deferred foreign key constraint isn't deferred Details: Bel