Re: [GENERAL] I want to search my project source code

2007-10-27 Thread Guy Rouillier
Matthew Wilson wrote: I have a lot of code -- millions of lines at this point, written over the last 5 years. Everything is in a bunch of nested folders. At least once a week, I want to find some code that uses a few modules, so I have to launch a find + grep at the top of the tree and then wai

[GENERAL] Postgres+Apache+PHP (again, but in different setup)

2007-10-27 Thread Wojtek Mach
Hi all, I've read everything in this subject you guys has discussed already (including topic started by Max Zorloff) but I haven't found my answer yet. I'm looking for hints on best configuration for my specific needs: I'm having complied program written in C, which reads lots of data from c

Re: [GENERAL] Fragments in tsearch2 headline

2007-10-27 Thread Oleg Bartunov
On Sat, 27 Oct 2007, Tom Lane wrote: "Catalin Marinas" <[EMAIL PROTECTED]> writes: Is there an easy way to generate a headline from separate fragments containing the search words and maybe separated by "..."? Hmm, the documentation for ts_headline claims it does this already: ts_headline

Re: [GENERAL] Fragments in tsearch2 headline

2007-10-27 Thread Tom Lane
"Catalin Marinas" <[EMAIL PROTECTED]> writes: > Is there an easy way to generate a headline from separate fragments > containing the search words and maybe separated by "..."? Hmm, the documentation for ts_headline claims it does this already: ts_headline accepts a document along with a q

Re: [GENERAL] How can I easily and effectively support (language) translation of column values?

2007-10-27 Thread Karsten Hilbert
On Sun, Oct 28, 2007 at 01:59:22AM +0200, Dennis Brakhane wrote: > I have some problems supporting "translatable columns" in a way that > is both efficient and comfortable for the programmer who has to write > SQL-Queries (we use iBatis) Maybe this helps a bit: http://salaam.homeunix.com

[GENERAL] How can I easily and effectively support (language) translation of column values?

2007-10-27 Thread Dennis Brakhane
Hi, I have some problems supporting "translatable columns" in a way that is both efficient and comfortable for the programmer who has to write SQL-Queries (we use iBatis) Suppose I have a simple table that contains an id field and (amongst others) a name field. Let's call this table foo. The name

Re: [GENERAL] select count() out of memory

2007-10-27 Thread Adrian Klaver
On Friday 26 October 2007 8:56 am, [EMAIL PROTECTED] wrote: > > Serious engineering does not imply perfect engineering, I have analyzed it > and made my tradeoffs. What you are forgetting here is that you clearly > dont understand the enire solution, So I will try to explain it again. And > if you

Re: [GENERAL] Version 8.3

2007-10-27 Thread Alexander Staubo
On 10/27/07, Bob Pawley <[EMAIL PROTECTED]> wrote: > I would like to try PostgreSQL 8.3 without uninstalling version 8.1. > > Is this possible?? Sure. If you're on Unix, download the source and install it somewhere in, say, your home directory. This requires a certain familiarity with the shell, h

Re: [GENERAL] Version 8.3

2007-10-27 Thread Raymond O'Donnell
On 27/10/2007 22:05, Bob Pawley wrote: I would like to try PostgreSQL 8.3 without uninstalling version 8.1. Is this possible?? Hi Bob, Yes, it is - it's usually a matter of putting the two versions to listen on two different ports. I haven't done it myself, but this crops up from time to ti

[GENERAL] Version 8.3

2007-10-27 Thread Bob Pawley
I would like to try PostgreSQL 8.3 without uninstalling version 8.1. Is this possible?? Bob Pawley ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] createdb argument question

2007-10-27 Thread Seneca Cunningham
On Sat, Oct 27, 2007 at 12:56:37PM -0500, Perry Smith wrote: > On my Mac systems, this work. On my AIX system it does not. I get: > > createdb dog -E utf8 > createdb: too many command-line arguments (first is "utf8") > Try "createdb --help" for more information. > > Has anyone else bumped in to

Re: [GENERAL] createdb argument question

2007-10-27 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > On Oct 27, 2007, at 12:56 , Perry Smith wrote: >> On my Mac systems, this work. On my AIX system it does not. I get: > Versions? I think the old shell-script version of createdb, in 7.3 and before, might have taken that ordering of arguments ...

Re: [GENERAL] createdb argument question

2007-10-27 Thread Perry Smith
On Oct 27, 2007, at 1:41 PM, Michael Glaesemann wrote: On Oct 27, 2007, at 12:56 , Perry Smith wrote: On my Mac systems, this work. On my AIX system it does not. I get: Versions? My AIX is 5.3 close to the latest. Postgres is 8.2.4 I built all of the open source stuff myself using g

Re: [GENERAL] createdb argument question

