Re: [HACKERS] But _where_ is the anoncvs server ?
fixed, permanently, or should be ... let me know .. I've also just changed the 'pull down' to be every hour at *:59 ... On Tue, 2 Oct 2001, Hannu Krosing wrote: Marko Kreen wrote: On Tue, Oct 02, 2001 at 09:49:03AM +0200, Hannu Krosing wrote: HI, I've seen lots of talk about anoncvs not working, but I can't even find out where it is ;( :pserver:[EMAIL PROTECTED]:/projects/cvsroot I got in now, but the general problems have now stuck me too: cvs server: failed to create lock directory for `/projects/cvsroot/pgsql/contrib/pgcrypto/expected' (/projects/cvsroot/pgsql/contrib/pgcrypto/expected/#cvs.lock): Permission denied cvs server: failed to obtain dir lock in repository `/projects/cvsroot/pgsql/contrib/pgcrypto/expected' cvs [server aborted]: read lock failed - giving up Probably all newly created directories become unsuitable for anoncvs, so just fixin perms does not hel - a more general solution is needed - perhaps some sticky bits on directories or configuration changes on cvs server Hannu ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] CVS changes
On Mon, 1 Oct 2001, Thomas Lockhart wrote: I would like to resolve the 12 hour lag for CVSup and anoncvs service, and frankly until that is resolved we should accept that we have a 12 hour turnaround on most changes. Coincidentally, that is the rate at which the docs are (or would be, if I could figure out where they should go) currently built. It should never have been 12hrs ... I had it set for 4 ... but, I have drop'd it down to hourly effective this morning ... Let's stop trying to each build a new wheel; we have plenty enough already. There are fundamental breakages in the current servers, and until those are resolve I'm not happy that we are changing web site info etc to suggest workarounds as permanent solutions. Agreed ... ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] CVS changes
On Mon, 1 Oct 2001, Vince Vielhaber wrote: On Tue, 2 Oct 2001, Thomas Lockhart wrote: ... Tom, what's missing or out of place? If I can I'll make sure it's there. This morning I noticed a number of things that I thought were there really weren't. What I was looking for was the place where development docs (built from daily snapshots) would go. They used to be underneath devel-corner in a doc(s ??) directory. devel-corner is now developer.postgresql.org These were the nitely builds, right? For a place to point, look to /docs in the developers tree. developers tree = /usr/local/www/developers ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] But _where_ is the anoncvs server ?
Marc, fix, please, permanently problem with permissions in anonymous CVS cvs server: Updating pgsql/contrib/pgcrypto/expected cvs server: failed to create lock directory for /projects/cvsroot/pgsql/contrib/pgcrypto/expected' (/projects/cvsroot/pgsql/contrib/pgcrypto/expected/#cvs.lock): Permission denied cvs server: failed to obtain dir lock in repository /projects/cvsroot/pgsql/contrib/pgcrypto/expected' cvs [server aborted]: read lock failed - giving up Oleg On Tue, 2 Oct 2001, Marc G. Fournier wrote: fixed, permanently, or should be ... let me know .. I've also just changed the 'pull down' to be every hour at *:59 ... On Tue, 2 Oct 2001, Hannu Krosing wrote: Marko Kreen wrote: On Tue, Oct 02, 2001 at 09:49:03AM +0200, Hannu Krosing wrote: HI, I've seen lots of talk about anoncvs not working, but I can't even find out where it is ;( :pserver:[EMAIL PROTECTED]:/projects/cvsroot I got in now, but the general problems have now stuck me too: cvs server: failed to create lock directory for `/projects/cvsroot/pgsql/contrib/pgcrypto/expected' (/projects/cvsroot/pgsql/contrib/pgcrypto/expected/#cvs.lock): Permission denied cvs server: failed to obtain dir lock in repository `/projects/cvsroot/pgsql/contrib/pgcrypto/expected' cvs [server aborted]: read lock failed - giving up Probably all newly created directories become unsuitable for anoncvs, so just fixin perms does not hel - a more general solution is needed - perhaps some sticky bits on directories or configuration changes on cvs server Hannu ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] But _where_ is the anoncvs server ?
should have auto-fixed itself about 10 minutes ago ... On Tue, 2 Oct 2001, Oleg Bartunov wrote: Marc, fix, please, permanently problem with permissions in anonymous CVS cvs server: Updating pgsql/contrib/pgcrypto/expected cvs server: failed to create lock directory for /projects/cvsroot/pgsql/contrib/pgcrypto/expected' (/projects/cvsroot/pgsql/contrib/pgcrypto/expected/#cvs.lock): Permission denied cvs server: failed to obtain dir lock in repository /projects/cvsroot/pgsql/contrib/pgcrypto/expected' cvs [server aborted]: read lock failed - giving up Oleg On Tue, 2 Oct 2001, Marc G. Fournier wrote: fixed, permanently, or should be ... let me know .. I've also just changed the 'pull down' to be every hour at *:59 ... On Tue, 2 Oct 2001, Hannu Krosing wrote: Marko Kreen wrote: On Tue, Oct 02, 2001 at 09:49:03AM +0200, Hannu Krosing wrote: HI, I've seen lots of talk about anoncvs not working, but I can't even find out where it is ;( :pserver:[EMAIL PROTECTED]:/projects/cvsroot I got in now, but the general problems have now stuck me too: cvs server: failed to create lock directory for `/projects/cvsroot/pgsql/contrib/pgcrypto/expected' (/projects/cvsroot/pgsql/contrib/pgcrypto/expected/#cvs.lock): Permission denied cvs server: failed to obtain dir lock in repository `/projects/cvsroot/pgsql/contrib/pgcrypto/expected' cvs [server aborted]: read lock failed - giving up Probably all newly created directories become unsuitable for anoncvs, so just fixin perms does not hel - a more general solution is needed - perhaps some sticky bits on directories or configuration changes on cvs server Hannu ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] But _where_ is the anoncvs server ?
Thanks, It works now On Tue, 2 Oct 2001, Marc G. Fournier wrote: should have auto-fixed itself about 10 minutes ago ... On Tue, 2 Oct 2001, Oleg Bartunov wrote: Marc, fix, please, permanently problem with permissions in anonymous CVS cvs server: Updating pgsql/contrib/pgcrypto/expected cvs server: failed to create lock directory for /projects/cvsroot/pgsql/contrib/pgcrypto/expected' (/projects/cvsroot/pgsql/contrib/pgcrypto/expected/#cvs.lock): Permission denied cvs server: failed to obtain dir lock in repository /projects/cvsroot/pgsql/contrib/pgcrypto/expected' cvs [server aborted]: read lock failed - giving up Oleg On Tue, 2 Oct 2001, Marc G. Fournier wrote: fixed, permanently, or should be ... let me know .. I've also just changed the 'pull down' to be every hour at *:59 ... On Tue, 2 Oct 2001, Hannu Krosing wrote: Marko Kreen wrote: On Tue, Oct 02, 2001 at 09:49:03AM +0200, Hannu Krosing wrote: HI, I've seen lots of talk about anoncvs not working, but I can't even find out where it is ;( :pserver:[EMAIL PROTECTED]:/projects/cvsroot I got in now, but the general problems have now stuck me too: cvs server: failed to create lock directory for `/projects/cvsroot/pgsql/contrib/pgcrypto/expected' (/projects/cvsroot/pgsql/contrib/pgcrypto/expected/#cvs.lock): Permission denied cvs server: failed to obtain dir lock in repository `/projects/cvsroot/pgsql/contrib/pgcrypto/expected' cvs [server aborted]: read lock failed - giving up Probably all newly created directories become unsuitable for anoncvs, so just fixin perms does not hel - a more general solution is needed - perhaps some sticky bits on directories or configuration changes on cvs server Hannu ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] CVS changes
Marc G. Fournier [EMAIL PROTECTED] writes: On Mon, 1 Oct 2001, Thomas Lockhart wrote: I would like to resolve the 12 hour lag for CVSup and anoncvs service, It should never have been 12hrs ... I had it set for 4 ... but, I have drop'd it down to hourly effective this morning ... That sounds like a good setting for anoncvs service. But I think Thomas (and any other committers who use cvsup) still need a cvsup server running on the master cvs machine. Even a 1-hour lag is too much when you are trying to commit changes. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] cvsweb
cvsweb is now working! It's available from the developer's site: http://developer.postgresql.org/ Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] cvsweb
Vince Vielhaber [EMAIL PROTECTED] writes: cvsweb is now working! It's available from the developer's site: http://developer.postgresql.org/ Thankyouthankyouthankyouthankyou ... I hadn't realized how much I'd come to depend on that service, until I didn't have it for awhile ... manual use of cvs log and cvs diff is a poor substitute. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Genetic Query Optimizer
James L. Hubbard III [EMAIL PROTECTED] writes: Who works on the genetic query optimizer (geqo)? AFAIK, no one has touched the genetic algorithm itself in years --- not since the original contributor, who has not been heard from in awhile. The only changes to that code have been to clean up its interfaces to the rest of the system (eg, make it use the new GUC mechanism to accept parameters). If you want to work on it, go right ahead! Does it need to be improved? Finding better plans in less time is always better. There aren't that many people using GEQO at the moment, I suspect, just because there aren't that many people doing umpteen-way joins. But I think it would be cool if it became a useful alternative to the standard exhaustive optimizer at a lower crossover point. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] cvsweb
.--[ Tom Lane wrote (2001/10/02 at 09:47:41) ]-- | | Vince Vielhaber [EMAIL PROTECTED] writes: | cvsweb is now working! It's available from the developer's site: |http://developer.postgresql.org/ | | Thankyouthankyouthankyouthankyou ... I hadn't realized how much I'd come | to depend on that service, until I didn't have it for awhile ... manual | use of cvs log and cvs diff is a poor substitute. | | regards, tom lane | `- Oops my original try at this only went to Tom ( sorry for the duplicate Tom ). It appears the cvs log functionality is working just fine, however you can't actually view the source of the file by clicking on the revision number. Clicking on: http://developer.postgresql.org/cvsweb.cgi/src/bin/psql/command.c?rev=1.58content-type=text/x-cvsweb-markup To view src/bin/psql/command.c gives me the following error: Error: Unexpected output from cvs co: cvs [checkout aborted]: /cvsroot/pgsql/CVSROOT: No such file or directory Check whether the directory /cvsroot/pgsql/CVSROOT exists and the script has write-access to the CVSROOT/history file if it exists. The script needs to place lock files in the directory the file is in as well. - Frank Wiles [EMAIL PROTECTED] http://frank.wiles.org - ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] cvsweb
On Tue, 2 Oct 2001, Frank Wiles wrote: It appears the cvs log functionality is working just fine, however you can't actually view the source of the file by clicking on the revision number. Clicking on: oops! fixed. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] cvsweb
Frank Wiles [EMAIL PROTECTED] writes: It appears the cvs log functionality is working just fine, however you can't actually view the source of the file by clicking on the revision number. Clicking on: http://developer.postgresql.org/cvsweb.cgi/src/bin/psql/command.c?rev=1.58content-type=text/x-cvsweb-markup Seems to work for me at the moment. Note that Vince appears to have just corrected the path: you need a /pgsql/ in there. Does http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/command.c?rev=1.58content-type=text/x-cvsweb-markup work for you? regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] CVS changes
will set that one up next ... On Tue, 2 Oct 2001, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: On Mon, 1 Oct 2001, Thomas Lockhart wrote: I would like to resolve the 12 hour lag for CVSup and anoncvs service, It should never have been 12hrs ... I had it set for 4 ... but, I have drop'd it down to hourly effective this morning ... That sounds like a good setting for anoncvs service. But I think Thomas (and any other committers who use cvsup) still need a cvsup server running on the master cvs machine. Even a 1-hour lag is too much when you are trying to commit changes. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ODBC] [HACKERS] UTF-8 support
-Original Message- From: Tatsuo Ishii [mailto:[EMAIL PROTECTED]] Sent: 24 September 2001 08:13 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [ODBC] [HACKERS] UTF-8 support Which ones belong to the backend and which ones to the frontend? Or even more: which ones belong to the backend, which ones to the frontend #1, which ones to the frontend #2, etc... For examle, I have two fronends: FE1: UNICODE, WIN1251 FE2: KOI8, UNICODE BE: UNICODE, LATIN1, ALT Which ones SELECT pg_available_encodings(); will show? The ones of the BE and the FE making the request? In case I need to communicate with BE using one common encoding between the two if it is available. I'm confused. What do you mean by BE? BE's encoding is determined by the database that FE chooses. If you just want to know what kind encodings are there in the database, why not use: SELECT DISTINCT ON (encoding) pg_encoding_to_char(encoding) AS encoding FROM pg_database; Also, FE's encoding could be any valid encoding that FE chooses, i.e. it' not BE's choice. Can you show me more concrete examples showing what you actually want to do? 3) Is there a way to query available encodings in PostgreSQL for display in pgAdmin. Could pgAdmin display multibyte chars in the first place ? Wao. If pgAdmin could not display multibyte chars, all discussions here are meaningless:- Apparently it can, I just don't know how to do it yet! From what Jean-Michel's said, it's just a case of kicking VB6 in the right part of the anatomy... Regards, Dave. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] cvsweb
On Tue, 2 Oct 2001, Tom Lane wrote: Frank Wiles [EMAIL PROTECTED] writes: It appears the cvs log functionality is working just fine, however you can't actually view the source of the file by clicking on the revision number. Clicking on: http://developer.postgresql.org/cvsweb.cgi/src/bin/psql/command.c?rev=1.58content-type=text/x-cvsweb-markup Seems to work for me at the moment. Note that Vince appears to have just corrected the path: you need a /pgsql/ in there. Does I just updated the line too so it goes straight to pgsql Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] What about CREATE OR REPLACE FUNCTION?
Did we come to any conclusion about whether to accept Gavin Sherry's CREATE OR REPLACE FUNCTION patch? http://fts.postgresql.org/db/mw/msg.html?mid=1035792 AFAIR, the score was that I liked it, Bruce didn't, and no one else had expressed an opinion. The patch itself needs a little bit of cleanup I think, but I'm willing to fix and apply it if there's a consensus that we want the feature. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] My last ECPG commit
Michael Meskes [EMAIL PROTECTED] writes: But now cvsup on my system stopped working because of that 10mil seconds bug but I failed to notice. Hey, I don't check the logfiles everytime. So when I made my last commit, I simply used these old files as a base and removed Tom's patch. I guess I better switch to cvs. :-) Or update to the fixed version of cvsup, anyway. Thomas Lockhart likes cvsup too, so you can be sure it will continue to be a workable means of working with our CVS tree. Making this long story short, Tom, I can understand if you feel angry about this (and I'm sure I would) and I will try my best to never let it happen again. Please take my apologies. Of course. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Problem on AIX with current
Tatsuo Ishii [EMAIL PROTECTED] writes: Strange enough, there's no other backend (of course except stats collectors) here. I make sure this with ps and pg_stat_activity view. If you have no better way of determining what's going on, it might help to recompile with LOCK_DEBUG defined, then enable trace_lwlocks in postgresql.conf (better turn on debug_print_query, log_timestamp, and log_pid too). This will generate rather voluminous log output, perhaps enough to provide a clue. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] pgAdmin users upgrading to PostgreSQL 7.2
Hi, It's come to my attention that users of pgAdmin (the original, not pgAdmin II) will not be able to dump/reload their 7.1.x databases into 7.2 without an additional step in the upgrade procedure. This is because pgAdmin creates a number of views on the server which include the oid column from tables such as pg_attribute - obviously attempting to reload these view will cause an error as there is no longer an oid column in pg_attribute in 7.2. pgAdmin II is unaffected by this problem. I will obviously try to assist anyone who suffers from this problem, but if the following text can be added to the INSTALL file and anywhere else that may be appropriate it might help ease the pain! {at the end of #2 under 'If you are upgrading) pgAdmin 7.x users will need to drop server side objects before dumping their database, otherwise the reload will fail. To do this, select 'Drop all pgAdmin Server Side Objects' from the 'Advanced' menu. pgAdmin does not support PostgreSQL 7.2, instead, please try pgAdmin II from http://pgadmin.postgresql.org/. Regards, Dave. -- Dave Page ([EMAIL PROTECTED]) pgAdmin Project Leader http://pgadmin.postgresql.org/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?
On Tue, 2 Oct 2001, Tom Lane wrote: Did we come to any conclusion about whether to accept Gavin Sherry's CREATE OR REPLACE FUNCTION patch? http://fts.postgresql.org/db/mw/msg.html?mid=1035792 AFAIR, the score was that I liked it, Bruce didn't, and no one else had expressed an opinion. Since you're asking for opinions, I think that something of the sort is needed. As for the naming, as long as we keep things that are similar to this reasonably consistantly named in the future (like if we decided to do a rule altering one, etc...) it should be fine. :) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Unicode combining characters
Bruce Momjian [EMAIL PROTECTED] writes: If no one can find a case where multibyte is slower, I think we should enable it by default. Comments? Well, he just did point out such a case: no MB with MB LIKE 0.09 msec 0.08 msec REGEX0.09 msec 0.10 msec But I agree with your conclusion. If the worst penalty we can find is that a regex comparison operator is 10% slower, we may as well turn it on by default. Most people will never notice the difference, and anyone who really cares can always turn it off again. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] do we're in time to catch 7.2 Beta ?
Bruce Momjian [EMAIL PROTECTED] writes: It is my understanding we can add things to /contrib even during beta, right? We are certainly more lax with beta than with the main backend tree. /contrib does get compiled so it does need to compile cleanly. The rules for contrib are laxer, for sure. We need maximum a week to finish, test, benchmark and document. I'd suggest that you concentrate on making some documentation now, so that you can send in a complete package before we go beta. Then worry about fixing bugs and benchmarking during beta ;-) regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] do we're in time to catch 7.2 Beta ?
Bruce Momjian [EMAIL PROTECTED] writes: It is my understanding we can add things to /contrib even during beta, right? We are certainly more lax with beta than with the main backend tree. /contrib does get compiled so it does need to compile cleanly. The rules for contrib are laxer, for sure. We need maximum a week to finish, test, benchmark and document. I'd suggest that you concentrate on making some documentation now, so that you can send in a complete package before we go beta. Then worry about fixing bugs and benchmarking during beta ;-) Ah, the old get it in and fix during beta. I love it. I have used the strategy many times, and was only caught a few. :-) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Unicode combining characters
Bruce Momjian [EMAIL PROTECTED] writes: If no one can find a case where multibyte is slower, I think we should enable it by default. Comments? Well, he just did point out such a case: no MB with MB LIKE 0.09 msec 0.08 msec REGEX 0.09 msec 0.10 msec But I agree with your conclusion. If the worst penalty we can find is that a regex comparison operator is 10% slower, we may as well turn it on by default. Most people will never notice the difference, and anyone who really cares can always turn it off again. But the strange thing is that LIKE is faster, perhaps meaning his measurements can't even see the difference, or is it because the LIKE optimization is off for multibyte. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] do we're in time to catch 7.2 Beta ?
Yup, not a crucial component of the base system ... once we start to get into the 'release candidate' mode, then it is kinda frowned upon, but early beta, no probs ... On Tue, 2 Oct 2001, Bruce Momjian wrote: It is my understanding we can add things to /contrib even during beta, right? We are certainly more lax with beta than with the main backend tree. /contrib does get compiled so it does need to compile cleanly. We're about to release brand new contrib module which is actually is a first step of integration of OpenFTS to postgres. Preliminary numbers are rather impressive - zen:~/app/pgsql/GiST/tsearch_index$ time psql-dev apod -c \ select title from titles where titleidx @@ 'gistpatch'; /dev/null real0m0.070s user0m0.010s sys 0m0.000s Table 'titles' contains 377905 titles from various mailing lists we accumulate in our mailware projects. apod=# select count(*) from titles; count 377905 (1 row) This contrib is based on our GiST development and will work only with 7.2. We need maximum a week to finish, test, benchmark and document. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Unicode combining characters
Bruce Momjian [EMAIL PROTECTED] writes: But the strange thing is that LIKE is faster, perhaps meaning his measurements can't even see the difference, Yeah, I suspect there's 10% or more noise in these numbers. But then one could read the results as saying we can't reliably measure any difference at all ... I'd feel more confident if the measurements were done using operators repeated enough times to yield multiple-second runtimes. I don't trust fractional-second time measurements on Unix boxen; too much chance of bogus results due to activity of other processes. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] When scripting, which is better?
Justin Clift writes: i.e. if [ -x $self_path/postmaster ] [ -x $self_path/psql ]; then or if [[ -x $self_path/postmaster -x $self_path/psql ]]; then I don't think the second one is a valid expression. ;-) Maybe you were wondering about [[ ]] vs [] -- In Autoconf [] are the quote characters so you have to double-quote, sort of. It's better to use 'test' in that case because m4 quoting can be tricky. I prefer test over [] in general because it is more consistent and slightly clearer. if [ x$foo = x ]; then Maximum safety for the case where $foo starts with a dash. Yes, that means all comparisons should really be done that way. No, I don't think we should do it in all cases if we know what $foo can contain, because that makes code *really* unreadable. or if [ $op = ]; then or if [ $foo ]; then These two are equivalent but the second one is arguably less clear. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] CVS changes
Bruce Momjian writes: I know you can manually run it on individual SGML files but I don't see a way to automate that. Do you? I don't because there isn't. For one, if a link points to some other file you lose. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Bulkloading using COPY - ignore duplicates?
Tom Lane writes: It occurs to me that skip-the-insert might be a useful option for INSERTs that detect a unique-key conflict, not only for COPY. (Cf. the regular discussions we see on whether to do INSERT first or UPDATE first when the key might already exist.) Maybe a SET variable that applies to all forms of insertion would be appropriate. What we need is: 1. Make errors not abort the transaction. 2. Error codes Then you can make your client deal with this in which ever way you want, at least for single-value inserts. However, it seems to me that COPY ignoring duplicates can easily be done by preprocessing the input file. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Unicode combining characters
Tatsuo Ishii writes: LIKE with MB seemed to be resonably fast, but REGEX with MB seemed a little bit slow. Probably this is due the wide character conversion overhead. Could this conversion be optimized to recognize when it's dealing with a single-byte character encoding? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] RFD: access to remore databases: altername suggestion
Hi! 0. I think access to other databases is really important. There was a discussion about that. Using a dot operator to specify a database (schema) seems to be very standard and elegant. But there is another way to implement it. Here is my suggestion. 1. First, some syntax: CREATE [ SHARED ] [ TRUSTED ] CONNECTION conn_name USING 'conn_string' [ CONNECT ON { LOGIN | USE } ] [ DISCONNECT ON { LOGOUT | COMMIT } ]; Description Creates a connection definition (Oracle: database link) to a remote database. SHARED Means only one instance of connection exists and is accessible to all qualified users. TRUSTED Only superusers can use this connection (like TRUSTED modifier in CREATE LANGUAGE). conn_name Just an identifier. 'conn_string' Connect string in standard form accepted by libpq 'PQconnectdb' function. CONNECT ON { LOGIN | USE } Defines whether connection should be established when user logs in, or when references remote object for the first time (default). DISCONNECT ON { LOGOUT | COMMIT } Defines whether connection should be closed when user logs out (default), or when transaction is ended (COMMIT, ROLLBACK, but also exiting). 2. Additional commands ALTER CONNECTION conn_name USING 'conn_string' [ CONNECT ON { LOGIN | USE } ] [ DISCONNECT ON { LOGOUT | COMMIT } ]; Description Changes behaviour of a defined connection (same parameters as for CREATE CONNECTION). DROP CONNECTION conn_name; Description Hmm... drop the connection definition? Also a new privilege CONNECT should be added, so GRANT CONNECT ON remote_database TO SCOTT; can be processed. 3. How to use this? SELECT local.id, remote.name FROM orders local, emp@remote_database remote WHERE local.emp_id = remote.id; SELECT give_a_raise_proc@rempte_database(1000); 4. Some notes (in random order) If a 'conn_string' does not contain a user/password information, connection is performed using current user identity. But, for SHARED connection always use a 'nobody' account (remeber to create 'nobody' user on remote database). For security reasons 'conn_string' must be stored in encrypted form. When CONNECT ON LOGIN is used, connection is etablished only if user has CONNECTprivilege granted on this. For TRUSTED connection also superuser rights must be checked. If first remote object is accessed within a transaction, a remote transaction should be started. When trancaction ends, remote transaction should also be ended same way (commit or rollback). SHARED connection should be established when first user logs in or uses remote object (depends on CONNECT ON clause) and terminated when last user ends transaction or disconnects (depens on DISCONNECT ON clause). Of course no remote transaction can be performed for SHARED connection. Of course it would require lot of work, but can be parted. The minimum IMHO can be a SHARED connection with CONNECT ON USE and DISCONNECT ON LOGOUT behaviour. 5. Conclusion I know it is much easier to 'invent' a new functionality than to implement it. I also realize this proposal is not complete nor coherent. Still want to listen/read your opinions about it. Regards, Mariusz Czulada P.S.: Is it planned to add 'auto_transaction' parameter on server or database levels, so events like login, commit or rolback automaticly start a new transaction without 'BEGIN WORK' (like Oracle does)? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] [GENERAL] Problem with the accents
Tatsuo Ishii wrote: You are definitely inputting ISO 8859-1 characters, not UTF-8. That's the source of your problem. Hello, In fact, we create and lodge Web sites and we use PostgreSQL/Apache/PHP. I parameterized the encoding in UNICODE thinking that it was most flexible. We are French, but we have also Brazilian customers. So you need to have an Unicode database but your client apps does not have the capability to input Unicode, right? Then the only solution would be upgrading to 7.1 and turning on --enable-unicode-conversion. 7.1 would do the conversion between ISO 8859 and Unicode on the server side. According to you, by using PostgreSQL 6.5.3 (the passage to version 7.1 is planned for the end of the year) can encoding MULE_INTERNAL solve the problem ? Yes. create a MULE_INTERNAL database and use set client_encoding to whatever... Thank you. PS: Sorry for my English: -) Me too:-) -- Tatsuo Ishii ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] HISTORY
Could you not include characters other than ASCII in the HISTORY file, please. Python fix fetchone() (Gerhard H$BgS(Bing) -- Tatsuo Ishii ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] timestamp and time now support precision
I've implemented timestamp and time precision per SQL99 spec. The syntax is TIMESTAMP(2) WITH TIME ZONE or TIME(0) etc etc. One result of this is that timestamp is no longer a valid external function name (among other things) due to parser ambiguity between TIMESTAMP(2) and, say, TIMESTAMP(date 'today') (the latter used to be supported). If you need to explicitly call a function by that name you need to surround the function name with double quotes, as in select timestamp(date 'today'); All regression tests pass, though we will probably need updates to the pre-1970 regression results. The CVS notes follow... - Thomas Implement precision support for timestamp and time, both with and without time zones. SQL99 spec requires a default of zero (round to seconds) which is set in gram.y as typmod is set in the parse tree. We *could* change to a default of either 6 (for internal compatibility with previous versions) or 2 (for external compatibility with previous versions). Evaluate entries in pg_proc wrt the iscachable attribute for timestamp and other date/time types. Try to recognize cases where side effects like the current time zone setting may have an effect on results to decide whether something is cachable or not. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] Missing inserts
For some reason, I seam to feel as if the inserts that should be executed by a rule are not all getting executed, or at least, they are not getting writen. How can I find out what the rule is really doing? The logs don't say much. Any help will be grear at this moment of stress!!! X- Saludos... :-) -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? - Martín Marqués |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Missing inserts
In 7.1.X and earlier the INSERT rules are executed _before_ the INSERT. This is changed to _after_ in 7.2. For some reason, I seam to feel as if the inserts that should be executed by a rule are not all getting executed, or at least, they are not getting writen. How can I find out what the rule is really doing? The logs don't say much. Any help will be grear at this moment of stress!!! X- Saludos... :-) -- Porqu? usar una base de datos relacional cualquiera, si pod?s usar PostgreSQL? - Mart?n Marqu?s |[EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral - ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] RFD: access to remore databases: altername suggestion
You are attacking here two things: a) schemas, which should be done in 7.3, thus multiple databases on same host would be unnecessary. b) connections to remote host' databases, which is partially implemented already (in a ugly way, but...) see contrib/dblink What you described is a syntactic sugar to implement b) which isn't a bad idea, but just consider, it is already done. sorta. On Wed, 3 Oct 2001 [EMAIL PROTECTED] wrote: Hi! 0. I think access to other databases is really important. There was a discussion about that. Using a dot operator to specify a database (schema) seems to be very standard and elegant. But there is another way to implement it. Here is my suggestion. 1. First, some syntax: CREATE [ SHARED ] [ TRUSTED ] CONNECTION conn_name USING 'conn_string' [ CONNECT ON { LOGIN | USE } ] [ DISCONNECT ON { LOGOUT | COMMIT } ]; Description Creates a connection definition (Oracle: database link) to a remote database. SHARED Means only one instance of connection exists and is accessible to all qualified users. TRUSTED Only superusers can use this connection (like TRUSTED modifier in CREATE LANGUAGE). conn_name Just an identifier. 'conn_string' Connect string in standard form accepted by libpq 'PQconnectdb' function. CONNECT ON { LOGIN | USE } Defines whether connection should be established when user logs in, or when references remote object for the first time (default). DISCONNECT ON { LOGOUT | COMMIT } Defines whether connection should be closed when user logs out (default), or when transaction is ended (COMMIT, ROLLBACK, but also exiting). 2. Additional commands ALTER CONNECTION conn_name USING 'conn_string' [ CONNECT ON { LOGIN | USE } ] [ DISCONNECT ON { LOGOUT | COMMIT } ]; Description Changes behaviour of a defined connection (same parameters as for CREATE CONNECTION). DROP CONNECTION conn_name; Description Hmm... drop the connection definition? Also a new privilege CONNECT should be added, so GRANT CONNECT ON remote_database TO SCOTT; can be processed. 3. How to use this? SELECT local.id, remote.name FROM orders local, emp@remote_database remote WHERE local.emp_id = remote.id; SELECT give_a_raise_proc@rempte_database(1000); 4. Some notes (in random order) If a 'conn_string' does not contain a user/password information, connection is performed using current user identity. But, for SHARED connection always use a 'nobody' account (remeber to create 'nobody' user on remote database). For security reasons 'conn_string' must be stored in encrypted form. When CONNECT ON LOGIN is used, connection is etablished only if user has CONNECTprivilege granted on this. For TRUSTED connection also superuser rights must be checked. If first remote object is accessed within a transaction, a remote transaction should be started. When trancaction ends, remote transaction should also be ended same way (commit or rollback). SHARED connection should be established when first user logs in or uses remote object (depends on CONNECT ON clause) and terminated when last user ends transaction or disconnects (depens on DISCONNECT ON clause). Of course no remote transaction can be performed for SHARED connection. Of course it would require lot of work, but can be parted. The minimum IMHO can be a SHARED connection with CONNECT ON USE and DISCONNECT ON LOGOUT behaviour. 5. Conclusion I know it is much easier to 'invent' a new functionality than to implement it. I also realize this proposal is not complete nor coherent. Still want to listen/read your opinions about it. Regards, Mariusz Czulada P.S.: Is it planned to add 'auto_transaction' parameter on server or database levels, so events like login, commit or rolback automaticly start a new transaction without 'BEGIN WORK' (like Oracle does)? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Unicode combining characters
Yeah, I suspect there's 10% or more noise in these numbers. But then one could read the results as saying we can't reliably measure any difference at all ... I'd feel more confident if the measurements were done using operators repeated enough times to yield multiple-second runtimes. I don't trust fractional-second time measurements on Unix boxen; too much chance of bogus results due to activity of other processes. Any idea to do that? I tried to do a measurements using something like SELECT * FROM t1 WHERE very-long-string-column LIKE 'aaa', but I'm afraid the I/O time masks the difference... -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Unicode combining characters
LIKE with MB seemed to be resonably fast, but REGEX with MB seemed a little bit slow. Probably this is due the wide character conversion overhead. Could this conversion be optimized to recognize when it's dealing with a single-byte character encoding? Not sure, will look into... -- Tatsuo Ishii ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] CVS changes
will set that one up next ... Great! Thanks... - Thomas That sounds like a good setting for anoncvs service. But I think Thomas (and any other committers who use cvsup) still need a cvsup server running on the master cvs machine. Even a 1-hour lag is too much when you are trying to commit changes. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] My last ECPG commit
... Yes, that's apossibility. But then the actual Debian package has not been updated. And why messing with two mechanisms? It may be that the static tarballs for RedHat will work for you (they work for me on Mandrake). I use CVSup to keep a local copy of the cvs repository on my laptop, so I have a *full* development environment when I'm traveling or otherwise off line. I'd have a very hard time working without it... - Thomas ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Unicode combining characters
Tatsuo Ishii [EMAIL PROTECTED] writes: I'd feel more confident if the measurements were done using operators repeated enough times to yield multiple-second runtimes. Any idea to do that? Maybe something like this: declare a plpgsql function that takes two text parameters and has a body like for (i = 0 to a million) boolvar := $1 like $2; Then call it with strings of different lengths and see how the runtime varies. You need to apply the LIKE to function parameters, else the system will probably collapse the LIKE operation to a constant... regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] btree_gist regression test busted?
In current CVS I see a failure in the btree_gist regression test. It kinda looks like the test data was changed without updating the expected results, but would you verify this? regards, tom lane *** ./expected/btree_gist.out Wed Aug 22 14:27:54 2001 --- ./results/btree_gist.outTue Oct 2 18:48:34 2001 *** *** 17,23 select count(*) from tstmp where t '2001-05-29 08:33:09+04'; count --- ! 7 (1 row) -- create idx --- 17,23 select count(*) from tstmp where t '2001-05-29 08:33:09+04'; count --- ! 66 (1 row) -- create idx *** *** 34,39 select count(*) from tstmp where t '2001-05-29 08:33:09+04'; count --- ! 7 (1 row) --- 34,39 select count(*) from tstmp where t '2001-05-29 08:33:09+04'; count --- ! 66 (1 row) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Bulkloading using COPY - ignore duplicates?
I have used Oracle SQLOADER for many years now. It has the ability to put rejects/discards/bad into an output file and keep on going, maybe this should be added to the copy command. COPY [ BINARY ] table [ WITH OIDS ] FROM { 'filename' | stdin } [ [USING] DELIMITERS 'delimiter' ] [ WITH NULL AS 'null string' ] [ DISCARDS 'filename' ] what do you think??? Tom Lane writes: It occurs to me that skip-the-insert might be a useful option for INSERTs that detect a unique-key conflict, not only for COPY. (Cf. the regular discussions we see on whether to do INSERT first or UPDATE first when the key might already exist.) Maybe a SET variable that applies to all forms of insertion would be appropriate. What we need is: 1. Make errors not abort the transaction. 2. Error codes Then you can make your client deal with this in which ever way you want, at least for single-value inserts. However, it seems to me that COPY ignoring duplicates can easily be done by preprocessing the input file. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)- -- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] cvs problem
On Mon, 1 Oct 2001, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: The one thing I can't check is the anoncvs directory. Not sure if that is the same as the CVS directory. It is the anoncvs server that's broken. The committers don't seem to be having any problem with accesses to the primary server. I suspect that there's a umask or group-membership issue on the anoncvs machine only. It seems you don't have to be new here to be a bit peeved about things;-( I'm peeved because I found instructions on how to checkout with anonymous CVS and did so a few times. I had a find old time finding and reporting problems (with the software). Then CVS stopped working because someone thought it a fine idea to reorganise the directory structure, to change the CVSROOT. No matter the user who had the old one stored on their computers. I've report it twice, pointing out that what I did before worked, and that I was doing coincided with what the web pages said. There was discussion that the web pages were wrong and who's job it was to fix. As an invited guest, I reckon it's the CVS repository that is wrong. It's wrong because it's different from what worked before. Time to get your act together fellas. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] CVS changes
On Sun, 30 Sep 2001, Bruce Momjian wrote: On Sun, 30 Sep 2001, Bruce Momjian wrote: just about to be moved to the new server, now that the new 18gi drive has been installed ... plan on getting that done this afternoon ... Don't rush. I am setting up my system to check the SGML docs every 15 minutes and rebuild if necessary. Overnight builds are not frequent Would it not be better to provide a means for developers to cause the rebuild on demand? A 15-minute wait doesn't seem convenient to me. Yep, but it takes 15 minutes to build anyway, so I figured I would check very 15 minutes and adding another 15, that makes 1/2 hour. We don't have a mechanism to build only a few html files. You have to do the whole thing. Suggestions? I don't know enough about how it works (or doesn't), but the delay looks worse. Add the delay for missing the bus and you're out to a 45-minute delay. The need for on-demand is even greater, even something done crudely: If a build's in process, flag the need. When the build completes, check if it has to be done again. I assume that updates aren't so frequent that you'd be constantly rebuilding, or so infrequently a missed rebuild would cause serious problems. Perhaps a way to check if a rebuild's in process so that if it's slower than usual a developer can see it's not forgotten (or who else is doing one). ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?
Tom Lane wrote: Did we come to any conclusion about whether to accept Gavin Sherry's CREATE OR REPLACE FUNCTION patch? http://fts.postgresql.org/db/mw/msg.html?mid=1035792 AFAIR, the score was that I liked it, Bruce didn't, and no one else had expressed an opinion. The patch itself needs a little bit of cleanup I think, but I'm willing to fix and apply it if there's a consensus that we want the feature. If it enables us to for example change a trigger function without redefining the trigger itself then surely it is needed. Hannu ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] My last ECPG commit
On Tue, Oct 02, 2001 at 10:33:55AM -0400, Tom Lane wrote: Or update to the fixed version of cvsup, anyway. Thomas Lockhart likes cvsup too, so you can be sure it will continue to be a workable means of working with our CVS tree. Yes, that's apossibility. But then the actual Debian package has not been updated. And why messing with two mechanisms? Michael -- Michael Meskes [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] cvs problem
On Monday 01 October 2001 07:33 pm, John Summerfield wrote: It seems you don't have to be new here to be a bit peeved about things;-( [snip] Time to get your act together fellas. This is open source John, not rocket science. (pun intended) Lighten up. The release will happen, regardless of minor server issues (that are being worked out right now, even as I write, by highly capable professionals, who, BTW, are doing this on a volunteer basis). -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] My last ECPG commit
Christof just told me that I overwrote Tom's patch fixing the setlocale problem in ecpg. I did not notice that and for some strange reason did not get Tom's mail either. Anyway, the CVS problem was that I use cvsup to keep an up-to-date source tree. I have set up my system so that it updates everytime I go on-line. I also automatically update my pgsql-ecpg checkout. This has a long history as I started using cvsup before I even was a developer and never felt the need to change that. When I change some stuff I usually do this in the complete source tree as I need it to even compile ecpg. Then I copy over the files I changed to the cvs checkout and commit them. This works well since it does not matter if the checkout is done via cvs or cvsup. But now cvsup on my system stopped working because of that 10mil seconds bug but I failed to notice. Hey, I don't check the logfiles everytime. So when I made my last commit, I simply used these old files as a base and removed Tom's patch. I guess I better switch to cvs. :-) Making this long story short, Tom, I can understand if you feel angry about this (and I'm sure I would) and I will try my best to never let it happen again. Please take my apologies. Michael -- Michael Meskes [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Unicode combining characters
Also, have we decided if multibyte should be the configure default now? Not sure. Anyway I have tested LIKE/REGEX query test using current. The query executed is: explain analyze select '000 5089 474e...( 16475 bytes long text containing only 0-9a-z chars) like 'aaa'; and explain analyze select '000 5089 474e...( 16475 bytes long text containing only 0-9a-z chars) ~ 'aaa'; Here is the result: no MB with MB LIKE0.09 msec 0.08 msec REGEX 0.09 msec 0.10 msec LIKE with MB seemed to be resonably fast, but REGEX with MB seemed a little bit slow. Probably this is due the wide character conversion overhead. -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] But _where_ is the anoncvs server ?
HI, I've seen lots of talk about anoncvs not working, but I can't even find out where it is ;( The old address gives [hannu@taru pgsql]$ ../update.cvs cvs update: authorization failed: server postgresql.org rejected access to /home/projects/pgsql/cvsroot for user anoncvs the link from developer .postgresql.org points to http://www.ca.postgresql.org/cgi/cvsweb.cgi/pgsql which gives Not Found The requested URL /cgi/cvsweb.cgi/pgsql was not found on this server. Apache/1.3.14 Server at www.ca.postgresql.org Port 80 When I do as instructed in http://developer.postgresql.org/TODO/docs/cvs.html I get: [hannu@taru cvs_new]$ cvs -d :pserver:[EMAIL PROTECTED]:/home/projects/pgsql/cvsroot login (Logging in to [EMAIL PROTECTED]) CVS password: cvs login: authorization failed: server postgresql.org rejected access to /home/projects/pgsql/cvsroot for user anoncvs What should I do ? --- Hannu ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] But _where_ is the anoncvs server ?
On Tue, Oct 02, 2001 at 09:49:03AM +0200, Hannu Krosing wrote: HI, I've seen lots of talk about anoncvs not working, but I can't even find out where it is ;( :pserver:[EMAIL PROTECTED]/projects/cvsroot -- marko ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] But _where_ is the anoncvs server ?
Marko Kreen wrote: On Tue, Oct 02, 2001 at 09:49:03AM +0200, Hannu Krosing wrote: HI, I've seen lots of talk about anoncvs not working, but I can't even find out where it is ;( :pserver:[EMAIL PROTECTED]:/projects/cvsroot I got in now, but the general problems have now stuck me too: cvs server: failed to create lock directory for `/projects/cvsroot/pgsql/contrib/pgcrypto/expected' (/projects/cvsroot/pgsql/contrib/pgcrypto/expected/#cvs.lock): Permission denied cvs server: failed to obtain dir lock in repository `/projects/cvsroot/pgsql/contrib/pgcrypto/expected' cvs [server aborted]: read lock failed - giving up Probably all newly created directories become unsuitable for anoncvs, so just fixin perms does not hel - a more general solution is needed - perhaps some sticky bits on directories or configuration changes on cvs server Hannu ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] When scripting, which is better?
Sorry guys, I didn't realise I actually sent this, it was part of an email I was putting together to achieve consistency in the scripts, but I thought I cancelled it when it got late in the morning. My apologies. Regards and best wishes, Justin Clift Bruce Momjian wrote: Hi all, Reading through the script files again, there seems to be several different methods of doing the same thing : i.e. if [ -x $self_path/postmaster ] [ -x $self_path/psql ]; then The above semicolon is useless. Actually, I have never see this. The normal way is: if [ -x $self_path/postmaster -a -x $self_path/psql ] or if [[ -x $self_path/postmaster -x $self_path/psql ]]; then I usually do: if [ ... ] then Pretty simple. if [ x$foo = x ]; then or if [ $op = ]; then This is done if you think $op may have a leading dash. or if [ $foo ]; then This tests whether $foo is not equal to . -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] CVS changes
On Mon, 1 Oct 2001, Bruce Momjian wrote: Until the dust settles the only two people with write access to either the developer or regular website will be Marc and myself. I have enough to do trying to get mirroring straight, keep up with changes to the sites, etc. that I really don't need anyone messing around. So Bruce, your request is going to be denied. All my links are broken until it is fixed. Here are the links I need, except it is /home/momjian now: lrwxrwxrwx 1 momjian pgsql 54 May 22 2000 aw_pgsql_book - /home/projects /pgsql/developers/momjian/aw_pgsql_book/ lrwxrwxrwx 1 momjian pgsql 48 May 22 2000 booktips - /home/projects/pgsq l/developers/momjian/booktips lrwxrwxr-x 1 momjian pgsql 54 Jun 18 14:38 hw_performance - /home/project s/pgsql/developers/momjian/hw_performance lrwxrwxr-x 1 momjian pgsql 56 Jun 18 14:55 internalpics.pdf - /home/proje cts/pgsql/developers/momjian/internalpics.pdf lrwxrwxr-x 1 momjian pgsql 52 Jun 18 14:38 writing_apps - /home/projects/ pgsql/developers/momjian/writing_apps Move these into a subdir under momjian and I'll point to that. Is the internalpics.pdf different than the one on the developers site? Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] cvs tip problems
On Mon, 1 Oct 2001, Bruce Momjian wrote: I would propose that the reference machine be one that one of the committers owns, and be one whose owner is willing to *always* go through the effort to resolve regression test changes and differences. Er ... wasn't that *you*? Yes. At the moment my toes are bright red and sore from being stepped on, and I'm trying to get out of the way or figure out what the problems are. I'm happy to continue to contribute things like this, but don't like being held up then bypassed then ignored (cf current docs building troubles). I'm frustrated. I think we are all just scrambing to get beta ready while the server reconfigures itself. :-) I don't see any fundamental changes being proposed. We are trying to plug leaks and are stepping on toes, or at least it looks that way sometimes. :-) I can yank my CVS build if it causes confusion once we get the main one working. the reason what we have not gone beta as of yet, and will not for a little whlie yet, is the disruption caused by re-merging all of the functionality on the new server ... docs have never been a hold up for beta in the past, not sure why you consider them to be now, but they definitely shouldn't be something that is 'rushed to go beta' ... tangents to bandaid a problem that needs to be fixed, like the docs build, just detract from everything else that has to get done, I think ... ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] do we're in time to catch 7.2 Beta ?
We're about to release brand new contrib module which is actually is a first step of integration of OpenFTS to postgres. Preliminary numbers are rather impressive - zen:~/app/pgsql/GiST/tsearch_index$ time psql-dev apod -c \ select title from titles where titleidx @@ 'gistpatch'; /dev/null real0m0.070s user0m0.010s sys 0m0.000s Table 'titles' contains 377905 titles from various mailing lists we accumulate in our mailware projects. apod=# select count(*) from titles; count 377905 (1 row) This contrib is based on our GiST development and will work only with 7.2. We need maximum a week to finish, test, benchmark and document. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] CVS changes
On Mon, 1 Oct 2001, Bruce Momjian wrote: Until the dust settles the only two people with write access to either the developer or regular website will be Marc and myself. I have enough to do trying to get mirroring straight, keep up with changes to the sites, etc. that I really don't need anyone messing around. So Bruce, your request is going to be denied. All my links are broken until it is fixed. Here are the links I need, except it is /home/momjian now: lrwxrwxrwx 1 momjian pgsql 54 May 22 2000 aw_pgsql_book - /home/projects /pgsql/developers/momjian/aw_pgsql_book/ lrwxrwxrwx 1 momjian pgsql 48 May 22 2000 booktips - /home/projects/pgsq l/developers/momjian/booktips lrwxrwxr-x 1 momjian pgsql 54 Jun 18 14:38 hw_performance - /home/project s/pgsql/developers/momjian/hw_performance lrwxrwxr-x 1 momjian pgsql 56 Jun 18 14:55 internalpics.pdf - /home/proje cts/pgsql/developers/momjian/internalpics.pdf lrwxrwxr-x 1 momjian pgsql 52 Jun 18 14:38 writing_apps - /home/projects/ pgsql/developers/momjian/writing_apps Move these into a subdir under momjian and I'll point to that. Is the internalpics.pdf different than the one on the developers site? OK, new directory is /home/momjian/docs and links need to be created in /usr/local/www/www/html/docs. internalpics.pdf is the same as the one you have on the developers site but it should be a link to the copy in my home directory so I can update it regularly. I know it is kind of strange to have a symlink for the same file from the main web site and the developers site to my home directory but the old URL for that is still used in other places so I need both. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] cvs problem
On Mon, 1 Oct 2001, Bruce Momjian wrote: Marc, it worked, but now I'm again getting: cvs server: failed to create lock directory for /projects/cvsroot/pgsql/contrib/pgcrypto/expected' (/projects/cvsroot/pgsql/contrib/pgcrypto/expected/#cvs.lock): Permission denied cvs server: failed to obtain dir lock in repository /projects/cvsroot/pgsql/contrib/pgcrypto/expected' cvs [server aborted]: read lock failed - giving up Seems, again wrong permissions Those are directories I just created. They have the same permission as all the other files here. Maybe there is a problem with CVS server creating stuff with the wrong permission. Did you change versions of cvs (the software)? I had a little fiddle with it some time ago, and there was a change whereby the newer version didn't do what I wanted. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] CVS changes
OK, new directory is /home/momjian/docs and links need to be created in /usr/local/www/www/html/docs. internalpics.pdf is the same as the one you have on the developers site but it should be a link to the copy in my home directory so I can update it regularly. I know it is kind of strange to have a symlink for the same file from the main web site and the developers site to my home directory but the old URL for that is still used in other places so I need both. All done. Let me know if anything's missing. Beautiful. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] cvs problem
On Tue, 2 Oct 2001, John Summerfield wrote: On Mon, 1 Oct 2001, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: The one thing I can't check is the anoncvs directory. Not sure if that is the same as the CVS directory. It is the anoncvs server that's broken. The committers don't seem to be having any problem with accesses to the primary server. I suspect that there's a umask or group-membership issue on the anoncvs machine only. It seems you don't have to be new here to be a bit peeved about things;-( I'm peeved because I found instructions on how to checkout with anonymous CVS and did so a few times. I had a find old time finding and reporting problems (with the software). Then CVS stopped working because someone thought it a fine idea to reorganise the directory structure, to change the CVSROOT. No matter the user who had the old one stored on their computers. Gee, I didn't realize we were doing it just cuze someone thought it a fine idea I've report it twice, pointing out that what I did before worked, and that I was doing coincided with what the web pages said. There was discussion that the web pages were wrong and who's job it was to fix. As an invited guest, I reckon it's the CVS repository that is wrong. It's wrong because it's different from what worked before. I just looked in cvs and it looks fine there. Time to get your act together fellas. Gee, I didn't realize we were screwing off. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] CVS changes
On Tue, 2 Oct 2001, Bruce Momjian wrote: On Mon, 1 Oct 2001, Bruce Momjian wrote: Until the dust settles the only two people with write access to either the developer or regular website will be Marc and myself. I have enough to do trying to get mirroring straight, keep up with changes to the sites, etc. that I really don't need anyone messing around. So Bruce, your request is going to be denied. All my links are broken until it is fixed. Here are the links I need, except it is /home/momjian now: lrwxrwxrwx 1 momjian pgsql 54 May 22 2000 aw_pgsql_book - /home/projects /pgsql/developers/momjian/aw_pgsql_book/ lrwxrwxrwx 1 momjian pgsql 48 May 22 2000 booktips - /home/projects/pgsq l/developers/momjian/booktips lrwxrwxr-x 1 momjian pgsql 54 Jun 18 14:38 hw_performance - /home/project s/pgsql/developers/momjian/hw_performance lrwxrwxr-x 1 momjian pgsql 56 Jun 18 14:55 internalpics.pdf - /home/proje cts/pgsql/developers/momjian/internalpics.pdf lrwxrwxr-x 1 momjian pgsql 52 Jun 18 14:38 writing_apps - /home/projects/ pgsql/developers/momjian/writing_apps Move these into a subdir under momjian and I'll point to that. Is the internalpics.pdf different than the one on the developers site? OK, new directory is /home/momjian/docs and links need to be created in /usr/local/www/www/html/docs. internalpics.pdf is the same as the one you have on the developers site but it should be a link to the copy in my home directory so I can update it regularly. I know it is kind of strange to have a symlink for the same file from the main web site and the developers site to my home directory but the old URL for that is still used in other places so I need both. All done. Let me know if anything's missing. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] CVS changes
On Sun, 30 Sep 2001, Bruce Momjian wrote: On Sun, 30 Sep 2001, Bruce Momjian wrote: just about to be moved to the new server, now that the new 18gi drive has been installed ... plan on getting that done this afternoon ... Don't rush. I am setting up my system to check the SGML docs every 15 minutes and rebuild if necessary. Overnight builds are not frequent Would it not be better to provide a means for developers to cause the rebuild on demand? A 15-minute wait doesn't seem convenient to me. Yep, but it takes 15 minutes to build anyway, so I figured I would check very 15 minutes and adding another 15, that makes 1/2 hour. We don't have a mechanism to build only a few html files. You have to do the whole thing. Suggestions? I don't know enough about how it works (or doesn't), but the delay looks worse. Add the delay for missing the bus and you're out to a 45-minute delay. True. The need for on-demand is even greater, even something done crudely: If a build's in process, flag the need. Added. I realized that I could have two running at the same time, which would be a disaster. When the build completes, check if it has to be done again. Great idea! Added. I assume that updates aren't so frequent that you'd be constantly rebuilding, or so infrequently a missed rebuild would cause serious problems. Yep. Perhaps a way to check if a rebuild's in process so that if it's slower than usual a developer can see it's not forgotten (or who else is doing one). Script attached. I could poll cvs more frequently but it seems rude to hit the cvs server more frequently than every 15 minutes. If people want it polled more frequently, and Marc doesn't mind, I can change the polling interval here. Also, I added something that will show the files modified in the current build. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 : trap rm -f /tmp/$$ /tmp/$$a /tmp/pgsql_sgml 0 1 2 3 15 [ -f /tmp/pgsql_sgml ] exit touch /tmp/pgsql_sgml cd /u/src/gen/pgsql/sgml/pgsql/doc/src while pgcvs update . 21 | grep -v '^?' /tmp/$$a do echo Build: `date` build.dates cat /tmp/$$a build.dates echo PostgreSQL CVS Documentation Build /tmp/$$ echo ==\n /tmp/$$ echo Build started:`date`\n /tmp/$$ gmake 21 | grep -v DTDDECL /tmp/$$ echo Build completed: `date`\n /tmp/$$ echo Changes in this build: cat /tmp/$$a /tmp/$$ echo \nErrors appear in red.\n /tmp/$$ pipe sed 's;HTML.manifest:;HTML.manifest :;g' /tmp/$$ txt2html -m -s 100 -p 100 --title PostgreSQL CVS Docs built `date` \ --link /u/txt2html/txt2html.dict \ --append_head /u/txt2html/BODY /tmp/$$ build.html pipe sed 's;^.*error.*$;FONT COLOR=RED/FONT;' build.html pipe sed 's;^.*Error.*$;FONT COLOR=RED/FONT;' build.html pipe sed 's;^.*:E:.*$;FONT COLOR=RED/FONT;' build.html rm -f /var/www/docs/main/writings/pgsql/sgml/* mv sgml/*.html build.html /var/www/docs/main/writings/pgsql/sgml cp sgml/*.css /var/www/docs/main/writings/pgsql/sgml done ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] do we're in time to catch 7.2 Beta ?
It is my understanding we can add things to /contrib even during beta, right? We are certainly more lax with beta than with the main backend tree. /contrib does get compiled so it does need to compile cleanly. We're about to release brand new contrib module which is actually is a first step of integration of OpenFTS to postgres. Preliminary numbers are rather impressive - zen:~/app/pgsql/GiST/tsearch_index$ time psql-dev apod -c \ select title from titles where titleidx @@ 'gistpatch'; /dev/null real0m0.070s user0m0.010s sys 0m0.000s Table 'titles' contains 377905 titles from various mailing lists we accumulate in our mailware projects. apod=# select count(*) from titles; count 377905 (1 row) This contrib is based on our GiST development and will work only with 7.2. We need maximum a week to finish, test, benchmark and document. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] What about CREATE OR REPLACE FUNCTION?
Did we come to any conclusion about whether to accept Gavin Sherry's CREATE OR REPLACE FUNCTION patch? http://fts.postgresql.org/db/mw/msg.html?mid=1035792 AFAIR, the score was that I liked it, Bruce didn't, and no one else had expressed an opinion. I withdraw my objection. When I read it, I thought we were going to have CREATE FUNCTION and REPLACE FUNCTION. I later realized it is literally CREATE OR REPLACE FUNCTION. Looks strange, but there is no standard way to do this and we usually take the Oracle syntax when the standard doesn't specify it. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Unicode combining characters
If no one can find a case where multibyte is slower, I think we should enable it by default. Comments? Also, have we decided if multibyte should be the configure default now? Not sure. Anyway I have tested LIKE/REGEX query test using current. The query executed is: explain analyze select '000 5089 474e...( 16475 bytes long text containing only 0-9a-z chars) like 'aaa'; and explain analyze select '000 5089 474e...( 16475 bytes long text containing only 0-9a-z chars) ~ 'aaa'; Here is the result: no MB with MB LIKE 0.09 msec 0.08 msec REGEX 0.09 msec 0.10 msec LIKE with MB seemed to be resonably fast, but REGEX with MB seemed a little bit slow. Probably this is due the wide character conversion overhead. -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] CVS changes
U ... I thought we weren't going to do this, but were going to fix the proper build process? On Tue, 2 Oct 2001, Bruce Momjian wrote: On Sun, 30 Sep 2001, Bruce Momjian wrote: On Sun, 30 Sep 2001, Bruce Momjian wrote: just about to be moved to the new server, now that the new 18gi drive has been installed ... plan on getting that done this afternoon ... Don't rush. I am setting up my system to check the SGML docs every 15 minutes and rebuild if necessary. Overnight builds are not frequent Would it not be better to provide a means for developers to cause the rebuild on demand? A 15-minute wait doesn't seem convenient to me. Yep, but it takes 15 minutes to build anyway, so I figured I would check very 15 minutes and adding another 15, that makes 1/2 hour. We don't have a mechanism to build only a few html files. You have to do the whole thing. Suggestions? I don't know enough about how it works (or doesn't), but the delay looks worse. Add the delay for missing the bus and you're out to a 45-minute delay. True. The need for on-demand is even greater, even something done crudely: If a build's in process, flag the need. Added. I realized that I could have two running at the same time, which would be a disaster. When the build completes, check if it has to be done again. Great idea! Added. I assume that updates aren't so frequent that you'd be constantly rebuilding, or so infrequently a missed rebuild would cause serious problems. Yep. Perhaps a way to check if a rebuild's in process so that if it's slower than usual a developer can see it's not forgotten (or who else is doing one). Script attached. I could poll cvs more frequently but it seems rude to hit the cvs server more frequently than every 15 minutes. If people want it polled more frequently, and Marc doesn't mind, I can change the polling interval here. Also, I added something that will show the files modified in the current build. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] CVS changes
U ... I thought we weren't going to do this, but were going to fix the proper build process? Well, until it works I can fiddle with it here. What will the future build interval be? Are people OK with that? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Preparation for Beta
On Tuesday 02 October 2001 08:32 am, Marc G. Fournier wrote: ftp.postgresql.org:/var/spool/ftp/pub/binary (216.126.85.28) So far so good. Login successful, group membership correct. I'll let you know if I stumble across a roadblock. Oh, and BTW: having done server splits and moves in the past myself, you and Vince have my gratitude and, well, sympathy, over this, as a dynamic website and ftpsite move by itself is never trivial. And there are many more details here than a typical site move -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] Elephant, Horse and Hare (Rabbit) : Oracle, PostgreSQL and MySQL !
Just a HUMOR, no offense and take it easy!! = If someone ask's you how do you compare the features and capability of these three popular SQL servers: Oracle, PostgreSQL and MySQL ?? Then comes the answer in layman's terms: "A Elephant, Powerful White Horse, Fast Hare (Rabbit). Please tell me which animal you want ??" Oracle = Elephant, Big and hefty but very bulky PostgreSQL = Powerful White Horse, top breed horse (I love riding horses) MySQL = Fast running Rabbit (Hare), I like rabbits as pets, very decent animals!! Oracle, PostgreSQL are in development for the last 22 years. Both had originations in University of California, Berkeley. Both are very mature, ACID compliant (Atomicity, Concurrency,.) and are robust. MySQL is like rabbit, it runs fast and can be a good pet. But see, the speed is NOT at all important when it comes to SQL server - it is the ACID compliance, Data Integrity and robustness and features and language interfaces which are important. You must not compare Elephant with Hare (Oracle with MySQL) But the best among these three animals is - White Powerful Horse!! (PostgreSQL !!) Why do you think every person is waiting in a long queue to get a ride on "White Powerful Horse" (PostgreSQL) ??? Every person on the planet wants to ride on PostgreSQL !! ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] [JDBC] LOCK TABLE oddness in PLpgSQL function called via JDBC
Dave Harkness wrote: At 01:45 PM 10/2/2001, Barry Lind wrote: Dave, Secondly, you don't need a table lock, you just need to lock the row between the select and the update. You should use 'select for update' to do this. That way when you issue the select to get the current value, it will lock the row, preventing other select for update requests from completing until the lock is released. That way the select and the update can be assured that no one else is changing the data. THANK YOU! That's what I thought, but the documentation was a bit light on the subject of SELECT ... FOR UPDATE. So to mirror it back to you, if I do next_id_block ( count ) (1) read idfactory row FOR UPDATE (2) update idfactory row increment next_id by count increment change_num by 1 where change_num is equal to that read in (1) (3) return next_id read in (1) As far as I see, this is a stored function issue not a Java issue. I got the exact code of the function from Dave. create function next_id_block ( varchar , integer ) returns bigint as ' DECLARE -- Parameters name_key alias for $1 ; block_sizealias for $2 ; -- Locals id_recrecord ; num_rows integer ; BEGIN -- To avoid a retry-loop, lock the whole table for the transaction lock table idfactory in exclusive mode ; -- Read the current value of next_id select into id_rec * from idfactory where name = name_key ; -- Increment it by block_size update idfactory set next_id = next_id + block_size, change_num = change_num + 1 where name = name_key and change_num = id_rec.change_num ; -- If the update failed, raise an exception get diagnostics num_rows = ROW_COUNT ; if num_rows != 1 then raise exception ''Update failed'' ; return -1 ; end if ; return id_rec.next_id ; END ; ' language 'plpgsql' ; The cause is that the stored function uses a common snapshot throughout the function execution. As I've complained many times, the current implementaion is far from intuition and this case seems to show that it isn't proper at all either. *lock table* certainly locks idfactory table but the subsequenct *select* sees the table using the snapshot taken before the function call. The *update* statement find the row matching the where clause using the common snapshot but will find the row was already updated and the updated row doesn't satisfy the condition any longer. [In case when we remove the *lock* statement and add a *for update* clause to the subsequent *select* statement] The *select .. for update* statement gets the latest (may be updated) change_num value. Unfortunately the subsequent *update* statement has a where clause containing change_num. The *update* statemnet can't find the row matching the where clause using the snapshot taken before the function call. regards, Hiroshi Inoue ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster