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

On Jun 25, 2014, at 22:14, Tom Lane wrote: > I wrote: >> Michael Glaesemann 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.

[HACKERS] sorting a union over inheritance vs pathkeys

ibits 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/mai

Re: [HACKERS] another error perhaps to be enhanced

On Jun 14, 2013, at 13:38, "Joshua D. Drake" 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. - http://www.commandprompt.com/ 509-416-

Re: [HACKERS] Tablespaces in the data directory

hat wouldn't be affected by this though, since it would only warn at > create tablespace. > > I'd still consider it a bad idea in general to do that, since you're > basically messing 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 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

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 Glaesema

Re: [HACKERS] Schema version management

function names relatively short. If we're dumping objects (tables, views, functions, what-have-you) into separate 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

for putting one function definition per 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-hacker

Re: [HACKERS] New Postgres committer: Kevin Grittner

judged that he has 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

Re: [HACKERS] proposal - urlencode, urldecode support

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-h

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

hed a version-independent hash 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.

lso having its meeting at the same time 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?

On Jul 4, 2011, at 10:09, Magnus Hagander wrote: > On Mon, Jul 4, 2011 at 00:01, Michael Glaesemann 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 g

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

C, something along the lines of: connection_pools={stats=3,superuser=10} 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 g

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

gt; by value or not. >> >> We already solved that for contrib/isn --- use the LIKE 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 ma

Re: [HACKERS] [GENERAL] PostgreSQL Core Team

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 (pg

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

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 subs

[HACKERS] OSSP gone missing? Fate of UUID?

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@postgresq

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

shmem --- it doesn't like variable-size shmem much. Maybe > that's another argument 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?

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

gt; collapsed -- right? I've seen this as well be a performance issue, 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".

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

a good introductory paper on > the topic? The README 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 seesp

Re: [HACKERS] patch: to_string, to_array functions

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)

Re: [HACKERS] Additional startup logging

of dumping the version and/or setting information on demand (or perhaps 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

Re: [HACKERS] hstore ==> and deprecate =>

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 pgsq

Re: [HACKERS] hstore ==> and deprecate =>

t > similarly, but I just work here. Perhaps -> Would a colon work? (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] Anyone know if Alvaro is OK?

/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 subscription:

Re: [HACKERS] Correcting Error message

On Feb 26, 2010, at 21:03 , Tom Lane wrote: Michael Glaesemann 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 be: SELECT foofunc(foo

Re: [HACKERS] Correcting Error message

any event, I couldn't get 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 n

Re: [HACKERS] Alpha4 Available Now

| f t | t| f| t (null) | f| (null) | (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] Pathological regexp match

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

Re: [HACKERS] Pathological regexp match

the task I had at hand 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] Pathological regexp match

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 

[HACKERS] Pathological regexp match

; } else { print 'does 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 re

Re: [HACKERS] creating index names automatically?

edent for abbreviations with automatic naming in Postgres, e.g., "_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

tests, 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 seesp

Re: [HACKERS] Hot Standby status

- Create, Drop, Alter, Comment (even for temporary tables because + currently these cause writes to catalog tables) + + Other commands are in all-caps. Any reason INSERT, UPDATE, DELETE, TRUNCATE, CREATE, DROP, ALTER, and COMMENT are not? Cheers, Michael Glaesemann

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

Have 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

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

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] 8.5 release timetable, again

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

table 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

Re: [HACKERS] pg_restore --multi-thread

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

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

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

ows=1770 width=8) -> Seq Scan on bars_20080929 bars (cost=0.00..215029.52 rows=11872652 width=8) -> Seq Scan on bars_20081006 bars (cost=0.00..223559.96 rows=12343346 width=8) -> Seq Scan on bars_20081013 bars (cost=0.00..46648.65 rows=2572965 width=

Re: [HACKERS] \df displaying volatility

atabase objects 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

t too long. How about "synchronized_scans", 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)---

Re: [HACKERS] Integer datatimes vs msvc

, 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

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 th

Re: [HACKERS] minimal update

