view problem
===================================================================
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. ____________
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
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