Re: [HACKERS] sorting a union over inheritance vs pathkeys

2014-06-26 Thread Michael Glaesemann
On Jun 25, 2014, at 22:14, Tom Lane t...@sss.pgh.pa.us wrote: I wrote: Michael Glaesemann g...@seespotcode.net writes: -- ERROR: could not find pathkey item to sort Hm ... I can reproduce that in 9.3 but it seems fine in 9.4 and HEAD. Don't know what's going on exactly. Interesting

[HACKERS] sorting a union over inheritance vs pathkeys

2014-06-25 Thread Michael Glaesemann
the issue. I’ve seen this in 9.2.8 and 9.3.4. I haven’t tested this in 9.4 or earlier than 9.2. Any thoughts? Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] another error perhaps to be enhanced

2013-06-14 Thread Michael Glaesemann
On Jun 14, 2013, at 13:38, Joshua D. Drake j...@commandprompt.com wrote: ERROR: index foo_idx We should probably add the schema. I've noticed similar issues with functions. I'd like to see those schema-qualified as well. JD -- Command Prompt, Inc. -

Re: [HACKERS] Tablespaces in the data directory

2012-12-03 Thread Michael Glaesemann
with the internal structure of the data directory. Why not just link it to some place outside the data directory? One reason is that subsequent copies of the data directory then also includes the tablespace data. Saves one step when setting up a standby. Michael Glaesemann grzm seespotcode net -- Sent

Re: [HACKERS] Schema version management

2012-07-05 Thread Michael Glaesemann
file. +1. It might make sense to include some sort of argument type information. The function signature is really its identifier. The function name is only part of it. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Schema version management

2012-07-05 Thread Michael Glaesemann
files, each of these functions is a separate object and should be in its own file. Michael Glaesemann grzm seespotcode net -- 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] Schema version management

2012-07-05 Thread Michael Glaesemann
On Jul 5, 2012, at 11:52, Alvaro Herrera wrote: Isn't this a perfect example of stuff that, since it does much the same thing, should be in the same file so that you remember to fix them all together if you find a bug in one? That's what tests are for. Michael Glaesemann grzm seespotcode

Re: [HACKERS] New Postgres committer: Kevin Grittner

2012-06-07 Thread Michael Glaesemann
the requisite skills, dedication to the project, and a suitable degree of caution to be a good committer. Please join me in welcoming him aboard. Congratulations, Kevin! Well-deserved! Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] proposal - urlencode, urldecode support

2012-04-25 Thread Michael Glaesemann
On Apr 25, 2012, at 13:54, Pavel Stehule wrote: what do you think about enhancing encode, decode functions for support of mentioned code? Sounds like a great idea for a PGXN module. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Document hashtext() and Friends?

2012-02-21 Thread Michael Glaesemann
function library: https://github.com/petere/pgvihash Michael Glaesemann grzm seespotcode net -- 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] logging in high performance systems.

2011-12-13 Thread Michael Glaesemann
this month) What time? I'd potentially like to attend. Philadelphia, represent! Michael Glaesemann grzm seespotcode net -- 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] non-superuser reserved connections? connection pools?

2011-07-04 Thread Michael Glaesemann
On Jul 4, 2011, at 10:09, Magnus Hagander wrote: On Mon, Jul 4, 2011 at 00:01, Michael Glaesemann g...@seespotcode.net wrote: It would be nice to be able to set aside a few connections for non-superusers, such as stats-monitoring connections. There's often no reason to grant these users

[HACKERS] non-superuser reserved connections? connection pools?

2011-07-03 Thread Michael Glaesemann
} max_connections=100 The connections allotted to superuser would have the same meaning as the current superuser_reserved_connections GUC. Does this seem to be a useful feature to anyone else? Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] exposing float8-as-value to PGXS/makefiles

2011-05-20 Thread Michael Glaesemann
clause in CREATE TYPE. Ooh, excellent, thanks. To confirm, this works for Postgres versions = 8.4, correct? Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] [GENERAL] PostgreSQL Core Team

2011-04-27 Thread Michael Glaesemann
On Apr 27, 2011, at 14:48, Dave Page wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Congratulations, Magnus! Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] OSSP gone missing? Fate of UUID?

2011-03-01 Thread Michael Glaesemann
On Mar 1, 2011, at 17:15, Hiroshi Saito wrote: Ooops, It is some trobles now. please see Ralf-san's comment. Thanks, Hiroshi! Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Why our counters need to be time-based WAS: WIP: cross column correlation ...

2011-02-28 Thread Michael Glaesemann
for looking harder into mmap or POSIX shmem, although it's not clear to me how well either of those fixes that. Spitballing here, but could sqlite be an intermediate, compromise solution? Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers

[HACKERS] OSSP gone missing? Fate of UUID?

2011-02-28 Thread Michael Glaesemann
A couple of weeks ago when installing uuid-ossp on a new server, I noticed that the ossp site is gone. I haven't found anything on the web to indicate what happened. Anyone know? Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] function(contants) evaluated for every row

2010-11-24 Thread Michael Glaesemann
, in particular with partitioned tables. Out of habit I now write functions that always cache the value of the function in a variable and use the variable in the actual query to avoid this particular gotcha. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance

2010-10-04 Thread Michael Glaesemann
in the postgres section of the git repo leads me to think the code that includes the fixes it there, if someone wants to look into it (wrt to the Postgres lock manager changes). Didn't check the licensing. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] patch: to_string, to_array functions

2010-07-21 Thread Michael Glaesemann
On Jul 21, 2010, at 12:30 , Robert Haas wrote: array_split() and array_join(), following Perl? +1. Seems common in other languages such as Ruby, Python, and Java as well. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Additional startup logging

2010-06-30 Thread Michael Glaesemann
at the beginning of each log file?): Shouldn't be too hard to put together a function which prints out such information via RAISE even now using PL/pgSQL. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] hstore == and deprecate =

2010-06-08 Thread Michael Glaesemann
? (That's enough bikeshedding for me.) Michael Glaesemann grzm seespotcode net -- 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] hstore == and deprecate =

2010-06-08 Thread Michael Glaesemann
On Jun 8, 2010, at 16:17 , Robert Haas wrote: (That's enough bikeshedding for me.) Test first, then post? :-) What? :) If I was productively contributing, I wouldn't be bikeshedding, now would I? Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] Anyone know if Alvaro is OK?

2010-02-27 Thread Michael Glaesemann
on the Russia/China/N.Korean border and now Chile? Hrmmm ... Should I rocket my children to a solar system with a yellow sun? ...Robert Isn't that Rob-el? Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Alpha4 Available Now

2010-02-26 Thread Michael Glaesemann
) | (null) (null) | t| (null) | (null) (6 rows) Michael Glaesemann grzm seespotcode net -- 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] Correcting Error message

2010-02-26 Thread Michael Glaesemann
your example to work on Postgres 8.4 regardless due to the varchar2 type. Which version of Postgres are you using? test=# CREATE TABLE footable(id int4, name varchar2(10)); ERROR: type varchar2 does not exist Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing

Re: [HACKERS] Correcting Error message

2010-02-26 Thread Michael Glaesemann
On Feb 26, 2010, at 21:03 , Tom Lane wrote: Michael Glaesemann g...@seespotcode.net writes: On Feb 26, 2010, at 3:30 , Piyush Newe wrote: SELECT (footable.*).foofunc FROM footable; ERROR: column footable.foofunc does not exist Is that calling syntax correct? I'd think it should

Re: [HACKERS] Pathological regexp match

2010-02-01 Thread Michael Glaesemann
problematic query that triggered the report, and it runs much faster. Thanks for the fix! Michael Glaesemann michael.glaesem...@myyearbook.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Pathological regexp match

2010-01-28 Thread Michael Glaesemann
not match'; } This is a simplified version of a match that finally finished after 18 hours. Given the nearly 4 orders of magnitude difference between the Perl script and the Postgres version, is there something that could be improved in the Postgres regex engine? Cheers, Michael Glaesemann

Re: [HACKERS] Pathological regexp match

2010-01-28 Thread Michael Glaesemann
On Jan 28, 2010, at 21:59 , Alvaro Herrera wrote: Hi Michael, Michael Glaesemann wrote: We came across a regexp that takes very much longer than expected. PostgreSQL 8.4.1 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-44), 64-bit SELECT 'ooo

Re: [HACKERS] Pathological regexp match

2010-01-28 Thread Michael Glaesemann
with a different regexp. I'm just reporting the particular unexpected nastiness we ran into. :) Michael Glaesemann michael.glaesem...@myyearbook.com -- 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] creating index names automatically?

2009-12-20 Thread Michael Glaesemann
., _fkey. Michael Glaesemann grzm seespotcode net -- 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] New VACUUM FULL

2009-12-04 Thread Michael Glaesemann
, and then Simon can remove extra tests after he's convinced that it works. I tested a variety of situations during my review, and everything worked as I expected. Would there be a way for you to package the scenarios you tested into a suite? Michael Glaesemann grzm seespotcode net

Re: [HACKERS] Hot Standby status

2009-11-10 Thread Michael Glaesemann
, DROP, ALTER, and COMMENT are not? Cheers, Michael Glaesemann grzm seespotcode net -- 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: make plpgsql IN args mutable (v1) [REVIEW]

2009-09-16 Thread Michael Glaesemann
$ As is this: CREATE FUNCTION mod (x int, y int) RETURNS int LANGUAGE plpgsql AS $f$ BEGIN RETURN (x % y); END; $f$ Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] PATCH: make plpgsql IN args mutable (v1) [REVIEW]

2009-09-16 Thread Michael Glaesemann
an example at hand? I'd argue that in a case of a function of more complexity from a code clarity standpoint you'd want to assign to a new variable that describes what the new value reflects. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] 8.5 release timetable, again

2009-08-26 Thread Michael Glaesemann
On Aug 26, 2009, at 11:18 , Jean-Michel Pouré wrote: Web apps are 95% of PostgreSQL possible users. Where does this figure come from? Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] generic options for explain

2009-05-25 Thread Michael Glaesemann
of explain results, gives each number an id and the id of its parent row, which behavior we could presumably copy. Or some other schema that allows us to preserve the tree. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] pg_restore --multi-thread

2009-02-12 Thread Michael Glaesemann
On 2009-02-12, at 14:15 , Jonah H. Harris wrote: On Thu, Feb 12, 2009 at 11:37 AM, Joshua D. Drake j...@commandprompt.com wrote: --num-workers or --num-connections would both work. --num-parallel? --num-concurrent? Michael Glaesemann michael.glaesem...@myyearbook.com -- Sent via

Re: [HACKERS] Proposal: new border setting in psql

2009-01-08 Thread Michael Glaesemann
or not that is useful here is another argument). I think there may be confusion here betwixt ReST/RST and REST. REST: http://en.wikipedia.org/wiki/Representational_State_Transfer ReST/RST: http://en.wikipedia.org/wiki/ReStructuredText Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing

[HACKERS] Constraint partition index usage

2008-10-14 Thread Michael Glaesemann
(cost=0.00..46648.65 rows=2572965 width=8) (14 rows) I thought Greg Stark had looked at some performance tweaks wrt constraint partitioning, but I can't recall the details. Was that related to this at all? Michael Glaesemann [EMAIL PROTECTED] -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] \df displaying volatility

2008-05-24 Thread Michael Glaesemann
that don't already show the comment.) Michael Glaesemann [EMAIL PROTECTED] -- 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] Proposed patch: synchronized_scanning GUC variable

2008-01-27 Thread Michael Glaesemann
, or synchronized_seqscans? We have enable_seqscan already, so that last choice seems to fit in. Would it make sense to match the plural as well? Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 4: Have you searched our list

Re: [HACKERS] Integer datatimes vs msvc

2007-12-03 Thread Michael Glaesemann
, similar to the formerly deprecated money type? Would we want to? Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] minimal update

2007-11-10 Thread Michael Glaesemann
On Nov 8, 2007, at 10:46 , Andrew Dunstan wrote: Tom Lane wrote: Michael Glaesemann [EMAIL PROTECTED] writes: What would be the disadvantages of always doing this, i.e., just making this part of the normal update path in the backend? (1) cycles wasted to no purpose in the vast

Re: [HACKERS] minimal update

2007-11-08 Thread Michael Glaesemann
. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS]

2007-10-31 Thread Michael Glaesemann
PROTECTED] List-Post: mailto:pgsql-hackers@postgresql.org List-Subscribe: mailto:[EMAIL PROTECTED] hackers List-Unsubscribe: mailto:[EMAIL PROTECTED] 20pgsql-hackers And from the website: http://archives.postgresql.org/pgsql-hackers/ Michael Glaesemann grzm seespotcode net

Re: [HACKERS] Latin vs non-Latin words in text search parsing

2007-10-23 Thread Michael Glaesemann
, hword_part and hword_numpart? I find the latter to be more readable as variable names. Or was your thought to be able to identify the content from the first part of the variable name? Michael Glaesemann grzm seespotcode net ---(end of broadcast

Re: [HACKERS] Latin vs non-Latin words in text search parsing

2007-10-23 Thread Michael Glaesemann
your answer off the air :) Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] rolcanlogin vs. the flat password file

2007-10-14 Thread Michael Glaesemann
. If the general consensus is to leave the current behavior, a comment should probably be included to note that the behavior is intentional. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map

Re: [HACKERS] Locales and Encodings

2007-10-12 Thread Michael Glaesemann
is this fundamentally different from PostgreSQL using a separate users/roles system than the OS? Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http

Re: [HACKERS] Seems we need a post-beta1 initdb already

2007-10-12 Thread Michael Glaesemann
On Oct 12, 2007, at 17:41 , Tom Lane wrote: Also, if we do #2 it means that we have the option to resolve the contrib/txid mess by pushing txid into the core backend before beta2. Any votes pro or con on that? +1 Michael Glaesemann grzm seespotcode net ---(end

Re: [HACKERS] Release notes introductory text

2007-10-11 Thread Michael Glaesemann
project such as PostgreSQL provides advantages here, in that preliminary testing can be performed during the development of the release, verified, of course, after the release has been made. Michael Glaesemann grzm seespotcode net PGP.sig Description: This is a digitally signed message part

Re: [HACKERS] quote_literal with NULL

2007-10-10 Thread Michael Glaesemann
-- comparison AND foo = 'ignore me' -- comparison Or is that what the smiley was about? :) Michael Glaesemann grzm seespotcode net PGP.sig Description: This is a digitally signed message part

Re: [HACKERS] Skytools committed without hackers discussion/review

2007-10-10 Thread Michael Glaesemann
make it in before feature freeze. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Skytools committed without hackers discussion/review

2007-10-09 Thread Michael Glaesemann
will contribute even more in the future. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] IDE

2007-10-01 Thread Michael Glaesemann
+ psql to work quite well. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Hash index todo list item

2007-09-25 Thread Michael Glaesemann
On Sep 25, 2007, at 11:26 , Kenneth Marshall wrote: Although I am very excited about this patch, I do not see any real value in including it in 8.3. I don't think you have to worry about it being in 8.3. Feature freeze was months ago. Michael Glaesemann grzm seespotcode net

Re: [HACKERS] SPI access to PostgreSQL query plan

2007-09-17 Thread Michael Glaesemann
views). AIUI, the stress is on the *can*, with a meaning of may, right? Not all SQL functions can be inlined. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Hash index todo list item

2007-09-06 Thread Michael Glaesemann
. There might be other issues with truncation, but preventing hashes from being unique isn't one of them. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [DOCS] [HACKERS] Contrib modules documentation online

2007-08-29 Thread Michael Glaesemann
want to see that happen next release. +1 Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] SQL feature requests

2007-08-23 Thread Michael Glaesemann
On Aug 23, 2007, at 10:47 , Ben Tilly wrote: On 8/22/07, Michael Glaesemann [EMAIL PROTECTED] wrote: *This* seems like a bug: test=# select record_id , count(observation_id) as bar from observation group by record_id , case when true

Re: [HACKERS] SQL feature requests

2007-08-23 Thread Michael Glaesemann
is impenetrable to you. Window clauses are part of the definition of analytic functions, which postgres does NOT yet implement. However they are on the todo list. And being worked on, from what I gather. Just not for 8.3. So hopefully you won't have to wait too much longer. Michael Glaesemann grzm

Re: [HACKERS] SQL feature requests

2007-08-23 Thread Michael Glaesemann
gensym? One alias you could always use and be guaranteed it would give a unique value. Still provide the alias, but don't have to think about name collisions. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 9: In versions

Re: [HACKERS] SQL feature requests

2007-08-22 Thread Michael Glaesemann
on this point.) I'm not trying to dismiss your points, just trying to address them. I'm interested to hear what others have to say. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] SQL feature requests

2007-08-22 Thread Michael Glaesemann
On Aug 22, 2007, at 20:36 , Ben Tilly wrote: On 8/22/07, Michael Glaesemann [EMAIL PROTECTED] wrote: On Aug 22, 2007, at 18:45 , Ben Tilly wrote: 1. Just a minor annoyance, but why must subqueries in FROM clauses have an alias? It's required by the SQL standard, AIUI. I wonder what

Re: [HACKERS] SQL feature requests

2007-08-22 Thread Michael Glaesemann
(observation_id) as bar from observation group by case when true then record_id end; ERROR: column observation.record_id must appear in the GROUP BY clause or be used in an aggregate function Michael Glaesemann grzm seespotcode net

Re: [HACKERS] change name of redirect_stderr?

2007-08-18 Thread Michael Glaesemann
be enabled to generate Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get

Re: [HACKERS] change name of redirect_stderr?

2007-08-14 Thread Michael Glaesemann
enable_logging or start_logger? Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] [EMAIL PROTECTED]: Re: [GENERAL] array_to_set functions]

2007-08-08 Thread Michael Glaesemann
guarantee element uniqueness (but that's just a naming issue). Michael Glaesemann grzm seespotcode net PGP.sig Description: This is a digitally signed message part

Re: [HACKERS] [EMAIL PROTECTED]: Re: [GENERAL] array_to_set functions]

2007-08-08 Thread Michael Glaesemann
On Aug 8, 2007, at 12:18 , Decibel! wrote: On Wed, Aug 08, 2007 at 12:03:34PM -0500, Michael Glaesemann wrote: Personally, I think expandarray is more appropriate and its functionality probably more generally useful, as it identifies the array indices as well. Note you can also rename

Re: [HACKERS] Label Security and Fine-grained auditing

2007-08-04 Thread Michael Glaesemann
. This is an important security enhancement. One other feature is called Fine-Grained Auditing. Ability to track user activities. I hope this is in PostgreSQL in one form or the other. Would Veil suit your needs? http://veil.projects.postgresql.org/ Michael Glaesemann grzm seespotcode net

Re: [HACKERS] log_autovacuum

2007-08-03 Thread Michael Glaesemann
to move forward with consistent naming or improve naming when the chance arises. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [HACKERS] Updated tsearch documentation

2007-07-17 Thread Michael Glaesemann
]? You're not qualifying the others with my_ ... or is there something you want to tell us, Bruce? :) Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [HACKERS] [Pgbuildfarm-members] time to play ...

2007-06-29 Thread Michael Glaesemann
On Jun 29, 2007, at 10:25 , Andrew Dunstan wrote: I will be on vacation in Spain for the next two weeks, and only sporadically in electronic contact. Have a great time! Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 1

Re: [HACKERS] Worries about delayed-commit semantics

2007-06-22 Thread Michael Glaesemann
On Jun 22, 2007, at 9:23 , Richard Huxton wrote: Or perhaps sync_on_commit = off? Or switch it around... sink_on_commit = on (sorry for the noise) Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 5: don't forget

Re: [HACKERS] tsearch in core patch

2007-06-22 Thread Michael Glaesemann
On Jun 22, 2007, at 9:28 , Tom Lane wrote: Is the point here for initdb to be able to establish a sane default initially? Seems to me it can guess the language from the first component of the locale (ru_RU - russian). How would this work for initdb with locale C? Michael Glaesemann grzm

Re: [HACKERS] Change sort order on UUIDs?

2007-06-15 Thread Michael Glaesemann
missed something? Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [HACKERS] question for serial types with CHECK conditions

2007-04-28 Thread Michael Glaesemann
constraint on a INTEGER (SERIAL) column, and the server is not (and will probably never be) smart enough to know your particular business rules without you telling it specifically. Does this help clarify the situation? Michael Glaesemann grzm seespotcode net

Re: [HACKERS] functions to obtain query plan

2007-04-21 Thread Michael Glaesemann
/interactive/performance-tips.html Hope this helps. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Developer TODO List as a PostgreSQL DB

2007-02-27 Thread Michael Glaesemann
On Feb 27, 2007, at 23:40 , Andrew Dunstan wrote: Maybe we need some extra FAQs, like: . Why do you still use CVS instead of insert favorite SCM system here? I just saw a patch from Robert Treat on just this topic. Doesn't look like its been applied yet. Michael Glaesemann grzm

Re: [HACKERS] period data type

2007-02-04 Thread Michael Glaesemann
together? Michael Glaesemann grzm seespotcode net [1]http://books.elsevier.com/uk/mk/uk/subindex.asp?isbn=9781558608559 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Modifying and solidifying contrib

2007-01-30 Thread Michael Glaesemann
system for a couple of years, so I'm not it a position currently to play around with this, but it's something I'd love to learn how to do. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 5: don't forget to increase your free

Re: [HACKERS] Modifying and solidifying contrib

2007-01-27 Thread Michael Glaesemann
an extension module ... They test standard SQL operations as well as the extended capabilities of PostgreSQL. The pgxs docs do use module as well, but as previously mentioned module already has a particular meaning in the spec. Michael Glaesemann grzm seespotcode net

Re: [HACKERS] ideas for auto-processing patches

2007-01-10 Thread Michael Glaesemann
On Jan 9, 2007, at 20:41 , Jim C. Nasby wrote: On Mon, Jan 08, 2007 at 10:40:16PM -0600, Michael Glaesemann wrote: On Jan 8, 2007, at 19:25 , Jim C. Nasby wrote: Actually, I see point in both... I'd think you'd want to know if a patch worked against the CVS checkout it was written against

Re: [HACKERS] ideas for auto-processing patches

2007-01-10 Thread Michael Glaesemann
On Jan 11, 2007, at 10:35 , Richard Troy wrote: On Wed, 10 Jan 2007, Jim C. Nasby wrote: On Thu, Jan 11, 2007 at 08:04:41AM +0900, Michael Glaesemann wrote: Wouldn't there be some value to knowing whether the patch failed due to bitrot vs it just didn't work on some platforms out

Re: [HACKERS] TODO item: update source/timezone for 64-bit tz files

2007-01-10 Thread Michael Glaesemann
no need to hold up 8.2 to fix it), but it ought to go on the TODO list. regards, tom lane Did this get fixed? I don't see it in the release notes for 8.2 or on the current TODO. Michael Glaesemann grzm seespotcode net ---(end of broadcast

Re: [HACKERS] TODO item: update source/timezone for 64-bit tz files

2007-01-10 Thread Michael Glaesemann
On Jan 11, 2007, at 12:51 , Tom Lane wrote: Michael Glaesemann [EMAIL PROTECTED] writes: Did this get fixed? I don't see it in the release notes for 8.2 or on the current TODO. No, nothing's been done. It's going to be a minor PITA, likely, since our sources have diverged from upstream

Re: [HACKERS] ideas for auto-processing patches

2007-01-08 Thread Michael Glaesemann
?) Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] Reverse-sort indexes and NULLS FIRST/LAST sorting

2007-01-05 Thread Michael Glaesemann
as an optional noise word? Users may be surprised if ASC were to throw an error. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Better management of mergejoinable operators

2006-12-12 Thread Michael Glaesemann
be not only the same type (text) but also of the same locale)? I'd think this is would be the case so it wouldn't end up being a problem. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Better management of mergejoinable operators

2006-12-12 Thread Michael Glaesemann
will just reinforce that. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] Better management of mergejoinable operators

2006-12-12 Thread Michael Glaesemann
On Dec 13, 2006, at 12:33 , Michael Glaesemann wrote: On Dec 13, 2006, at 8:45 , Tom Lane wrote: the entire operator/function structure is built on the assumption that there is, say, only one = between any two datatypes. You mean only on = between any two values of a given datatype

Re: [HACKERS] timestamp subtraction (was Re: [SQL] formatting intervals with to_char)

2006-10-05 Thread Michael Glaesemann
, perhaps the change in behavior should come in 8.3. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [HACKERS] @ versus ~, redux

2006-09-09 Thread Michael Glaesemann
is deprecated and not even documented, maybe this isn't worth fixing. Any thoughts? I'd say leave tinterval as it is. If it's ever updated to use the modern time types (rather than abstime), that would be a logical time to change it, it seems to me. Michael Glaesemann grzm seespotcode net

Re: [HACKERS] @ versus ~, redux

2006-09-04 Thread Michael Glaesemann
included the other Allen operators at the bottom for completeness. Michael Glaesemann grzm seespotcode net r1 = r2 r1 equals r2 r1 r2r1 does not equal r2 For the following, the or indicates the relative position of the two ranges if they were depicted on an line that increases from left

Re: [HACKERS] [PATCHES] Interval month, week - day

2006-09-03 Thread Michael Glaesemann
On Sep 1, 2006, at 9:32 , Tom Lane wrote: Michael Glaesemann [EMAIL PROTECTED] writes: On Sep 1, 2006, at 9:12 , Tom Lane wrote: I agree that this seems like an oversight in the original months/days/seconds patch, rather than behavior we want to keep. But is DecodeInterval the only place

Re: [HACKERS] [PATCHES] Interval month, week - day

2006-09-03 Thread Michael Glaesemann
On Sep 3, 2006, at 20:00 , Michael Glaesemann wrote: On Sep 1, 2006, at 9:32 , Tom Lane wrote: Michael Glaesemann [EMAIL PROTECTED] writes: On Sep 1, 2006, at 9:12 , Tom Lane wrote: I agree that this seems like an oversight in the original months/days/seconds patch, rather than behavior

Re: [HACKERS] [PATCHES] Interval month, week - day

2006-09-03 Thread Michael Glaesemann
On Sep 4, 2006, at 9:41 , Tom Lane wrote: This patch fails to apply --- looks like whitespace got mangled in transit. Please resend as an attachment. Please let me know if you have any problems with this one. Michael Glaesemann grzm seespotcode net 10interval_input_0904T0855+0900.diff

  1   2   3   >