Thread

1. view problem

   Marc G. Fournier <scrappy@hub.org> — 1998-05-16T17:44:14Z

   
   ===================================================================
   This message has been sent to a DEAD mailing list, and subsequently 
   reforwarded to the proper one: pgsql-interfaces@postgresql.org
   ===================================================================
   
   
   	Hey, can someone tell me why this happens and/or possibly a better way
   to do it?:
   
   misc=> create view fifteen as
   misc->     select * from rstat where
   misc->     (
   misc->         time>datetime(now())-'1 minute'::timespan and
   misc->         time<datetime(now())+'1 minute'::timespan
   misc->     ) or
   misc->     (
   misc->         time>datetime(now())-'16 minutes'::timespan and
   misc->         time<datetime(now())-'15 minutes'::timespan
   misc->     )
   misc-> ;
   ERROR:  DefineQueryRewrite: rule plan string too big.
   
   	I'm taking samples of rstat, and I want to be able to pull out one
   current sample, and one sample from fifteen minutes ago.  I've tried this with
   between, and I tried it with the date truncation stuff, just won't take my
   view.  I also tried making a function that did something similar, 'cept it
   produces a strange output, (just returns OIDs?).  TIA
   
   --
   SA, software.net         My girlfriend asked me which one I like better.
   pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
   |    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE 
   L_______________________ I hope the answer won't upset her. ____________
   
   
   

2. ERROR

   Ricardo Romero <rromero@netfriendly.com> — 1998-05-17T15:30:18Z

   Hi.
   
   postgreSQL instaled since 15/may/98 on FreeBSD 2.2.5
   
   # su - pgsql
   $ postmaster -S
   $ createdb mydb
   Connection to database 'template1' failed.
   connectDB() failed: Is the postmaster running at 'localhost' on port '5432'?
   createdb: database creation failed on mydb.
   $ createuser rromero
   Connection to database 'template1' failed.
   connectDB() failed: Is the postmaster running at 'localhost' on port '5432'?
   createuser: database access failed.
   $ destroydb mydb
   Connection to database 'template1' failed.
   connectDB() failed: Is the postmaster running at 'localhost' on port '5432'?
   destroydb: database destroy failed on mydb.
   $ psql
   Connection to database 'pgsql' failed.
   connectDB() failed: Is the postmaster running at 'localhost' on port '5432'?
   $
   
   
   Somebody help-me please ?????
   
   
   rromero@netserv.com.br
   
   
   

3. Re: [GENERAL] ERROR

   Peter Mount <pgsqlgen@retep.org.uk> — 1998-05-17T20:12:07Z

   k
   On Sun, 17 May 1998, Ricardo Romero wrote:
   
   > Hi.
   > 
   > postgreSQL instaled since 15/may/98 on FreeBSD 2.2.5
   > 
   > # su - pgsql
   > $ postmaster -S
   
   try:
   
   $ postmaster -S -i
   
   > $ createdb mydb
   
   instead of createdb, try:
   
   $ psql template1
   ...
   template1> create database mydb;
   
   > Connection to database 'template1' failed.
   > connectDB() failed: Is the postmaster running at 'localhost' on port '5432'?
   > createdb: database creation failed on mydb.
   > $ createuser rromero
   > Connection to database 'template1' failed.
   > connectDB() failed: Is the postmaster running at 'localhost' on port '5432'?
   > createuser: database access failed.
   > $ destroydb mydb
   > Connection to database 'template1' failed.
   > connectDB() failed: Is the postmaster running at 'localhost' on port '5432'?
   > destroydb: database destroy failed on mydb.
   > $ psql
   > Connection to database 'pgsql' failed.
   > connectDB() failed: Is the postmaster running at 'localhost' on port '5432'?
   > $
   > 
   > 
   > Somebody help-me please ?????
   > 
   > 
   > rromero@netserv.com.br
   > 
   > 
   
   -- 
   Peter T Mount peter@retep.org.uk or petermount@earthling.net
   Main Homepage: http://www.retep.org.uk
   ************ Someday I may rebuild this signature completely ;-) ************
   Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk