[PATCHES] note on dropped columns in pg_attribute

I didn't see it documented anywhere that a 0 in attypid of pg_attribute, and given the note on the need to match pg_type lest failure seems to warrant the mention. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: src/include/catalog/pg_attribute.h

Re: [PATCHES] note on dropped columns in pg_attribute

On Friday 05 September 2003 16:24, Peter Eisentraut wrote: Robert Treat writes: I didn't see it documented anywhere that a 0 in attypid of pg_attribute, and given the note on the need to match pg_type lest failure seems to warrant the mention. A column is dropped if and only

[PATCHES] akward wording in autovacuum README

Change some awkward wording in the pg_autovacuum README file. I really only read this because of Niel :-) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: README.pg_autovacuum === RCS file

[PATCHES] beta5 references beta4 in INSTALL

better late than never? Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: INSTALL === RCS file: /projects/cvsroot/pgsql-server/INSTALL,v retrieving revision 1.91 diff -c -r1.91 INSTALL *** INSTALL

Re: [PATCHES] minor cleanup in plpgsql.sgml

Sorry Neil. I thought I recalled you submitting a similar patch, but must have missed it in the archives and didn't see the change reflected in cvs so assmeme'd that your change was in a different place.. :-( Robert Treat On Tue, 2003-11-25 at 14:04, Neil Conway wrote: Robert Treat [EMAIL

Re: [PATCHES] minor cleanup in plpgsql.sgml

version of that statement. Robert Treat On Tuesday 25 November 2003 20:30, Christopher Kings-Lynne wrote: Ummm - surely the original was correct? Chris Robert Treat wrote: Marcos Truchado [EMAIL PROTECTED] reported this on -docs yesterday. Robert Treat

Re: [PATCHES] FAQ updates

I think I can work that up. Out of curiosity are the plain text files generated from the html files? Also I noticed that not all plain text FAQ's have html FAQ's associated with them... is that by design or just the fact that no one has bothered to bring them up to speed? Robert Treat On Fri

Re: [PATCHES] [HACKERS] Is trust really a good default?

databases but must come through ident on a unix socket. Different strokes for different folks eh? Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: you can get off all lists at once

[PATCHES] minor doc change

This patch makes mention to use the newer pg_dump when migrating, as suggested by a few folks. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: backup.sgml === RCS file: /projects/cvsroot/pgsql

[PATCHES] FAQ update

added question on website development -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: FAQ.html === RCS file: /projects/cvsroot/pgsql/doc/src/FAQ/FAQ.html,v retrieving revision 1.227 diff -c

[PATCHES] Give the TODO list a little more verbose explanation

People seem to get confused about just what the TODO list is, this patch gives a more verbose explanation of how it works. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: TODO === RCS file

Re: [PATCHES] Give the TODO list a little more verbose explanation

This is certainly nicer than what I had. This seems to be mostly a copy/paste change, but if I need to submit a new patch lmk. Robert Treat On Saturday 13 November 2004 03:57, Gavin Sherry wrote: Robert, I think there are some mistakes with your addition. Here's a reworked paragraph

[PATCHES] default timezone in postgresql.conf

Changes the doc's to reflect what the user will find as default. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: runtime.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/runtime.sgml,v

[PATCHES] small typo in create user --help

I guess this has to be saved for 8.1... shame. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: createuser.c === RCS file: /projects/cvsroot/pgsql/src/bin/scripts/createuser.c,v retrieving

Re: [PATCHES] Continue transactions after errors in psql

a revised patch which fixes the problem, however I'm sure there is a better way. Thanks to Neil for putting up with me on irc :-) -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: command.c === RCS file

Re: [PATCHES] Continue transactions after errors in psql

our 'don't begin things with pg_' philosophy. I was actually thinking of calling it something like pg_xact-start-time thinking that would be pretty unique within a transaction, though having a specific documented name seemed ok too. Robert Treat -- Build A Brighter Lamp :: Linux Apache

[PATCHES] Update to download info in install docs

Inspired by comments from steve [EMAIL PROTECTED], adds a few urls for more download options. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: installation.sgml === RCS file: /projects/cvsroot

[PATCHES] update some urls

This patch updates a number of urls in a number of files. Most are just poinitng to the TODO list within the main website. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ? url_update.patch Index: doc/src/FAQ/FAQ.html

Re: [HACKERS] [PATCHES] Continue transactions after errors in psql

people coming from other dbs where this behavior is more common who might in fact expect it to work this way. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 9: the planner will ignore

[PATCHES] Problem with Create Domain example

. Oh.. and Andrew @ Supernews had nothing to do with this ;-) -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: create_domain.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref

Re: [PATCHES] Problem with Create Domain example

On Saturday 30 April 2005 21:14, Alvaro Herrera wrote: On Sat, Apr 30, 2005 at 06:12:27PM -0400, Robert Treat wrote: --- 167,174 programlisting CREATE DOMAIN us_postal_code AS TEXT CHECK( !VALUE ~ '^\\d{5}$' ! OR VALUE ~ '^\\d{5}-\\d{4}$' ); Huh, why not VALUE

Re: [PATCHES] Problem with Create Domain example

On Sunday 01 May 2005 11:58, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: The example given in create domain seems to be broken. ISTM it requires some extra escaping to be usable (at least in my goings on today it sure was, and I the entries in pg_constraint sure seem to indicate

[PATCHES] add navigation links for domains

A couple of the domain commands were missing see also references, this patch adds those references. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: alter_domain.sgml === RCS file: /projects

Re: [PATCHES] psql backslash consistency

for showing only user-defined functions or types by default. I think consistency is not necessarily desirable here. See the archives for previous discussion and/or use cases. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end

Re: [PATCHES] psql backslash consistency

On Friday 27 May 2005 15:09, Peter Eisentraut wrote: Robert Treat wrote: I see hardly any use case for showing only user-defined functions or types by default. I think consistency is not necessarily desirable here. See the archives for previous discussion and/or use cases. I

Re: [PATCHES] psql backslash consistency

it shouldn't be a barrier to having the current patch be applied. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PATCHES] psql backslash consistency

On Saturday 28 May 2005 11:12, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: I'm not against the idea of a config variable, but this is what, the third or fourth go around on this? It seems rather unfair to put this burden upon the current patch writer at this stage of the game

[PATCHES] really minor sgml change

Found this in my cvs tree, guess I should submit it. Should give the proper tagging for the compatability section of the alter domain page -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: alter_domain.sgml

Re: [HACKERS] [PATCHES] Dbsize backend integration

. Just my .02 :-) -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [HACKERS] [PATCHES] Dbsize backend integration

On Monday 04 July 2005 13:25, Bruce Momjian wrote: Robert Treat wrote: Actually I'd agree with Tom, pg_dbfile_size is ugly, and suggest to me I could use a filename as an argument. ISTM that if we think that functions like pg_database_size and pg_tablespace_size all make sense

Re: [PATCHES] 5 new entries for FAQ

#SQL-SYNTAX-IDENTIFIERS Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED

Re: [PATCHES] [DOCS] PostgreSQL 8.0.3 Documentation - Chapter 30. The Information Schema

instances of this and didnt find any... attached is a patch to correct this one. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: information_schema.sgml === RCS file: /projects/cvsroot/pgsql/doc/src

Re: [PATCHES] [HACKERS] Improved \df(+) in psql + backward-compatibility

the time to start making that happen. That said, number of folks have looked at this problem and agree it would be nice to do, they just haven't formed a consensus on how to do it. If you have a plan for how you would want to approach this in 8.2, feel free to post it. -- Robert Treat Build

[PATCHES] small changes to autovacuum maintainance

afaict) and looking in pg_settings there would be no indication that anything was wrong, other than autovacuum being set to off (perhaps if it was set to 'error, stats disabled' or some such it might be better?) -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index

Re: [PATCHES] default resource limits

installations are not production webservers). There is also the argument to be made that just because systems these days have more memory doesn't mean we have to use it. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast

Re: [PATCHES] [HACKERS] Patch Submission Guidelines

On Tuesday 14 February 2006 20:42, Robert Treat wrote: On Tuesday 14 February 2006 16:00, Martijn van Oosterhout wrote: I would like to suggest that we increase substantially the FAQ entries relating to patch submission. By we, I actually mean please could the committers sit down

Re: [PATCHES] [HACKERS] Patch Submission Guidelines

On Thursday 16 February 2006 00:27, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: ! liThe patch should be generated in contextual diff format and should !be applicable from the root directory. If you are unfamiliar with ! this, you might find

Re: [PATCHES] [HACKERS] Patch Submission Guidelines

On Thursday 16 February 2006 00:27, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: As stated, the following patch adds a list of patch submission guidelines based on Simon Riggs suggestions to the developers FAQ. A couple minor comments ... Attached patch updated based on previous

Re: [PATCHES] [HACKERS] please actualize FAQ, broken urls

is broken, second moved thanks for the report, the attached patch updates that section. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: FAQ.html === RCS file: /projects/cvsroot/pgsql/doc/src/FAQ

[PATCHES] Update link for GUI Tools in FAQ