es as well. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS]

TED]> 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

I'll take 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] Latin vs non-Latin words in text search parsing

, 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] rolcanlogin vs. the flat password file

of the failure. 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 t

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

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 of

Re: [HACKERS] Locales and Encodings

? How 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

Re: [HACKERS] Release notes introductory text

same time, an open source 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

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

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

Re: [HACKERS] quote_literal with NULL

-- 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

d I'm sure 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

applications, I find $EDITOR + 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

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 seespotcod

Re: [HACKERS] SPI access to PostgreSQL query plan

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

ons. 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

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

e altogether. I really 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

bqueries. How about something like 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)-

Re: [HACKERS] SQL feature requests

on 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 Glaes

Re: [HACKERS] SQL feature requests

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 whe

Re: [HACKERS] SQL feature requests

3 | 2 (3 rows) And for good measure: test=# select record_id , count(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

Re: [HACKERS] SQL feature requests

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

Re: [HACKERS] SQL feature requests

out of hand (though you can check the archives), just that no one's gotten around to it. (Don't know what the SQL-spec says 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] change name of redirect_stderr?

nabled 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 through t

Re: [HACKERS] change name of redirect_stderr?

: messages are just sent to stderr. Why something simple like 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]

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 the

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

r | 2 baz | 3 (3 rows) array_to_set really isn't, as AFAICS it didn't 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] Label Security and Fine-grained auditing

. 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

is whether it's better 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

Re: [HACKERS] Updated tsearch documentation

]? 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 subs

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

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] tsearch in core patch

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 g

Re: [HACKERS] Worries about delayed-commit semantics

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&#

Re: [HACKERS] Change sort order on UUIDs?

y so. Or have I 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

The crux of the issue is that there may be valid reasons to have a CHECK 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 he

Re: [HACKERS] functions to obtain query plan

g/docs/8.2/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

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 here>? I just saw a patch from Robert Treat on just this topic. Doesn't look like its been applied yet. Michael Glaesemann grzm seespot

Re: [HACKERS] period data type

Model[1] very helpful. Interested in possibly working 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

building on a local 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:

Re: [HACKERS] Modifying and solidifying contrib

. Here is an example that builds 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. Mich

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

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 d

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

y see 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

Re: [HACKERS] ideas for auto-processing patches

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

Re: [HACKERS] ideas for auto-processing patches

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 writt

Re: [HACKERS] ideas for auto-processing patches

ted as a diff anyway?) 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

ASC 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

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

Re: [HACKERS] Better management of mergejoinable operators

m missing? So what you're doing 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

e 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] timestamp subtraction (was Re: [SQL] formatting intervals with to_char)

e it is in the cycle, 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 [EMAI

Re: [HACKERS] @ versus ~, redux

. Given that tinterval 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.

Re: [HACKERS] @ versus ~, redux

t use the one that applies and leave out the other. Granted, it means two pairs of reassignments (the to the left/right of and the subset/ superset), but if we're breaking it, one more pair isn't that big of a deal. And it leaves @ to mean something else. Michael Glaesemann grzm seespotcode net ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] [PATCHES] possible ecpg vpath build error

On Sep 4, 2006, at 13:12 , Tom Lane wrote: Michael Glaesemann <[EMAIL PROTECTED]> writes: For the record, the error I'm getting is Makefile:3: ../../../src/Makefile.global: No such file or directory make: *** No rule to make target `../../../src/Makefile.global'. St

Re: [HACKERS] @ versus ~, redux

aning of contains and is contained in is inclusive (rather than strict), then we'd have a <<= b : a contains b a =>> b : a is contained by b I've included the other Allen operators at the bottom for completeness. Michael Glaesemann grzm seespotcode net r1 = r2 r1 equals

Re: [HACKERS] [PATCHES] possible ecpg vpath build error

k at them later. There's a good chance the problem is with the script rather than the build itself. For the record, the error I'm getting is Makefile:3: ../../../src/Makefile.global: No such file or directory make: *** No rule to make target `../../../src/Makefile.global

  1   2   3   >