Re: [BUGS] BUG #1643: dbf2pg broken + quick fix

2005-05-03 Thread Tom Lane
Boris van Schooten <[EMAIL PROTECTED]> writes: > See the spec. > http://www.dbase.com/KnowledgeBase/int/db7_file_fmt.htm Thanks for the link. As far as can be told from this, dbase hasn't got nulls at all -- is that correct, or are they just omitting a ton of relevant information? It looks to m

Re: [BUGS] BUG #1644: control structeres perfomance in pgsql

2005-05-03 Thread Tom Lane
Klint Gore <[EMAIL PROTECTED]> writes: > On Wed, 04 May 2005 11:52:32 +1000, Neil Conway <[EMAIL PROTECTED]> wrote: >> I don't understand. Can you explain what the problem is? > I think they mean that it doesn't do short-circuit evaluation. AFAICS the claimed example cannot exhibit any different

Re: [BUGS] BUG #1644: control structeres perfomance in pgsql

2005-05-03 Thread Klint Gore
On Wed, 04 May 2005 11:52:32 +1000, Neil Conway <[EMAIL PROTECTED]> wrote: > tirny wrote: > > any code instructions > > *** > > IF FOUND AND TG_OP = 'UPDATE' THEN > > *** > > END IF; > > *** > > > > if not found plsql does't break this structure after IF FOUND and proceed > > TG_OP = \'UPDATE\', w

Re: [BUGS] BUG #1644: control structeres perfomance in pgsql

2005-05-03 Thread Neil Conway
tirny wrote: any code instructions *** IF FOUND AND TG_OP = 'UPDATE' THEN *** END IF; *** if not found plsql does't break this structure after IF FOUND and proceed TG_OP = \'UPDATE\', what bring control structures to: IF FOUND THEN IF TG_OP = 'UPDATE' THEN *** END IF; END IF; inconveniently,

Re: [BUGS] BUG #1643: dbf2pg broken + quick fix

2005-05-03 Thread Tom Lane
"Boris van Schooten" <[EMAIL PROTECTED]> writes: > As it turns out, the integer checking code (contrib/dbase/dbf2pg.c, function > isinteger) is broken. It appears the function reports 0 in case it finds a > space in the dbf rather than a digit. I disabled it (always made it return > 1). Now, my

[BUGS] BUG #1643: dbf2pg broken + quick fix

2005-05-03 Thread Boris van Schooten
The following bug has been logged online: Bug reference: 1643 Logged by: Boris van Schooten Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.5, 8.0.2 Operating system: FreeBSD Description:dbf2pg broken + quick fix Details: As several people on the mailing li

[BUGS] BUG #1644: control structeres perfomance in pgsql

2005-05-03 Thread tirny
The following bug has been logged online: Bug reference: 1644 Logged by: tirny Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: FreeBSD 5.3 Description:control structeres perfomance in pgsql Details: for example, look at this code: any c

[BUGS] BUG #1641: Server crash at 182 connections

2005-05-03 Thread Joek Hondius
The following bug has been logged online: Bug reference: 1641 Logged by: Joek Hondius Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Windows XP pro Description:Server crash at 182 connections Details: Hi, i get server crashes when conne

Re: [BUGS] BUG #1632: Several jailed PostgreSQL instances.

2005-05-03 Thread Achilleus Mantzios
O Tom Lane έγραψε στις May 3, 2005 : > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > Its obvious that FreeBSD says: DONT USE IPC in jails, so its far from a > > bug. > > Marc's been running PG inside FreeBSD jails for years, so it seems > like there's some disconnect here ... I don't have t

Re: [BUGS] BUG #1632: Several jailed PostgreSQL instances.

2005-05-03 Thread Tom Lane
Achilleus Mantzios <[EMAIL PROTECTED]> writes: > Its obvious that FreeBSD says: DONT USE IPC in jails, so its far from a > bug. Marc's been running PG inside FreeBSD jails for years, so it seems like there's some disconnect here ... I don't have the knowledge to resolve it though.