[BUGS] Bug #774: Sometimes we do not get the correct record set

2002-09-19 Thread pgsql-bugs
Michelle ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Sometimes we do not get the correct record set Long Description We did a select statement to select a recordset from the database and the recordset size differs. For ex

Re: [BUGS] Bug #774: Sometimes we do not get the correct record set

2002-09-19 Thread Rod Taylor
Could you attach an sql test case that shows the error you see, or a detailed description of how to recreate it? On Thu, 2002-09-19 at 03:55, [EMAIL PROTECTED] wrote: > Michelle ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Descrip

[BUGS] posgres on win2k, install cygipc

2002-09-19 Thread * *
I'm trying to install postgres on my win2k pro computer. Also I'm not familiar with the Linux OS. I downloaded all the necessary software. I installed cygwin but I'm having problems with cygipc. I've extracted cygipc to \usr\local\cygipc In the shell I type in ipc-daemon.exe and I get the

[BUGS] Server hangs on multiple connections

2002-09-19 Thread David Christian
Hi, I posted this through the web page but it didn't come over the list, so I am sending it directly. Hope that's okay. I am able to get PostgreSQL 7.2.2 built and installed, and postmaster starts up fine, but when hit with multiple simultaneous connections (2 or more), the server freezes

[BUGS] Bug #775: Unable to identify an operator '=' for types 'numeric' and 'double precision'

2002-09-19 Thread pgsql-bugs
Daniel Serodio ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Unable to identify an operator '=' for types 'numeric' and 'double precision' Long Description If I create a table with a 'numeric' column, and try to make a query

Re: [BUGS] Server hangs on multiple connections

2002-09-19 Thread Tom Lane
David Christian <[EMAIL PROTECTED]> writes: > The problem I'm describing is only happening when I install on the > following platform: Yellow Dog Linux 2.3 on PowerPC (PowerMac G4 > QuickSilver, dual processor) with 1.5GB RAM. Hmm ... I'm not sure whether anyone's tried it with a dual-proces

Re: [BUGS] Bug #775: Unable to identify an operator '=' for types 'numeric' and 'double precision'

2002-09-19 Thread Tom Lane
[EMAIL PROTECTED] writes: > Unable to identify an operator '=' for types 'numeric' and 'double precision' At the moment you have to cast the literal to numeric (or cast the column to float8, if you'd rather use float arithmetic, which I imagine you wouldn't). The existing parser doesn't see any

Re: [BUGS] Server hangs on multiple connections

2002-09-19 Thread David Christian
On Thursday, Sep 19, 2002, at 17:10 US/Eastern, Tom Lane wrote: > Could you build with --enable-debug and --enable-cassert (if you didn't > already), repeat the 'make check' scenario, and then attach to a few of > the stuck backend processes with gdb and get stack traces from them? > That would g

Re: [BUGS] Server hangs on multiple connections

2002-09-19 Thread Tom Lane
David Christian <[EMAIL PROTECTED]> writes: > Happy to. Interestingly, when I build with --enable-debug and > --enable-cassert, the server doesn't lock up during 'make check', it > just (very quickly) fails all of the tests and exits. I tried several > times. Oh, that's interesting; that

[BUGS] Bug #776: PGSQL 7.2.2 build broken on OS X 10.2

2002-09-19 Thread pgsql-bugs
Lee Nelson ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description PGSQL 7.2.2 build broken on OS X 10.2 Long Description Postgresql 7.2.2 does not build on Mac OS X 10.2 . Worked perfectly on OS X 10.1.4. Developer disk (GCC, etc

[BUGS] 7.3 Doc Bug in plpython

2002-09-19 Thread elein
The valid return value should be MODIFY instead of MODIFIED. The error message said so :-) In 25.3. Using PL/Python If the trigger "when" is BEFORE, you may return None or "OK" from the Python function to indicate the tuple is unmodified, "SKIP" to abort the event, or "MO

[BUGS] Fix for PSQL 7.2.2 doesn't compile on OS X 10.2

2002-09-19 Thread jld123
Hello, I took a crack at fixing this one myself. It turns out there are (of course) header differences between 10.1 and 10.2 I found a fix, but I'm sure a careful analysis would find a better one - I just copied over the current system header file into the psql tree, and tweaked it.

Re: [BUGS] Bug #770: 7.2.1 --> 7.2.2 =? Problems with speed

2002-09-19 Thread Yury Bokhoncovich
Hello! On Mon, 16 Sep 2002 [EMAIL PROTECTED] wrote: > Long Description > Hello, I updated my PostgreSQL 7.2.1 to 7.2.2. > Now I have problems with the speed. It's very very slow. Mmm...what is your way to backup? RPMs? Did you ever do vacuum after? -- WBR, Yury Bokhoncovich, Senior System Admi

Re: [BUGS] Bug #758: show_planner_stats does not work for new PREPARE

2002-09-19 Thread Bruce Momjian
Patch applied. Thanks. --- Neil Conway wrote: > Tom Lane <[EMAIL PROTECTED]> writes: > > I'm not sure why NDirectFileRead/NDirectFileWrite are unused at the > > moment, but they used to be used; I think the correct respon