Re: [HACKERS] Do we want a CVS branch now?

to be really needed? Stuff still feels a bit too chaotic. Regards and best wishes, Justin Clift regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] pg_config : postgresql.conf adjustments?

and best wishes, Justin Clift Joe -- 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

[HACKERS] How to REINDEX in high volume environments?

to work without having this side affect? Pre-creating a bunch of dangling symlinks doesn't work (tried that, it gives a ERROR: cannot create accounts_pkey: File exists on FreeBSD 4.6.2 when using the REINDEX). Any suggestions? :-) Regards and best wishes, Justin Clift -- My grandfather once told

Re: [HACKERS] How to REINDEX in high volume environments?

value would be, maybe the PGDATA directory, maybe something as a GUC variable, etc, but that's the concept. :-) Regards and best wishes, Justin Clift May be transaction logs, indexes goes in separte directory which can be symlinked. Linking a directory is much simpler solution than linking

Re: [HACKERS] How to REINDEX in high volume environments?

and best wishes, Justin Clift Putting indexes into a separate subdirectoy and mount/link that directory on a device that is on a separate SCSI channel is what I can think of as last drop of performance out of it.. Just a thought, as usual.. I don't know how much efforts it would take

Re: [HACKERS] v7.3 Branched ...

, but am hoping that maybe 7.4 would be able to include it. :-) Regards and best wishes, Justin Clift So, for those doing commits or anoncvs, remember that the 'stable' branch requires you to use: -rREL7_3_STABLE while the development branch is 'as per normal' ... -- My

Re: [HACKERS] 7.2.3?

. :-) Which other fixes would be included? Regards and best wishes, Justin Clift Are we too close to 7.3 for this to be worthwhile? Certainly there will be people distributing 7.2.X for some time as 7.3 stabilizes. -- Bruce Momjian| http://candle.pha.pa.us

Re: [HACKERS] 7.2.3?

, then for it to do the conversion process of the old data format to the new one before going any further? Sounds like a pain to create initially, but nifty in the end. :-) Regards and best wishes, Justin Clift snip -- Alvaro Herrera (alvherre[a]atentus.com) La fuerza no está en los medios

Re: [HACKERS] v7.3 Branched ...

don't have to go hunting all over GBorg to find the bits that they'd want. :-) Regards and best wishes, Justin Clift -- 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

[HACKERS] pg_config : postgresql.conf adjustments?

, but the concept sounds useful. :-) Regards and best wishes, Justin Clift -- 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

Re: [HACKERS] [GENERAL] Performance while loading data and indexing

. Have a bunch of Ultra160 hardware for the Intel platform, and am testing against it as time permits. Not as high end as I'd like, but it's a start. :-) Regards and best wishes, Justin Clift snip Bye Shridhar -- My grandfather once told me that there are two kinds of people: those who work

Re: [HACKERS] [GENERAL] Performance while loading data and indexing

. :-) Regards and best wishes, Justin Clift -- 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

Re: [HACKERS] [GENERAL] Performance while loading data and indexing

Shridhar Daithankar wrote: On 26 Sep 2002 at 19:05, Martijn van Oosterhout wrote: snip fsync IIRC only affects the WAL buffers now but it may be quite expensive, especially considering it's running on every transaction commit. Oh, your WAL files are on a seperate disk from the data?

Re: [HACKERS] [GENERAL] Performance while loading data and indexing

the PostgreSQL Performance mailing list to this thread too, Just In Case. (wow that's a lot of cross posting now). Regards and best wishes, Justin Clift Bye Shridhar -- Cropp's Law:The amount of work done varies inversly with the time spent in the office

Re: [HACKERS] [GENERAL] New PostgreSQL Tool available :pg_autotune

, and using a large tolerance factor by default. It would be good to improving on that. :-) Regards and best wishes, Justin Clift -- Tatsuo Ishii -- 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

Re: [HACKERS] PGXLOG variable worthwhile?

has migrated away from a PGXLOG environment variable to discuss PGXLOG in general (good or bad) and also has implementation points too (about which people have been arguing). Regards and best wishes, Justin Clift -- Nigel J. Andrews ---(end of broadcast

[HACKERS] New PostgreSQL Tool available : pg_autotune

It was created on a FreeBSD system, but should also work on at least Linux, Solaris, and MacOS X. This is a time load intensive tool, so you'll need to ensure you only run it when you have a couple of hours to wait for the results. Overnight is good. :) Regards and best wishes, Justin Clift -- My

Re: [HACKERS] [GENERAL] New PostgreSQL Tool available : pg_autotune

Tom Lane wrote: Justin Clift [EMAIL PROTECTED] writes: Have been putting together a tool called pg_autotune for automatically tuning a PostgreSQL database (either local or remote). It does this by repetitively benchmarking PostgreSQL (using Tatsuo's pgbench code) with different buffer

[HACKERS] Where to post a new PostgreSQL utility?

works (albeit time consuming). Where do I post it (here or PATCHES?) because if the code is rugged enough then it might be useful in contrib? :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit

[HACKERS] Would you be able to update the MySQL manual?

based on the ANSI AS3AP database testing standard. The main site for the Open Source Database Benchmark is: http://osdb.sf.net :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me

Re: [HACKERS] Having no luck with getting pgbench to run multipletimes

. Am just fine tuning this util, and it's looking to be pretty nifty. It automatically tunes local or remote PostgreSQL databases (currently it's limited to the shared_buffers, sort_mem, and vacuum_mem variables). But it's a start. :) Regards and best wishes, Justin Clift Greg Copeland wrote

[HACKERS] Having no luck with getting pgbench to run multiple times

a few minutes to look at my code and point out the problem? :-) Regards and best wishes, Justin Clift -- 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

Re: [HACKERS] PGXLOG variable worthwhile?

and best wishes, Justin Clift -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html -- My

Re: [HACKERS] PGXLOG variable worthwhile?

at the filesystem for info about where to put the xlog files. Regards and best wishes, Justin Clift Mike Mascari [EMAIL PROTECTED] -- 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

[HACKERS] Looking for more big name places that use PostgreSQL

it publicly. Please don't let this stop you from letting us know privately, as we are interested in the implementation details and will respect your confidentiality. So, if you're using PostgreSQL and haven't directly let us know, please do so now if you can. :-) Regards and best wishes, Justin

[HACKERS] An opportunity to prove PostgreSQL and our requirement of Case Study info

forward to help them out with info about the reliability and performance of PostgreSQL in Mission Critical situations? :-) Regards and best wishes, Justin Clift -- 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

[HACKERS] PGXLOG variable worthwhile?

it might be useful. :-) Regards and best wishes, Justin Clift -- 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

Re: [HACKERS] Wanted: pgdiff ($$$)

Hi all, Just a link to this from the front page of the techdocs.postgresql.org site. Hope it helps. :-) Regards and best wishes, Justin Clift Greg Stark wrote: [EMAIL PROTECTED] (ad wolf) writes: We're offering a small reward for a PG hacker that can code up a mysqldiff-like

Re: Release of v7.2.2 (Was: Re: [HACKERS] @(#)Mordred Labs ad...)

that will need to be applied to the 7.2.x branch. :-) Regards and best wishes, Justin Clift Oleg Bartunov wrote: Tom, I think it's worth to include patch for query planner which fixes using indices with predicates for join plans. We found it's quite useful. http://fts.postgresql.org/db/mw

[HACKERS] [Fwd: Re: Multiple vulnerabilities in PostgreSQL]

Hi guys, Sir Mordred seems okay, and is happy to help us out as long as we give him credit where it's due. Can't see where that would be a problem with anyone here, as it's totally in line with how we work, so am going to say yes to him up front. :-) Regards and best wishes, Justin Clift

Re: [HACKERS] Multiple vulnerabilities in PostgreSQL

community are the decent up-front kind of folk, and we welcome your assistance and expertise in helping us find the vulnerabilities in PostgreSQL. So, yep, it's all cool with us. :-) Regards and best wishes, Justin Clift Sir Mordred The Traitor wrote: Hi Justin. Something that is concerning us

Re: [HACKERS] @(#)Mordred Labs advisory 0x0003: Buffer overflow in

incompatibility in regards to functions/opaque, should we open some discussion on 7.3 really being 8.0? Depending on how far back we push this, we might be able to get Windows Native support added. That'd be cool and probably contribute to an 8.0. :) Regards and best wishes, Justin Clift Robert

Re: [HACKERS] @(#)Mordred Labs advisory 0x0003: Buffer overflow in

been running preliminary multi-user AS3AP tests on it (with OSDB) and getting a significant performance throughput increase in comparison to the cygwin version. :) Hope I'm not pushing too strongly for this, as, after all, I can't do the coding needed here. :( Regards and best wishes, Justin

Re: [HACKERS] @(#)Mordred Labs advisory 0x0003: Buffer overflow in

Bruce Momjian wrote: Justin Clift wrote: Only two things which have the potential to be worth waiting for, from what I'm aware of. There may be others: - Find out from Sir Mordred if he wants to take a look at the CVS version of code and audit in that for a bit, Just In Case he

[HACKERS] Multiple vulnerabilities in PostgreSQL

amount of time in advance so we can create the necessary patches/fixes, etc? :-) Regards and best wishes, Justin Clift -- 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

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

Hi Vince, Glad he made the advisory for something there's a fix for. :) Regards and best wishes, Justin Clift Vince Vielhaber wrote: Surprised it took this long. Vince. -- == Vince Vielhaber -- KA8CSHemail

Re: [HACKERS] [SECURITY] DoS attack on backend possible

Hi Florian, You guys *definitely* write scarey code. :-( Regards and best wishes, Justin Clift Florian Weimer wrote: Alvar Freude [EMAIL PROTECTED] writes: What about checking the input for backslash, quote, and double quote (\')? If you are not taking care of those in input

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

Vince, Do you reckon it's worth you responding to Sir Mordred and pointing out that he overstated the vulnerability? :-) Regards and best wishes, Justin Clift Tom Lane wrote: Justin Clift [EMAIL PROTECTED] writes: Glad he made the advisory for something there's a fix

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

Christopher Kings-Lynne wrote: On Tue, 20 Aug 2002, Justin Clift wrote: Vince, Do you reckon it's worth you responding to Sir Mordred and pointing out that he overstated the vulnerability? Not me. Tom (pref) or Marc would be the proper respondent. Has it actually been

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

that these kinds of DOS bugs exists. Mentally, it's not a good thing. Not trying to be a pain here, but instead trying to keep our QA level up. :) Regards and best wishes, Justin Clift Cheers Mark -- My grandfather once told me that there are two kinds of people: those who work and those

[HACKERS] About to update the PostgreSQL Functions in the official PHP Manual

? :-) Regards and best wishes, Justin Clift Original Message Subject: [GENERAL] About to update the PostgreSQL-Functions in the PHP Manual Date: Sun, 18 Aug 2002 13:32:21 +0200 From: Cornelia Boenigk [EMAIL PROTECTED] Hi everyone, I am in the process of updating some parts

[HACKERS] Finally, a list of *big* companies using PostgreSQL for *serious* projects. Why use PostgreSQL? Here's why.

-record-plus business information database. I'm pretty sure everyone will appreciate the significance of these companies showing their support. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take

Re: [HACKERS] [SECURITY] DoS attack on backend possible (was: Re:

characters and formatting hacks) on the date given, then use the date as part of a SQL query, and PostgreSQL will die? ? Regards and best wishes, Justin Clift Florian Weimer wrote: Justin Clift [EMAIL PROTECTED] writes: Is it possible to crash a 7.2.1 backend without having an entry

Re: [HACKERS] [SECURITY] DoS attack on backend possible (was: Re:

, Justin Clift Florian Weimer wrote: Justin Clift [EMAIL PROTECTED] writes: - A PostgreSQL 7.2.1 server can be crashed if it gets passed certain date values which would be accepted by standard front end parsing? So, a web application layer can request a date from a user, do standard

Re: [HACKERS] [SECURITY] DoS attack on backend possible (was: Re:

, Justin Clift Chris -- 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

[HACKERS] Interesting message about printf()'s in PostgreSQL

and of PostgreSQL needing an audit. Any idea if the things mentioned in this are true? :-) Regards and best wishes, Justin Clift -- 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

Re: [HACKERS] [SECURITY] DoS attack on backend possible (was: Re:

Hi Florian, Is it possible to crash a 7.2.1 backend without having an entry in the pg_hba.conf file? i.e. Is every PostgreSQL 7.2.1 installation around vulnerable to a remote DoS (or worse) from any user anywhere, at this moment in time? Regards and best wishes, Justin Clift Florian Weimer

Re: [HACKERS] TPC-* Benchmarks

), and if you have suggestions regarding the publishing of benchmarks, this is probably the place they will be implemented. Hope this helps. :-) Regards and best wishes, Justin Clift Paul Ramsey wrote: Have any organizations run TPC benchmarks against PostgreSQL other than the old and much maligned

Re: [HACKERS] Postgres idea list

of flamewars. Or maybe that's just my own perception not anyone else's. There is already a pgsql-advocacy list (as was pointed out recently), but it's unused. Borrow a leaf from the OpenOffice.org project, how about a pgsql-marketing list? :-) Regards and best wishes, Justin Clift

Re: [HACKERS] Nextgres?

Hi everyone, This is Jonah's explanation of what Nextgres is, as his response didn't make it to the list (some kind of software or network problem). :-) Regards and best wishes, Justin Clift Original Message Subject: Re: [HACKERS] Nextgres? Date: Wed, 26 Jun 2002 12:18:57

Re: [HACKERS] pgAdmin2 to be included in Dev-C++

PostgreSQL could be included in the Database Foundry on the Sourceforge site. :) http://www.sf.net/projects/pgsql And then I started a new contract and haven't had time to do anything with it (oh well). Regards and best wishes, Justin Clift snip Rome ne s'est pas faite en une nuit. Cheers, Jean

Re: [HACKERS] Native Windows, Apache Portable Runtime

of splitting it off easy, etc), but we'll never know if we don't say hello. (Hey, that rhymes!) :-) Regards and best wishes, Justin Clift It looks like the APR is pretty analogous to SysV with a few changes, so it should not be too hard to code it into PostgrsSQL

