[PATCHES] note on dropped columns in pg_attribute

2003-09-04 Thread Robert Treat
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

2003-09-05 Thread Robert Treat
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

2003-10-08 Thread Robert Treat
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

2003-10-23 Thread Robert Treat
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

[PATCHES] minor cleanup in plpgsql.sgml

2003-11-25 Thread Robert Treat
Marcos Truchado [EMAIL PROTECTED] reported this on -docs yesterday. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQLIndex: plpgsql.sgml === RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml

Re: [PATCHES] minor cleanup in plpgsql.sgml

2003-11-25 Thread Robert Treat
On Tue, 2003-11-25 at 11:24, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: ! SELECT INTO users_rec * FROM users WHERE user_id=3; --- 986,993 ! SELECT * FROM users WHERE user_id=3 INTO users_rec; Why do you want to change the example to disagree with the advice given

Re: [PATCHES] minor cleanup in plpgsql.sgml

2003-11-25 Thread Robert Treat
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

2003-11-25 Thread Robert Treat
On Tue, 2003-11-25 at 14:24, Peter Eisentraut wrote: Tom Lane writes: Robert Treat [EMAIL PROTECTED] writes: ! SELECT INTO users_rec * FROM users WHERE user_id=3; --- 986,993 ! SELECT * FROM users WHERE user_id=3 INTO users_rec; Why do you want to change the example

Re: [PATCHES] minor cleanup in plpgsql.sgml

2003-11-25 Thread Robert Treat
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

2004-03-19 Thread Robert Treat
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] new aggregate functions v2

2004-05-04 Thread Robert Treat
these. 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 if your joining column's datatypes do not match

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

2004-07-13 Thread Robert Treat
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

2004-09-29 Thread Robert Treat
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

2004-10-28 Thread Robert Treat
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

2004-11-12 Thread Robert Treat
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

2004-11-13 Thread Robert Treat
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

2004-12-12 Thread Robert Treat
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

2004-12-13 Thread Robert Treat
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

2005-01-27 Thread Robert Treat
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

2005-01-28 Thread Robert Treat
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

2005-03-28 Thread Robert Treat
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

2005-04-09 Thread Robert Treat
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

2005-04-27 Thread Robert Treat
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

2005-04-30 Thread Robert Treat
. 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

2005-04-30 Thread Robert Treat
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

2005-05-01 Thread Robert Treat
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

2005-05-01 Thread Robert Treat
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

2005-05-27 Thread Robert Treat
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

2005-05-27 Thread Robert Treat
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

2005-05-28 Thread Robert Treat
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

2005-05-28 Thread Robert Treat
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

2005-05-31 Thread Robert Treat
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

2005-07-04 Thread Robert Treat
. 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

2005-07-04 Thread Robert Treat
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

2005-08-10 Thread Robert Treat
#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

2005-08-27 Thread Robert Treat
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

2005-08-29 Thread Robert Treat
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

2005-09-15 Thread Robert Treat
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

2005-12-24 Thread Robert Treat
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

2006-02-15 Thread Robert Treat
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

2006-02-16 Thread Robert Treat
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

2006-02-16 Thread Robert Treat
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

2006-04-07 Thread Robert Treat
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

2006-05-31 Thread Robert Treat
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

2006-06-01 Thread Robert Treat
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

2006-06-01 Thread Robert Treat
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

[PATCHES] fix minor spelling issues in FAQ

2006-06-07 Thread Robert Treat
Attached patch fixes a couple of spelling mistakes in the FAQ -- 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

Re: [PATCHES] drop if exists remainder

2006-06-07 Thread Robert Treat
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

2006-06-07 Thread Robert Treat
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

2006-06-30 Thread Robert Treat
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

2006-07-14 Thread Robert Treat
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)

2006-07-14 Thread Robert Treat
, 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

2006-07-22 Thread Robert Treat
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

2006-07-30 Thread Robert Treat
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

2006-08-22 Thread Robert Treat
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

2006-09-25 Thread Robert Treat
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

2006-12-26 Thread Robert Treat
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

2007-01-06 Thread Robert Treat
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

2007-01-06 Thread Robert Treat
. 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

2007-01-17 Thread Robert Treat
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

2007-02-07 Thread Robert Treat
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

2007-02-07 Thread Robert Treat
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

2007-02-16 Thread Robert Treat
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

2007-02-27 Thread Robert Treat
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

2007-05-11 Thread Robert Treat
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

2007-06-16 Thread Robert Treat
) 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

2007-07-01 Thread Robert Treat
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

2007-07-01 Thread Robert Treat
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

2007-07-01 Thread Robert Treat
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

2007-07-01 Thread Robert Treat
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

2007-09-05 Thread Robert Treat
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.

2008-04-03 Thread Robert Treat
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.

2008-04-03 Thread Robert Treat
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.

2008-04-03 Thread Robert Treat
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.

2008-04-04 Thread Robert Treat
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

2008-05-29 Thread Robert Treat
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