[GENERAL] XML objects in Postgres

1999-04-20 Thread listuser
Hi, I intend to store and retrieve XML objects in a Postgres database. Has anybody already gained experience with this? If so, could we share experience? Maybe we could do some common development in terms of datamodelling, methods, functions etc. Thanks Frank Kooger Best regards, listuser

[GENERAL] Object-oriented stuff and postgres

1999-04-20 Thread Chris Bitmead
What's the best way to do this in postgres? (basicly finding the type of objects). I want to run a web site with different types of content - question and answers, stories etc. I propose an object hierarchy... webobject (title, body) question inherits webobject story (image) inherits (webob

[GENERAL] Default table structure

1999-04-20 Thread AGRE Enterprises Limited
I am making the assumption that when a table is created, it is always a heap. Is this in fact true ? If so, then the only way to get keyed access is through the use of an index. I use Ingres at work and it is great being able to change the structure of a table so that another index isn't needed

[GENERAL] tracking postgres

1999-04-20 Thread Guo Ge
hi all I am tracking the psql and postgres recently.After psql sends the query to the backend,I cann't continue to track.I don't know how the postgres puts the results into the conn. Because the psql gets results of query afetr it sends query. If I do "gdb postgres" , because of the va

[GENERAL] Insert NULL date field

1999-04-20 Thread Rick Rosque
I have a table in postgresql 6.4.2 that has date fields. I'm trying to insert a null into the date field and cannot find any docs on how to do this. Can someone please give me some help. insert into employee ( empnumber, hiredate, terminationdate ) values ( 4, '04/19/99', NULL ) the above NULL

RE: [GENERAL] Optimal indicies

1999-04-20 Thread Jackson, DeJuan
> Hi! > > On Fri, 16 Apr 1999, Jackson, DeJuan wrote: > > try: > > EXPLAIN SELECT pos_id, rating > > FROM pos_rating pr > > WHERE date_i = current_date AND city_id = 2 AND > > EXISTS (SELECT DISTINCT pos_id FROM positions p WHERE subsec_id = 1 AND > > status = 'A' AND pr.pos_id=p.pos_id) > >

Re: [GENERAL] TUPLES <> HEAP

1999-04-20 Thread Karl DeBisschop
Not sure that you can drop/create system indexes (I didn't notice that when I posted earlier - sorry). But the the same idea may apply - can you dump and recreate the database tables. $ pg_dump existing > existing.dump $ psql -e secondtry < exidting.dump BTW, do you need to cross-post to all t

[GENERAL] TUPLES <> HEAP

1999-04-20 Thread JT Kirkpatrick
Hi all. Head hanging a little low, even though system still seems to work fine. Here is what I did: - update pg_class set relname = lower(relname); - update pg_attribute set attname = lower(attname); - (why did I do that? Following something I read, not really having problems in the first pl

RE: [GENERAL] How to get seq after insert

1999-04-20 Thread Michael J Davis
Cool!!! I did not know this. Thanks for verifying how this works. I will change my application to use currval instead of nextval. -Original Message- From: Ross J. Reedstrom [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 20, 1999 10:33 AM To: [EMAI

Re: [GENERAL] How to get seq after insert

1999-04-20 Thread Ross J. Reedstrom
Hmm, Ross needs to break for lunch - his brain is runing out of glucose! Ross J. Reedstrom wrote: > > No, as Herouth pointed out, currval is multiuser-safe: it returns the > last value given in the current session, and every user get's their own gets > session. I just tried it out in two psql s