Re: [HACKERS] HEADS UP: Win32/OS2/BeOS native ports

. :-) Regards and best wishes, Justin Clift Marc G. Fournier wrote: On Fri, 3 May 2002, mlw wrote: Marc G. Fournier wrote: Morning all ... Just a heads up that over the next little while, I'm planning on making a bunch of commits in order to work on making the code

Re: [HACKERS] new food for the contrib/ directory

Hi Bruce, Haven't looked at the code, but there's no license with it. Andreas, are you cool with having the same License as PostgreSQL for it (BSD license)? :-) Regards and best wishes, Justin Clift Bruce Momjian wrote: Can someone comment on this? I can't decide

Re: [HACKERS] Index Scans become Seq Scans after VACUUM ANALYSE

Thomas Lockhart wrote: snip If that were exposed, then folks could have additional control over the optimizer no matter what syntax they prefer to use. And in fact could alter the behavior without having to completely rewrite their query. One could also think about a threshold mechanism

Re: [HACKERS] Places to update when a new version is out

Hi Chris, I don't have time at the moment to start making the needed document. :( Does anyone want to throw together the basics of it and put it somewhere useful? :-) Regards and best wishes, Justin Clift Christopher Kings-Lynne wrote: I remember someone mentioning on the list that we

[HACKERS] A New Release list of places to contact about new releases of PostgreSQL

for PostgreSQL. It's still got version 6.5.3 as being the one to download. Perhaps we should make a list of which places have downloads like this, and at release time a couple of people each take care of a few and confirm the changes? Sound feasible? :-) Regards and best wishes, Justin Clift

[HACKERS] [Fwd: AW: More UB-Tree patent information]

Hi everyone, This is Prof. Bayer's response to the question is it alright to use UB-Tree's in Open Source projects?. It's a No, but we can discuss a licensing model type answer. Regards and best wishes, Justin Clift Original Message Subject: AW: More UB-Tree patent

Re: [HACKERS] [Fwd: AW: More UB-Tree patent information]

