Re: [ADMIN] analytics

2004-09-22 Thread Michael Adler
Mondrian just went 1.0 and support PostgreSQL. Never tried it, though. http://perforce.eigenbase.org:8080/open/mondrian/doc/index.html On Wed, Sep 22, 2004 at 09:21:54AM -0500, Ben Kim wrote: > > Dear list, > > I wonder if I could get recommendations/reviews/experience for analytics > tools tha

Re: [ADMIN] Making a Persistent Postgres Connection

2004-09-22 Thread David Stanaway
Check out the SO_KEEPALIVE option for the socket. I am not sure there is a safe way to do this with the PGconn handle, but looking at the header there is an internal struct pg_conn you can look at include/postgresql/internal/libpq-int.h And the socket file handle is the sock member. By default,

Re: [ADMIN] Important Question.

2004-09-22 Thread G u i d o B a r o s i o
lol :) > [EMAIL PROTECTED] wrote: > > Hi, > > I have MySQL installed on my box and many users using it and I would > > like to start a irc server but I need to use PostgreSQL for the services > > ( Only Postgree supported ). > > Can I use MySQL and PostgreSQL on the same box? They will or the w

Re: [ADMIN] Important Question.

2004-09-22 Thread Bradley Kieser
We run PG and MySQL concurrently on many servers and there has never been an issue other than PG is better. Gaetano Mendola wrote: [EMAIL PROTECTED] wrote: Hi, I have MySQL installed on my box and many users using it and I would like to start a irc server but I need to use PostgreSQL for the se

Re: [ADMIN] Important Question.

2004-09-22 Thread Gaetano Mendola
[EMAIL PROTECTED] wrote: Hi, I have MySQL installed on my box and many users using it and I would like to start a irc server but I need to use PostgreSQL for the services ( Only Postgree supported ). Can I use MySQL and PostgreSQL on the same box? They will or the won't interfere eachother? You

[ADMIN] Important Question.

2004-09-22 Thread Futcur
Hi, I have MySQL installed on my box and many users using it and I would like to start a irc server but I need to use PostgreSQL for the services ( Only Postgree supported ). Can I use MySQL and PostgreSQL on the same box? They will or the won't interfere eachother?   Hope you can help me.  

[ADMIN] postgres and freebsd

2004-09-22 Thread Boris Tomic
Hi I have vps (virtual private server) with freebsd-4.8. I have installed postgresql manually and when I run "/usr/local/etc/rc.d/postgresql.sh start" from shell server starts normally but when I use same script for booting the server I get following log: Sep 20 08:38:58 mymasin postgres[48663]

Re: [ADMIN] Getting the OID of inserted row in a rule

2004-09-22 Thread Bradley Kieser
Ah! I didn't know that! Michael, thank you so much! No, I don't have anything sharing these sessions, they are rules in the back end so they should (unless someone tells me differently) AFAIK be in their own threads. Top man! Brad Michael Fuhr wrote: On Wed, Sep 22, 2004 at 04:30:06PM +0100, Bra

Re: [ADMIN] Getting the OID of inserted row in a rule

2004-09-22 Thread Gaetano Mendola
Bradley Kieser wrote: Hi Michael, But what if another insert happens in the mean time? Then the sequence would have advanced that the data will be scrambled. |Given that this could be a very active dataset, that situation is almost certain to occur. I think you are wrong, the sequence are not af

Re: [ADMIN] Getting the OID of inserted row in a rule

2004-09-22 Thread Michael Fuhr
On Wed, Sep 22, 2004 at 04:30:06PM +0100, Bradley Kieser wrote: > Michael Fuhr wrote: > > >CREATE RULE v_ins AS ON INSERT TO v DO INSTEAD ( > > INSERT INTO a (xxx) VALUES (NEW.xxx); > > INSERT INTO b (col1, col2, col3) VALUES (NEW.col1, NEW.col2, > > currval('a_id_seq')) > >); > > But what if ano

Re: [ADMIN] analytics

2004-09-22 Thread Ray Ontko
We have been happily using Brio/Hyperion Intelligence with postgresql via odbc. Ray On Wed, Sep 22, 2004 at 09:21:54AM -0500, Ben Kim wrote: > > Dear list, > > I wonder if I could get recommendations/reviews/experience for analytics > tools that can work off Postgresql database. I guess ROLAP w

Re: [ADMIN] Getting the OID of inserted row in a rule

2004-09-22 Thread Bradley Kieser
Hi Michael, But what if another insert happens in the mean time? Then the sequence would have advanced that the data will be scrambled. |Given that this could be a very active dataset, that situation is almost certain to occur. Brad Michael Fuhr wrote: On Wed, Sep 22, 2004 at 02:21:42PM +0100, B

Re: [ADMIN] Getting the OID of inserted row in a rule

2004-09-22 Thread Michael Fuhr
On Wed, Sep 22, 2004 at 02:21:42PM +0100, Bradley Kieser wrote: > I have a rule on a view that needs to insert into two tables. The one > table has a serial ID as its unique key. The second table links to the > first one in one of its columns. > > I would prefer to keep this as a rule-based solu

Re: [ADMIN] Making a Persistent Postgres Connection

2004-09-22 Thread Tom Lane
Aryan Ariel Rodriguez Chalas <[EMAIL PROTECTED]> writes: > I have any problems when I make a connection to the > Local Database, but every time I make a postgres > connection (via Internet) to a Remote Database, I find > the problem that the connections falls down every 10 > minutes more or less.

Re: [ADMIN] analytics

2004-09-22 Thread Bradley Kieser
I may be wrong but I am pretty sure that Cognos can work with it. Brad Ben Kim wrote: Dear list, I wonder if I could get recommendations/reviews/experience for analytics tools that can work off Postgresql database. I guess ROLAP will be the natural solution, but is there a MOLAP engine that can wor

[ADMIN] analytics

2004-09-22 Thread Ben Kim
Dear list, I wonder if I could get recommendations/reviews/experience for analytics tools that can work off Postgresql database. I guess ROLAP will be the natural solution, but is there a MOLAP engine that can work with Postgresql database? But established vendors' products don't seem to include

[ADMIN] Making a Persistent Postgres Connection

2004-09-22 Thread Aryan Ariel Rodriguez Chalas
Hi everybody I really would apreciate if somebody could help me on how to make a persistent connection to a Remote Database using "C Language". I work in "Linux" Operating System and use the header I have any problems when I make a connection to the Local Database, but every time I make a postgr

[ADMIN] pg_autovacuum

2004-09-22 Thread iulia . pacurar
Hi! I run pg_autovacuum: ./pg_autovacuum -D but then I cannot find pg_autovacuum.log file. Where shoud I look for it? Thank you. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining colum

[ADMIN] Getting the OID of inserted row in a rule

2004-09-22 Thread Bradley Kieser
I have a rule on a view that needs to insert into two tables. The one table has a serial ID as its unique key. The second table links to the first one in one of its columns. I would prefer to keep this as a rule-based solution and not have to write a function as I hope to relicate the solution