2007-10-27 Thread Michael Glaesemann
On Oct 27, 2007, at 12:56 , Perry Smith wrote: On my Mac systems, this work. On my AIX system it does not. I get: Versions? Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ign

[GENERAL] Stored Procs Vs User Defined Functions vis-a-vis UDF's in Postgresql

2007-10-27 Thread Harpreet Dhaliwal
Hi, lately I have been looking at difference between a Stored Proc and User Defined Functions in other RDBMS like Sql Server / Oracle. However, in postgresql, I think Stored Procs are wrapped around in User Defined functions, if I am not wrong. The following is the list of main differences b/w a St

[GENERAL] createdb argument question

2007-10-27 Thread Perry Smith
For some odd reason, Rails decided to call createdb as: createdb foo_database -E utf8 On my Mac systems, this work. On my AIX system it does not. I get: createdb dog -E utf8 createdb: too many command-line arguments (first is "utf8") Try "createdb --help" for more information. Has anyone els

Re: [GENERAL] Selecting tree data

2007-10-27 Thread Shane Ambler
Pat Maddox wrote: On 10/26/07, brian <[EMAIL PROTECTED]> wrote: Pat Maddox wrote: On 10/26/07, brian <[EMAIL PROTECTED]> wrote: SELECT * FROM posts ORDER BY root_id, id; brian ---(end of broadcast)--- TIP 4: Have you searched our list archiv

Re: [GENERAL] I want to search my project source code

2007-10-27 Thread Oleg Bartunov
openfts.sf.net is tool for you. It has even example scripts for indexing/searching file system. Oleg On Sat, 27 Oct 2007, Matthew Wilson wrote: I have a lot of code -- millions of lines at this point, written over the last 5 years. Everything is in a bunch of nested folders. At least once a

Re: [GENERAL] I want to search my project source code

2007-10-27 Thread Tom Lane
Matthew Wilson <[EMAIL PROTECTED]> writes: > At least once a week, I want to find some code that uses a few modules, > so I have to launch a find + grep at the top of the tree and then wait > for it to finish. Personally I use glimpse for this. It's a bit old and creaky but it performs wonders.

Re: [GENERAL] WAL archiving idle database

2007-10-27 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > We *could* force it to perform a log switch whether or not new WAL has > been written. That would be a truly awful idea. I think the right answer for Kevin's situation really is to be doing a dummy transaction every few minutes as one component of his sys

Re: [GENERAL] Postgres+Apache+PHP (again, but in different setup)

2007-10-27 Thread andy
Wojtek Mach wrote: Hi all, I've read everything in this subject you guys has discussed already (including topic started by Max Zorloff) but I haven't found my answer yet. I'm looking for hints on best configuration for my specific needs: I'm having complied program written in C, which reads

[GENERAL] I want to search my project source code

2007-10-27 Thread Matthew Wilson
I have a lot of code -- millions of lines at this point, written over the last 5 years. Everything is in a bunch of nested folders. At least once a week, I want to find some code that uses a few modules, so I have to launch a find + grep at the top of the tree and then wait for it to finish. I w

Re: [GENERAL] INDEX and JOINs

2007-10-27 Thread Andreas Kretschmer
Reg Me Please <[EMAIL PROTECTED]> schrieb: > Il Saturday 27 October 2007 08:51:09 Andreas Kretschmer ha scritto: > > Reg Me Please <[EMAIL PROTECTED]> schrieb: > > > How can I "Increasing the statistics target for the larger table"? > > > I'ìm sorry for asking, but I'm not that deep into RDBMS. >

Re: [GENERAL] WAL archiving idle database

2007-10-27 Thread Simon Riggs
On Fri, 2007-10-26 at 14:39 -0700, Jeff Davis wrote: > On Fri, 2007-10-26 at 15:08 -0600, Brian Wipf wrote: > > I have a test PG 8.2.5 installation that has been left idle with no > > connections to it whatsoever for the last 24 hours plus. WALs are > > being archived exactly 5 minutes apart, e

[GENERAL] Postgres+Apache+PHP (again, but in different setup)

2007-10-27 Thread Wojtek Mach
Hi all, I've read everything in this subject you guys has discussed already (including topic started by Max Zorloff) but I haven't found my answer yet. I'm looking for hints on best configuration for my specific needs: I'm having complied program written in C, which reads lots of data from c

Re: [GENERAL] INDEX and JOINs

2007-10-27 Thread Reg Me Please
Il Saturday 27 October 2007 08:51:09 Andreas Kretschmer ha scritto: > Reg Me Please <[EMAIL PROTECTED]> schrieb: > > How can I "Increasing the statistics target for the larger table"? > > I'ìm sorry for asking, but I'm not that deep into RDBMS. > > alter table alter column SET STATISTICS ; > > An