[ADMIN] Genetic algorithms

2001-11-20 Thread Miguel Gonzalez
dear all, I am looking for some information of how to use the query optimization facility using genetic algorithms in PostgreSQL. I tried to find some information on the internet, but I couldnt find any detailed information of how to use genetic algorithms in PostgreSQL. Has anyone know any

[ADMIN] database cluster

2001-11-20 Thread Jodi Kanter
Let's try this again. Please respond to this message as it has my correct email address I mistakenly created a second database cluster. Can someone tell me how to remove this? Also, I need to reinitialize my original cluster since I did not have my locale set properly. I have

Re: [ADMIN] Numbers of entries in pg_trigger

2001-11-20 Thread Stephan Szabo
On Tue, 20 Nov 2001, Jeff Boes wrote: Does anyone have a pointer to info on what kinds of things cause entries in pg_trigger? We're trying to understand why some tables have a half-dozen corresponding entries, and some have 30. With that many I'd guess foreign keys. Each fk constraint adds

[ADMIN] installing

2001-11-20 Thread Dan MacNeil
Please let me know if this is not the right place for this question or if there is a more appropriate place I'm looking to install .postgresql as debain packages via apt-get I'm running debain 2.2 (stable) The postgresql package for that distribution is 6.5.3-26 This seems way out of

Re: [ADMIN] Genetic algorithms

2001-11-20 Thread Bruce Momjian
dear all, I am looking for some information of how to use the query optimization facility using genetic algorithms in PostgreSQL. I tried to find some information on the internet, but I couldnt find any detailed information of how to use genetic algorithms in PostgreSQL. Has

Re: [ADMIN] Please help

2001-11-20 Thread Ferdinand Smit
Hi Mike, Can anyone help me write a trigger on a table, I have created an audit table for a table and what I want trigger to do is to whenever a record is deleted from the table it should first be inserted into the audit table, just to keep track of whatever records are deleted. Is this

[ADMIN] Time Zones and Brain Damage :)

2001-11-20 Thread Brian McCane
Howdy, At least 2 years ago, when I created my original PostgreSQL database, I set the postmaster to have a default time zone of 'CDT6CST5'. And it has happily given me all of my dates formatted like that ever since. Last night I setup a new database server and transferred one

[ADMIN] Numbers of entries in pg_trigger

2001-11-20 Thread Jeff Boes
Does anyone have a pointer to info on what kinds of things cause entries in pg_trigger? We're trying to understand why some tables have a half-dozen corresponding entries, and some have 30. -- Jeff Boes vox 616.226.9550 Database Engineer

Re: [ADMIN] Numbers of entries in pg_trigger

2001-11-20 Thread Tom Lane
Jeff Boes [EMAIL PROTECTED] writes: Does anyone have a pointer to info on what kinds of things cause entries in pg_trigger? We're trying to understand why some tables have a half-dozen corresponding entries, and some have 30. If you didn't make the triggers yourself, I think they must have

Re: [ADMIN] Postmaster will not start???

2001-11-20 Thread David Stanaway
On Monday, November 19, 2001, at 03:30 AM, Eric Theis wrote: I am running PostgreSQL 7.1.2/3 on Mandrake 8.1. My problem (well my immediate problem) is that the Postmaster will not start. I installed MDK a couple months ago. In that time, Postgres has started fine until a couple

Re: [ADMIN] database cluster

2001-11-20 Thread raja kumar thatte
you can rename that dir. i.e mvabcd abcdold Jodi Kanter [EMAIL PROTECTED] wrote: Let's try this again. Please respond to this message as it has mycorrect email addressI mistakenly created a second database cluster. Can someone tell me howto remove this?Also, I need to reinitialize my