Bruce -
I searched thru my libs (/usr/lib, /usr/ccs/lib and /usr/ucblib)
and managed to eliminate most of ecpg's complaints with -lnwutil
and -lucb...
But there appears to be one problem I can't resolve:
lex_init does not exist in any obj code anywhere on my system (as other
than undef).
This
Bruce - by commenting ecpg out of the interfaces Makefile I got
all of Postgres to compile and have successfully run initdb...
As soon as I can resolve the IpcMemory errors I hope to have this
thing going.
Thanks for all of your help,
Tom
North Richmond Community Mental Health
On Thu, 29 Apr 1999, Herouth Maoz wrote:
At 18:50 +0300 on 28/04/1999, Aaron Holtz wrote:
db= select count(distinct customer_username) from customerdata;
ERROR: parser: parse error at or near "distinct"
How do you get a count of distinct data output via postgres? I can always
At 21:04 +0300 on 29/04/1999, Brett W. McCoy wrote:
I think, Aaron, you could get a count of distinct customer names like this:
SELECT DISTINCT customer_username, COUNT(*) FROM customerdata
GROUP BY customer_username;
This will give you 2 columns, one with the distinct customer_usernames
dbtest= set QUERY_LIMIT TO 10;
ERROR: parser: parse error at or near "10"
dbtest= set QUERY_LIMT TO 10;
ERROR: parser: parse error at or near "10"
Didn't work. I guess I'll have to re-install postgresql 6.5
BTW, is this 6.5 version stable enough for production?
Please comment.
And also if
Sorry for the previous posting. The following worked.
BTW, this affects just this database or throughout the entire postgresql
server?
And, how does one reset this variable to max?
Thanks
martin
-Original Message-
·ol : Margarita Barvinok [EMAIL PROTECTED]
¶æ : [EMAIL PROTECTED]
This is from the Tutorial for version 6.4 of PostgreSQL.
SET - Set run-time parameters for session
SET variable { TO | = } { 'value' | DEFAULT }
SET TIME ZONE { 'timezone' | LOCAL };
QUERY_LIMIT
Sets the number of rows returned by a query.
Value
Maximum number of rows
Martin Wong ha scritto:
Sorry for the previous posting. The following worked.
BTW, this affects just this database or throughout the entire postgresql
server?
Only current_session;
And, how does one reset this variable to max?
RESET QUERY_LIMIT;
Hi,
I've got a large application with hundreds of different queries. I
thought I had them all sorted out (i.e. determined the correct indices
to make them quick), but now I see that, with 5 copies of the
application running, I'm getting some serious contention on the
database. Is there
v6.5 is definitely not stable enough for production...purely a "use at own
risk" at this time...
On Thu, 29 Apr 1999, Martin Wong wrote:
dbtest= set QUERY_LIMIT TO 10;
ERROR: parser: parse error at or near "10"
dbtest= set QUERY_LIMT TO 10;
ERROR: parser: parse error at or near "10"
On Thu, 29 Apr 1999, Jun Zhang wrote:
After commented the line with "ecpg" (there is only one such line)
from the GNUmake file, the make all didn't go very far but ended with
the following message:
I'm sorry but I'm confused...you did *not* succeed in compiling?
I eventually did succeed and
If anyone out there is using AOLserver on Linux for their webserver
with Postgres 6.4.2 I'd like to know how you recompiled the postgres
driver to get it to work with AOLserver. I know that it needs to be a
shared library, but I can't seem to get it function properly. Any ideas?
12 matches
Mail list logo
