agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedproblem.
2+ messages / 2 participants
[nested] [flat]
* problem.
@ 1995-02-13 01:41 Ken Dueker <ken@mantle.colorado.edu>
0 siblings, 1 reply; 2+ messages in thread
From: Ken Dueker @ 1995-02-13 01:41 UTC (permalink / raw)
To: legacy
other queries work, but this one give this:
monitor -N -T -c retrieve ( E.enum, E.jday, E.hr, E.min, E.sec, E.msec, E.lat, E.lon, E.depth, E.mag, S.sname, S.lat, S.lon, SE.das, SE.sens, SE.pflag ) from E in event, S in site, SE in site_ep where E.jday >= "200"::int2 and E.jday <= "322"::int2 and E.jday >= SE.sday and E.jday <= SE.eday and S.sname = SE.sname and SE.pflag = "0"::int2 ebr
WARN:Feb 12 18:38:53:Cache lookup failed for procedure 63
any ideas ?
ken
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: problem.
@ 1995-02-13 03:24 Paul M. Aoki <aoki@cs.berkeley.edu>
parent: Ken Dueker <ken@mantle.colorado.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Paul M. Aoki @ 1995-02-13 03:24 UTC (permalink / raw)
To: Ken Dueker <ken@mantle.colorado.edu>; +Cc: legacy
Ken Dueker <ken@mantle.colorado.edu> writes:
> monitor -N -T -c retrieve ( E.enum, E.jday, E.hr, E.min, E.sec, E.msec, E.lat, E.lon, E.depth, E.mag, S.sname, S.lat, S.lon, SE.das, SE.sens, SE.pflag ) from E in event, S in site, SE in site_ep where E.jday >= "200"::int2 and E.jday <= "322"::int2 and E.jday >= SE.sday and E.jday <= SE.eday and S.sname = SE.sname and SE.pflag = "0"::int2 ebr
> WARN:Feb 12 18:38:53:Cache lookup failed for procedure 63
is this really how it appears on the command line, or is the query
actually enclosed in single-quotes? the use of shell metacharacters
("(", ")", ">", "<", the double-quotes) makes it hard to predict what
the query passed to the backend will actually end up looking like..
--
Paul M. Aoki | University of California at Berkeley
aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division (#1776)
| Berkeley, CA 94720-1776
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1995-02-13 03:24 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1995-02-13 01:41 problem. Ken Dueker <ken@mantle.colorado.edu>
1995-02-13 03:24 ` Paul M. Aoki <aoki@cs.berkeley.edu>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox