Skip site navigation (1) Skip section navigation (2)

Some items for the TODO list

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Some items for the TODO list
Date: 1998-07-08 23:26:09
Message-ID: 312.899940369@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Things I'd like to see get in there before 6.4:

1. On HPUX, the new no-exec method of starting the backend means that
all the backends claim to be "postmaster"; there's no way to tell 'em
apart via ps(1).  There is some code in postgres.c that tries to update
the process title information by tweaking the original argv[] array, but
that just plain doesn't work under HPUX, nor under quite a few other
Unix variants.  I'm finding out that not being able to tell which
process is which is a real pain in the neck; I don't think it will be
acceptable for production use.  I think we are going to have to bite the
bullet and borrow the process-title-setting code from sendmail --- I
know it's ugly, but it *works* on many many Unixes.

2. I'm starting to get annoyed by the inability to "unlisten" from
a particular relation.  Is there a reason that there is not an UNLISTEN
command?  (Like maybe it's not in ANSI SQL?)  Or is it just something
that never got to the top of the to-do queue?  I see that the low-level
code for a backend to unlisten itself is in there, but there's no way
for the frontend to command it to happen.

If no one else feels like working on these, maybe I will.  I could use
some pointers for #2 though ... what needs to be done to add a new SQL
statement?

			regards, tom lane

Responses

pgsql-hackers by date

Next:From: ocieDate: 1998-07-09 01:04:49
Subject: Re: [HACKERS] Some items for the TODO list
Previous:From: Jan WieckDate: 1998-07-08 18:34:45
Subject: Re: [PG95-DEV] Rule system

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group