Re: [GENERAL] Language C - Console-based FrontEnd

2001-07-20 Thread Tim Barnard
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] Language C -

[GENERAL] Re: Red Hat to support PostgreSQL

2001-06-27 Thread Tim Barnard
snip ...This is not the same in my book, since I don't care to run RHL in any kind of production environment... snip 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

Re: [GENERAL] Re: Red Hat to support PostgreSQL

2001-06-27 Thread Tim Barnard
d and move on. Thanks again. Tim - Original Message -----From: "Tim Barnard" tbarnard@povn.comTo: [EMAIL PROTECTED]Subject: Re: [GENERAL] Re: Red Hat to support PostgreSQLOn 27 Jun 2001,Tim Barnardwrote:snip...This is not the same in my book, since I don't careto run RHL in an

[GENERAL] Index rebuild question

2001-06-13 Thread Tim Barnard
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

Re: [GENERAL] libpq++ PgDatabase and PgConnection

2001-06-12 Thread Tim Barnard
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

Re: [GENERAL] Re: [SQL] maximum number of rows in table - what about oid limits?

2001-06-12 Thread Tim Barnard
snip so, i guess my question still stands ... what happens when oids wrap? snip 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

[GENERAL] Re: [ADMIN] Limiting simultaneous connections

2001-06-05 Thread Tim Barnard
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

[GENERAL] libpq and PostgreSQL NOTICEs

2001-06-04 Thread Tim Barnard
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

Re: [GENERAL] libpq and PostgreSQL NOTICEs

2001-06-04 Thread Tim Barnard
!?!?! :-) 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 On Mon, Jun 04, 2001 at 10:59:14AM -0700, Tim Barnard wrote: rather than spewing across

Re: [GENERAL] libpq and PostgreSQL NOTICEs

2001-06-04 Thread Tim Barnard
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] libpq and PostgreSQL NOTICEs Tim Barnard [EMAIL PROTECTED

Re: [GENERAL] Re: [SQL] Difficult SQL Statement

2001-05-29 Thread Tim Barnard
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: [GENERAL] Re: [SQL] Difficult SQL Statement I wrote: select

Re: [GENERAL] Get status of connection (C)

2001-05-29 Thread Tim Barnard
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

Re: [GENERAL] Help with C++

2001-05-29 Thread Tim Barnard
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 Subject: Re: [GENERAL] Help with C++ Hi Tim

[GENERAL] PQclear question...

2001-05-29 Thread Tim Barnard
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

[GENERAL] PQclear question, repeated

2001-05-29 Thread 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

Re: [GENERAL] PQclear question...

2001-05-29 Thread Tim Barnard
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 [EMAIL PROTECTED] writes: Is it necessary to call PQclear

Re: [GENERAL] Help with C++

2001-05-28 Thread Tim Barnard
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: [GENERAL]

[GENERAL] Re: [SQL] Difficult SQL Statement

2001-05-28 Thread Tim Barnard
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

Re: [GENERAL] Newbie HOWTO

2001-05-11 Thread Tim Barnard
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 09,

Re: [GENERAL] A different compile problem for 7.1.1

2001-05-08 Thread Tim Barnard
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 Subject: Re: [GENERAL] A different compile problem

[GENERAL] A different compile problem for 7.1.1

2001-05-07 Thread Tim Barnard
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:

[GENERAL] Re: A different compile problem for 7.1.1

2001-05-07 Thread Tim Barnard
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 Subject

Re: [GENERAL] 7.1 compile problem

2001-05-07 Thread Tim Barnard
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

Re: [GENERAL] How to check if a table exists

2001-03-08 Thread Tim Barnard
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

Re: [GENERAL] 7.1beta4 initdb problem

2001-02-05 Thread Tim Barnard
:-) 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: [GENERAL] 7.1beta4 initdb problem Pet

Re: [GENERAL] Problems installing version 7.1beta4

2001-02-05 Thread Tim Barnard
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

Re: [GENERAL] Data entry screen building utilities

2001-01-23 Thread Tim Barnard
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 Subject: Re: [GENERAL] Data e

Re: [GENERAL] Data entry screen building utilities

2001-01-23 Thread Tim Barnard
al 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 at 03:14:36PM -0800, Tim Barnard wrote:

Re: [GENERAL] Data entry screen building utilities

2001-01-23 Thread Tim Barnard
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 snip Rather than writing PostgreSQL

[GENERAL] Data entry screen building utilities

2001-01-22 Thread Tim Barnard
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

[GENERAL] RE: PQsetnonblocking

2000-12-27 Thread Tim Barnard
Never mind. I figured it out via the src code. Thanks anyway! Tim S.E. Mgr. Hartford Communications

[GENERAL] Max sessions question

2000-12-22 Thread Tim Barnard
Hello all, I've looked through the docs and I can't find anyanswers tothis 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

Re: [GENERAL] Postgres demographics?

2000-12-11 Thread Tim Barnard
snip We have some demographics available at http://www.pgsql.com/user_gallery snip I believe what was intended was: http://www.pgsql.com/register Tim