Hannu Krosing wrote: On Wed, 2002-04-10 at 16:32, Justin Clift wrote: Hi everyone, This is Prof. Bayer's response to the question is it alright to use UB-Tree's in Open Source projects?. Have you found out _what_ exaclty is patented ? Is it just his concrete implementation of UB

[HACKERS] [Fwd: AW: UB-Tree's and patents]

Hi everyone, For anyone who's interested in the patent status of UB-Tree's, here is further info. :-) Regards and best wishes, Justin Clift Original Message Subject: AW: UB-Tree's and patents Date: Thu, 4 Apr 2002 17:41:10 +0200 From: Rudolf Bayer [EMAIL PROTECTED

Re: [HACKERS] [Fwd: AW: UB-Tree's and patents]

have his response in a day or two. :-) Regards and best wishes, Justin Clift Oleg Bartunov wrote: On Sat, 6 Apr 2002, Justin Clift wrote: Hi everyone, For anyone who's interested in the patent status of UB-Tree's, here is further info. :-) I dont' understand that. Does it means

Re: [HACKERS] ANALYZE after restore

of a restore - by default only - is a good idea. Regards and best wishes, Justin Clift regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- My grandfather once told

Re: [HACKERS] ANALYZE after restore

from taking into account that the majority of users out there are fairly PostgreSQL clue-less. If we can make it easy without much inconvenience and without sacrificing the power of the database, we should. :-) Regards and best wishes, Justin Clift snip -- My grandfather once told me

Re: [HACKERS] ANALYZE after restore

this will all be a moot point. :-) Regards and best wishes, Justin Clift There's been discussion of adding automatic background vacuums to Postgres; that seems like a more useful response to the issue. regards, tom lane -- My grandfather once told me that there are two

Re: [HACKERS] ANALYZE after restore

Tom Lane wrote: Justin Clift [EMAIL PROTECTED] writes: I agree adding an automatic background vacuum thread/process/something will be really, really useful too. Should we instead have this proposed automatic background something also update the statistics every now and again? Yes, I

Re: [HACKERS] [GENERAL] Re : Solaris Performance - Profiling (Solved)

Hi Tom, How about we include this and have configure somehow ensure the Solaris users get it automatically? There are a *bunch* of Solaris users out there. :-) Regards and best wishes, Justin Clift Mark kirkwood wrote: On Wed, 2002-04-03 at 04:02, Tom Lane wrote: Hmm. Where

[HACKERS] Posix AIO in new Red Hat Linux

AIO for disk access (database helper) Does anyone know what this does, and if it's something we'll be able to leverage (i.e. better performance, etc)? Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take

Re: [HACKERS] Rolling v7.2.1 ...

Bruce Momjian wrote: snip Why? Why shouldn't the documentation match the release number? Shouldn't major version still be 7.2, and version be 7.2.1. i.e. 7.2.1 is a minor release/update/subversion of 7.2? Regards and best wishes, Justin Clift -- Bruce Momjian

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

Re: [HACKERS] Bulkloading using COPY - ignore duplicates?

and best wishes, Justin Clift need to be added to the COPY command (I hope not)? Thanks, -- Lee Kindness, Senior Software Engineer Concept Systems Limited. -- 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

[HACKERS] When scripting, which is better?

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 or if [[ -x $self_path/postmaster -x $self_path/psql ]]; then if [ x$foo = x ]; then or if [ $op =

Re: [HACKERS] Spinlock performance improvement proposal

be a good reminder for experienced admins if they forget too. Maybe something simple like pg_ctl shell script message, or something proper like a postmaster start-up check. This wouldn't break anything would it? Regards and best wishes, Justin Clift regards, tom lane

Re: [HACKERS] Glitch in handling of postmaster -o options

and know their scripts will work into the future? ??? Regards and best wishes, Justin Clift Tom Lane wrote: Marko Kreen [EMAIL PROTECTED] writes: I am suggesting this. [ code snipped ] Okay, that would mean that -o '-S nnn' still works, but -o -F doesn't. But ... the thing

Re: [HACKERS] Spinlock performance improvement proposal

Vadim Mikheev wrote: I have committed changes to implement this proposal. I'm not seeing any significant performance difference on pgbench on my single-CPU system ... but pgbench is I/O bound anyway on this hardware, so that's not very surprising. I'll be interested to see what other

Re: [HACKERS] Glitch in handling of postmaster -o options

if we could just having options that replace each -o option (i.e. -F instead of -o '-F', -x -y instead of -o '-x -y') so it's similar to how other programs command line arguments work. Regards and best wishes, Justin Clift regards, tom lane

[HACKERS] Should we disable Solaris using Unix Domain Sockets in the regression test?

, Justin Clift -- 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

Re: [HACKERS] Should we disable Solaris using Unix Domain Sockets in the

Cool. :) Regards and best wishes, Justin Clift Ian Lance Taylor wrote: Justin Clift [EMAIL PROTECTED] writes: Did anyone ever figure out why Solaris boxes had those random failures during the regression tests? It should be better now that listen() is being called with a larger

