[GENERAL] Installation Problem

Hi All, I'm trying ot install postgresql 8.0.4 on suse 9.0. I can run ./configure but when I try to run make, the program cannot find a usable c compiler. I tried ./configure CC=/usr/lib/gcc-lib/i586-suse-linux/3.3.3/cc1 but get the error: cannot run c compiled programs. I tried to downlaod an

Re: [GENERAL] Restore to a database with another name?

Lonni J Friedman wrote: On Wed, 30 Mar 2005 15:58:02 -0500, phil campaigne <[EMAIL PROTECTED]> wrote: Scott Marlowe wrote: On Wed, 2005-03-30 at 14:28, phil campaigne wrote: Hi All, I want to move my development database (7.2.3) to my production server but the production

Re: [GENERAL] Restore to a database with another name?

Scott Marlowe wrote: On Wed, 2005-03-30 at 14:28, phil campaigne wrote: Hi All, I want to move my development database (7.2.3) to my production server but the production server database has a different name. What is the procedure for restoring a database pg_dump to another machine with a

[GENERAL] Restore to a database with another name?

Hi All, I want to move my development database (7.2.3) to my production server but the production server database has a different name. What is the procedure for restoring a database pg_dump to another machine with a different database name? Thanks in advance, Phil ---(

[GENERAL] [OT] Duration between two timestamps

Hi All, In my java application I need to subtract two java.sql.timestamps. and I want to store the result as sql type "interval". But my insert statement is failing. Does anyone know what java type I need to use in the insert statement? (it must accept null values) thanks in advance, Phil

Re: [GENERAL] error while loading shared libraries: libpq.so.3

Russell Smith wrote: On Mon, 21 Feb 2005 08:05 pm, Surabhi Ahuja wrote: it now says: i do the following make sample LDLIBRARY = /usr/local/pgsql/lib ./sample LDLIBRARY: Command not found. do you still experience problems when you run LDLIBRARY=/usr/local/pgsql/lib ./sample Note there is no

Re: [GENERAL] Problem with select statement

Ragnar Hafstað wrote: On Sun, 2005-02-20 at 20:01 -0500, phil campaigne wrote: Hi gnari, I forgot one thing. I also need to restrict the selecct with two more qualifiers where contest_id =1 and team='Duke' I'm confused where to put it in the select statement. I tried this

Re: [GENERAL] Problem with select statement

Ragnar Hafstað wrote: On Sun, 2005-02-20 at 18:18 -0500, phil campaigne wrote: Yes Gnari it works now! all I had to do in addition to your advice was alias the sub select: hardwoodthunder=# select player_number,player_name,cum_score,sum(a),sum(c),sum(t) from ( select player_number

[GENERAL] Problem with select statement

Yes Gnari it works now! all I had to do in addition to your advice was alias the sub select: hardwoodthunder=# select player_number,player_name,cum_score,sum(a),sum(c),sum(t) from ( select player_number, player_name, cum_score, (select player_points where aspect='A') as A ,(select player_points

[GENERAL] Problems with select statement

I see that I need another qualifier, cum_score in the select statement, but I still need to consolidate the rows: hardwoodthunder=# select player_number, player_name, cum_score, (select player_points where aspect='A') as A ,(select player_points where aspect='C') as C, (select player_points whe

[GENERAL] Problems with select statement

Hi all, I'm haveing trouble writing a select statement that gives me a resulting row like this: player_number, player name,a,c,t, (total of a+c+t). here's what I have so far but it puts the a,c,t in separate rows. hardwoodthunder=# select (select player_points where aspect='A') as A,(select play

Re: [GENERAL] Duration between two timestamps

Steve Crawford wrote: On Friday 04 February 2005 7:37 am, you wrote: Hi All, I have stored event records in Postgresql 7.3.4 and now need to calculate the duration between each event in succession. I have "record_id" and a" timestamp without time zone" columns for each event. What is a good way

[GENERAL] Duration between two timestamps

Hi All, I have stored event records in Postgresql 7.3.4 and now need to calculate the duration between each event in succession. I have "record_id" and a" timestamp without time zone" columns for each event. What is a good way to calculate the difference in timestamp and store it in the record

[GENERAL] Error Message

Hi All, false alarm... I found the problem. I tried to reuse an insertStatement. can't do it. Phil ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] Error Message

Hi All, I'm getting the following from an "insertStatement.executeUpdate();" error message: postgresql.stat.result [EMAIL PROTECTED] Does anybody know why? thanks, Phil ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an

[GENERAL] Numeric type

Hi All, I have a double type in java that I am trying to store in postgresql as type numeric and it doesn't seem to like it. The error message is, function double(numeric) does not exist unable to identify a function that satisfies the given argument type you may need to add explicit type casts.

[GENERAL] Partitioning Postgresql

>phil campaigne wrote: Hello All, I know that with Oracle you can partition the tables into logical subsets and was wondering if this was also possible in postgres. >No (except by hand, with a view layered over the top). Also is postgresql supported on linux cluusters? >And no (at

[GENERAL] Partitioning Postgresql

Hello All, I know that with Oracle you can partition the tables into logical subsets and was wondering if this was also possible in postgres. Also is postgresql supported on linux cluusters? Thanks in advance, Phil ---(end of broadcast)--- TIP 9: t

[GENERAL] null value of type java.sql.Time

Thanks for the insight Thomas and Gregory. I think I can make a work around. Phil ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] null value of type java.sql.Time

Occasionally I want to store a null value for my java.sql.Time--> Time column in Postgresql. update event set game_clock=null where event_id=1; I can retreive the record with the null value (type Time) if I select on the primary key, select game_clock from event where event_id = 1; but when

[GENERAL] correct representation of timestamp difference

Hi I'm trying to create a select statement that will return all rows that are older than 30 milleseconds. Is either of these correct? select event_id from event where (current_timestamp-timestamp)>.030 or select event_id from event where (current_timestamp-timestamp)>00030.00 thanks, Phi

[GENERAL] Setting up Postgresql in Linux

Phil Campaigne wrote: Hi Ron, I had a couple of questions on your instructions: 1. what is this for? >#make install-all-headers According to the docs you need it if you are going to create your own functions, however the documentation is a bit *vague*. "If you plan to do any ser

[GENERAL] Setting up Postgresql on Linux

On Mon, 1 Mar 2004, phil campaigne wrote: Nigel J. Andrews wrote: >On Mon, 1 Mar 2004, Phil Campaigne wrote: > > > >>Hello, >>I originally installed postgresql as root user and now I am setting up a >>development environment with cvs and a java ide an

[GENERAL] Setting up Postgresql on Linux

Thanks for the great response. I will try all of your ideas and get back with the results in a couple of days. thanks, again, Phil ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] problem with jdbc connection to postgesql

Hi All, I am seting up my web app with a tomcat/postgresql hosting service. From my psql client I type psql and then I am asked for my password. This logs me into my hosted database just fine. However, I can't log on from my webapp to the database thru jdbc like I could when my webapp/Tomcat/po

[GENERAL] psql: relocation error: psql: undefined symbol: PQgetssl

Hi All, I just installed postgresql 7.3.4 as an upgrade to 7.3.2 and all went well untill I tried to log into a database that I successfully created. Here are the steps in question: bash-2.05b$ psql -h localhost -U postgres hardwoodthunder Welcome to psql 7.3.2, the PostgreSQL interactive termi

[GENERAL] psql error: cannot open libpq.so.3

Hi Tom, THanks for your response. Here are my results: -bash-2.05b$ ldd /usr/local/pgsql/bin/psql libpq.so.3 => /usr/local/pgsql/lib/libpq.so.3 (0x40013000) libz.so.1 => /usr/lib/libz.so.1 (0x4002f000) libreadline.so.4 => /usr/lib/libreadline.so.4 (0x4003d000) libte