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
object.
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
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
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
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
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
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
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 don't
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
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 darcy@{druid|vex}.net | Democracy is
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
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()
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_sorttemp
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:
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 (unreserved
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
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
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 is
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 do not
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 SPRO6U2
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
21 matches
Mail list logo