Re: [GENERAL] php and pgsql and rpm/compile

2000-09-07 Thread Lamar Owen
Tressens Lionel wrote: > > Le 07.09.00 a 14:23, "Lamar Owen" m'ecrivait : > > > It is coming back with a dependency for libpq.so.2.0 > > I had this problem. I created a symlink for this file and a told rpm not > to check dependies, and it worked. > rpm --nodeps -ivh ... And, if you know the ra

Re: [GENERAL] php and pgsql and rpm/compile

2000-09-07 Thread Tressens Lionel
Le 07.09.00 a 14:23, "Lamar Owen" m'ecrivait : > It is coming back with a dependency for libpq.so.2.0 I had this problem. I created a symlink for this file and a told rpm not to check dependies, and it worked. rpm --nodeps -ivh ... Lionel == Lion

Re: [GENERAL] php and pgsql and rpm/compile

2000-09-07 Thread Lamar Owen
Adam Lang wrote: > > I have php installed from rpm. I'm trying to rpm the package > php-pgsql-3.0.15.i386.rpm so that I can tie in to the postgres server. > > It is coming back with a dependency for libpq.so.2.0 The original packages distributed with RH 6.1 and 6.2 are for PostgreSQL 6.5.3 --

[GENERAL] Materialized views in PostgreSQL?

2000-09-07 Thread Daniel P. Katz
Hi. Does PostgreSQL 7.0 support materialized views? Sorry if this is a FAQ, but I didn't find it in the FAQ list, the users guide, or the archives for this list. Thanx. Dan

Re: [GENERAL] php and pgsql and rpm/compile

2000-09-07 Thread Mike Sears
I had this problem a few weeks ago when I was setting up php and postgress. The easeist way (not recomended by my sysadmin =) ) was to rpm install all of my postgress programs, (postgress 7.02, server, test rpms) and then compiled php from scratch which was fairly painless I simply compiled php t

Re: [GENERAL] php and pgsql and rpm/compile

2000-09-07 Thread Adam Lang
Nevermind... apparently if I rpm it with --nodeps it ignores it, but the php script still runs correctly. Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "Adam Lang" <[EMAIL PROTECTED]> To: "PGSQL General" <[EMAIL PROTECTED]> Sent: Thursday, Septem

[GENERAL] php and pgsql and rpm/compile

2000-09-07 Thread Adam Lang
I have php installed from rpm. I'm trying to rpm the package php-pgsql-3.0.15.i386.rpm so that I can tie in to the postgres server. It is coming back with a dependency for libpq.so.2.0 I made a softlink to libpq.so.2.1 pointing to libpq.so.2.1, but it still has that dependency. I have /usr/loc

[GENERAL] query question

2000-09-07 Thread chris mutchler
I am new to using postgresql and have the following question. if i submit a query (through a perl script), what values (and in what order) will be returned to me? here is my query: SELECT p.ids_name, m.start_time, m.end_time FROM mail_schedule m, personnel p WHERE p.ids_

Re: [GENERAL] postgres not allowing new database?

2000-09-07 Thread lee johnson
"Trewern, Ben" wrote: You need to create a database first and connect to it. Best to do createdb testdb at the command line below is error i get when trying to do above command i realize i need to start postmaster but all trys not successful as from docs i can't tell how to get m

[GENERAL] Stored Procedures

2000-09-07 Thread Andreas Tille
Hello after playing around for a while with PostgreSQL's Stored Functions I think I understood the concept behind it a little bit. It is mighty but quite different from all other SQL servers Stored Procedures. Considering the fact that there is another OpenSourced SQL database engine Interbase,

Re: [GENERAL] That killer 3rd join...

2000-09-07 Thread Oliver Smith
On Thu, Sep 07, 2000 at 10:23:57AM -0300, The Hermit Hacker wrote: > BTW, what do you mean by 'went away'? crashed, or just hung there? Stopped using CPU, stopped responding to signals (except in the end -9), and when I did finally kill it (the following day, to give it chance to do what it was

Re: [GENERAL] That killer 3rd join...

2000-09-07 Thread Oliver Smith
On Thu, Sep 07, 2000 at 02:11:38PM +0100, Oliver Smith wrote: > However, when I did that, postgres went away. I'll give your idea a try, > it looks quite promising. I still found this took quite a long time to process the query. So - I created the four views, silver, elec, gold, plat, and a new v

Re: [GENERAL] That killer 3rd join...

2000-09-07 Thread The Hermit Hacker
On Thu, 7 Sep 2000, Oliver Smith wrote: > CREATE VIEW silver AS > SELECT * FROM jcombo_query WHERE metal_uid = 1 ; > > CREATE VIEW elec AS > ... > > However, when I did that, postgres went away. I'll give your idea a try, > it looks quite promising. Ya, looked at that ... you were doing a VI

Re: [GENERAL] That killer 3rd join...

2000-09-07 Thread Oliver Smith
On Wed, Sep 06, 2000 at 10:52:34PM -0300, The Hermit Hacker wrote: > SELECT > stone_name, st.stone_uid, stone_modifies, stone_difficulty, stone_cost, > silver.jtyp_name AS silver_name, (silver.metal_cost + stone_cost) AS Expr1, > silver.jcombo_stats AS silver_stats, > elec.jtyp_name AS el

[GENERAL] RE:Error building JDBC Driver

2000-09-07 Thread Mark Kirkwood
Previously: > >When attempting to build JDBC 7.0 driver with "make jdbc2 jar", the following >error occurs: > > org.postgresql.Connection.java: Can't find class org/postgresql/Field > >Any ideas? Thanks. I encountered this error when using an older JDK ( < 1.2 ) Downloading 1.2.2 from S