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

2003-11-06 Thread Robert Treat
the main site, namely its bi-lingualness and the different target audience, but perhaps with adding bi-lingual capabilities to the main site these two sites could be brought together. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end

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

2003-11-06 Thread Robert Treat
On Thu, 2003-11-06 at 09:46, Alvaro Herrera wrote: On Thu, Nov 06, 2003 at 09:25:38AM -0500, Robert Treat wrote: The advocacy site does have different requirements than the main site, namely its bi-lingualness and the different target audience, but perhaps with adding bi-lingual

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

2003-11-06 Thread Robert Treat
On Thursday 06 November 2003 17:18, Peter Eisentraut wrote: Robert Treat writes: rant we don't need links, we need patches /rant Let me ask you the questions that people always ask of us: How does one get involved? post proposals to pgsql-www and start coding Where is the code? http

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

2003-11-07 Thread Robert Treat
would like that Idea, I think I will create a little sample page later to see how it could look like :) I disagree... the tech and the content are separate issues, let's keep them that way or we'll never make progress on either of them. Robert Treat -- Build A Brighter Lamp :: Linux Apache

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

2003-11-07 Thread Robert Treat
or two mentioning it's use and the fact that it can be interfaced with completely by email. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

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

2003-11-07 Thread Robert Treat
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 a paragraph or two mentioning

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

2003-11-10 Thread Robert Treat
On Fri, 2003-11-07 at 18:37, Andrew Dunstan wrote: 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

[HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Robert Treat
sure the community rpm builders would have access to those platforms in order to build rpms against them? Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 3: if posting/reading through

Re: [HACKERS] rpm support for 7.4 and beyond

2003-11-12 Thread Robert Treat
On Wed, 2003-11-12 at 10:23, 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

Re: [HACKERS] cvs head? initdb?

2003-11-13 Thread Robert Treat
be, but not always, you can report errors if you want or wait until they sort it out. You should still be able to get an RC2 build with the appropriate tags applied. HTH Robert Treat On Wed, 2003-11-12 at 21:04, elein wrote: What is the status of CVS head? Isn't it in sync with 7.4.RC2? I just upgraded

Re: [HACKERS] cvs head? initdb?

2003-11-14 Thread Robert Treat
is is it worth the effort to give people those options? Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] cvs head? initdb?

2003-11-14 Thread Robert Treat
On Friday 14 November 2003 12:03, Jan Wieck wrote: Robert Treat wrote: On Fri, 2003-11-14 at 10:32, Jan Wieck wrote: Or did you mean ARC itself? Since it replaced the old LRU code, it is the only choice you have now. Which sort of raises the question if we would want to have multiple

Re: [HACKERS] cvs head? initdb?

2003-11-14 Thread Robert Treat
On Friday 14 November 2003 14:23, Neil Conway wrote: Jan Wieck [EMAIL PROTECTED] writes: Robert Treat wrote: people would always want to have those choices (especially for doing development/testing/benchmarking between the different methods) the question is is it worth the effort to give

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-18 Thread Robert Treat
http://www-inst.eecs.berkeley.edu/~cs186/hwk0/index.html Are these screenshots of PgAccess on Mac OSX? Robert Treat On Tue, 2003-11-18 at 13:07, Sailesh Krishnamurthy wrote: PostgreSQL most definitely works great on Solaris x86 ! At UC Berkeley, we have our undergraduate students hack

Re: [HACKERS] Build farm

2003-11-18 Thread Robert Treat
should be all that's required for that. look in the tools directory of cvs, i swear Bruce checked in a script he uses for similar tasks.. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 5

Re: [HACKERS] Commercial binary support?

