Re: [HACKERS] New Contrib Build?

2005-05-12 Thread David Walker
./configure --with-perl --with-dblink --with-newsysviews This would make installing and upgrading BSD ports easier. David ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's

Re: [HACKERS] Can we get patents?

2005-05-10 Thread David Walker
That depends; is the SFLC offering to pay for the patent applications? Last I checked, it was somewhere around $6000 per patent. Nolo press (www.nolo.com) sells a book on patents. Many people file their own patent applications successfully. The cost is less that $1000. David

Re: [HACKERS] Call for porting reports

2004-12-20 Thread David Walker
was installed make check failed the first time with a cannot set locale error. I installed 8.0.0rc1, make check was successful == All 96 tests passed. == Thanks for a great database, David Walker ---(end of broadcast

Re: [MLIST] Re: [HACKERS] location of the configuration files

2003-02-14 Thread David Walker
In reference to determining what port postgres or any program is listening on On my Redhat Linux machines netstat --inet -nlp when run as root produces a nice list of all programs listening on the network with IP and port number the process is listening on, the name of the process and the pid.

[HACKERS] Bad download link

2002-12-28 Thread David Walker
Trying to download 7.3.1 today I found a bad link on http://www.us.postgresql.org/sitess.html The ftp link goes to 7.3 and the http link returns a 404 not found. I did successfully download 7.3.1 via the HTTP access to the main repository link. ---(end of

Re: [MLIST] Re: [mail] Re: [HACKERS] Big 7.4 items - Replication

2002-12-15 Thread David Walker
Another concern I have with multi-master systems is what happens if the network splits in 2 so that 2 master systems are taking commits for 2 separate sets of clients. It seems to me that to re-sync the 2 databases upon the network healing would be a very complex task or impossible task. On

Re: [HACKERS] Boolean casting in 7.3 - changed?

2002-11-27 Thread David Walker
Does this mean that in the future '342' may not be valid as an insert into a numeric field and that we should be using 342 instead? On Wednesday 27 November 2002 05:07 pm, (Via wrote: Ian Barwick writes: Casting integers to boolean (for example, 0::bool) is no longer allowed, use '0'::bool

Re: [HACKERS] Turning the PLANNER off

2002-10-29 Thread David Walker
Does PREPARE turn select * from mytable into select mytable.field1,mytable.field2 from mynamespace.mytable ? I was looking for this functionality for one of my projects so I'm curious. On Monday 28 October 2002 06:55 pm, (Via wrote: That is a good question. The planner does more than just

Re: [HACKERS] Vacuum improvement

2002-10-16 Thread David Walker
Vacuum full locks the whole table currently. I was thinking if you used a similar to a hard drive defragment that only 2 rows would need to be locked at a time. When you're done vacuum/defragmenting you shorten the file to discard the dead tuples that are located after your useful data.

Re: [HACKERS] Virus Emails

2002-07-28 Thread David Walker
That may be true with some variants. However my mail server has rejected the relay of several mails sent pretending to be from me (envelope sender) to other parties and I think these could be klez variants or another such virus. Since my server rejected them I cannot be sure of the contents.

Re: [HACKERS] Suggestions please: names for function cachability attributes

2002-04-02 Thread David Walker
My 2 cents. Level 1. with (isCachableStatic) Level 2. with (isCachableDynamic) Level 3. default In my mind (isCachable) sounds like level 1 On Tuesday 02 April 2002 03:40 pm, Tom Lane wrote: Since I'm about to have to edit pg_proc.h to add a namespace column, I thought this would be a good

Re: [HACKERS] How to give permission to others on data directory

2002-03-31 Thread David Walker
Create a separate user and both of you use sudo to start the database. If you're insistent on keeping yourself owner of the data then use sudo to give permission to your project partner to start the database. On Sunday 31 March 2002 05:49 am, Amit Khare wrote: Hi Peter, Thank you very much for