[HACKERS] Re: Re: Hey guys, check this out.

2001-04-16 Thread Lincoln Yeoh
At 08:38 PM 15-04-2001 -0700, you wrote: On Sun, Apr 15, 2001 at 10:05:46PM -0400, Vince Vielhaber wrote: On Mon, 16 Apr 2001, Lincoln Yeoh wrote: Maybe you guys should get some Great Bridge marketing/PR person to handle stuff like this. After reading Ned's comments I figured that's how

[HACKERS] Too many open files in system

2001-04-16 Thread ryan
What does this error mean - and how can I avoid it in the future? postmaster: StreamConnection: accept: Too many open files in system Any help would be much appreciated! Ryan Mahoney ---(end of broadcast)--- TIP 5: Have you checked our

[HACKERS] Re: Too many open files in system

2001-04-16 Thread mlw
[EMAIL PROTECTED] wrote: What does this error mean - and how can I avoid it in the future? postmaster: StreamConnection: accept: Too many open files in system Any help would be much appreciated! Ryan Mahoney It would be helpful if you could give more information, but if you are

[HACKERS] RE: [BUGS] Problem with 7.0.3 dump - 7.1b4 restore

2001-04-16 Thread Rainer Mager
I noticed that 7.1 has officially been released. Does anyone know the status of the bug I reported regarding encoding problems when dumping a 7.0 db an restoring on 7.1? Thanks, --Rainer ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [HACKERS] cvs postgres doesn't compile with libreadline 4.2

2001-04-16 Thread Juhan-Peep Ernits
On Sat, 14 Apr 2001, Peter Eisentraut wrote: andrea gelmini writes: debian unstable, i386. upgrade libreadline 4.2 postgres doesn't compile. It seems there were some incompatible changes in readline 4.2. Use version 4.1 until we have a fix. The essence of the problem seems to be

[HACKERS] Re: [PATCHES] Patch for PostgreSQL 7.0.3 to compile on Tru64 UNIX v5.0A with Compaq C T6.4-212 (dtk)

2001-04-16 Thread Thomas Lockhart
No, those don't do it. We need an actual NaN value. These are just flags, I think. gmake -C adt SUBSYS.o gmake[4]: Entering directory `/usr/users/dcarmich/postgresql-7.1/src/ backend/utils/adt' cc -std -O4 -Olimit 2000 -I../../../../src/include -c -o float.o float.c cc:

Re: [HACKERS] Re: [PATCHES] Patch for PostgreSQL 7.0.3 to compile on Tru64 UNIX v5.0A with Compaq C T6.4-212 (dtk)

2001-04-16 Thread Tom Lane
Thomas Lockhart [EMAIL PROTECTED] writes: cc -std -O4 -Olimit 2000 -I../../../../src/include -c -o float.o float.c cc: Error: float.c, line 251: In this statement, the libraries on this platform do not yet support compile-time evaluation of the constant expression "0.0/0.0". (constfoldns)

[HACKERS] 7.1 on 7.1

2001-04-16 Thread Trond Eivind Glomsrød
PostgreSQL 7.1 on Red Hat Linux 7.1[1]: All 76 tests passed. I'll submit it to the website soonish. [1] Available this morning, http://www.redhat.com/about/presscenter/2001/press_sevenone.html -- Trond Eivind Glomsrd Red Hat, Inc. ---(end of

[HACKERS] Re: 7.1 on 7.1

2001-04-16 Thread Thomas Lockhart
PostgreSQL 7.1 on Red Hat Linux 7.1[1]: All 76 tests passed. -- Trond Eivind Glomsrd Red Hat, Inc. It's about time RH saw the light and sync'd their release labeling with ours ;) - Thomas ---(end of broadcast)--- TIP 5:

Re: [HACKERS] 7.1 on 7.1

2001-04-16 Thread Lamar Owen
Trond Eivind Glomsrd wrote: PostgreSQL 7.1 on Red Hat Linux 7.1[1]: All 76 tests passed. I'll submit it to the website soonish. [1] Available this morning, http://www.redhat.com/about/presscenter/2001/press_sevenone.html And RPMs are also available for 7.1 on 7.1 in our RPM area. Red

[HACKERS] integer arrays

2001-04-16 Thread mlw
I have looked and I have looked, it is not immediately clear to me how integer arrays are passed to C function. create table fubar (vars integer[]) ; select c_function(vars) from fubar; insert into fubar (vars) values ('{1,2,3,4,5,6}'); extern "C" c_function (varlena var) {

Re: [HACKERS] integer arrays

2001-04-16 Thread Tom Lane
mlw [EMAIL PROTECTED] writes: I have looked and I have looked, it is not immediately clear to me how integer arrays are passed to C function. See src/include/utils/array.h, also src/backend/utils/adt/arrayfuncs.c and src/backend/utils/adt/arrayutils.c. Beware: this code is pretty messy.

[HACKERS] No printable 7.1 docs?

2001-04-16 Thread Christopher Masto
On Sun, Apr 15, 2001 at 01:11:34PM -0400, Mitch Vincent wrote: The "Current Release Docs" on the PostgreSQL website still look 7.0.Xish.. I can't finh the 7.1 PS docs anywhere. The stuff in the doc directory on the FTP sites is from last year, and the docs in the tar files are all SGML and

Re: [HACKERS] No printable 7.1 docs?

2001-04-16 Thread Vince Vielhaber
They're not ready yet. Vince. On Mon, 16 Apr 2001, Christopher Masto wrote: On Sun, Apr 15, 2001 at 01:11:34PM -0400, Mitch Vincent wrote: The "Current Release Docs" on the PostgreSQL website still look 7.0.Xish.. I can't finh the 7.1 PS docs anywhere. The stuff in the doc directory on

[HACKERS] Re: No printable 7.1 docs?

2001-04-16 Thread Thomas Lockhart
They're not ready yet. Since they were deemed non-essential for this release, and since the release schedule is not built around their creation, I no longer feel obligated to have them finished on the release date. A nice change from the deadlines I've been working on for the last three years

RE: [HACKERS] Truncation of object names

2001-04-16 Thread Christopher Kings-Lynne
Call me thick as two planks, but when you guys constantly refer to 'schema support' in PostgreSQL, what exactly are you referring to? Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane Sent: Saturday, 14 April 2001 5:46 AM To: [EMAIL

[HACKERS] broken web server?

2001-04-16 Thread bpalmer
I know this isn't really hackers traffic, but... one of the servers in www.postgresql.org is http://postgresql.bbksys.com/ which is giving me 404 errors.. I've mailed webmaster@, but thought this should be mailed on anyway.. - brandon b. palmer, [EMAIL PROTECTED] pgp:

RE: [HACKERS] Truncation of object names

2001-04-16 Thread Mike Mascari
The ability to place database objects into a logical partitioning of data. For example, in Oracle, each user creates tables, views, sequences, synonyms, and snapshots in their own schema. So if I were to create a table called 'Employees', I could query it as: SELECT * FROM employees; But

[HACKERS] JDBC Select Performance

2001-04-16 Thread Thomas Hii
Hi, While doing some testing with Postgresql 7.1, I noticed some perculiar behaviour with the JDBC driver. Selecting a single record from a table is 5-10 times slower than doing an insert (even if the table only contains a single record, and the select query does not contain any join). On

re: NetBSD Bad address failure (was Re: [HACKERS] Third call for platform testing)

2001-04-16 Thread matthew green
yes, this is a bug in netbsd-current that was introduced with about 5 month ago with the new unified buffer cache system. it has been fixed. thanks. From: Chuck Silvers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: CVS commit: syssrc Date: Mon, 16 Apr 2001 17:37:44 +0300 (EEST)

[HACKERS] RedHat/Postgres.pm Error

2001-04-16 Thread Allan C Huffman
May I please ask you guys a question about Postgres.pm. Right now I'm working on a Red Hat 6.2, Apache 1.3.9 and Perl5. I've finally got Apache setup which was no easy task even with a $80.00 Mohawk GUI administration front end. But now I get the following from my perl/cgi program error:

Re: [HACKERS] Re: No printable 7.1 docs?

2001-04-16 Thread Christopher Masto
On Tue, Apr 17, 2001 at 12:07:26AM +, Thomas Lockhart wrote: They're not ready yet. Since they were deemed non-essential for this release, and since the release schedule is not built around their creation, I no longer feel obligated to have them finished on the release date. A nice