2003-11-19 Thread Robert Treat
If by up to date you mean 7.4, your probably going to have to wait, but I believe that Command Prompt, dbExperts, Red Hat, and SRA all have some type of binary based support available. Robert Treat On Tue, 2003-11-18 at 17:19, Austin Gonyou wrote: I've been looking all over but I can't seem

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-19 Thread Robert Treat
there are other good projects in there, like allowing indexes for searching nulls, or adding concurrency to GIST, or allowing non btree indexes to handle unique's Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-19 Thread Robert Treat
On Wed, 2003-11-19 at 12:16, Sailesh Krishnamurthy wrote: Robert == Robert Treat [EMAIL PROTECTED] writes: Robert allowing indexes for searching nulls, or adding Robert concurrency to GIST, or allowing non btree indexes to Oh this has come up before on -hackers and I've been

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the

2003-11-19 Thread Robert Treat
On Wed, 2003-11-19 at 10:47, Sailesh Krishnamurthy wrote: Mike == Mike Mascari [EMAIL PROTECTED] writes: Mike Robert Treat wrote: While some form of bitmapped indexing would be cool, other ideas might be to implement different buffer manager strategies. I was impressed

Re: [HACKERS] Commercial binary support?

2003-11-19 Thread Robert Treat
:-) Robert Treat On Wed, 2003-11-19 at 17:17, Austin Gonyou wrote: All, I sincerely apologize for possibly starting a flame war, I wasn't aware this might be a hot-button issue. Hopefully some good will come of it none-the-less, like others who come after me might see the reasons our db

Re: [HACKERS] question about fixes in v7.4...

2003-11-20 Thread Robert Treat
. Would it be worth putting in a partial implementation? I'm thinking specifically about functions that return table types. Could they be hooked up with dependency information and made to complain? Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Re: [HACKERS] [PERFORM] More detail on settings for pgavd?

2003-11-21 Thread Robert Treat
on rel_tuples (or rel_pages). This would give autovacuum a place to look for each table as to when it should vacuum, and gives administrators the option to tweak it on a per table basis if they find they need a specific table to vacuum at a different rate than the standard. Robert Treat -- Build

Re: [HACKERS] logical column position

2003-11-21 Thread Robert Treat
. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(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] pg_restore and create FK without verification check

2003-11-26 Thread Robert Treat
like it accomplish what the original poster requires... Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] 7.3.5 bundled ...

2003-12-03 Thread Robert Treat
: 7615664 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Built fine on the phppgadmin demo server. Robert Treat -- Build A Brighter Lamp :: Linux

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread Robert Treat
On Tue, 2003-12-09 at 12:32, Andrew Dunstan wrote: PL/Java would be way cool, though, and have very significant appeal, and is very much worth doing, I believe. (Not that I have the time to do it.) http://pljava.sourceforge.net/ Someone did it but it didn't catch fire. Robert Treat

Re: [HACKERS] pljava revisited

2003-12-10 Thread Robert Treat
ways, with a recommendation on which is best to follow. Speaking of plR, I'd recommend anyone interested in developing pl's, whether enhancing old ones or creating new ones, to check out the plR code on gborg, it was written recently and is pretty advanced. Robert Treat -- Build A Brighter Lamp

Re: [HACKERS] ERROR: Index pg_toast_8443892_index is not a btree

2003-12-10 Thread Robert Treat
of what caused the problem, possibly forcing this problem on other users in the future because you were unwilling to help us to improve the software. But we understand, it's not like we wrote an entire database system for you... oh wait we did. :-) Robert Treat -- Build A Brighter Lamp :: Linux Apache

Re: [HACKERS] Project status pages

2003-12-18 Thread Robert Treat
these pages? Perhaps they should be moved into the wiki framework up on techdocs? Robert Treat On Wed, 2003-12-17 at 21:37, Bruce Momjian wrote: I have put up a list of projects being worked on and their TODO lists in hope that people will find it easier to work on them: http

Re: [HACKERS] psql \d option list overloaded

2004-01-11 Thread Robert Treat
stumbled over the show syntax when trying to get anything other than tables in mysql. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

Re: [HACKERS] OLE DB driver

2004-01-11 Thread Robert Treat
for the project. I don't think there is an official policy on this, but this seems like a reasonable request as long as your willing to either update the old code or leave it as it's own seperate module within the cvs tree. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware

Re: [HACKERS] Permissions and PGSQL

2004-01-11 Thread Robert Treat
privileges lying around, but I've never had enough motivation to do the other, more complicated half... Is there a TODO and TODO.detail warrented here? Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast

Re: [HACKERS] OLE DB driver

2004-01-12 Thread Robert Treat
Chris, do you have any additional info (email?) on how to contact the original project admin? Is it possible for you to manually set up Shachar as admin on the project? Robert Treat On Monday 12 January 2004 04:30, Shachar Shemesh wrote: Robert Treat wrote: Can you fill us in on your

Re: [HACKERS] set search_path and pg_dumpall

2004-01-16 Thread Robert Treat
I can't be the only one forsee frustration from users who typo the set search_path statement and then can't figure out why their tables aren't showing up... can we emit a warning that not all of the schemas in the search path were found? Robert Treat On Fri, 2004-01-16 at 06:47, [EMAIL

Re: [HACKERS] Strange COPY from problem (resent)

2004-01-19 Thread Robert Treat
It's not ideal, but can you dump those tables using INSERT commands and load them into your database? Robert Treat On Wednesday 14 January 2004 13:53, [EMAIL PROTECTED] wrote: Hi all, I resend this mail because I didn't have any answer; I still did'nt find any solution, the same line

Re: [HACKERS] LWLock/ShmemIndex startup question

2004-01-27 Thread Robert Treat
with their packages, though it's based on 7.2 according to the author. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] Recursive queries?

2004-02-04 Thread Robert Treat
. If this patch has a serious chance I'd like to do some investigation and some real-world data testing. Seems it has no chance of getting in as it is GPL'd code... so step one would be convincing him to relicense it. As a side note, I thought Joe Conway also had an implementation of this... Robert

Re: [HACKERS] Preventing duplicate vacuums?

2004-02-06 Thread Robert Treat
would agree for sure, but i the second vacuum could see that it is being blocked by the current vacuum, exiting out would be a bonus, since in most scenarios you don't need to run that second vacuum so it just ends up wasting resources (or clogging other things up with it lock) Robert Treat -- Build

Re: [HACKERS] Preventing duplicate vacuums?

2004-02-09 Thread Robert Treat
On Sat, 2004-02-07 at 02:07, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: Don't know if I would agree for sure, but i the second vacuum could see that it is being blocked by the current vacuum, exiting out would be a bonus, since in most scenarios you don't need to run that second

Re: [HACKERS] MS SQL features for new version

2004-02-10 Thread Robert Treat
was trying to decide how much better this was than BEGIN; DROP INDEX foo ON bar; CREATE INDEX foo ON bar; COMMIT; Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 9: the planner

Re: [HACKERS] MS SQL features for new version

2004-02-10 Thread Robert Treat
On Tue, 2004-02-10 at 15:40, Rod Taylor wrote: On Tue, 2004-02-10 at 15:37, Robert Treat wrote: On Tue, 2004-02-10 at 13:20, Rod Taylor wrote: http://www.microsoft.com/sql/yukon/productinfo/top30features.asp Notice the Snapshot Isolation. Sounds like MVCC for MSSQL? Actually

Re: [HACKERS] RFC: Security documentation

2004-02-15 Thread Robert Treat
it to determine what should or should not be added to the standard docs. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] No Timeout in SELECT..FOR UPDATE

2004-02-16 Thread Robert Treat
is a lock_timeout, which times out soley for cases where the lock can not be aquired in a speedy manner. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] [Resend: Domains and function]

2004-02-20 Thread Robert Treat
is certainly a deficiency if not a bug. hmm..examples above on 7.3, which didnt support check constraints, so this is potentially different on 7.4. Robert Treat On Thursday 05 February 2004 15:46, elein wrote: I sent this a while ago to general and then hackers and got no response

Re: [HACKERS] [PATCHES] NO WAIT ...

2004-02-20 Thread Robert Treat
the vote. I have updated the TODO list to indicate this. Tatsuo posted a patch to add NO WAIT to the LOCK command, so we will see if we can get that into CVS. Is it premature to add allow vacuum command to use no wait semantics on locks to the TODO list? Robert Treat -- Build A Brighter Lamp

Re: [HACKERS] bgwriter never dies

2004-02-25 Thread Robert Treat
it to durable storage. Yes, roll back any existing/uncommited transactions and shutdown those connections, but make sure that committed transactions are stored on disk before exiting completly. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Re: [HACKERS] [SQL] Materialized View Summary

2004-02-24 Thread Robert Treat
. That's got to be possible in some cases, but I'm not sure how difficult it is to do in all cases. it seems somewhere between Joe Conways work work arrays and polymorphic functions in 7.4 this should be feasible. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Re: [PERFORM] [HACKERS] [SQL] Materialized View Summary

2004-02-25 Thread Robert Treat
On Wed, 2004-02-25 at 03:19, Jonathan M. Gardner wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm not sure if my original reply made it through. Ignore the last one if it did. But I liked the last one :-) On Tuesday 24 February 2004 1:48 pm, Robert Treat wrote: On Tue, 2004

Re: [HACKERS] [pgsql-www] Collaboration Tool Proposal

2004-02-26 Thread Robert Treat
work for us... Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [pgsql-www] [HACKERS] Collaboration Tool Proposal

2004-02-26 Thread Robert Treat
of this move if the larger community does not want to move the main project to a gforge based system? or vice versa? Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 7: don't forget to increase

Re: [HACKERS] [ADMIN] Schema comparisons

2004-02-29 Thread Robert Treat
tool to do it written in perl could certianly be nice. If nothing else you could toss it up on gborg. Incidentally I think there is already a tool that does this on sourceforge, but it uses tcl and requires a running webserver, so it's a little overbearing for most peoples needs imho. Robert

Re: [HACKERS] Check Constraints and pg_dump

2004-03-02 Thread Robert Treat
allow you later to delete the plan without deleting the contract. Wouldn't a FK on both tables be the appropriate schema? With the FK on contract being deffered? Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast

Re: [HACKERS] Regression tests on Nintendo Game Cube

2004-03-04 Thread Robert Treat
Very Cool! Can we add this to the list of supported platforms? Also what do folks think of submitting this as a news blurb to slashdot? This seems like some good feelings type news that is right up thier alley. Robert Treat On Thu, 2004-03-04 at 02:46, Hans-Jürgen Schönig wrote: Folks

Re: [HACKERS] raising the default default_statistics_target

2004-03-09 Thread Robert Treat
into the patch queue, but Tom raised some doubts about it and it was subsequently removed. Robert Treat On Mon, 2004-03-08 at 14:41, Josh Berkus wrote: Tom, Are you sure you're not thinking of stats for functional indexes? Positive.I even remember seeing that the patch was accepted

Re: [HACKERS] Default Stats Revisited

2004-03-11 Thread Robert Treat
number is simpler, though could be convinced to go with whichever is higher... Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

Re: [pgsql-www] [HACKERS] The Name Game: postgresql.net vs.

2004-03-12 Thread Robert Treat
and pgfoundry.com before someone else does. yug... if we go with postgres.org|net|com we are just asking for the press to keep referring to the product as postgres instead of postgresql, so i'd strongly be against that idea. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware

Re: [HACKERS] The Name Game: postgresql.net vs. pgfoundry.org

2004-03-12 Thread Robert Treat
that. (breaking previous rule) I agree. Also, the gforge people would prefer us *not* to use a name that includes gforge, because of the risk of confusion. That's how we came up with pgfoundry in the first place. maybe pgsqlfoundry is a better compromise? Robert Treat -- Build A Brighter

Re: [HACKERS] PITR Functional Design v2 for 7.5

2004-03-12 Thread Robert Treat
as to Richards. If there are no objections, I'd like to put the first part of this email up on techdocs as an explination of our current crash recovery system. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast

Re: [pgsql-www] [HACKERS] The Name Game: postgresql.net vs.

2004-03-12 Thread Robert Treat
in this ointment, but wouldn't project.projects.postgresql.org be better? especially if you could then point people to projects.postgresql.org as the main place to start looking for projects related to postgresql. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Re: [HACKERS] Log rotation

2004-03-13 Thread Robert Treat
there with recreate cron, another feature many people think an enterprise database has to have. Personally I think in place upgrades are far, far more important than either of those two, to both end users and to the development community. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware

Re: [HACKERS] Log rotation

2004-03-14 Thread Robert Treat
. Yep. The other basic thing I recomend is putting syslog/log output on a different disk than where your data goes. Maybe not proactical for everyone, but not a big deal for enterprise level users (which was the op's target audience) Robert Treat -- Build A Brighter Lamp :: Linux Apache

Re: [HACKERS] Some one deleted pg_database entry how to fix it?

2004-03-16 Thread Robert Treat
Try doing a vacuum full on template1 and restart the database. I've had to do this before after renaming a database via the system catalogs. Robert Treat On Tue, 2004-03-16 at 12:05, Dave Cramer wrote: Tom, Thanks, first of all it wasn't my mess, but someone elses. Secondly this worked

Re: [HACKERS] postgres on windows page update

2004-03-23 Thread Robert Treat
Those pages are wiki based, so anyone can add content to them as they see fit. Robert Treat On Tue, 2004-03-23 at 09:54, Shachar Shemesh wrote: Hi, I'm wondering who's doing the PostgreSQL on Windows page (http://techdocs.postgresql.org/guides/Windows). I wanted to offer to add the OleDB

Re: [HACKERS] bug in 7.4 SET WITHOUT OIDs

2004-03-23 Thread Robert Treat
on columns when dropping columns without even a notice. Point being that in the original case, I think the index on the oid column should be dropped automagically, to follow similar behavior with normal columns. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Re: [HACKERS] Log rotation

2004-03-25 Thread Robert Treat
for this? After all, nobody has to use it if they don't want to. Shouldn't all of these just be on gborg? Some could simply be an article/guide on techdocs and/or a chapter in the docs... how to use postgresql with apache logrotate for example Robert Treat -- Build A Brighter Lamp :: Linux Apache

Re: [HACKERS] pg_advisor schema proof of concept

2004-03-25 Thread Robert Treat
is just an info. Are you planning on making some type of differentiation on advise that is performance based rather than advise that is theory based? I see both cases being hinted at and it seems like a subtle but important piece of information... Robert Treat -- Build A Brighter Lamp :: Linux

Re: [HACKERS] Solaris initdb fails: shmmax tweak alternative?

2004-04-06 Thread Robert Treat
Anyone see a benefit of adding command line flags to initdb to force lower shared memory use without require a recompile? Robert Treat On Mon, 2004-04-05 at 08:53, Andrew Dunstan wrote: Greg Sabino Mullane said: Having to recompile initdb.c is probably not an option. Which version

Re: [HACKERS] pg_hba.conf view from the database?

2004-04-06 Thread Robert Treat
postgresql.conf info database side. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL

Re: [HACKERS] PostgreSQL configuration

2004-04-08 Thread Robert Treat
postgresql.confs on a server tuned to specific tasks at hand... ie one for a pg_restore vs. one for normal operations... it would be nice to point the db at a specific one rather than having to copy files back and forth. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware

Re: [HACKERS] PostgreSQL configuration

2004-04-12 Thread Robert Treat
certainly be a bonus... and this would have also solved the original complaint of not knowing where the $PGDATA path was... connect to the database and query for it... Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast

Re: [HACKERS] PostgreSQL configuration

2004-04-13 Thread Robert Treat
for store the PGDATA dir value inside a running postgresql so you can query the running database to find out what datafiles it is using. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: you

Re: [HACKERS] [pgsql-advocacy] Analysis/Overview of PostgreSQL and SQL2003

2004-04-14 Thread Robert Treat
in other more marketing oriented venues. Any plans to update the docs as well? Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

Re: [HACKERS] pgmex, a MATLAB interface for PostgreSQL

2004-04-14 Thread Robert Treat
On Thursday 01 April 2004 12:52, Tony Reina wrote: Last link was wrong. Here's the correct one. http://www.dertech.com/pgmex/pgmex.html Updated website code in CVS, should appear after the next update/build cycle. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-22 Thread Robert Treat
that it's a radical departure from the way things have always been done and I'm not confident that there would be enough support to make the changes. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast

Re: [HACKERS] pg_encoding not needed anymore

2004-04-22 Thread Robert Treat
deprecated ;-) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Robert Treat
but not the other, which is bad practice anyways... so i would say if your serious about it, make the patch as GUC case_folding for upper or lower and get a taste for what breaks inside the db. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-23 Thread Robert Treat
On Fri, 2004-04-23 at 11:02, Rod Taylor wrote: On Thu, 2004-04-22 at 23:05, Robert Treat wrote: On Thursday 22 April 2004 13:55, Barry Lind wrote: I think the solution lies in improving www.postgresql.org. At the end of the day it doesn't matter where source code lives, what matters

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Robert Treat
initdb time... of course you could just create duplicates of all the functions in both upper and lower case, that way whichever way you fold it matches :-) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