[HACKERS] Further CVS errors

@justinspc cvs]$ cvs -d :pserver:[EMAIL PROTECTED]:/projects/cvsroot logout (Logging out of [EMAIL PROTECTED]) [justin@justinspc cvs]$ Also tried with using the password of 'postgresql'. I'm get the feeling the problem is not on my end. :( Regards and best wishes, Justin Clift

Re: [HACKERS] MySQL development MUST immdediately cease - Due to

To whoever sent this posting (being Al Dev, or someone spoofing), Please stop posting to the PostgreSQL mailing lists. You are not helping PostgreSQL with your postings, instead you are inciting anger and hostility. Cease and desist these postings immediately. Justin Clift peace_flower

Re: [HACKERS] 7.2 RPMs

compile the driver specifically. This way the user I reckon the user is WAY more likely to have something which works well for them. Bumped into a problem with this just over a week ago. Regards and best wishes, Justin Clift snip -- Peter Eisentraut [EMAIL PROTECTED] http

Re: [HACKERS] querying system catalogs to extract foreign keys

trigger. :-) Regards and best wishes, Justin Clift Rene Pijlman wrote: On 13 Sep 2001 22:56:16 -0700, you wrote: I tried to use the getImportedKeys and getExportedKeys of java.sql.DatabaseMetadata... But it didnt give any expected results... This is probably a limitation or bug in the JDBC

Re: [HACKERS] Re: List response time...

Hey guys, Can you move this thread elsewhere? It's EXTREMELY off topic now. :( Regards and best wishes, Justin Clift Ian Lance Taylor wrote: David Ford [EMAIL PROTECTED] writes: ooohh I've been raggin on Marc on that one for well over

Re: [HACKERS] Link to bug webpage

How about we trial it, but with the understanding that bugs we fix will be marked as such? After all, every bug is given an ID, so whomever fixes the bug with that ID should also mark it off. Looking at the present situation, it seems we began a good idea, but never really followed through with

Re: [HACKERS] Link to bug webpage

A web-based interface allows people to submit bug reports they might otherwise not be able to report. Not everyone is able/willing to sign-up to a mailing list, nor have newsfeed access. The one we have (had) allows the reporting, but has the flaw of not showing when something has been done

Re: [HACKERS] Re: CREATEDB Where ??

, you'll need to create a process for updating the *.conf (postgresql.conf, pg_ident.conf, pg_hba.conf) files correctly too. Perl, sed, etc, would all be a starting point here. Regards and best wishes, Justin Clift Peter Moscatt wrote: Thanks Tony... yes that helps explain why I am not seeing

[HACKERS] Idea: Worthwhile creating a wrapper script to automate pg_hba.conf entries?

Hi all, Just wondering if it'd be worthwhile creating a wrapper script people can run which would automatically generate/update the pg_hba.conf/pg_ident.conf files? Just to make it easier for the end-user. Called bin/pg_auth or something. Regards and best wishes, Justin Clift -- My

Re: [HACKERS] Locale by default?

Hi Peter, Any idea of how many extra memory moving operations that would be? :-) Regards and best wishes, Justin Clift Peter Eisentraut wrote: It occurred to me that a server with locale features that is started in the C locale is going to behave the same as a server without locale

Re: [HACKERS] Locale by default?

