[HACKERS] docco on external storage?

2003-11-03 Thread Andrew Dunstan
Perhaps I am missing something, but the documentation on external storage appears remarkably sparse. It says it is better for substring searches, but otherwise doesn't say very much. I have a table with two modest-length bytea fields (around 9K and 2K respectively) of already compressed data.

Re: [HACKERS] docco on external storage?

2003-11-04 Thread Andrew Dunstan
Thanks. We don't really expect DBAs to go hunting through the source code, though, do we? cheers andrew - Original Message - From: Joe Conway [EMAIL PROTECTED] To: Andrew Dunstan [EMAIL PROTECTED] Cc: Postgresql Hackers [EMAIL PROTECTED] Sent: Monday, November 03, 2003 9:50 PM

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-04 Thread Andrew Dunstan
Tom Lane wrote: Jan Wieck [EMAIL PROTECTED] writes: What still needs to be addressed is the IO storm cause by checkpoints. I see it much relaxed when stretching out the BufferSync() over most of the time until the next one should occur. But the kernel sync at it's end still pushes the

Re: [HACKERS] [PATCHES] equal() perf tweak

2003-11-04 Thread Andrew Dunstan
Tom Lane wrote: snip excellent scheme for improving List /snip Just a thought - if we are messing with the List definition should we at the same time address the strict aliasing issues arising from Node's multiple personalities (I think it is the main offender). Or is the intention never to

Re: [HACKERS] [PATCHES] equal() perf tweak

2003-11-04 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Just a thought - if we are messing with the List definition should we at the same time address the strict aliasing issues arising from Node's multiple personalities (I think it is the main offender). Or is the intention never

Re: [HACKERS] Open Sourcing pgManage

2003-11-04 Thread Andrew Dunstan
Marc G. Fournier wrote: On Tue, 4 Nov 2003, Joshua D. Drake wrote: Hello, If that is the case that is fine. I just wanted to throw it out there but doesn't that mean that psql would be separate as well? no new client applications BTW, Joshua, thanks for releasing this - all my

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

2003-11-04 Thread Andrew Dunstan
scott.marlowe wrote: On Tue, 4 Nov 2003, Tom Lane wrote: The main problem with this is knowing which files need to be fsync'd. Wasn't this a problem that the win32 port had to solve by keeping a list of all files that need fsyncing since Windows doesn't do sync() in the classical sense?

Re: [HACKERS] Open Sourcing pgManage

2003-11-04 Thread Andrew Dunstan
Andreas Pflug wrote: Marc G. Fournier wrote: JSP, remotely, through Jakarta-Tomcat? One of the limitations of pgAdmin, as far as I'm concerned, is the fact that you can run it remotely ... if you could run pgManage under something like Jakarta-Tomcat as a JSP, that would be *really* cool

Re: [HACKERS] Open Sourcing pgManage

2003-11-05 Thread Andrew Dunstan
Dave Page wrote: -Original Message- From: Andrew Dunstan [mailto:[EMAIL PROTECTED] Don't get me wrong - pgadmin is cool - I especially recommend it to my Windows oriented clients and colleagues who hate using command lines. Why not your Linux or FreeBSD oriented colleagues

Re: [HACKERS] Performance features the 4th

2003-11-05 Thread Andrew Dunstan
Jan Wieck wrote: How portable is getrusage()? Could the postmaster issue that frequently for RUSAGE_CHILDREN and leave the result somewhere in the shared memory for whoever is concerned? SVr4, BSD4.3, SUS2 and POSIX1003.1, I believe. I also believe there is a M$ dll available that gives that

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-05 Thread Andrew Dunstan
Bruce Momjian wrote: Tom Lane wrote: Josh Berkus [EMAIL PROTECTED] writes: B) What contributors are listed under Major Developers who haven't contributed any code since 7.1.0? I think we had agreed that formerly-listed contributors would not be deleted, but would be moved to a

Re: [HACKERS] Information Schema and constraint names not unique

2003-11-06 Thread Andrew Dunstan
Tom Lane wrote: The reason the spec defines these views this way is that it expects constraint names to be unique across a whole schema. We don't enforce that, and I don't think we want to start doing so (that was already proposed and shot down at least once). You are of course free to use

Re: [HACKERS] Information Schema and constraint names not unique