Attached patch updates FAQ 2.3 updating the link for the GUI Tools page to the new page in the new techdocs, along with some verbage changes. Note this link should be updated by all translators. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: FAQ.html

Re: [PATCHES] [PATCH] Magic block for modules

a good idea, except: where is this info going to be displayed or used? Marko's suggestion on producing a list of installed modules comes to mind, and I suspect tools like pgadmin or ppa will want to be able to show this information. -- Robert Treat Build A Brighter Lamp :: Linux Apache

Re: [PATCHES] [PATCH] Magic block for modules

be nice too) I think we ought to keep in mind the idea of sql based modules. Nothing jumps to mind here ppa wise, but I could see an application looking to see if mysqlcompat was installed before running if it had a good way to do so. -- Robert Treat Build A Brighter Lamp :: Linux Apache

Re: [PATCHES] drop if exists remainder

demand. Let's decide before too much bitrot occurs, though. +1 :) +1 -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[PATCHES] update link / fix spelling error

Updates the link for the sql 2003 spec, also fixes a spelling error. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: FAQ_DEV.html === RCS file: /projects/cvsroot/pgsql/doc/src/FAQ/FAQ_DEV.html,v

[PATCHES] update commercial services link

Updates link to support companies from old techdocs to main website -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL Index: doc/src/FAQ/FAQ.html === RCS file: /projects/cvsroot/pgsql/doc/src/FAQ/FAQ.html

Re: [PATCHES] [DOCS] maintenance diff

a couple of other minor things I noticed too... Joshua, do you mind if I make some changes and resubmit this patch? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 4: Have you searched

Re: [PATCHES] [DOCS] Maintenance and External Projects (try 2)

, including a bunch of stuff already there. However, I do not claim, in any way to be an editor. The following patches provide some editorializing for Joshua's patches. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL Index: doc/src/sgml/external-projects.sgml

Re: [PATCHES] Mark change-on-restart-only values in postgresql.conf

types of configurations? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED

Re: [HACKERS] [PATCHES] extension for sql update

is that group is a small minority of who would benefit from this version of the update command. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [HACKERS] [PATCHES] COPY view

than handwaving... people have also had plenty of time to come up with a replacement if that's what they really wanted. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 4: Have you

[PATCHES] minor editorial of tsearch2 readme

just fixes up a couple of minor points, -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL Index: README.tsearch2 === RCS file: /projects/cvsroot/pgsql/contrib/tsearch2/README.tsearch2,v retrieving

Re: [HACKERS] [PATCHES] Patch(es) to expose n_live_tuples and

be removed yet). Given this patch came from userland, istm people are comfortable enough with this terminology there is no need to change it. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 9

Re: [PATCHES] COPY with no WAL, in certain circumstances

suggest somewhere under chapter 27, with something akin to what we have for documenting lock levels and the different operations that use them. We document the reasons you want to avoid WAL and various operations in the database that do this automagically. -- Robert Treat Build A Brighter LAMP

Re: [PATCHES] COPY with no WAL, in certain circumstances

. Am I overlooking something? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

Re: [pgsql-patches] [PATCHES] Tablespace for temporary objects and

to HEAD, any committer want to review it? Why is this PGC_SUSET? ISTM it should be PGC_USERSET. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

[PATCHES] Fwd: Re: [DOCS] [HACKERS] Broken link in PG docs

in CVS. See attached (btw, this is in the docs back to at least 7.2). -- Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --- -- Robert Treat Build A Brighter

Re: [PATCHES] Fwd: Re: [DOCS] [HACKERS] Broken link in PG docs

On Wednesday 07 February 2007 23:35, Bruce Momjian wrote: Robert Treat wrote: Can someone apply Jim's patch at least to HEAD and REL8_2_STABLE? We recently got a report of a broken link on the website due to this; seems it is still broken... OK, we were aware that the URL was bad

Re: [pgsql-patches] [PATCHES] pg_standby

through to the mailing list cleanly -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 6: explain analyze is your friend

[PATCHES] FAQ_DEV Update: Fix Answer for Q 1.19, add Q on SCMS

Subject pretty much says it all. Somewhere the answer to 1.19 got regurgitated to 2.9, so this corrects that and adds an answer to the SCMS question based on recent hackers thread. -- Robert Treat Database Architect OmniTI Computer Consulting, Inc. -- http://www.omniti.com/ Index

Re: [PATCHES] Have vacuum emit a warning when it runs out of maintenance_work_mem

as well), wouldn't it be better if the warning occured at the end of vacuum, and told you how much memory was actually needed, so you'd know what maintainence_work_mem should be. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end

Re: [PATCHES] [pgsql-www] out of date url in developer faq

) What is configure all about?/h3 pThe files iconfigure/i and iconfigure.in/i are part of --- 512,517 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware

[PATCHES] dblink connection security

Patch based on recent -hackers discussions, it removes usage from public, and adds a note to the documentation about why this is neccessary. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL Index: contrib/dblink/dblink.sql.in

Re: [PATCHES] dblink connection security

On Sunday 01 July 2007 13:15, Gregory Stark wrote: Joe Conway [EMAIL PROTECTED] writes: Robert Treat wrote: Patch based on recent -hackers discussions, it removes usage from public, and adds a note to the documentation about why this is neccessary. I agree with the fix as the simplest

Re: [PATCHES] dblink connection security

to make changes to thier code to live with this. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PATCHES] dblink connection security

On Sunday 01 July 2007 17:59, Joe Conway wrote: Joe Conway wrote: Robert Treat wrote: Joe Conway [EMAIL PROTECTED] writes: Well certainly dbi-link has the exact same issue. dbi-link only works in plperlu, so you've already decided your superuser only. How so

Re: [PATCHES] Lazy xid assignment V4

the transaction column, there is no way to see the XID for relations thats have been updated (which by definition will have locks on them). Am I mis-reading the docs, or have we lost that functionality? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Re: [PATCHES] Expose checkpoint start/finish times into SQL.

to adjust your bgwriter settings, and it is a serious drag to parse postgresql logs for this info. Even if this were true, surely the answer is to improve the logging. Exposing everything into the log files isn't always sufficient (says the guy who maintains a remote admin tool) -- Robert

Re: [PATCHES] Expose checkpoint start/finish times into SQL.

isn't going to tell you much. How does one measure when the bgwriter is failing at this effort? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http

Re: [PATCHES] Expose checkpoint start/finish times into SQL.

On Friday 04 April 2008 00:09, Greg Smith wrote: On Thu, 3 Apr 2008, Robert Treat wrote: You can plug a single item graphed over time into things like rrdtool to get good trending information. And it's often easier to do this using sql interfaces to get the data than pulling it out of log

Re: [PATCHES] Expose checkpoint start/finish times into SQL.

of a crash 6) Helps give an indication on if you should enter a manual checkpoint before issuing a pg_start_backup call -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your

Re: [PATCHES] Extending grant insert on tables to sequences

SELECT on table to SELECT on sequence ? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches