Re: [HACKERS] blatantly a bug in the documentation

/frs/download.php/1719/pagila-0.10.1.zip), which i think devrim may have packaged into an rpm; it wouldn't hurt to add it to the win32 installer, but would you feel better if it were a contrib module or something? -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http

Re: [HACKERS] Column reordering in pg_dump

a COPY without columns names in the data dump; but that only arises with version 7.3. yeah, i remember using that trick a lot... ah the good ole days :-P -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Final /contrib cleanup -- yes/no?

changing the install schema will break them right now (i think intarray is an example of one) -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Hot Standby utility and administrator functions

we need? Is it possible to give the master/slave knowledge about each other? -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Hot Standby utility and administrator functions

On Monday 27 October 2008 12:12:18 Simon Riggs wrote: On Mon, 2008-10-27 at 11:42 -0400, Robert Treat wrote: On Monday 20 October 2008 05:25:29 Simon Riggs wrote: I'm looking to implement the following functions for Hot Standby, to allow those with administrative tools or management

Re: [HACKERS] TODO item: adding VERBOSE option to CLUSTER [with patch]

in 6 pages -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] The Axe list

like intagg to stay in contrib. While I agree that the right solution would be to make this code work more generally for other aggregates, I also think that until someone is willing to do that work, this needs to stay in contrib, and that we ought to accept patches improving it. -- Robert Treat

Re: [HACKERS] FSM rewrite committed, loose ends

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

Re: [HACKERS] Block-level CRC checks

to do a migration or something ;-) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Function management in PG

://phppgadmin.sourceforge.net/ (2) https://labs.omniti.com/trac/pgsoltools/wiki/getddl -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Block-level CRC checks

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

Re: [HACKERS] Hot Standby Design

On Wednesday 24 September 2008 03:27:44 Simon Riggs wrote: On Wed, 2008-09-24 at 00:30 -0400, Robert Treat wrote: here are some scattered thoughts i had while reading it : Thanks for your comments. It is very detailed, so further feedback is going to be very beneficial in making this all

Re: [HACKERS] Hot Standby Design

. * The following commands will not be accepted during recovery mode GRANT, REVOKE, REASSIGN How is user management done on a standby? can you have users that dont exist on the primary (it would seem not). ... more to come i'm sure, but fading out... thanks again for the work so far Simon. -- Robert

Re: [HACKERS] Where to Host Project

On Friday 19 September 2008 14:05:36 David E. Wheeler wrote: On Sep 18, 2008, at 18:43, Robert Treat wrote: * Google Code does not offer mailing lists I get mail for the test-more project there. It's through Google Groups, which is a little weird, but works. I didn't think

Re: [HACKERS] 8.3.1 autovacuum stopped doing anything months ago

SIGSTOP idea dangerous? If Heikis solution applies, it's better (see also vacuum_freeze_min_age) , but if its too late for that, you can go into single user mode, which will prevent autovacuum; it's a bit more heavy handed though. -- Robert Treat Build A Brighter LAMP :: Linux Apache

Re: [HACKERS] Where to Host Project

they are. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Transaction Snapshots and Hot Standby

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

Re: [HACKERS] [PATCH] Cleanup of GUC units code

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

Re: [HACKERS] [patch] GUC source file and line number

edit it). If I have read this patch right, anything commented out (aka all of our default values) will emit null in these fields... right? Trying to decide just how helpful this will actually be for tool writers. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Re: [HACKERS] initdb change

directory would be helpful. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: Does anything dump per-database config settings? (was Re: [HACKERS] ALTER DATABASE vs pg_dump)

are not dumped with the other installation wide settings. Meaning that pg_dumpall -g has no bearing on the alter database commands being set, you actually have to dumpall the entire data set to get those lines. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Re: [HACKERS] A smaller default postgresql.conf

