Re: [HACKERS] What goes into the security doc?

2003-01-24 Thread Dan Langille
On 22 Jan 2003 at 13:29, Christopher Kings-Lynne wrote: > Recommend always running "initdb -W" and setting all pg_hba entries to md5. Thanks. I also encountered this item on IRC: [09:26] Guys, is there a problem with using /bin/true of /bin/false as the shell of the postgres user? The docs on

Re: [HACKERS] What goes into the security doc?

2003-01-24 Thread Andrew Dunstan
man su says (on Linux): -s, --shell=SHELL run SHELL if /etc/shells allows it Illustration: [adunsta:adunsta]$ su -s /bin/tcsh - -c 'ps -f $$' Password: UIDPID PPID C STIME TTY STAT TIME CMD root 10682 10681 0 10:34 pts/0S 0:00 -tcsh -c ps -f $$

[HACKERS] Client interfaces documentation

2003-01-24 Thread Jeroen T. Vermeulen
Something that just occurred to me: should the documentation tree still contain full documentation for the various client interfaces, now that they have been unbundled? If so, I'd very much like to see the part about libpq++ being "the" C++ interface changed to mention libpqxx as a replacement.

[HACKERS] JDBC drivers and streaming content

2003-01-24 Thread Chris Smith
I'm about to start implemention streaming of queries to the server in the pgsql jdbc drivers when PreparedStatement is used with setBinaryStream... but before I get started, since I've never contributed before, I wanted to run it by everyone. I'm planning on making the following changes: 1. In Qu

Re: [HACKERS] Suggestion for aggregate function

2003-01-24 Thread Greg Stark
Greg Stark <[EMAIL PROTECTED]> writes: > Manfred Koizar <[EMAIL PROTECTED]> writes: > > > Greg, we already have this feature, just the syntax is a bit different :-) > > > >SELECT DISTINCT ON (item_id) item_id, > > price AS lowest_price, > > store_id AS lowest

Re: [HACKERS] Suggestion for aggregate function

2003-01-24 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > What would be useful is something like > SELECT item_id, >first(price) as min_price, first(store_id) as min_store, >avg(price) as avg_price, >last(price) as max_price, last(store_id) as min_store, >count(distinct store_id)

Re: [HACKERS] Client interfaces documentation

2003-01-24 Thread Tom Lane
"Jeroen T. Vermeulen" <[EMAIL PROTECTED]> writes: > Something that just occurred to me: should the documentation tree still > contain full documentation for the various client interfaces, now that > they have been unbundled? No, and it doesn't AFAICS ... only the still-bundled client libs are ment

Re: [HACKERS] Options for growth

2003-01-24 Thread Andrew Sullivan
On Thu, Jan 16, 2003 at 12:23:52PM -0500, Neil Conway wrote: > > The estimates I've heard from a couple parties are that PostgreSQL tends > to scale well up to 4 CPUs. I've been meaning to take a look at > improving that, but I haven't had a chance yet... I can definitely tell you that Postgres s

[HACKERS] docbook and postgresql

2003-01-24 Thread Sailesh Krishnamurthy
Hi folks I'm trying to build the documentation for pgsql (so that I can change it for the stuff we are building) and I'm having trouble finding the necessary docbook stuff. I looked at: http://developer.postgresql.org/docs/postgres/doc-build.html checking for onsgmls... onsgmls chec

[HACKERS] PSQL and backward compatibility

2003-01-24 Thread Rod Taylor
I've started playing with a structure based on the description in this message: http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&selm=1043257402.83856.112.camel%40jester&rnum=21 Basically, it consists of a very simple schema to tell PSQL what \? commands are available,

Re: Windows Build System was: [HACKERS] Win32 port patches submitted

2003-01-24 Thread Kevin Brown
Curtis Faith wrote: > tom lane writes: > > You think we should drive away our existing unix developers > > in the mere hope of attracting windows developers? Sorry, it > > isn't going to happen. > > Tom brings up a good point, that changes to support Windows should not > add to the tasks of tho

[HACKERS] WAL replay logic (was Re: [PERFORM] Mount options for Ext3?)

2003-01-24 Thread Tom Lane
Kevin Brown <[EMAIL PROTECTED]> writes: > One question I have is: in the event of a crash, why not simply replay > all the transactions found in the WAL? Is the startup time of the > database that badly affected if pg_control is ignored? Interesting thought, indeed. Since we truncate the WAL aft

Re: [HACKERS] Odd subselect in target list behavior WRT aggregates

2003-01-24 Thread Tom Lane
"Mike Mascari" <[EMAIL PROTECTED]> writes: > Hello. I have some code which generates subselects in the target > list of a query and then aggregates the results. The code allows > the user to determine the attributes of the aggregation. If the > user chooses to aggregate on the same value twice, I g

Re: [HACKERS] Odd subselect in target list behavior WRT aggregates

2003-01-24 Thread Mike Mascari
Tom Lane wrote: "Mike Mascari" <[EMAIL PROTECTED]> writes: Hello. I have some code which generates subselects in the target list of a query and then aggregates the results. The code allows the user to determine the attributes of the aggregation. If the user chooses to aggregate on the same value

Re: [HACKERS] Postgresql source

2003-01-24 Thread Hannu Krosing
[EMAIL PROTECTED] kirjutas N, 23.01.2003 kell 02:29: > Can you please tell me how can I download all the source codes for > postgresql?? ftp://ftp.postgresql.org/ > -Radha Manohar > > ---(end of broadcast)--- > TIP 6: Have you searched our list ar

[HACKERS] I am back

2003-01-24 Thread Bruce Momjian
I am back from training at the Big Nerd Ranch. We had 13 people for the week and it went very well. I have church meetings tomorrow but will try to get back to email this weekend. I also have to polish my presentations for Tokyo/Brussels because I leave on Wednesday. Also, I have Internet acces