2004-04-23 Thread Robert Treat
On Fri, 2004-04-23 at 14:28, Andrew Dunstan wrote: Robert Treat wrote: of course you could just create duplicates of all the functions in both upper and lower case, that way whichever way you fold it matches :-) That strikes me as an instant recipe for shooting yourself in the foot

Re: [HACKERS] Do we prefer software that works or software that looks good?

2004-04-24 Thread Robert Treat
studied software useability will know that uppercase should, in general, be avoided as it hurts readability. It isn't about looking pretty, it's about being more usable. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast

Re: [HACKERS] Do we prefer software that works or software that looks good?

2004-04-24 Thread Robert Treat
On Saturday 24 April 2004 08:09, Shachar Shemesh wrote: Robert Treat wrote: Anyone who has studied software useability will know that uppercase should, in general, be avoided as it hurts readability. You convinced me! let's change the SQL standard. We plan to, right after we have

Re: [HACKERS] Do we prefer software that works or software that looks good?

2004-04-24 Thread Robert Treat
On Saturday 24 April 2004 09:21, Shachar Shemesh wrote: Robert Treat wrote: Oh well... let's see if we can find a way to support both... You are welcome to join the other leg of this thread, then. That one is not CCed to advocacy, as it is 100% technical. I'm already there... Robert Treat

Re: [HACKERS] ALTER TABLE TODO items

2004-05-06 Thread Robert Treat
cascade drop triggers as an option so you can still do it in one line should you want to? What about rules/views/functions and who knows what else (domains?) might be dependant on the current type definition? It seems like a pretty big can of worms really. Robert Treat -- Build A Brighter Lamp

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

2004-05-04 Thread Robert Treat
this to PHP's adoption rate over Java and .net, but your comment made me think this really applies to my$ql and postgresql as well. check out http://www.sitepoint.com/forums/showpost.php?p=1121502postcount=2 for a bit more. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware

Re: [HACKERS] ALTER TABLE TODO items

2004-05-05 Thread Robert Treat
to implement the reordering functionality... ie. rewrite the table and fix up any dependencies as needed. way to back track on myself eh? Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Robert Treat
this over the weekend... if nested transactions doesn't make it into 7.5, does this mean that we won't get 2PC either? Seems that would be a shame if we have a 2PC patch that is ready to go... Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Robert Treat
branch. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Call for 7.5 feature completion

2004-05-19 Thread Robert Treat
is an alpha build of the win32 version once the folks developing it feel it's stable enough to merit such a thing... Course as Bruce mentioned in a post somewhere 'round here, testing is not the real deficiency here, people who can help code is. Robert Treat -- Build A Brighter Lamp :: Linux Apache

Re: [HACKERS] Call for 7.5 feature completion

2004-05-21 Thread Robert Treat
of the OS it runs on, but we still want to make it as solid as possible. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] Reconstructing FKs in pg_dump

2002-09-26 Thread Robert Treat
to think of the cases where this extraction might fail, but maybe more important is what happens if it does fail? Robert Treat ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Reconstructing FKs in pg_dump

2002-09-26 Thread Robert Treat
On Thu, 2002-09-26 at 17:22, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: I'm trying to think of the cases where this extraction might fail, but maybe more important is what happens if it does fail? Then you have broken RI triggers ... which is the problem now. Uh...yeah, I

Re: [HACKERS] [PHP] WebDB Developers Wanted

2002-09-27 Thread Robert Treat
AFAIK it's because it is a members-only list. It is archived and the archives are web viewable if you know where to look (not that I can remember, but I have done it before). Robert Treat On Fri, 2002-09-27 at 02:48, Markus Bertheau wrote: On Mon, 2002-09-16 at 10:52, Christopher Kings-Lynne

Re: [HACKERS] Large databases, performance

2002-10-03 Thread Robert Treat
the vacuum after each insert is unnecessary, unless your also deleting/updating data behind it. Perhaps just running an ANALYZE on the table would suffice while reducing overhead. Robert Treat On Thu, 2002-10-03 at 08:36, Shridhar Daithankar wrote: Machine

Re: [HACKERS] Little note to php coders

2002-10-08 Thread Robert Treat
This is one of the reasons I usually recommend running with magic quotes on, it provides a bit of insurance for those spots where your data validation is not up to snuff. Robert Treat On Tue, 2002-10-08 at 06:11, Nigel J. Andrews wrote: On Tue, 8 Oct 2002, Sir Mordred The Traitor wrote

Re: [HACKERS] [GENERAL] Postgres-based system to run .org registry?

2002-10-14 Thread Robert Treat
. (wink wink) should come up with a press release. Robert Treat - Original Message - From: David De Graff [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, October 14, 2002 3:42 PM Subject: [GENERAL] Postgres-based system to run .org registry

Re: [HACKERS] Postgresql and multithreading

2002-10-16 Thread Robert Treat
, regardless if they're released separately as add-on patches or not. I'm pretty sure BSD allows you to relicense derived code as you see fit. However, any derived project that was released GPL would have a hell of a time ever getting put back into the main source (short of relicensing). Robert Treat

Re: [HACKERS] Vacuum improvement

2002-10-16 Thread Robert Treat
it to 1.1 MB. I am running 7.2.0 (all my vacuuming is done by superuser). Not that I'm against the idea, but isn't this just a sign that your just not vacuuming frequently enough? Robert Treat ---(end of broadcast)--- TIP 3: if posting/reading

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

2002-10-16 Thread Robert Treat
Perhaps one could just create a PostgreSQL Powertools section on techdocs, naming the packages and where to get them. This would eliminate the need to maintain a package that just duplicates other packages... Robert Treat On Wed, 2002-10-16 at 16:00, Justin Clift wrote: Thomas Swan wrote

Re: [HACKERS] [GENERAL] Security implications of (plpgsql) functions

2002-10-21 Thread Robert Treat
I've seen the idea of user resource limits bandied about before as a way to address these problems; depending on implementation that might be the way to go. Robert Treat On Mon, 2002-10-21 at 12:44, Tom Lane wrote: Joe Conway [EMAIL PROTECTED] writes: Is there any way to recognize infinite

Re: [HACKERS] idle connection timeout ...

2002-10-25 Thread Robert Treat
user... Robert Treat ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

  1   2   3   4   5   6   7   8   9   >