On Wednesday 20 August 2008 02:22:26 Jaime Casanova wrote: On Tue, Aug 19, 2008 at 9:40 PM, Tom Lane [EMAIL PROTECTED] wrote: Robert Treat [EMAIL PROTECTED] writes: I'd still like to see us adopt the proposal from some time ago where we stop commenting out the parameters at all, but short

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make the pg_stat_activity view call a SRF

pg_get_keywords() works but SELECT * FROM pg_show_all_settings() does not. If this isn't critical, and no one is working on it yet, I can see about whittling away at it for 8.4. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers

Re: [HACKERS] Adjusting debug_print_plan to be more useful by default

be turning this off? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] A smaller default postgresql.conf

. If people really don't like large conf files, it is far easier to delete entries than it is to add them... Greg Mullane had it right, and Greg Smith was not too far off the mark either. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers

Re: [HACKERS] any psql static binary for iphone ?

, I'd be happy to spend some time making this work better. :-) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] temporary statistics option at initdb time

as PGC_SIGHUP, and a change to the location would move the file on-the-fly as they say. (There might be practical limitation to making that work, but it would certainly be simpler for admins, imho) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql

Re: [HACKERS] CommitFest July Over

On Tuesday 05 August 2008 04:36:24 Magnus Hagander wrote: Robert Treat wrote: On Monday 04 August 2008 15:38:35 Josh Berkus wrote: Post-mortem things we've learned about the commitfest are: 1) It's hard to get anything done in June-July. True... vacations and conferences abound

Re: [HACKERS] Mini improvement: statement_cost_limit

On Monday 04 August 2008 03:50:40 daveg wrote: On Sun, Aug 03, 2008 at 10:57:55PM -0400, Robert Treat wrote: ISTR that what ended up killing the enthusiasm for this was that most people realized that this GUC was just a poor tool to take a stab at solving other problems (ie. rate limiting

Re: [HACKERS] Mini improvement: statement_cost_limit

On Monday 04 August 2008 16:49:43 Simon Riggs wrote: On Mon, 2008-08-04 at 14:35 -0400, Robert Treat wrote: On Monday 04 August 2008 03:50:40 daveg wrote: And you'll note, I specifically said that a crude tool is better than nothing. But your completely ignoring that a crude tool can

Re: [HACKERS] Mini improvement: statement_cost_limit

On Monday 04 August 2008 15:56:25 daveg wrote: On Mon, Aug 04, 2008 at 02:35:07PM -0400, Robert Treat wrote: On Monday 04 August 2008 03:50:40 daveg wrote: That's great for you, I am talking in the scope of a general solution. (Note I'd also bet that even given the same hardware

Re: [HACKERS] CommitFest July Over

Managers for each CF... is that not the case? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Mini improvement: statement_cost_limit

are trying to solve, and see if there are better tools they can be given to solve them. Barring that, I suppose a crude solution is better than nothing, though I fear people might point at the crude solution as a good enough solution to justify not working on better solutions. -- Robert Treat Build

Re: [HACKERS] Parsing of pg_hba.conf and authentication inconsistencies

that is just going to break things when the first connection happens. For that matter, why would we ever not want to parse it at HUP time rather than connect time? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] PATCH: CITEXT 2.0 v4

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

Re: [HACKERS] CommitFest rules

, but see up thread where Tom disagreed with this idea. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Solaris ident authentication using unix domain sockets

wonder if there should be additional hurdles in place to enable this on that platform. Note that isn't an objection from me, though I'm curious if any of the Sun guys want to chime in on this. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers

Re: [HACKERS] CommitFest rules

to be better about linking to that and the various commmitfest pages within the wiki itself. Right now it's a bit disorienting trying to find your way around within the wiki itself well, maybe I will get some time to fix that in the next couple of days. -- Robert Treat Build A Brighter

Re: [HACKERS] CommitFest rules

to sound like submitting a patch involves two steps from now on; email to the list, and add your patch to the next commitfest page. Does that sound right? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] CommitFest rules

