Re: [HACKERS] [GENERAL] Updating column on row update

2009-11-22 Thread Thom Brown
2009/11/22 Craig Ringer cr...@postnewspapers.com.au On 23/11/2009 4:15 AM, Scott Marlowe wrote: On Sun, Nov 22, 2009 at 12:50 PM, Thom Brown thombr...@gmail.com wrote: Hi, This should be simple, but for some reason I'm not quite sure what the solution is. I want to be able to update

Re: [HACKERS] [GENERAL] Updating column on row update

2009-11-23 Thread Thom Brown
2009/11/23 Tom Lane t...@sss.pgh.pa.us CREATE OR REPLACE has got far safer semantics from the viewpoint of a script that wants to bull through without having any actual error handling (which is more or less the scenario we are arguing here, no?) After successful execution of the command you

Re: [HACKERS] [GENERAL] Updating column on row update

2009-11-23 Thread Thom Brown
2009/11/23 Tom Lane t...@sss.pgh.pa.us Thom Brown thombr...@gmail.com writes: As for having plpgsql installed by default, are there any security implications? Well, that's pretty much exactly the question --- are there? It would certainly make it easier for someone to exploit any other

Re: [HACKERS] [GENERAL] Updating column on row update

2009-11-24 Thread Thom Brown
2009/11/24 Hannu Krosing ha...@2ndquadrant.com On Sun, 2009-11-22 at 18:51 -0500, Tom Lane wrote: Craig Ringer cr...@postnewspapers.com.au writes: I do think this comes up often enough that a built-in trigger update named column with result of expression on insert trigger might be

[HACKERS] Feature request: permissions change history for auditing

2009-11-30 Thread Thom Brown
Hi, As far as I am aware, there is no way to tell when a user/role was granted permissions or had permissions revoked, or who made these changes. I'm wondering if it would be useful for security auditing to maintain a history of permissions changes only accessible to superusers? Thanks Thom

Re: [HACKERS] Feature request: permissions change history for auditing

2009-11-30 Thread Thom Brown
2009/11/30 Glyn Astill glynast...@yahoo.co.uk --- On Mon, 30/11/09, Thom Brown thombr...@gmail.com wrote: As far as I am aware, there is no way to tell when a user/role was granted permissions or had permissions revoked, or who made these changes. I'm wondering if it would be useful

Re: [HACKERS] More broken links in documentation

2009-12-08 Thread Thom Brown
2009/12/8 Magnus Hagander mag...@hagander.net I wrote a small script to check our SGML, and the following links are returning not found in our docs: ftp://ftp.ora.com/pub/examples/nutshell/ujip/doc/cjk.inf in charset.sgml, detailed info about some charsets. Do we just remove this? Anybody

Re: [HACKERS] idea - new aggregates median, listagg

2009-12-16 Thread Thom Brown
2009/12/15 Pavel Stehule pavel.steh...@gmail.com Hello I am looking on new feature - ORDER clause in aggregate, and I thing, so we are able to effectively implement some non standard, but well known aggregates. a) function median - it is relative frequent request - with usually slow

Re: [HACKERS] 8.5 vs. 9.0

2010-01-21 Thread Thom Brown
2010/1/21 Dave Page dp...@pgadmin.org In an attempt to pre-empt the normally drawn-out discussions about what the next version of PostgreSQL will be numbered. the core team have discussed the issue and following a lenghty debate lasting literally a few minutes decided that the next release

Re: [HACKERS] Patch: psql \whoami option

2010-01-27 Thread Thom Brown
2010/1/27 Josh Berkus j...@agliodbs.com however, \conninfo is probably the better name. +1 Something along the lines of: Connected to localhost port 5432 as user thomb? Thom

Re: [HACKERS] Patch: psql \whoami option

2010-01-27 Thread Thom Brown
2010/1/27 Thom Brown thombr...@gmail.com 2010/1/27 Josh Berkus j...@agliodbs.com however, \conninfo is probably the better name. +1 Something along the lines of: Connected to localhost port 5432 as user thomb? Thom Er... ignore that. Just saw the other examples which are better ;)

Re: [HACKERS] Review: listagg aggregate

2010-02-01 Thread Thom Brown
I noticed that the regression test results don't include the following case: select string_agg(a) from (values(null),(null)) g(a); There is one similar where a delimiter is provided. Which leads me to ask for clarification, would it be safe to assume that string_agg can never itself return

Re: [HACKERS] Review: listagg aggregate

2010-02-01 Thread Thom Brown
On 1 February 2010 13:40, Pavel Stehule pavel.steh...@gmail.com wrote: 2010/2/1 Thom Brown thombr...@gmail.com: I noticed that the regression test results don't include the following case: select string_agg(a) from (values(null),(null)) g(a); There is one similar where a delimiter

[HACKERS] Streaming replication in docs

2010-02-07 Thread Thom Brown
The post about the dev docs needing more hot standby mentions prompted me to have a look at how streaming replication is documented. Ignore this if this has already been discussed (I couldn't find any posts), but I couldn't find any mention of streaming replication except in the write ahead log

Re: [HACKERS] Streaming replication in docs

2010-02-07 Thread Thom Brown
On 7 February 2010 10:20, Thom Brown thombr...@gmail.com wrote: The post about the dev docs needing more hot standby mentions prompted me to have a look at how streaming replication is documented.  Ignore this if this has already been discussed (I couldn't find any posts), but I couldn't find

Re: [HACKERS] Streaming replication in docs

2010-02-07 Thread Thom Brown
On 7 February 2010 10:49, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: Thom Brown wrote: On 7 February 2010 10:20, Thom Brown thombr...@gmail.com wrote: The post about the dev docs needing more hot standby mentions prompted me to have a look at how streaming replication

[HACKERS] Remove ROW | ROWS from OFFSET and FETCH

2010-03-25 Thread Thom Brown
Hi, I was wondering if it might be worth making ROW/ROWS optional for OFFSET and FETCH clauses? And can ONLY be optional too? So: OFFSET start { ROW | ROWS } FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY Would become OFFSET start [ ROW | ROWS ] FETCH { FIRST | NEXT } [ count ] [ ROW |

Re: [HACKERS] Remove ROW | ROWS from OFFSET and FETCH

2010-03-25 Thread Thom Brown
On 26 March 2010 00:14, Marko Tiikkaja marko.tiikk...@cs.helsinki.fi wrote: On 3/26/10 2:01 AM +0200, Thom Brown wrote: I was wondering if it might be worth making ROW/ROWS optional for OFFSET and FETCH clauses?  And can ONLY be optional too? AIUI the only time you'd want to use that syntax

Re: [HACKERS] I am interested in the MERGE command implementation as my gSoC project

2010-03-30 Thread Thom Brown
On 30 March 2010 08:26, Zhai Boxuan bxz...@gmail.com wrote: I have read some infor about the MERGE command, which has not been implemented yet in Postgres 8. I considered the problem and have a brief plan for the jobs. You may find these to be some help if you haven't already read them:

Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-03-31 Thread Thom Brown
On 31 March 2010 07:56, Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp wrote: Robert Haas robertmh...@gmail.com wrote: * (seq_page_cost/(random_page_cost)) * EXCLUDE constraints has no tags to be linked. * EXCLUDE constraints is not indexed from the Index page. CREATE TABLE ...

Re: [HACKERS] sorry, too many standbys already vs. MaxWalSenders vs. max_wal_senders

2010-03-31 Thread Thom Brown
On 31 March 2010 15:45, Robert Haas robertmh...@gmail.com wrote: On Wed, Mar 31, 2010 at 10:44 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Wed, Mar 31, 2010 at 12:54 AM, Fujii Masao masao.fu...@gmail.com wrote: could not accept connection from

Re: [HACKERS] Postgres 9.1 - Release Theme

2010-04-01 Thread Thom Brown
On 1 April 2010 09:13, Dave Page dp...@postgresql.org wrote: Following a great deal of discussion, I'm pleased to announce that the PostgreSQL Core team has decided that the major theme for the 9.1 release, due in 2011, will be 'NoSQL'. There is a growing trend towards NoSQL databases, with

Re: [HACKERS] sorry, too many standbys already vs. MaxWalSenders vs. max_wal_senders

2010-04-01 Thread Thom Brown
On 1 April 2010 01:51, Robert Haas robertmh...@gmail.com wrote: On Wed, Mar 31, 2010 at 11:24 AM, Thom Brown thombr...@gmail.com wrote: [patch] As a general rule, I really appreciate people being willing to take the time to put proposed changes into patch form, even if they're small

Re: [HACKERS] [pgadmin-hackers] Feature request: limited deletions

2010-04-08 Thread Thom Brown
On 8 April 2010 11:55, Ian Barwick barw...@gmail.com wrote: 2010/4/8 Thom Brown thombr...@gmail.com: I couldn't find any discussion on this, but the request is quite straightforward. Implement a LIMIT on DELETE statements like SELECT statements. So you could write: DELETE FROM

Re: [HACKERS] CIText and pattern_ops

2010-04-26 Thread Thom Brown
On 26 April 2010 11:19, Robert Haas robertmh...@gmail.com wrote: On Fri, Apr 23, 2010 at 11:27 PM, Rod Taylor p...@rbt.ca wrote: Is there any particular reason why the citext module doesn't have citext_pattern_ops operator family? You forgot to send in the patch. :-) ...Robert Yes,

Re: [HACKERS] pg_migrator to /contrib in a later 9.0 beta

2010-05-06 Thread Thom Brown
On 6 May 2010 20:55, Bruce Momjian br...@momjian.us wrote: Bruce Momjian wrote: Tom Lane wrote: Joshua D. Drake j...@commandprompt.com writes: On Wed, 2010-05-05 at 20:24 -0400, Robert Haas wrote: I think it will be confusing if we change the name, so I vote to not change the

Re: [HACKERS] Bug with ordering aggregates?

2010-05-18 Thread Thom Brown
On 18 May 2010 16:37, Stephen Frost sfr...@snowman.net wrote: Greetings,  This doesn't seem right to me: postgres=# select postgres-# string_agg(column1::text order by column1 asc,',') postgres-# from (values (3),(4),(1),(2)) a;  string_agg  1234 (1 row)  I'm thinking we

[HACKERS] Idle connection timeout

2009-10-09 Thread Thom Brown
I saw a recent blog entry where someone came up with a solution for expiring idle connections ( http://dividebyzeroexception.blogspot.com/2009/10/implementing-waittimeout-in-postgresql.html) and I was surprised there wasn't a config option for this already. Is this something that can be

Re: [HACKERS] Idle connection timeout

2009-10-09 Thread Thom Brown
2009/10/9 Bruce Momjian br...@momjian.us Thom Brown wrote: I saw a recent blog entry where someone came up with a solution for expiring idle connections ( http://dividebyzeroexception.blogspot.com/2009/10/implementing-waittimeout-in-postgresql.html ) and I was surprised there wasn't

Re: [HACKERS] Idle connection timeout

2009-10-09 Thread Thom Brown
2009/10/10 Alvaro Herrera alvhe...@commandprompt.com Our TODO has: Add idle_in_transaction_timeout GUC so locks are not held for long periods of time Awesome! Thanks for the info Bruce. This is quite a different thing though. You were talking about idle

Re: [HACKERS] Idle connection timeout

2009-10-10 Thread Thom Brown
2009/10/10 Dimitri Fontaine dfonta...@hi-media.com Thom Brown thombr...@gmail.com writes: Oh, I see. Yes, that is different. In which case, I'd still like to see such a feature implemented as I imagine it could be useful for auto-killing connections not being used that are continuously

Re: [HACKERS] \du quite ugly in 8.4

2009-10-21 Thread Thom Brown
2009/10/21 Peter Eisentraut pete...@gmx.net: Could someone clarify why this (from PG 8.4) # \du              List of roles   Role name   | Attributes  | Member of ---+-+  admin         | Create role | {}               : Create DB  postgres      |

Re: [HACKERS] Parsing config files in a directory

2009-10-29 Thread Thom Brown
2009/10/29 Andrew Dunstan and...@dunslane.net: Pavel Stehule wrote: 2009/10/27 Simon Riggs si...@2ndquadrant.com: On Tue, 2009-10-27 at 00:38 -0400, Greg Smith wrote: new feature One additional point that would be useful is a way to match up the usage of custom_variable_classes with

Re: [HACKERS] [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns

2009-11-04 Thread Thom Brown
2009/11/4 Alvaro Herrera alvhe...@commandprompt.com: KaiGai Kohei wrote:   postgres=# SELECT * FROM t2;   ERROR:  could not find inherited attribute b of relation t3 Because t3.b is also inherited from the t2, but ALTER TABLE does not care about multiple inherited columns well. I think we

Re: [HACKERS] PG 9.0 release timetable

2010-05-31 Thread Thom Brown
On 31 May 2010 09:33, Simon Riggs si...@2ndquadrant.com wrote: We're currently at 4 weeks since last beta, with no new beta in sight. My understanding was beta 2 would be out on 7th June. Is that changing? Thom -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

[HACKERS] VACUUM messages without newlines

2010-06-01 Thread Thom Brown
This has annoyed me for some time, but it appears that in the VACUUM log, the line which says... INFO: analyzing %s.%s ...( and appears in pgsql/src/backend/commands/analyze.c lines 282 and 287 ) doesn't terminate with a newline, meaning the next message appears immediately after it. Either

Re: [HACKERS] VACUUM messages without newlines

2010-06-01 Thread Thom Brown
On 1 June 2010 16:28, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Thom Brown's message of mar jun 01 11:16:33 -0400 2010: This has annoyed me for some time, but it appears that in the VACUUM log, the line which says... INFO: analyzing %s.%s ...( and appears in

Re: [HACKERS] VACUUM messages without newlines

2010-06-01 Thread Thom Brown
On 1 June 2010 16:50, Tom Lane t...@sss.pgh.pa.us wrote: Thom Brown thombr...@gmail.com writes: I see what you mean.  I'm seeing this in the latest version of pgAdmin III (1.10.3) so looks like it's not up-to-date in that respect. Should report it as a pgAdmin problem then? Yes.  The message

Re: [HACKERS] pg_dump does not honor namespaces when functions are used in index

2010-06-17 Thread Thom Brown
On 17 June 2010 12:31, Jean-Baptiste Quenot j...@caraldi.com wrote: Dear hackers, I have a pretty nasty problem to submit to your careful scrutiny. Please consider the following piece of SQL code: CREATE SCHEMA bar; SET search_path = bar; CREATE FUNCTION bar() RETURNS text AS $$ BEGIN

Re: [HACKERS] pg_dump does not honor namespaces when functions are used in index

2010-06-17 Thread Thom Brown
On 17 June 2010 14:20, Robert Haas robertmh...@gmail.com wrote: On Thu, Jun 17, 2010 at 8:13 AM, Thom Brown thombr...@gmail.com wrote: On 17 June 2010 12:31, Jean-Baptiste Quenot j...@caraldi.com wrote: Dear hackers, I have a pretty nasty problem to submit to your careful scrutiny

[HACKERS] Re: pg_dump does not honor namespaces when functions are used in index

2010-06-18 Thread Thom Brown
On 18 June 2010 09:31, Jean-Baptiste Quenot j...@caraldi.com wrote: 2010/6/17 Greg Stark gsst...@mit.edu: On Thu, Jun 17, 2010 at 4:08 PM, Tom Lane t...@sss.pgh.pa.us wrote: I actually wonder if we shouldn't automatically tag plpgsql functions with the search_path in effect at the time of

Re: [HACKERS] Using multidimensional indexes in ordinal queries

2010-06-21 Thread Thom Brown
On 6 June 2010 21:04, Alexander Korotkov aekorot...@gmail.com wrote: Hello hackers, I would like to share some my thoughts about usage of multidimensional indexes for queries which deal with ordinal unidimensional data types. I think that gist indexes (especially with knngist) can produce

Re: [HACKERS] beta3 the open items list

2010-06-28 Thread Thom Brown
On 19 June 2010 14:43, Robert Haas robertmh...@gmail.com wrote: It would be nice if we could make a final push to get these issues resolved and another beta out the door before the end of the month... So should we expect beta3 imminently, or are these issues still outstanding? Thanks Thom --

[HACKERS] Look-behind regular expressions

2010-06-29 Thread Thom Brown
Are there any plans to support look-behind and negative look-behind for regular expressions in future? Thanks Thom -- 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] Look-behind regular expressions

2010-06-29 Thread Thom Brown
On 29 June 2010 15:40, Tom Lane t...@sss.pgh.pa.us wrote: Thom Brown thombr...@gmail.com writes: Are there any plans to support look-behind and negative look-behind for regular expressions in future? No.  Or are you volunteering? A n00b like me volunteer for that? It's more of a suggestion

Re: [PATCH] Re: [HACKERS] Issue: Deprecation of the XML2 module 'xml_is_well_formed' function

2010-07-12 Thread Thom Brown
On 10 July 2010 14:12, Mike Fowler m...@mlfowler.com wrote: Robert Haas wrote: On Fri, Jul 9, 2010 at 4:06 PM, Peter Eisentraut pete...@gmx.net wrote: On ons, 2010-07-07 at 16:37 +0100, Mike Fowler wrote: Here's the patch to add the 'xml_is_well_formed' function. I suppose we should

Re: [PATCH] Re: [HACKERS] Issue: Deprecation of the XML2 module 'xml_is_well_formed' function

2010-07-12 Thread Thom Brown
On 12 July 2010 13:07, Mike Fowler m...@mlfowler.com wrote: Thom Brown wrote: Just wondering about that semi-colon after the namespace definition. Thom The semi-colon is not supposed to be there, and I'm not sure where it's come from. With Thunderbird I see the email with my patch

Re: [HACKERS] ERROR: argument to pg_get_expr() must come from system catalogs

2010-07-13 Thread Thom Brown
On 13 July 2010 16:31, Dave Page dp...@pgadmin.org wrote: We had a report of the above error from a pgAdmin user testing 1.12.0b3 with PG 9.0b3. The (highly simplified) query below works fine as a superuser: SELECT pg_get_expr(proargdefaults, 'pg_catalog.pg_class'::regclass)  FROM pg_proc pr

Re: [HACKERS] ERROR: argument to pg_get_expr() must come from system catalogs

2010-07-13 Thread Thom Brown
On 13 July 2010 16:44, Thom Brown thombr...@gmail.com wrote: On 13 July 2010 16:31, Dave Page dp...@pgadmin.org wrote: We had a report of the above error from a pgAdmin user testing 1.12.0b3 with PG 9.0b3. The (highly simplified) query below works fine as a superuser: SELECT pg_get_expr

Re: [HACKERS] ERROR: argument to pg_get_expr() must come from system catalogs

2010-07-13 Thread Thom Brown
On 13 July 2010 16:50, Dave Page dp...@pgadmin.org wrote: On Tue, Jul 13, 2010 at 4:48 PM, Thom Brown thombr...@gmail.com wrote: On 13 July 2010 16:44, Thom Brown thombr...@gmail.com wrote: On 13 July 2010 16:31, Dave Page dp...@pgadmin.org wrote: We had a report of the above error from

Re: [HACKERS] ERROR: argument to pg_get_expr() must come from system catalogs

2010-07-13 Thread Thom Brown
On 13 July 2010 17:00, Dave Page dp...@pgadmin.org wrote: On Tue, Jul 13, 2010 at 4:56 PM, Thom Brown thombr...@gmail.com wrote: I works if you use pr.proargdefaults so not unresolvable.  Maybe it's because it can't tell where the column's coming from at that point? Hmm, so it does. It still

Re: [HACKERS] ERROR: argument to pg_get_expr() must come from system catalogs

2010-07-13 Thread Thom Brown
On 13 July 2010 17:01, Thom Brown thombr...@gmail.com wrote: On 13 July 2010 17:00, Dave Page dp...@pgadmin.org wrote: On Tue, Jul 13, 2010 at 4:56 PM, Thom Brown thombr...@gmail.com wrote: I works if you use pr.proargdefaults so not unresolvable.  Maybe it's because it can't tell where

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Thom Brown
On 15 July 2010 16:20, Simon Riggs si...@2ndquadrant.com wrote: On Thu, 2010-07-15 at 11:05 -0400, Tom Lane wrote: Simon Riggs si...@2ndquadrant.com writes: The biggest turn off that most people experience when using PostgreSQL is that psql does not support memorable commands. I would

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Thom Brown
On 15 July 2010 16:52, Andrew Dunstan and...@dunslane.net wrote: Thom Brown wrote: Looks like the last time this was discussed, there wasn't any clear conclusion.  Someone created a patch and it's still on the TODO list: http://archives.postgresql.org/pgsql-hackers/2010-01/msg01845.php

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Thom Brown
On 15 July 2010 17:07, Marc G. Fournier scra...@hub.org wrote: On Thu, 15 Jul 2010, Thom Brown wrote: If it's only a psql problem, why implement it as SQL?  Is it just so we're not adding keywords specifically to psql?  In that case, it shouldn't support QUIT. Personally, I think

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Thom Brown
On 15 July 2010 17:16, Marc G. Fournier scra...@hub.org wrote: On Thu, 15 Jul 2010, Thom Brown wrote: On 15 July 2010 17:07, Marc G. Fournier scra...@hub.org wrote: On Thu, 15 Jul 2010, Thom Brown wrote: If it's only a psql problem, why implement it as SQL?  Is it just so we're not adding

Re: [HACKERS] SHOW TABLES

2010-07-16 Thread Thom Brown
On 16 July 2010 13:49, Bruce Momjian br...@momjian.us wrote: Bruce Momjian wrote: Andrew Dunstan wrote: Bruce Momjian wrote: I assume SHOW TABLES would only be useful for interactive terminal sesssions, not for application code (which should use information_schema), so what

Re: [HACKERS] reducing NUMERIC size for 9.1

2010-07-16 Thread Thom Brown
On 16 July 2010 14:14, Brendan Jurd dire...@gmail.com wrote: On 16 July 2010 22:51, Richard Huxton d...@archonet.com wrote: On 16/07/10 13:44, Brendan Jurd wrote: At this scale we should be seeing around 2 million bytes saved, but instead the tables are identical.  Is there some kind of

[HACKERS] psql auto-completion for multiple where clauses

2010-07-16 Thread Thom Brown
Someone highlighed on IRC that after the first WHERE clause, autocomplete no longer works. An example: CREATE TABLE tab_completion ( id serial, stuff text, meow boolean ); SELECT * FROM tab_completion WHERE id = 2 AND stabtab This would output a blank line. Is there any chance of improving

Re: [HACKERS] psql auto-completion for multiple where clauses

2010-07-16 Thread Thom Brown
On 16 July 2010 16:04, Greg Sabino Mullane g...@turnstep.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Someone highlighed on IRC that after the first WHERE clause, autocomplete no longer works. ... SELECT * FROM tab_completion WHERE id = 2 AND stabtab ... Is there any

Re: [HACKERS] string_to_array has to be stable?

2010-07-20 Thread Thom Brown
On 20 July 2010 10:31, Pavel Stehule pavel.steh...@gmail.com wrote: Hello I am working on to_array, to_string functions and I am looking on string_to_array function. I am surprised so this function is marked as immutable postgres=# select array_to_string(array[current_date],',');  

Re: [HACKERS] Query results differ depending on operating system (using GIN)

2010-07-20 Thread Thom Brown
On 20 July 2010 10:41, Artur Dabrowski a...@astec.com.pl wrote: Hello, I have been redirected here from pg-general. I tested full text search using GIN index and it turned out that the results depend on operating system. Not all the rows are found when executing some of queries on pg

Re: [HACKERS] Query results differ depending on operating system (using GIN)

2010-07-20 Thread Thom Brown
On 20 July 2010 11:14, Artur Dabrowski a...@astec.com.pl wrote: Thom, please have a look at this message of Oleg Bartunov for details of this operating system: http://old.nabble.com/Incorrect-FTS-results-with-GIN-index-tc29172750.html#a29212846 Artur Ah, so gcc 4.4.1 on Ubuntu or

Re: [HACKERS] Develop item from TODO list

2010-08-03 Thread Thom Brown
programs, can someone recommend a good C-editor for Ubuntu? What do others use? Thanks in advance, Chris Viktor I can't answer the main question, but you can try Anjuta as a C editor: http://www.anjuta.org/ -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-hackers mailing list

[HACKERS] Re: Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-04 Thread Thom Brown
. I wish I had held back on mentioning it as I remembered later that this has already been discussed to a degree, and I'd probably have kept my mouth shut upon recalling it. -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Re: Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-04 Thread Thom Brown
to the initdbs and otherwise.  I think 9.0 is going to have a pretty darned solid pg_upgrade because of it. Leave my name off the commit comment then ;) People who have been waiting for this will burn me as a heretical witch... er.. man witch... warlock? -- Thom Brown Registered Linux user: #516935

Re: [HACKERS] Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-04 Thread Thom Brown
, but from looking at the patch, you're only removing the function with a single-parameter signature, which is quite innocuous. So I'm for now. -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Drop one-argument string_agg? (was Re: [BUGS] string_agg delimiter having no effect with order by)

2010-08-05 Thread Thom Brown
you've called. What function name do you believe was called? -- Thom Brown Registered Linux user: #516935 -- 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] host name support in pg_hba.conf

2010-08-09 Thread Thom Brown
), and + the name found in the reverse lookup is compared with the + specified host name. That's one lng sentence! -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Session timeout on commitfest.postgresql.org

2010-08-10 Thread Thom Brown
with this?: http://hivelogic.com/articles/the-safari-cookie-issue-fixed -- Thom Brown Registered Linux user: #516935 -- 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] string_to_array with an empty input string

2010-08-10 Thread Thom Brown
-array result saner.  Given the general inconsistency surrounding empty arrays elsewhere, I think this wouldn't be a very problematic change for most users. Thoughts? I, personally, would expect an empty array output given an empty input, and a null output for a null input. -- Thom Brown

Re: [HACKERS] patch: psql variables tabcomplete

2010-08-16 Thread Thom Brown
On 16 August 2010 10:52, Pavel Stehule pavel.steh...@gmail.com wrote: Hello I found so there are not support for tabcomple of psql variables. Regards Pavel Stehule s/out of mempry/out of memory/ -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Progress indication prototype

2010-08-18 Thread Thom Brown
steps? Obviously for ones with a LIMIT applied it wouldn't know how far through it had got, but for things like a sequential scan or sort it should be able to indicate how far through it is. -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Avoiding deadlocks ...

2010-08-20 Thread Thom Brown
. -- Thom Brown Registered Linux user: #516935 -- 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] Why assignment before return?

2010-08-20 Thread Thom Brown
:        if ((tabentry = pgstat_fetch_stat_tabentry(relid)) == NULL)                PG_RETURN_INT64(0);        else                PG_RETURN_INT64(tabentry-blocks_fetched); -- And then drop the int64result; declaration as a result. -- Thom Brown Registered Linux user: #516935 -- Sent via

Re: [HACKERS] Version Numbering

2010-08-20 Thread Thom Brown
/golden-rules-of-version-naming/ -- Thom Brown Registered Linux user: #516935 -- 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] Replacing the pg_get_expr security hack with a datatype solution

2010-08-21 Thread Thom Brown
On 21 August 2010 20:30, Tom Lane t...@sss.pgh.pa.us wrote: * Change all system catalog columns holding expression trees to be declared as this type. *snip* We could go with something like pg_parse_tree, perhaps.  Or maybe that's overthinking it. How about pg_expr_tree? -- Thom Brown

Re: [HACKERS] WIP: extensible enums

2010-08-23 Thread Thom Brown
to the syntax. Let the bikeshedding begin. cheers andrew When you write the supporting doc changes, you might want to add a note in to mention that you cannot remove a label once it has been added. Will the modified enums remain intact after a dump/restore? -- Thom Brown Registered Linux user

Re: [HACKERS] WIP: extensible enums

2010-08-23 Thread Thom Brown
'orange'; -- Thom Brown Registered Linux user: #516935 -- 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] array_agg() NULL Handling

2010-09-01 Thread Thom Brown
); INSERT 0 4 try=# select array_agg(id) from foo;  array_agg ──  {1,2,NULL,3} (1 row) So are the docs right, or is array_agg() right? I think it might be both. array_agg doesn't return NULL, it returns an array which contains NULL. -- Thom Brown Twitter: @darkixion IRC

Re: [HACKERS] array_agg() NULL Handling

2010-09-01 Thread Thom Brown
On 1 September 2010 07:56, Thom Brown t...@linux.com wrote: On 1 September 2010 06:45, David E. Wheeler da...@kineticode.com wrote: The aggregate docs say: The first form of aggregate expression invokes the aggregate across all input rows for which the given expression(s) yield non-null

Re: [HACKERS] array_agg() NULL Handling

2010-09-01 Thread Thom Brown
NULLs in the column being targeted by array_agg() or not. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: register/unregister standby Re: [HACKERS] Synchronous replication

2010-09-02 Thread Thom Brown
will require. +1 I don't like the idea of having to guess how many WAL files you think you'll need to keep around. And if these standby instances have to register, could there be a view to list subscriber information? -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux

Re: [HACKERS] Streaming a base backup from master

2010-09-03 Thread Thom Brown
. Would it be possible to not require pg_start/stop_backup() for this new feature? (yes, I'm probably missing something obvious here) -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Streaming a base backup from master

2010-09-03 Thread Thom Brown
On 3 September 2010 12:30, Magnus Hagander mag...@hagander.net wrote: On Fri, Sep 3, 2010 at 13:25, Thom Brown t...@linux.com wrote: On 3 September 2010 12:19, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: TODO: * We need a smarter way to do pg_start/stop_backup

Re: [HACKERS] Streaming a base backup from master

2010-09-03 Thread Thom Brown
this would be horribly slow so not feasible for that. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Streaming a base backup from master

2010-09-04 Thread Thom Brown
Willy Wonka a Mars bar. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 -- 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] Misleading CREATE TABLE error

2011-12-27 Thread Thom Brown
On 27 December 2011 20:16, Peter Eisentraut pete...@gmx.net wrote: It's not only the error message that's misleading, but the whole code, because the entire code for CREATE TABLE ... (LIKE ...) claims to do inheritance based on an ancient understanding of the SQL standard.  I know this has

Re: [HACKERS] measuring spinning

2012-01-11 Thread Thom Brown
On 12 January 2012 01:48, Robert Haas robertmh...@gmail.com wrote: I've had cause, a few times this development cycle, to want to measure the amount of spinning on each lwlock in the system.  To that end, I've found the attached patch useful.  Note that if you don't define LWLOCK_STATS, this

[HACKERS] Temp file missing during large pgbench data set

2012-01-27 Thread Thom Brown
Hi, I'm using latest git master (latest entry 0816fad6eebddb8f1f0e21635e46625815d690b9) and I'm getting an error when trying to create a large data set with pgbench: thom@swift:~/Development$ createdb pgbench thom@swift:~/Development$ pgbench -i -s 100 pgbench NOTICE: table pgbench_branches

Re: [HACKERS] Temp file missing during large pgbench data set

2012-01-28 Thread Thom Brown
On 28 January 2012 09:04, Magnus Hagander mag...@hagander.net wrote: On Sat, Jan 28, 2012 at 09:57, Magnus Hagander mag...@hagander.net wrote: On Sat, Jan 28, 2012 at 05:30, Tom Lane t...@sss.pgh.pa.us wrote: Thom Brown t...@linux.com writes: I'm using latest git master (latest entry

[HACKERS] Triggers with DO functionality

2012-02-17 Thread Thom Brown
Hi, This may have already been discussed before, but I can't find any mention of it. Would it be desirable to add support for triggers that contain their own anonymous functions (i.e. DO)? So instead of CREATE TRIGGER... EXECUTE PROCEDURE functioname(); you'd have: CREATE TRIGGER... DO $$

Re: [HACKERS] Triggers with DO functionality

2012-02-17 Thread Thom Brown
On 17 February 2012 16:29, David E. Wheeler da...@justatheory.com wrote: On Feb 17, 2012, at 5:22 AM, Thom Brown wrote: The purpose being to only have a single statement to set up the trigger rather than setting up a separate trigger function which will unlikely be re-used by other triggers

Re: [HACKERS] Triggers with DO functionality

2012-02-17 Thread Thom Brown
On 17 February 2012 16:43, Andrew Dunstan and...@dunslane.net wrote: On 02/17/2012 11:29 AM, David E. Wheeler wrote: On Feb 17, 2012, at 5:22 AM, Thom Brown wrote: The purpose being to only have a single statement to set up the trigger rather than setting up a separate trigger function

Re: [HACKERS] Triggers with DO functionality

2012-02-17 Thread Thom Brown
On 17 February 2012 17:26, Peter Eisentraut pete...@gmx.net wrote: On fre, 2012-02-17 at 13:22 +, Thom Brown wrote: So instead of CREATE TRIGGER... EXECUTE PROCEDURE functioname(); you'd have: CREATE TRIGGER... DO $$ ... $$; I had wished for this many times and was about

Re: [HACKERS] Triggers with DO functionality

2012-02-17 Thread Thom Brown
On 17 February 2012 20:40, Dimitri Fontaine dimi...@2ndquadrant.fr wrote: Thom Brown t...@linux.com writes: And thinking about it, DO is a bit nonsense here, so maybe we'd just have something like: CREATE TRIGGER... AS $$ BEGIN END; $$; i.e. the same as a function. I like that.  How

Re: [HACKERS] Triggers with DO functionality

2012-02-17 Thread Thom Brown
On 17 February 2012 21:07, Andrew Dunstan and...@dunslane.net wrote: On 02/17/2012 03:58 PM, Thom Brown wrote: On 17 February 2012 20:40, Dimitri Fontainedimi...@2ndquadrant.fr  wrote: Thom Brownt...@linux.com  writes: And thinking about it, DO is a bit nonsense here, so maybe we'd just

Re: [HACKERS] determining a type oid from the name

2012-02-22 Thread Thom Brown
On 22 February 2012 18:00, Andrew Dunstan and...@dunslane.net wrote: Say I'm writing an extension X, and I want to process data values from another extension that creates type Y (e.g. an hstore), what's the best way to determine the Oid of type Y in my module X code? SPI code that runs select

Re: [HACKERS] determining a type oid from the name

2012-02-22 Thread Thom Brown
On 22 February 2012 18:34, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Thom Brown t...@linux.com wrote: Does this help? test=# SELECT pg_typeof('4834.34'::numeric)::oid;  pg_typeof ---       1700 (1 row) Wouldn't it be easier to do this instead? test=# SELECT 'numeric

Re: [HACKERS] Triggers with DO functionality

2012-02-23 Thread Thom Brown
On 23 February 2012 07:15, Gianni Ciolli gianni.cio...@2ndquadrant.it wrote: On Fri, Feb 17, 2012 at 11:43:53AM -0500, Andrew Dunstan wrote: On 02/17/2012 11:29 AM, David E. Wheeler wrote: On Feb 17, 2012, at 5:22 AM, Thom Brown wrote: The purpose being to only have a single statement to set

  1   2   3   4   5   6   7   8   >