agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedpostgres question
5+ messages / 5 participants
[nested] [flat]
* postgres question
@ 1992-08-05 22:00 Rex Jakobovits <rex@cs.washington.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Rex Jakobovits @ 1992-08-05 22:00 UTC (permalink / raw)
To: legacy
Hello,
I'm a PhD student doing research for Dr. Linda Shapiro at the
University of Washington. We have NSF support to design and build a
spatial database system based on a hierarchical relational data
structure. We are interested in evaluating POSTGRES as a potential
framework for our project.
We have installed POSTGRES at our site, and I've been experimenting
with the examples in the Manual. One thing I have not been able to
figure out is: how do I list the classes and fields defined in a
database? Suggestions would be greatly appreciated.
Rex Jakobovits (rex@cs.washington.edu)
Dept. of Computer Science
University of Washington
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: postgres question
@ 1992-08-06 02:44 Alfredo Sanchez <joseash@bush.tamu.edu>
0 siblings, 0 replies; 5+ messages in thread
From: Alfredo Sanchez @ 1992-08-06 02:44 UTC (permalink / raw)
To: legacy
Rex Jakobovits (rex@cs.washington.edu) writes:
> One thing I have not been able to
> figure out is: how do I list the classes and fields defined in a
> database? Suggestions would be greatly appreciated.
>
Someone answered this and I've used it now and then, so I repost:
>
> You can query the system catalogs directly:
>
> retrieve (pg_class.relname)
>
> retrieve (pg_attribute.attname)
> where pg_attribute.attrelid = pg_class.oid
> and pg_class.relname = "foo"
>
> The first query gives you all class names in the database and
> the second query gives you all attribute names for class foo
> (this includes both system and user defined attributes).
>
Regards,
J Alfredo Sanchez H
-------------------
Hypermedia Research Lab
Texas A&M University
^ permalink raw reply [nested|flat] 5+ messages in thread
* POstgres Question
@ 1992-11-20 08:34 Tom Vijlbrief <tom@izf.tno.nl>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Vijlbrief @ 1992-11-20 08:34 UTC (permalink / raw)
To: legacy; +Cc: legacy
Are you by any chance using palloc and pfree in the frontend application ?
This is not the intention, you should only use it in functions which
are loaded by the postgres backend and never in the application....
Hope this helps,
Tom
^ permalink raw reply [nested|flat] 5+ messages in thread
* postgres question
@ 1994-05-30 07:15 Jorge Najenson <najenson@cs.huji.ac.il>
1994-05-30 09:40 ` Re: postgres question Paul M. Aoki <aoki@postgres.Berkeley.EDU>
0 siblings, 1 reply; 5+ messages in thread
From: Jorge Najenson @ 1994-05-30 07:15 UTC (permalink / raw)
To: legacy
Sender: oris@CS.HUJI.AC.IL
Hi,
I wonder if you have an idea to solve my problem...
after creating database:
createdb test1
and running the following shell script:
#!/bin/csh
monitor -c 'create Persons(id=int4,name=char16,address=char16,byear=int2)' $1
monitor -c 'create Books(serial=int4,title=char16,section=char16)' $1
monitor -c 'create Authors(id=int4,title=char16)' $1
monitor -c 'retrieve into tmp (p.name,year=p.byear)\
from p in Persons,a in Authors,b in Books\
where p.id=a.id and\
a.title=b.title and b.section="AI"' $1
monitor -c 'retrieve into tmp2 (year=int2max{tmp.year})' $1
I get the message :
WARN:Dec 19 21:47:12:ExecAgg: no initial value given and no valid tuples
found
which is logical since tmp is empty,but when I try to use the database again
for let say :
monitor -c 'retrieve (pg_class.all)' test1
I get :
WARN:Dec 19 21:49:42:OperatorObjectIdFillScanKeyEntry: unknown operator 609
and it repeat it self for every query I try on that database.
even stranger, I cannot destroy the database with
destroydb test1
because it hangs the postmaster which I have to kill and run again to
successfully destroy the database.
I will be glad to get a quick reply since we give here a DataBase course and
exercises will be given on the postgres system.
p.s. please add me to your mailing list.
Ori.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sternberg Ori,
C.S. System Group, Hebrew University,
Jerusalem 91904, ISRAEL.
oris@cs.huji.ac.il
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
------- End of Forwarded Message
==============================================================================
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.
==============================================================================
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: postgres question
1994-05-30 07:15 postgres question Jorge Najenson <najenson@cs.huji.ac.il>
@ 1994-05-30 09:40 ` Paul M. Aoki <aoki@postgres.Berkeley.EDU>
0 siblings, 0 replies; 5+ messages in thread
From: Paul M. Aoki @ 1994-05-30 09:40 UTC (permalink / raw)
To: Jorge Najenson <najenson@cs.huji.ac.il>; +Cc: legacy
Jorge Najenson <najenson@cs.huji.ac.il> writes:
> WARN:Dec 19 21:47:12:ExecAgg: no initial value given and no valid tuples
> found
> which is logical since tmp is empty,but when I try to use the database again
> for let say :
> monitor -c 'retrieve (pg_class.all)' test1
> I get :
> WARN:Dec 19 21:49:42:OperatorObjectIdFillScanKeyEntry: unknown operator 609
dunno. i just tried it on 4.2 and didn't get the second message.
(are you really seeing "Dec 19" on queries you're running right now?)
> p.s. please add me to your mailing list.
you're on it. my last set of bounce messages contain:
451 najenson@cs.huji.ac.il,oris@cs.huji.ac.il... reply: read error from pnlg.pnl
.gov.
(which makes me wonder why i'm bothering to mail this.. well, maybe
it's a transient error..)
--
Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU
| Berkeley, CA 94720 | ...!uunet!ucbvax!aoki
==============================================================================
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.
==============================================================================
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1994-05-30 09:40 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1992-08-05 22:00 postgres question Rex Jakobovits <rex@cs.washington.edu>
1992-08-06 02:44 Re: postgres question Alfredo Sanchez <joseash@bush.tamu.edu>
1992-11-20 08:34 POstgres Question Tom Vijlbrief <tom@izf.tno.nl>
1994-05-30 07:15 postgres question Jorge Najenson <najenson@cs.huji.ac.il>
1994-05-30 09:40 ` Paul M. Aoki <aoki@postgres.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