Re: [HACKERS] PQstatus() detect change in connection...

2001-10-17 Thread Matthew Hagerty
I am trying to re-establish a connection, however, I cannot afford to issue a query to determine if the connection still exists. I'm writing a server that uses the asynchronous query processing functions and speed is an issue. Queries are slow compared to what the server does and it cannot w

Re: [HACKERS] schema support, was Package support for Postgres

2001-10-17 Thread Bill Studenmund
On Sun, 14 Oct 2001, Bill Studenmund wrote: > On Mon, 15 Oct 2001, Tom Lane wrote: > > > Bill Studenmund <[EMAIL PROTECTED]> writes: > > > For the most part, I think packages and schemas are orthogonal. I'm taking > > > a cue from Oracle here. Oracle considers packages to be a schema-specific > >

[HACKERS] autoconf taking forever?

2001-10-17 Thread bpalmer
I'm working on making some changes to the top level configure.in and m4 has now been running for 17 minutes on a 1.4G tbird. Am I missing something or is this know to take forever? Thanks guys, - Brandon c: 646-456-5

Re: [HACKERS] pg_sorttemp files

2001-10-17 Thread Christopher Kings-Lynne
My guess is probably yes it's ok - just shut down the server before deleting them! Chris > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of D'Arcy J.M. Cain > Sent: Thursday, 18 October 2001 3:46 AM > To: [EMAIL PROTECTED] > Subject: [HACKERS] pg_sort

Re: [HACKERS] PQstatus() detect change in connection...

2001-10-17 Thread Mark Pritchard
I presume you are trying to re-establish a connection automatically...if that doesn't apply, ignore the rest of this email :) The way I interpreted the docs was that you can use the return codes from PQexec() to establish whether the command was sent to the backend correctly. PQresultStatus() ret

[HACKERS] PQstatus() detect change in connection...

2001-10-17 Thread Matthew Hagerty
Greetings, PostgreSQL 7.1.3, FreeBSD-4.3-RELEASE, gcc 2.95.3 I'm trying to attempt to detect a failed backend connection, but a call to PQstatus() always returns the state of the backend when the call was made. For example, take this test code: PGconn *pgConn; PGresult *pgRes

Re: [HACKERS] compiling libpq++ on Solaris with Sun SPRO6U2 (fixed

2001-10-17 Thread Dan
whats wrong with kill -9' the postmaster works fine for me hahahaa. > Date: Wed, 17 Oct 2001 22:34:47 +0200 (CEST) > From: Peter Eisentraut <[EMAIL PROTECTED]> > To: Denis A Ustimenko <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: [HACKERS] compiling libpq++ on Solaris with Sun SP

Re: [HACKERS] Package support for Postgres

2001-10-17 Thread Bill Studenmund
On Wed, 17 Oct 2001, Peter Eisentraut wrote: > Bill Studenmund writes: > > > Yes, I want a namespace below schemas. > > > > The difference between packages and schemas is that schemas encapsulate > > everything. As Tom pointed out, that includes types (and I'd assume > > operators too). Packages

Re: [HACKERS] Package support for Postgres

2001-10-17 Thread Peter Eisentraut
Bill Studenmund writes: > Yes, I want a namespace below schemas. > > The difference between packages and schemas is that schemas encapsulate > everything. As Tom pointed out, that includes types (and I'd assume > operators too). Packages do not encapsulate types and operators. Of course nobody i

Re: [HACKERS] Column names - time

2001-10-17 Thread Peter Eisentraut
Tom Lane writes: > Probably. Peter has a script that generates that table directly from > gram.y, and I assume he'll run it sometime before 7.2 release... After beta has started. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of b

Re: [HACKERS] compiling libpq++ on Solaris with Sun SPRO6U2 (fixed

2001-10-17 Thread Peter Eisentraut
Denis A Ustimenko writes: [change -Wl,-R to -R and -Wl,-h to -h] I'm having a difficult time understanding this. Both -R and -h are linker options, not compiler options. So while the compiler driver might be nice enough to recognize them as the former and pass them through, this change just pu

[HACKERS] Package support diffs

2001-10-17 Thread Bill Studenmund
are on their way to the patches list. Given the mail delay we've been seeing, they'll take a while to get there. Oh, it turns out there _is_ a size limit for patches, so it'll need to get approved. There are still a few warts in the code. 1) One wart is that I needed to make an identifier for th

[HACKERS] pg_sorttemp files

2001-10-17 Thread D'Arcy J.M. Cain
I have tons of old files with names like base/db/pg_sorttemp.##. I assume that they are temporary sorting files but somehow they never got cleared out. Is it safe to delete these from a running system. The files are months old. -- D'Arcy J.M. Cain| Democracy is three wolves http://w

Re: [HACKERS] Pre-forking backend

2001-10-17 Thread Daniel Varela Santoalla
On Mon 15 Oct 2001 04:32, you wrote: DBBalancer (http://www.sourceforge.net/projects/dbbalancer/) does something like that. > > Create a small program that makes a few connections to postgresql, does > some initialization, preconnects to various DBs (or maybe limited to one DB > specified on

Re: [HACKERS] Package support for Postgres

2001-10-17 Thread Bill Studenmund
On Sat, 13 Oct 2001, Peter Eisentraut wrote: > Bill Studenmund writes: > > > session-specific package variables, > > I think this is assuming a little too much about how a PL might operate. > Some PLs already support this in their own language-specific way, with or > without packages. Thus, I do

Re: [HACKERS] Column names - time

2001-10-17 Thread Tom Lane
Lee Kindness <[EMAIL PROTECTED]> writes: > Tom Lane writes: >>> There is an up-to-date list of keywords in the documentation: >>> >http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/sql-keywords-appendix.html > Thanks for the info. Would I be right in saying that the status of > time (u

[HACKERS] compiling libpq++ on Solaris with Sun SPRO6U2 (fixed & tested)

2001-10-17 Thread Denis A Ustimenko
Sorry, previous patch was wrong. Denis Ustimenko -- *** orig/postgresql-7.1.3//src/makefiles/Makefile.solaris ÷Ó äÅË 17 00:14:25 2000 --- postgresql-7.1.3//src/makefiles/Makefile.solarisóÒ ïËÔ 17 14:33:11 2001 *** *** 6,12 export_dy

[HACKERS] DBBalancer bugs

2001-10-17 Thread Pramod Reddy
Hello, I am trying to install and run DBBalancer-0.3.0.tar .gz file on RedHat Linux 7.0 . I am using PostgreSQL 7.0 which comes with RedHat Linux 7.0 distribution. As per the INSTALL file I have installed ACE-5.2.tar.gz file sucessfully under /usr/local/src. But when I am issuing the co

[HACKERS] compiling libpq++ on Solaris with Sun SPRO6U2

2001-10-17 Thread Denis A Ustimenko
Here is my patches for libpq++ compiling by Sun C++: -- *** ../postgresql-7.1.3.orig//src/Makefile.shlib÷Ó áÐÒ 15 10:25:07 2001 --- .//src/Makefile.shlib óÒ ïËÔ 17 12:23:41 2001 *** *** 179,185

Re: [HACKERS] ecpg - GRANT bug

2001-10-17 Thread Lee Kindness
Bill Studenmund writes: > I think this patch is wrong. Wouldn't it be better to make the line number > in yylineno be correct? Also, there are users of the line number in pcg.l > which you didn't change. > Looking at it, I don't see why the line number is off. It is initialized > to 1 at the

Re: [HACKERS] Column names - time

2001-10-17 Thread Lee Kindness
Tom Lane writes: > There is an up-to-date list of keywords in the documentation: > >http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/sql-keywords-appendix.html Thanks for the info. Would I be right in saying that the status of time (unreserved for PostgreSQL) for 7.2 needs to be ch