wishes, Justin Clift Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: (I sincerely hope that all systems' libcs have optimized paths for the C locale.) So we could get rid of this --enable-locale switch altogether. Some experimental evidence to support the claim that --enable

[HACKERS] PostgreSQL buffer exploits

PostgreSQL in this regard yet. Regards and best wishes, Justin Clift -- 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

[HACKERS] Re: [GENERAL] PostgreSQL buffer exploits

an [ANNOUNCE] when it's all up and ready. :-) Regards and best wishes, Justin Clift Bruce Momjian wrote: Hi all, Just wondering if anyone knows of or has tested for PostgreSQL buffer exploits over the various interfaces (JDBC, ODBC, psql, etc) or directly through socket connections

Re: [HACKERS] Re: To be 7.1.3 or not to be 7.1.3?

/regress/ Regards and best wishes, Justin Clift Mikhail Terekhov wrote: Is it possible to include patch for libpgtcl tcl 8.0 in this release? Regards, Mikhail Terekhov Bruce Momjian wrote: I have to fix my old fault in TID handling. I am able to have a cvs access now

Re: [HACKERS] Re: To be 7.1.3 or not to be 7.1.3?

None of my Solaris boxes have direct internet access, but if someone is willing to make a snapshot tar.gz/tar.bz2 file, I can download and test on Solaris 8 SPARC/INTEL. :) Regards and best wishes, Justin Clift Tatsuo Ishii wrote: OK, 7.1.3 is packaged and ready to go, date stamped

Re: [HACKERS] Re: [PATCHES] Select parser at runtime

as the DBA's gained more experience and understanding of PostgreSQL's strengths. i.e. Chalk up a win. Vince Vielhaber wrote: On Mon, 13 Aug 2001, Justin Clift wrote: Hi guys, Not sure if Peter was joking, but Ian's approach sounds much more user-friendly. Getting Oracle users

Re: [HACKERS] OpenFTS (Open Source Full Text Search engine) pre-announce

Hi Anatoly, Just tried it, it works for me. Would it possibly be your browser is broken? If not, maybe you got to it during an update, etc. Does it work for you now? Regards and best wishes, Justin Clift Anatoly K. Lasareff wrote: OB == Oleg Bartunov [EMAIL PROTECTED] writes: OB

[HACKERS] To be 7.1.3 or not to be 7.1.3?

Hi guys, Just wondering if we are going to release a version 7.1.3 or not? Regards and best wishes, Justin Clift -- 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

[HACKERS] [Fwd: Re: [GENERAL] Unisersal B-Tree]

Hi all, Not sure if this is useful, but it might be good to file and reference somewhere. Regards and best wishes, Justin Clift Original Message Subject: Re: [GENERAL] Unisersal B-Tree Date: Mon, 30 Apr 2001 17:59:49 +0200 From: Jörg Schulz [EMAIL PROTECTED] Organization

Re: [HACKERS] --tuning compile and runtime option (?)

ources though, in a second-by-second situation. What do you think? Regards and best wishes, Justin Clift Bruce Momjian wrote: My idea was to have PostgreSQL output tips to help performance. The TODO item is: * Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM

[HACKERS] --tuning compile and runtime option (?)

uperserver postmaster -t shared postmaster -t embedded What do people think? Regards and best wishes, Justin Clift P.S. - I'm not on the Hackers mailing list from this account. Can anyone responding please include me directly in their replies? -- "My grandfather once told me that there are two

Re: [HACKERS] Re: Call for platforms

I know that Sourceforge has been adding all sorts of machines to their compile farm. Maybe it would be worthwhile taking a look if they have platforms we don't? Regards and best wishes, Justin Clift Thomas Lockhart wrote: The non-test-and-set case should work again in current CVS, and I'd

[Fwd: Re: [HACKERS] Call for platforms]

Hi all, Vince asked me to forward this here. Regards and best wishes, Justin Clift Original Message Subject: Re: [HACKERS] Call for platforms Date: Sun, 25 Mar 2001 19:45:37 -0500 (EST) From: Vince Vielhaber [EMAIL PROTECTED] To: Justin Clift [EMAIL PROTECTED] On Mon, 26

<    1   2   3   4   >