We used NCurses and libpq to write our own character-based front-end. Of
course, that still left a whole lot of work to be done :-(
Tim
- Original Message -
From: "Marcelo Pereira" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 10:46 AM
Subject: [GENERAL] Languag
s thread and move on.
Thanks again.
Tim
- Original Message -----From: "Tim Barnard" <tbarnard@povn.com>To: <[EMAIL PROTECTED]>Subject:
Re: [GENERAL] Re: Red Hat to support PostgreSQLOn 27 Jun 2001, Tim
Barnard wrote:...This is not the same in my book,
since I don&
...This is not the same in my book, since I don't care
to run RHL in any kind of production environment...
What is it about RHL that various people wouldn't
recommend running it in a production envornment?
I don't have a contrary view, so much as I'd like to
know what's specifically wrong with
Can anyone tell me whether or not vacuum rebuilds
indexes or do I need to explicitly drop and recreate an index if I suspect its
corrupted?
Tim
so, i guess my question still stands ... what happens when oids wrap?
Answer: Very little. Just remember 2 things if you expect OIDs to wrap
in your application:
1. Don't key off of them. Use a sequence of your own.
2. Watch for creations and insertions to fail due to duplica
Just pass the parameters separated with whitespace.
Example:
PgDatabase data("dbname=mydb user=foo
password=bar");
Tim
- Original Message -
From:
Lucky
To: [EMAIL PROTECTED]
Sent: Monday, June 11, 2001 9:13 PM
Subject: [GENERAL] libpq++ PgDatabase and
PgCon
I don't believe its possible to do that at this time.
Tim
- Original Message -
From: "Tauren Mills" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 05, 2001 12:30 PM
Subject: RE: [ADMIN] Limiting simultaneous connections
> I don't mean to be a pest, but I haven't heard
The 'client' side. Thanks, I'll give it a try.
Tim
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Tim Barnard" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 1:40 PM
Subject: Re: [GENERAL] li
ther ideas? This is really driving me bonkers!?!?! :-)
Tim
- Original Message -
From: "Andrew Sullivan" <[EMAIL PROTECTED]>
To: "Tim Barnard" <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 11:23 AM
Subject: Re: [GENERAL] libpq and PostgreSQL NOTICEs
&
Is there any way to force Postgre not to send
NOTICEs to the console? I have an ncurses app that from time to time gets
notices stating that "begin is already a transaction in progress." Now I know I
need to track down where I'm issuing a "begin" twice, but I would rather Postgre
log these w
Thanks.
Tim
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Tim Barnard" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 3:30 PM
Subject: Re: [GENERAL] PQclear question...
> "Tim Barnard" <
Hello all,
Is it necessary to call PQclear if a query
that
would normally return tuples fails? What if
the
query returns 0 tuples? In other words, is
it
only necessary to call it if you get back
one
or more tuples?
Thanks in advance!
Tim
Is it necessary to call PQclear if a query
that
would normally return tuples fails? What if
the
query returns 0 tuples? In other words, is
it
only necessary to call it if you get back
one
or more tuples?
Tim
n this see the 11 message thread in the archives, starting
with: http://fts.postgresql.org/db/mw/msg.html?mid=114659
Tim
- Original Message -
From: "Justin Clift" <[EMAIL PROTECTED]>
To: "Tim Barnard" <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 3:42 AM
S
Page 4 of the programmers reference states:
"At any time during connection, the status of the
connection may be checked, by calling PQstatus."
I use it and so far its worked great, by which I mean
it has subsequently reported bad connections after
having reported CONNECTION_OK, which has
happened
Thanks for the helpful tip!
Tim
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Tim Barnard" <[EMAIL PROTECTED]>
Cc: "Jim" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 7:50 AM
Subject: Re: [G
I was able to do this, but not with a simple query :-(
Here's the solution I came up with. Perhaps someone else
knows an easier way to do this?
Using your table (called 'RESULTS' in my example):
test=# select ASMT_CODE,count(*)::float4 as TOTAL into tmp1 from RESULTS
group by ASMT_CODE;
Table t
Look in the programmer docs
For C: www.postgresql.org/idocs/index.php?libpq.html
For C++: www.postgresql.org/idocs/index.php?libpqplusplus.html
Tim
- Original Message -
From: "Mayan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 21, 2001 10:36 PM
Subject: [GENER
Here are some links to SQL tutorials:
http://www.intermedia.net/support/sql/sqltut.shtm
a PostgreSQL-specific tutorial can be found at:
http://www.eskimo.com/~ericj/comp/sql1.htm
Tim
- Original Message -
From: "Mark R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May
I downloaded the latest version from Sun's site, Java 2 SDK EE 1.2.1.
Tim
- Original Message -
From: "Joseph Shraibman" <[EMAIL PROTECTED]>
To: "Tim Barnard" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 07, 2001 5:59 PM
Some additional info, I've installed Ant ver. 1.3 and Sun's Java 2 SDK
Enterprise Edition 1.2.1. JAVA_HOME is set to /usr/local/java
and /usr/local/java/bin is in the path.
Tim
- Original Message -----
From: Tim Barnard
To: [EMAIL PROTECTED]
Sent: Monday, May 07, 2001 12:16 PM
Thanks for the help guys.
Tim
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
I'm compiling PostgreSQL 7.1.1 with Java support
(--with-java).
During gmake, immediately after this
line:
/usr/local/ant/bin/ant -buildfile
../../../build.xml -Dmajor=7 -Dminor=1
-Dfullversion=7.1.1 -Ddef_pgport=5432
I get the following error:
/usr/local/java/bin/java: /
I do it this way using libpq: select count(*) from pg_class where
relname='table name goes here'
and test for a count > 1.
Tim
- Original Message -
From: "Jeff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 8:48 PM
Subject: [GENERAL] How to check if a table
If you're sure your're su-ed into "postgres", check the permissions on the
directory your trying to create the database in. I got that same error and
eventually figured out and fixed it when the directory I was trying to
create it in didn't have "write" permission. Yes, it's a strange error to
get
rew me off :-)
Regards,
Tim
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Peter Eisentraut" <[EMAIL PROTECTED]>
Cc: "Tim Barnard" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, February 04, 2001 7:54 PM
Subject: Re
Interesting idea. I hadn't thought of trying this.
Thanks.
Tim
- Original Message -
From: "Prasanth Kumar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 22, 2001 7:03 PM
Subject: Re: [GENERAL] Data entry screen building utilities
>
> >Rather than writing PostgreSQL
- Original Message -
From: "Paul M Foster" <[EMAIL PROTECTED]>
To: "Tim Barnard" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 22, 2001 5:45 PM
Subject: Re: [GENERAL] Data entry screen building utilities
> On Mon, Jan 22, 2001
Thanks for the idea, but like you stated lynx is too crude an interface.
Tim
- Original Message -
From: "Robert B. Easter" <[EMAIL PROTECTED]>
To: "Tim Barnard" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, January 22, 2001 11:07 PM
Su
Rather than writing PostgreSQL data entry screens
from scratch using ncurses and cdk, is anyone aware of any data entry screen
building utilities useful for character-based screens, as opposed to GUI
utilities?
Tim
Never mind. I figured it out via the src
code.
Thanks anyway!
Tim
S.E. Mgr.
Hartford Communications
Hello all,
I've looked through the docs and I can't find
any answers to this question: How can I increase the maximum
number of sessions (clients)? I understand from a previous posting that the
default is set to 16.
Tim
HCC
>
> We have some demographics available at http://www.pgsql.com/user_gallery
>
I believe what was intended was:
http://www.pgsql.com/register
Tim
33 matches
Mail list logo