On Saturday 05 July 2008 18:07:46 Robert Treat wrote: On Thursday 03 July 2008 15:12:08 Joshua D. Drake wrote: On Thu, 2008-07-03 at 20:06 +0100, Dave Page wrote: On Thu, Jul 3, 2008 at 8:02 PM, Marko Kreen [EMAIL PROTECTED] wrote: On 7/3/08, Dave Page [EMAIL PROTECTED] wrote

Re: [HACKERS] Commitfest status?

put your names on the stuff you know you can review now. Note that Robert Lor has an updated patch for the dtrace probes that we have seen over here @ omniti, but I don't think he has posted it yet, so it isn't reflected in the wiki... Robert, care to post that? -- Robert Treat Build

Re: [HACKERS] DTrace probes.

the July commitfest entry to point to this patch, case anyone wants to review it. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL Index: src/backend/access/transam/clog.c === RCS file: /projects/cvsroot

Re: Does anything dump per-database config settings? (was Re: [HACKERS] ALTER DATABASE vs pg_dump)

are creating the database manually. (Now, one might argue that you could still dump with --create and ignore the error of the database creation command, but that probably isn't ideal). -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers

Re: [HACKERS] A new take on the foot-gun meme

it interferes with your golf game. https://www.redhat.com/archives/fedora-devel-list/2008-June/msg01501.html So is that a golf club gun? Careful what you wish for http://www.totallyabsurd.com/12gaugegolfclub.htm -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Re: Does anything dump per-database config settings? (was Re: [HACKERS] ALTER DATABASE vs pg_dump)

of people I have talked to, but I don't have much hope in seeing the behavoir change... perhaps someday if we get around to merging pg_dump and pg_dumpall -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] ...Roll Back issue in PGSQL..

part fails, they all fail. Well, wrapping the bits of table2 in a beginexception block would allow him to do what he wants. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Backend Stats Enhancement Request

there are other places this might manifest itself besides pg_stat_activity... I'm struggling to come up with something other than our custom dtrace prob... ah, well, this will also control the size of statement written into the logfile right? So we might want to take that into account. -- Robert Treat

Re: [HACKERS] Crash in pgCrypto?

for years now, while module support is still vaporware. However, I am looking forward to your patch. :-) BTW, I am suspecting part of your support will be giving pg_dump -m and -M flags to control dumping or ignoring of specific modules? -- Robert Treat Build A Brighter LAMP :: Linux Apache

Re: [HACKERS] pg_stat_statements

On Sunday 15 June 2008 22:31:59 ITAGAKI Takahiro wrote: Robert Treat [EMAIL PROTECTED] wrote: On Friday 13 June 2008 12:58:22 Josh Berkus wrote: I can see how this would be useful, but I can also see that it could be a huge performance burden when activated. So it couldn't be part

Re: [HACKERS] How to Sponsor a Feature

plenty of ways to list your contributors. Also, don't forget we allow contributors to list companies next to thier names if they so desire. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Crash in pgCrypto?

with this if we ever decide to make it the default setup) /broken record -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] pg_stat_statements

nicer than doing the whole logging/analyze piece. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Overhauling GUCS

ISTM we need something that can run inside the db as well, i'm thinking something like pg_check_conf() to go with pg_reload_conf(). Also, these should probably check validity of the pg_hba.conf as well. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent

[HACKERS] default client encoding in postgresql.conf

will be in, but since it does know what encoding template0 friends will be in, and most databases are copied from those (including encoding), wouldn't a better default be to set it the encoding of template0? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via

Re: [HACKERS] default client encoding in postgresql.conf

On Thursday 12 June 2008 17:38:26 Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: looking in my freshly installed 8.3.3, I see this in the postgresql.conf #client_encoding = sql_ascii# actually, defaults to database

Re: [HACKERS] default client encoding in postgresql.conf

On Thursday 12 June 2008 21:11:57 Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: looking in my freshly installed 8.3.3, I see this in the postgresql.conf #client_encoding = sql_ascii# actually, defaults to database # encoding But isn't putting a default