2003-11-06 Thread Andrew Dunstan
Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: I don't think we really need a method to guarantee unique names. It would already help a lot if we just added the table name, or something that was until a short time before the action believed to be the table name, or even only the

Re: [HACKERS] Bogus bind() warnings

2003-11-06 Thread Andrew Dunstan
Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: When I start up with -i, I get the following log: LOG: could not bind IPv4 socket: Address already in use There is no other postmaster running anywhere. I suspect that this has to do with IPv6. This is a SuSE 8.something

Re: [HACKERS] Bogus bind() warnings

2003-11-06 Thread Andrew Dunstan
Tom Lane wrote: Kurt Roeckx [EMAIL PROTECTED] writes: Should we just not give that error message, in case we already binded to AF_INET6 ::? Seems like a cure worse than the disease to me --- it could mask real problems. I suppose we could think about dropping it from LOG to DEBUG1 level,

Re: [HACKERS] Information Schema and constraint names not

2003-11-06 Thread Andrew Dunstan
Philip Warner wrote: At 03:37 AM 7/11/2003, Peter Eisentraut wrote: It would already help a lot if we just added the table name, or something that was until a short time before the action believed to be the table name, or even only the table OID, before (or after) the $1. Can we

Re: [HACKERS] Information Schema and constraint names not unique

2003-11-07 Thread Andrew Dunstan
Bruce Momjian wrote: Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: On Thu, Nov 06, 2003 at 11:42:13AM -0500, Tom Lane wrote: I don't have a problem with switching from $1 to tablename_$1, or some such, for auto-generated constraint names. But if it's not guaranteed

Re: [HACKERS] Information Schema and constraint names not unique

2003-11-07 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: . add tableoid or tablename to information_schema.{check_constraints, referential_constraints} (I think those are the only places where it would be needed, from my quick skimming). . add tableoid or tablename to autogenerated table

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Andrew Dunstan
Alvaro Herrera wrote: I don't have an opinion on the Win32 issue. I do :-) I think the most important thing for Win32 is for you to set the direction somewhat (i.e. in more detail than is on your win32 page) and then jump on Joshua's offer of a dedicated developer (possibly two) to work on

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Andrew Dunstan
Marc G. Fournier wrote: On Fri, 7 Nov 2003, Robert Treat wrote: I know most people have talked about using bugzilla, but is anyone familiar with GNATS? I'm currently rereading Open Sources and there's a paragraph or two mentioning it's use and the fact that it can be interfaced with

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Andrew Dunstan
Christopher Browne wrote: [EMAIL PROTECTED] (Bruce Momjian) writes: The worst was my upstairs hallway that had no light fixtures, so late at night if no other lights were on in the house, you had to walk down the hallway with your hands out in front of you so you didn't bump into anything. We

Re: [HACKERS] Experimental ARC implementation

2003-11-07 Thread Andrew Dunstan
Greg Stark wrote: Bruce Momjian [EMAIL PROTECTED] writes: I am not really aiming at removing sync() alltogether. We know already that open,fsync,close does not guarantee you flush dirty OS-buffers for which another process might so far only have done open,write. And you So for what

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-07 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Bugzilla is far from perfect. But it's getting better. FWIW, I would like to try a bugzilla-based tracking system for Postgres. Our last attempt at a tracking system failed miserably, but I think that was (a) because the software we

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Andrew Dunstan
Robert Treat wrote: On Fri, 2003-11-07 at 15:28, Andrew Dunstan wrote: Marc G. Fournier wrote: On Fri, 7 Nov 2003, Robert Treat wrote: I know most people have talked about using bugzilla, but is anyone familiar with GNATS? I'm currently rereading Open Sources and there's

Re: [HACKERS] What do you want me to do?

2003-11-07 Thread Andrew Dunstan
Dave Cramer wrote: Jira is a fantastic bug tracking project management system and is available free of charge for open source projects. http://www.atlassian.com/software/jira/ Wow, that looks very cool indeed! And they are Aussies to boot! :-) cheers andreew

Re: [HACKERS] What do you want me to do?

2003-11-08 Thread Andrew Dunstan
Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: I don't think we need decicated bug transferrers. Typically, when someone reports a problem by email, the first step is that some developer or other expert responds (unless the reporter gets blown away by fellow users as clueless

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-08 Thread Andrew Dunstan
Christopher Kings-Lynne wrote: The doesn't quite make the best use of PG quote is one of the best examples of buck-passing I've seen in awhile. If Bugzilla had been designed with some thought to DB independence to start with, we'd not be having this discussion. You have to laugh at an app

Re: [HACKERS] [7.3.x] function does not exist ... ?

2003-11-10 Thread Andrew Dunstan
Marc G. Fournier wrote: 'k, this doesn't look right, but it could be that I'm overlooking something ... The function I created: CREATE FUNCTION month_trunc (timestamp without time zone) RETURNS timestamp without time zone AS 'SELECT date_trunc(''month'', $1 )' LANGUAGE sql IMMUTABLE; The

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Andrew Dunstan
Peter Eisentraut wrote: Andrew Dunstan writes: Seriously, I have wondered if it might be a good idea to assemble a small hit team that would take some high profile open source projects and make sure they worked with Postgres. Bugzilla would be the most obvious candidate

Re: [HACKERS] bugzilla (Was: What do you want me to do?)

2003-11-11 Thread Andrew Dunstan
Peter Eisentraut wrote: Andrew Dunstan writes: Your suggestion elsewhere of pick your second favourite app is likely to result in a more scattergun approach. Also, if it had the imprimatur of the PostgreSQL community to some extent appraoches to projects might be more welcome - Dear open

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Andrew Dunstan
Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: Also (and maybe someone from Red Hat can weigh in here) are there any plans from Red Hat to release RHEL rpms for postgresql in the future, I can tell you that Red Hat is getting beat up regularly for having omitted Postgres (and

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Andrew Dunstan
I wrote: I just spent 15 minutes searching on the RH web site trying to locate a complete list of packages in the various RHEL personalities, with conspicuous lack of success. How anyone can make decisions about it without knowing exactly what is in it is beyond me. However, you can see a

Re: [HACKERS] cvs head? initdb?

2003-11-13 Thread Andrew Dunstan
and the problem seen here with the order of messages sent by initdb has been fixed by Tom in the head branch (which is the only place it would have occurred). cheers andrew Robert Treat wrote: They are no longer in sync. Jan has started committing some of his ARC work (though I think it

Re: [HACKERS] heads up -- subtle change of behavior of new initdb

2003-11-14 Thread Andrew Dunstan
The shell script said this: $ECHO_N fixing permissions on existing directory $PGDATA... $ECHO_C chmod go-rwx $PGDATA || exit_nicely There's no more rationale than that for this patch. I'm inclined to agree with you, though. cheers andrew Greg Stark wrote: + if

Re: [HACKERS] heads up -- subtle change of behavior of new initdb

2003-11-14 Thread Andrew Dunstan
Tom Lane wrote: Greg Stark [EMAIL PROTECTED] writes: I'm not suggesting making that the default setup, just loosening the paranoia check so that if an admin sets the directory to be group readable the database doesn't refuse to start up. In previous discussions of this point, paranoia was

Re: [HACKERS] oh dear ...

2003-11-14 Thread Andrew Dunstan
Marc G. Fournier wrote: On Fri, 14 Nov 2003, Bruce Momjian wrote: Tom Lane wrote: I said: This worked in 7.3: regression=# select '1999-jan-08'::date; ERROR: date/time field value out of range: 1999-jan-08 HINT: Perhaps you need a different datestyle setting. Setting

Re: [HACKERS] heads up -- subtle change of behavior of new initdb

2003-11-14 Thread Andrew Dunstan
darnit! patch attached. (Thinks - do we need to worry about suid sgid and sticky bits on data dir?) andrew Tom Lane wrote: Joe Conway [EMAIL PROTECTED] writes: I just noticed tonight that the new initdb introduced a subtle change of behavior. I use a shell script to automate the process

Re: [PATCHES] [HACKERS] heads up -- subtle change of behavior of

2003-11-14 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: darnit! patch attached. Applied with correction (you got the return-value check backwards) and further work to deal reasonably with error conditions occurring in check_data_dir. darnit again. I'm taking a break - my head

Re: [HACKERS] Connexions question

2003-11-17 Thread Andrew Dunstan
Er, that's a per-server limit, not a per-database limit (which is what he asked for), isn't it? cheers andrew Dann Corbit wrote: It's a command line option for the server. http://developer.postgresql.org/docs/postgres/app-postmaster.html -Original Message- From: [EMAIL PROTECTED]

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-18 Thread Andrew Dunstan
Claudio Natoli wrote: I'm sorry if I'm being alow here - is there any problem with running a production server on cygwin's postgresql? Is the cygwin port of lesser quality, or otherwise inferior? Performance, performance, perfomance... and perfomance... it is (almost) always worse

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-18 Thread Andrew Dunstan
Bruce Momjian wrote: I am ready to work with anyone to make fork/exec happen. It requires we find out what globals are being set by the postmaster, and have the child run those same routines. I can show you examples of what I have done and walk you through areas that need work. If you look at

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-18 Thread Andrew Dunstan
ow wrote: Have *never* seen ppl running Oracle or Sybase on Windows. Not sure about DB/2 or Informix, never worked with them, but I'd suspect the picture is the same. Then you need to get out more. I have seen Oracle, Sybase, DB2 (and probably Informix, I forget) all running on Windows in a

Re: [pgsql-www] [HACKERS] Release cycle length

2003-11-18 Thread Andrew Dunstan
Josh Berkus wrote: Guys, I agree with Neil ... it's not the length of the development part of the cycle, it's the length of the beta testing. I do think an online bug tracker (bugzilla or whatever) would help. I also think that having a person in charge of testing would help as well ... no

[HACKERS] Build farm

2003-11-18 Thread Andrew Dunstan
Marc G. Fournier wrote: On Tue, 18 Nov 2003, Andrew Dunstan wrote: Maybe some sort of automated distributed build farm would be a good idea. Check out http://build.samba.org/about.html to see how samba does it (much lighter than the Mozilla tinderbox approach). We wouldn't need

Re: [HACKERS] Build farm

2003-11-19 Thread Andrew Dunstan
Peter Eisentraut wrote: Andrew Dunstan writes: If there's general interest I'll try to cook something up. (This kind of stuff is right up my alley). I'd prefer some automated display of results, though. A simple CGI script should be all that's required for that. The real problem

Re: [HACKERS] initdb segfaults - latest cvs

2003-11-19 Thread Andrew Dunstan
strk wrote: Running initdb: creating template1 database in /pgroot-cvs/data/base/1 ... child process was terminated by signal 11 It is working fine for me (RH9). Can you provide more details? Platform? How you are calling initdb? cheers andrew ---(end of

Re: [HACKERS] Build farm

2003-11-19 Thread Andrew Dunstan
Peter Eisentraut wrote: Andrew Dunstan writes: Useful is probably subjective. That list would at least be a good place to start, though. What combinations of variables do you think we would need? First of all, I don't necessarily think that a large list of CPU/operation system

Re: [HACKERS] Build farm

2003-11-19 Thread Andrew Dunstan
Peter Eisentraut wrote: The Samba build daemon suite is pretty good. We have a couple of those hosts in our office in fact. (I think they're building PostgreSQL regularly as well.) A tip: You might find that adopting the source code of the Samba suite to PostgreSQL is harder than writing a new

Re: [HACKERS] 4 Clause license?

2003-11-20 Thread Andrew Dunstan
This whole thing is starting to make my head hurt. There has been more effort spent over this license issue than I would have spent if I hadn't taken the shortcut of using the FreeBSD code. I think maybe the simplest thing is for me to prepare a patch that rips that code out and replaces it

Re: [HACKERS] Build farm

2003-11-20 Thread Andrew Dunstan
Peter Eisentraut wrote: Andrew Dunstan writes: Essentially what I have is something like this pseudocode: cvs update Be sure check past branches as well. check if there really was an update and if not exit OK. configure; get config.log Ideally, you'd try all

Re: [HACKERS] 4 Clause license?

2003-11-20 Thread Andrew Dunstan
Rod Taylor wrote: I think maybe the simplest thing is for me to prepare a patch that rips that code out and replaces it with a (slightly simpler - less umask hacking required, I think) piece of code that I will write. The FreeBSD folks sorted it out for us. Everyones names should be in

Re: [HACKERS] 4 Clause license?

2003-11-20 Thread Andrew Dunstan
Marc G. Fournier wrote: On Thu, 20 Nov 2003, Joshua D. Drake wrote: Based on the below wouldn't they also have to go after Microsoft? Depends ... does MicroSoft use BSD TCP/IP, or did they write their own? I know that Linux is not using BSD TCP/IP (or, at least, they didn't in their

Re: [HACKERS] Build farm

2003-11-21 Thread Andrew Dunstan
Tom Lane wrote: I think the main value of a build farm is that we'd get nearly immediate feedback about the majority of simple porting problems. Your previous arguments that it wouldn't smoke everything out are certainly valid --- but we wouldn't abandon the regression tests just because they

Re: [HACKERS] initdb mkdir_p() doesn't work

2003-11-23 Thread Andrew Dunstan
Peter Eisentraut wrote: Here is what I get: peter ~$ pg-install/bin/initdb pg-install/var/data ... creating directory pg-install/var/data ... initdb: failed No points for details in the error message here either. If I create pg-install/var first, then it work. I will check it out. I know I

Re: [HACKERS] initdb mkdir_p() doesn't work

2003-11-23 Thread Andrew Dunstan
Tom Lane wrote: AFAICS mkdatadir() shouldn't consider subdir == NULL as a reason to fail rather than trying mkdir_p. Indeed, if anything the opposite: when subdir isn't NULL the immediately prior directory level should exist already. Right. In fact, I can't see any good reason to call mkdir

Re: [HACKERS] initdb mkdir_p() doesn't work

2003-11-23 Thread Andrew Dunstan
Andrew Dunstan wrote: Peter Eisentraut wrote: Here is what I get: peter ~$ pg-install/bin/initdb pg-install/var/data ... creating directory pg-install/var/data ... initdb: failed No points for details in the error message here either. If I create pg-install/var first, then it work. I

Re: [HACKERS] initdb mkdir_p() doesn't work

2003-11-23 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Tom Lane wrote: AFAICS mkdatadir() shouldn't consider subdir == NULL as a reason to fail rather than trying mkdir_p. Right. In fact, I can't see any good reason to call mkdir and then mkdir_p at all. See my patch from

Re: [HACKERS] Build farm

2003-11-24 Thread Andrew Dunstan
Jean-Michel POURE wrote: Le Vendredi 21 Novembre 2003 19:47, Tom Lane a crit : I think the main value of a build farm is that we'd get nearly immediate feedback about the majority of simple porting problems. Your previous arguments that it wouldn't smoke everything out are certainly valid

Re: [HACKERS] Build farm

2003-11-25 Thread Andrew Dunstan
Bruce Momjian wrote: FYI, the HP testdrive farm, http://www.testdrive.hp.com, has shared directories for most of the machines, meaning you can CVS update once and telnet in to compile for each platform. As Peter pointed out, these machines are firewalled. But presumably one could upload a

Re: [HACKERS] Build farm

2003-11-25 Thread Andrew Dunstan
Bruce Momjian wrote: Andrew Dunstan wrote: Bruce Momjian wrote: FYI, the HP testdrive farm, http://www.testdrive.hp.com, has shared directories for most of the machines, meaning you can CVS update once and telnet in to compile for each platform. As Peter pointed out

Re: [HACKERS] initdb should create a warning message [was Re:

2003-12-01 Thread Andrew Dunstan
Greg Stark wrote: Oliver Elphick [EMAIL PROTECTED] writes: Then it needs to be stated very prominently. But the place to put a sign saying Dangerous cliff edge is beside the path that leads along it. The only way to make this prominent would be a file with the *name* THIS DIRECTORY

[HACKERS] remaining patches?

2003-12-01 Thread Andrew Dunstan
What's happening to the remaining patches that were held over for 7.5, e.g. mine which does some logging enhancements? cheers andrew ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] [pgsql-hackers-win32] What packages from Mingw and MSys are needed?

2003-12-02 Thread Andrew Dunstan
Tony and Bryn Reina wrote: 1. Which parts of MSYS and Mingw are needed for the building a Win32 version of PostgreSQL? There are several packages listed on the Mingw website: MingGW-3.1.0-1.exe mingw-utils-0.2 mingw-runtime-3.2 msys-1.0.9.exe msysDTK-1.0.1.exe binutils gcc win32api-2.4

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread Andrew Dunstan
E.Rodichev wrote: On Fri, 28 Nov 2003, Tom Lane wrote: E.Rodichev [EMAIL PROTECTED] writes: /e:2createdb test test | er | SQL_ASCII - Incorrect! (3 rows) Let's note than the last line is in fact completely incorrect. What's incorrect about it? You

Re: [HACKERS] Inside the Regex Engine

2003-12-03 Thread Andrew Dunstan
Tom Lane wrote: [EMAIL PROTECTED] (David Fetter) writes: While PL/Perl is great, it's not available everywhere, and I'd like to be able to grab atoms from a regex match in, say, a SELECT. Is there some way to get access to them? There's a three-parameter variant of substring() that

Re: [HACKERS] Encoding problem with 7.4

2003-12-03 Thread Andrew Dunstan
E.Rodichev wrote: On Wed, 3 Dec 2003, Stephan Szabo wrote: On Wed, 3 Dec 2003, E.Rodichev wrote: On Fri, 28 Nov 2003, Tom Lane wrote: E.Rodichev [EMAIL PROTECTED] writes: /e:2createdb test test | er | SQL_ASCII - Incorrect! (3 rows)

Re: [HACKERS] Encoding problem with 7.4

2003-12-04 Thread Andrew Dunstan
E.Rodichev wrote: On Wed, 3 Dec 2003, Stephan Szabo wrote: The locale settings depend on LC_* at initdb time only. When the postmaster starts it sets the locale based on the stored values from initdb, not on the current environment. With an SQL_ASCII database being accessed from a client with

Re: [HACKERS] Minor (very) feature request...

2003-12-04 Thread Andrew Dunstan
Marc G. Fournier wrote: run it through syslog? or set log_timestamp = true in postgresql.conf ? On Thu, 4 Dec 2003, Steve Wampler wrote: Would it be (is it?) possible to add timestamp to the log messages put out by postgresql? I've got several databases running in an environment where

Re: [HACKERS] Double linked list with one pointer

2003-12-06 Thread Andrew Dunstan
Bruce Momjian wrote: Gaetano Mendola wrote: I don't think the article is available online, alas, but you can find some related source code demonstrating the technique at: http://www.semantics.org/tyr/tyr0_5/list.h That certainly is an amazing idea. You know the pointer you are

Re: [HACKERS] IDENT and IPv6 (was Re: [GENERAL] pg_hba.conf

2003-12-06 Thread Andrew Dunstan
Kurt Roeckx wrote: On Sat, Dec 06, 2003 at 01:30:02PM -0600, Seum-Lim Gan wrote: Hi, The ident server we currently use is pidentd 3.0.16 from : http://www.lysator.liu.se/ or ftp://ftp.lysator.liu.se/pub/ident/servers The ChangeLog of it says: Solaris 8 (including IPv6) support added.

Re: [HACKERS] CVS HEAD compile failure

2003-12-07 Thread Andrew Dunstan
fresh checkout just compiled fine for me on Linux (RH8) with ssl enabled. Maybe it is your openssl installation? cheers andrew Bruce Momjian wrote: Attached is a compile failure I am seeing in CVS HEAD in bin/pg_dump. The offending lines are: gmake[3]: Leaving directory

Re: [HACKERS] CVS HEAD compile failure

2003-12-08 Thread Andrew Dunstan
Bruce Momjian wrote: Andrew Dunstan wrote: fresh checkout just compiled fine for me on Linux (RH8) with ssl enabled. Maybe it is your openssl installation? It is openssl 0.9.7c. 7.4 CVS compiles fine so I don't see how it can be my SSL install. I just tried with this version

Re: [HACKERS] CVS HEAD compile failure

2003-12-08 Thread Andrew Dunstan
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Where is the typedef here: int CRYPTO_set_locked_mem_functions(void *(*m)(size_t), void (*free_func)(void *)); size_t ... If there's a missing typedef shouldn't we see something like this: `size_t' undeclared (first use in this

Re: [HACKERS] CVS HEAD compile failure

2003-12-08 Thread Andrew Dunstan
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Andrew Dunstan wrote: fresh checkout just compiled fine for me on Linux (RH8) with ssl enabled. Maybe it is your openssl installation? It is openssl 0.9.7c. 7.4 CVS compiles fine so I don't see how it can be my SSL

Re: [HACKERS] CVS HEAD compile failure

2003-12-08 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Tom Lane wrote: I've been able to reproduce this on one of my machines, and it's nasty. In that case I'm confused about why this code compiles on my machine: What compiler are you using? I'm using gcc 2.95.3

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread Andrew Dunstan
Frank Wiles wrote: On Tue, 9 Dec 2003 07:15:41 -0800 (PST) Ivelin Ivanov [EMAIL PROTECTED] wrote: Has this subject been discussed before? I did not find any references to it in the archives. I think that a co-bundle between an open source J2EE container like JBoss and a scalable database like

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread Andrew Dunstan
Neil Conway wrote: Andrew Dunstan [EMAIL PROTECTED] writes: As a Java programmer, I do agree that having a pure Java RDBMS system would be a Good Thing (tm) Are there any advantages that this would provide that we could get without investing so much effort? For example, PL/Java seems like

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread Andrew Dunstan
D'Arcy J.M. Cain wrote: On December 9, 2003 12:15 pm, Neil Conway wrote: P.S. While we're contemplating pies-in-the-sky, I'd personally love to rewrite PostgreSQL in Objective Caml. I vote for InterCal. :-) Pick your poison from this site: http://99-bottles-of-beer.ls-la.net/ (see

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread Andrew Dunstan
Dave Cramer wrote: Have a look at Axion for a pure java db http://axion.tigris.org/ Not as full featured,but still useful. Er, I take it that not as full featured is an example of meiosis :-) Here's what the web page says: Not (Yet) Supported

Re: [HACKERS] pljava revisited

2003-12-10 Thread Andrew Dunstan
Thomas Hallgren wrote: Hi, I'm working on a new pl/java prototype that I hope will become production quality some time in the future. Before my project gets to far, I'd like to gather some input from other users. I've taken a slightly different approach than what seems to be the case for other

Re: [HACKERS] pljava revisited

2003-12-10 Thread Andrew Dunstan
Thomas Hallgren wrote: The JVM will be started on-demand. Although I realize that one JVM per connection will consume a fair amount of resources, I still think it is the best solution. The description of this system must of course make it very clear that this is what happens and ultimately

Re: [HACKERS] CSV hack

2003-12-10 Thread Andrew Dunstan
You also need to quote values containing the separator. cheers andrew (who used to set creating CSV as a programming exercise - students almost never get it right) David Fetter wrote: Kind people, I've come up with yet another little hack, this time for turning 1-d arrays into CSV format.

Re: [HACKERS] 7.4 build problem on Linux Vserver

2003-12-11 Thread Andrew Dunstan
Tom Lane wrote: Dave Page [EMAIL PROTECTED] writes: gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations prod -I../../src/include -D_GNU_SOURCE -I/usr/include -c -o path.o path.c gcc: cannot specify -o with -c or -S and multiple compilations How is prod getting

Re: [HACKERS] pljava revisited

2003-12-11 Thread Andrew Dunstan
Peter Eisentraut wrote: Thomas Hallgren wrote: What are your thoughts and ideas? Instead of making up your own stuff, there's a whole SQL standard that tells you how Java embedded in an SQL server should work. Of course that doesn't tell you about implementation details. Where

Re: [HACKERS] Use of 'cp -r' in CREATE DATABASE

2003-12-11 Thread Andrew Dunstan
Nigel J. Andrews said: On Thu, 11 Dec 2003, Alvaro Herrera wrote: On Thu, Dec 11, 2003 at 06:36:05PM -0500, Bruce Momjian wrote: Our dbcommands.c has for create database: snprintf(buf, sizeof(buf), cp -r '%s' '%s', src_loc, target_dir); [...] I think we should switch to

Re: [HACKERS] Use of 'cp -r' in CREATE DATABASE

2003-12-12 Thread Andrew Dunstan
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: but my BSD/OS manual only documents 'cp -R' and mentions: I think we should switch to -R in our code. And break the code on who knows how many other systems? No thanks. If we want to do anything at all with this code, we should

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-12 Thread Andrew Dunstan
re Windows: pipes, yes, hard links, no (and no sane symlinks either) - also of course no (sane) shell - is this going to be a script or a C program? Maybe use an option which you would disable on Windows to copy the files instead of hardlinking them. Yes it would take lots more time and space,

Re: [HACKERS] Resurrecting pg_upgrade

2003-12-12 Thread Andrew Dunstan
Matthew T. O'Connor wrote: On Fri, 2003-12-12 at 14:51, Andrew Dunstan wrote: re Windows: pipes, yes, hard links, no (and no sane symlinks either) Actually, NTFS does support hard links, there is just no support for it in any MS file management GUI. http://msdn.microsoft.com/library

Re: [HACKERS] [PATCHES] fork/exec patch

2003-12-14 Thread Andrew Dunstan
[moved to hackers / win32] Claudio Natoli wrote: Or do people have strong leanings towards fix as you go along? Just feels like that way could see us getting bogged down making things perfect instead of advancing the port... w.r.t. Win32, I think the way to proceed is (in this order): . make

Re: [HACKERS] [PATCHES] fork/exec patch

2003-12-15 Thread Andrew Dunstan
Bruce Momjian wrote: Andrew Dunstan wrote: Now for the fun part (signals). Actually, no. I thought fork/exec would be a real mess (as did Tom), but Claudio has done an excellent job of producing a minimal patch. The work isn't done yet, but this small patch has taken us much closer, so

Re: [HACKERS] [PATCHES] fork/exec patch

2003-12-15 Thread Andrew Dunstan
Bruce Momjian wrote: Have you looked at the CONNX signal code on the Win32 page: http://momjian.postgresql.org/main/writings/pgsql/win32.html It uses shared memory and events. Yes, and I just did again. I guess I must be missing something, though - I don't see what in that code causes the

Re: [HACKERS] [PATCHES] fork/exec patch

2003-12-16 Thread Andrew Dunstan
Magnus Hagander wrote: Bruce Momjian wrote: Have you looked at the CONNX signal code on the Win32 page: http://momjian.postgresql.org/main/writings/pgsql/win32.html It uses shared memory and events. Yes, and I just did again. I guess I must be missing something, though - I don't see what

Re: [pgsql-hackers-win32] [HACKERS] [PATCHES] fork/exec patch

2003-12-16 Thread Andrew Dunstan
Magnus Hagander wrote: Absolutely, but there are other signals to send, no? Or you might want to send a signal directly to a backend (to cancel for example), as you can do on Unix. In normal operation the only thing that should be signalling a backend is the postmaster. cheers andrew

Re: [pgsql-hackers-win32] [HACKERS] [PATCHES] fork/exec patch

2003-12-16 Thread Andrew Dunstan
Neil Conway said: Andrew Dunstan [EMAIL PROTECTED] writes: In normal operation the only thing that should be signalling a backend is the postmaster. Oh? What about LISTEN/NOTIFY? er, yeah. *self-lart* + ... or another backend cheers andrew ---(end of broadcast

Re: [HACKERS] [PATCHES] Double Backslash example patch

2003-12-17 Thread Andrew Dunstan
Andreas Pflug wrote: Tom Lane wrote: I think the minimum amount of additional work that has to be done before we can apply it is to teach psql's input parser about $QUOTE$ --- without that, the feature is not only useless but counterproductive. IMHO it's not useless. pgAdmin already knows

Re: [HACKERS] [PATCHES] Double Backslash example patch

2003-12-17 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: I see that psql/mainloop.c contains this comment: * FIXME: rewrite this whole thing with flex Is now the time to do that? If you feel like giving it a shot, ain't nobody gonna stand in your way. MainLoop() is well past the level

Re: [HACKERS] TODO list

2003-12-17 Thread Andrew Dunstan
Jonathan Gardner wrote: Marko Zmak wrote: I've been usin psql for quite a long time and I found it to be very comfortable. Since some web providers in my country refuse to put psql while some thing are still in psql TODO list, I'm interested in following... I'd like to know when are you

Re: [HACKERS] TODO list

2003-12-17 Thread Andrew Dunstan
Tom Lane said: Andrew Dunstan [EMAIL PROTECTED] writes: case 6 - limit all users' connections regardless of database: limit all all n That's called max_connections. Don't think we need a redundant implementation of same ... no - this was intended to limit *each* user - max-connections

Re: [HACKERS] TODO list

2003-12-17 Thread Andrew Dunstan
Þórhallur Hálfdánarson said: I'd like to mention that administrators likely to use the this feature would probably like to be able to tune this without having to modify a file -- updating via SQL (= storing this in a system table) would be extremely nice... We set connection permissions in

[HACKERS] replace all with * in pg_hba.conf

2003-12-18 Thread Andrew Dunstan
If people are happy with Tom's suggestion of using '*' instead of 'all' in pg_hba.conf I will prepare a patch for it. (I will also replace the ugly long IP6 localhost netmask with a CIDR mask). cheers andrew ---(end of broadcast)--- TIP 2: you

  1   2   3   4   5   6   7   8   9   10   >