Postgres Pro
Downloads
Home   >   mailing lists

Thread: view problem

view problem

From
The Hermit Hacker
Date:

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

ERROR

From
Ricardo Romero
Date:
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

Re: [GENERAL] ERROR

From
Peter Mount
Date:
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