Re: [HACKERS] pg_dump restore time and Foreign Keys

(to handle normal constraint, not null constraints, etc...), it would certainly be a big win, and i think most would see it as a reasonable compromise. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] pg_dump restore time and Foreign Keys

the check. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Overhauling GUCS

On Sunday 08 June 2008 19:07:21 Gregory Stark wrote: Joshua D. Drake [EMAIL PROTECTED] writes: On Fri, 2008-06-06 at 20:19 -0400, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: Actually, the reason it's still 10 is that the effort expended to get it changed has been *ZERO*. I

Re: [HACKERS] pg_dump restore time and Foreign Keys

On Sunday 08 June 2008 20:12:15 Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: and i'm sure no one is against that idea, but you're never going to be able to match the performance of just avoiding the check. We'll never be able to match the performance of not having transactions

Re: [HACKERS] pg_dump restore time and Foreign Keys

actually) and it really helps working around having to hold locks on large relations for lengthy periods of times. Heck, I'd like to see a no check option for all constraints really. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing

Re: [HACKERS] New DTrace probes proposal

that needs to be distriubuted with the core? I'd lean towards reviving the dtrace project on pgfoundry, but it might be worth expanding the dynamic tracing chapter to include more examples and a pointer to pgfoundry. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware

Re: [HACKERS] Overhauling GUCS

On Wednesday 04 June 2008 15:48:47 Andrew Dunstan wrote: simply remove all the comment lines from your config file. +1. That would clear up a lot of confusion on it's own. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Overhauling GUCS

other DB's strictly through graphical interfaces (something we are rather lacking in ability to do comparativly). consider also that if this is built atop the current pg_settings, all the normal sql tools can still help... ie. pg_dump -t if you want to check something into svn. -- Robert

Re: [HACKERS] Overhauling GUCS

buffer restart scenario). I think most of the user base would like to approach administration from that point-of-view, and as of yet I haven't seen a technical reason why that world view is wrong, only philosphical ones. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware

Re: [HACKERS] Overhauling GUCS

something showed up... you could probably find that in the archives if you look around. of course to me this sounds like an excellent idea for a dtrace probe ;-) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Overhauling GUCS

to just populate the search bot with every guc anchored to family though... -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Overhauling GUCS

making the change though... not sure in which way you would slant the output though. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] New DTrace probes proposal

On Friday 06 June 2008 14:32:27 Robert Lor wrote: Robert Treat wrote: certainly by the time 8.4 ships, these should work with freebsd I'd think. ideally we would need to confirm this by release time, certainly getting a bsd buildfarm member to compile with them would be a start (and very

Re: [HACKERS] rfc: add pg_dump options to dump output

On Tuesday 03 June 2008 01:17:43 Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: Anyone see any issues with this? I'm a bit worried about breaking diff-equality of matching dumps, If you are calling pg_dump with different flags, it seems likely your breaking diff equality anyway so

[HACKERS] rfc: add pg_dump options to dump output

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

Re: [HACKERS] Core team statement on replication in PostgreSQL

beyond 8.4. Now it is possible that the time frame could be sooner, but unless someone already has the patch, this reminds me a little too much of the arguments for including windows support in a single release because we already had a work port/patch set to go from. -- Robert Treat Build

Re: [HACKERS] Core team statement on replication in PostgreSQL

. (Note I say address, not solve). -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Core team statement on replication in PostgreSQL

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

Re: [HACKERS] Core team statement on replication in PostgreSQL

bits. Seems like more work with less upside that read-only slaves vs. pitr warm standby we have now. Interesting that core views this differently. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] New DTrace probes proposal

party uptake of the set, it might be better to get something in sooner rather than later, so yes, we'd be happy to see the patch set adopted upstream./chime -- Robert Treat Database Architect http://www.omniti.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] odd output in restore mode

it can be deleted. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Syntax decisions for pl/pgsql RAISE extension

it in C, but there are lot of users, that could use only plpgsql. I think nod's toward PL/SQL compatability should be given in general. If people want a PSM style language, let's work on getting pl/psm better maintained or integrated. -- Robert Treat Build A Brighter LAMP :: Linux Apache

Re: [HACKERS] Auto-updated fields

a trigger? I have a generic version of this in pagila. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] statement timeout vs dump/restore

for the backup scenario. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] [PATCHES] GUC parameter cursors_tuple_fraction

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

Re: [HACKERS] MERGE Specification

On Thursday 24 April 2008 23:40, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: Perhaps a better option would be to implement Merge per spec, and then implement a replace into command for the oltp scenario. This way you keep the spec behavior for the spec syntax, and have a clearly

Re: [HACKERS] MERGE Specification

. This way you keep the spec behavior for the spec syntax, and have a clearly non-spec command for non-spec behavior. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] get rid of psql welcome message

the .psqlrc file. :-) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] get rid of psql welcome message

On Friday 18 April 2008 00:24, Joshua D. Drake wrote: On Fri, 18 Apr 2008 00:21:58 -0400 Robert Treat [EMAIL PROTECTED] wrote: We could just do: psql 8.1.10 - postgresql server version 8.1.10 Type: \h for SQL help, \? for psql help, \q to quit postgres=# I think it's

Re: [HACKERS] get rid of psql welcome message

, but barring that, the SSL info is very handy when you're working on SSL enabled servers. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] MERGE SQL Statement

towards. Thoughts? (Apart from jokes about having a WHY clause...) Nice work, hope my comments will be helpful. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] [COMMITTERS] pgsql: Remove mention of the Berkeley origins of the alias Postgres

. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} Postgre -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search

for) but it certainly looks like the issue discussed here: http://archives.postgresql.org/pgsql-performance/2008-03/msg00191.php -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Script binaries renaming

packages. I use Solaris and this wouldn't bother me at all. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search

On Thursday 27 March 2008 17:11, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: On Sunday 16 March 2008 22:18, Tom Lane wrote: Fix TransactionIdIsCurrentTransactionId() to use binary search instead of linear search when checking child-transaction XIDs. Are there any plans

Re: [HACKERS] Including PL/PgSQL by default

party application developers (ie. mediawiki types) are trying to accommodate. They would like to be able to take advantage of plpgsql in their applications, but without it being included by default they have to exclude it from their application. -- Robert Treat Build A Brighter LAMP :: Linux

Re: [HACKERS] Including PL/PgSQL by default

On Tuesday 26 February 2008 12:20, Andrew Dunstan wrote: Robert Treat wrote: There are a lot of people who have a database provider of some sort who creates a database for them, giving them ownership of that specific database, with pg_hba.conf specifying connection only to that db

Re: [HACKERS] Permanent settings

was read-only, so the behavior would be similar to trying to edit it on the box as postgres user. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 5: don't forget to increase your free space

Re: [HACKERS] Permanent settings

in security arrangements. If you are superuser, you can write a C function (or just install adminpacks functions) and do this anyway. (there might be a way to prevent this, but I'm not quite sure how you would do it) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Re: Fwd: [HACKERS] PostgreSQL 8.4 development plan

? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: Fwd: [HACKERS] PostgreSQL 8.4 development plan

hiss :-P -- 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] so

[HACKERS] crash / data recovery issues

)... thoughts? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] crash / data recovery issues

On Wednesday 06 February 2008 13:56, Alvaro Herrera wrote: Robert Treat wrote: it looks as if the indexes on pg_class have become corrupt. (ie. reindex claimes duplicate rows, which do not show up when doing count() manipulations on the data). As it turns out, I can't drop these indexes

Re: [HACKERS] [PATCHES] Better default_statistics_target

? -- 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] so that your

<    1   2   3   4   5   6   7   8   9   >