Re: [HACKERS] Proposed patch - psql wraps at window width

Bruce Momjian [EMAIL PROTECTED] writes: Gregory Stark wrote: Now, we could get fancy and honor $COLUMNS only in non-interactive mode, but that seems confusing. We could always read COLUMNS early on before readline is initialized and stash the value away in a variable. But... We

Re: [HACKERS] Recent buildfarm failures involving statement_timeout

and not psql. Hm. Perhaps Bruce's terminate patch wasn't completely reverted and there was a flag somewhere which isn't being reset properly? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing

Re: [HACKERS] Proposed patch - psql wraps at window width

it as such. If you want a way to specify wrapped on a terminal but not to a non-terminal then you should make that explicit and separate from the column-width determination. I'm done with this thread now. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7

Re: [HACKERS] Proposed patch - psql wraps at window width

. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- 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] Proposed patch - psql wraps at window width

Bruce Momjian [EMAIL PROTECTED] writes: Gregory Stark wrote: Earlier I suggested -- and nobody refuted -- that we should follow the precedents of ls and man and other tools which need to find the terminal width: Explicitly set width takes precedence always, if it's not explicitly set

Re: [HACKERS] Index AM change proposals, redux

, like what do you do on leaf pages? You have to be able to follow leaf pages down the chain without consulting their parent. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql

Re: [HACKERS] Proposed patch - psql wraps at window width

and uh, I don't know what happens. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Proposed patch - psql wraps at window width

. If you come up with complicated logic trying to anticipate every case and get it wrong users get angry. If you just have simple rules which always apply then users understand they they need to override them for their corner cases. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com

Re: [HACKERS] Proposed patch - psql wraps at window width

ignore the user's -Pformat=wrapped ? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] Proposed patch - psql wraps at window width

to it and always follow the same logic to determine the width. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Proposed patch - psql wraps at window width

Alvaro Herrera [EMAIL PROTECTED] writes: On what platforms does ioctl() fail? On ssh for example. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Proposed patch - psql wraps at window width

-- which doesn't seem bad to me but it means it isn't satisfying your desires. I do think we might be adding an 'auto' format the does aligned/wrapped/expanded based on the table width, but only for interactive use. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me

Re: [HACKERS] Proposed patch - psql wraps at window width

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Alvaro Herrera [EMAIL PROTECTED] writes: On what platforms does ioctl() fail? On ssh for example. That'd certainly be a showstopper if true, but it seems to be okay for me. ssh'ing from an xterm window

Re: [HACKERS] Proposed patch - psql wraps at window width

and man and other tools which need to find the terminal width: Explicitly set width takes precedence always, if it's not explicitly set then you use the ioctl, and if that fails then you use the COLUMNS environment variable. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me

Re: [HACKERS] Numeric Functions

. All the var stuff is internal to the numeric data type operators. What kind of user defined code are you writing? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] CommitFest Wiki page annoyance

then happened is I accidentally pasted the part I was recovering back into that same old version rather than the current one and hit save. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training

Re: [HACKERS] MERGE Specification

or insert successfully. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] INSERT ... SELECT ... FOR SHARED?

|0 | 6 | 1 |0 | 7 | 1 |0 | 8 | 1 |0 | 9 | 1 |0 | 10 | 1 |0 | (10 rows) postgres=# select distinct age(xmax) from tellers; age - 0 (1 row) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask

Re: [HACKERS] MERGE Specification

conditions what advantage does it offer over writing plpgsql or client code to do it? I thought the whole advantage of having a built-in command is that it could do the kind of locking our unique constraints do to avoid race conditions. -- Gregory Stark EnterpriseDB http

Re: [HACKERS] Lessons from commit fest

that these are a basically the same order of magnitude. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] Cross-field statistics

to actually gather on the resulting column sets. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Plan targetlists in EXPLAIN output

that offhand anyways. So +1 for just redefining VERBOSE. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Lessons from commit fest

pgindent on their own added code it won't work since their own code will be precisely the code with the missing typedefs. How easy is it to manually add a handful of typedefs to the list? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA

Re: [HACKERS] Plan targetlists in EXPLAIN output

understand what width means. Or does the planner think most of these columns are mostly null? Or is it estimating the width based on the belief that only the thousand column is actually going to be emitted? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce

Re: [HACKERS] Lessons from commit fest

their name? 3) How would this work with typedefs which come from system or library includes? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] RFD: hexstring(n) data type

if we could declare columns as NUMERIC but attach a default format to them for use when string representation is desired. Similarly with bytea we could choose a default string representation different from the default in/out functions. -- Gregory Stark EnterpriseDB http

Re: [HACKERS] pgsql: Fix a couple of oversights associated with the physical tlist

? Is it going to force us to do extra work to reconstruct the same data? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Lessons from commit fest

Tom Lane [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: 1) I take it we feel safe guaranteeing that we won't use any fancy macros inside typedefs. So no '#define pgtype(x) _pg_##x' or anythin like

Re: [HACKERS] pg_terminate_backend() issues

for sure that it's the *right* cleanup routine or enough cleanup routines but hopefully we would catch the error often enough to notice. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing

Re: [HACKERS] pg_terminate_backend() issues

Gregory Stark [EMAIL PROTECTED] writes: Or weakly -- an assert in CHECK_FOR_INTERRUPTS oops, that's irrelevant of course. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Collation at database level

these collations. These are encodings. What ANSI spec are you referring to, SQL? What does it actually say? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Improve shutdown during online backup

would work too) to kick off users based on various criteria you can specify. Then you can put in your backup scripts two commands, one to kick off idle users and then do a smart shutdown. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS

Re: [HACKERS] pg_terminate_backend() issues

at a CHECK_FOR_INTERRUPTS() call. You'd just need to be sure there wasn't one in the cleanup code. Wait, huh? In that case I don't see what advantage any of this has over Bruce's patch. And his approach seemed a lot more robust. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com

Re: [HACKERS] pg_terminate_backend() issues

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: No, we wouldn't, because a SIGTERM can only actually fire at a CHECK_FOR_INTERRUPTS() call. You'd just need to be sure there wasn't one in the cleanup code. Wait, huh

Re: [HACKERS] Improving planner variable handling

of extra work. But at least you would only have to pay that for that one level, not carry it along and pay for it for the rest of the planning. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training

Re: [HACKERS] Lessons from commit fest

generate this file? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- 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] How to submit a patch

the rationale was for the changes. That's why waiting until feature freeze was so awful from my point of view. There was never any time left to return patches to the author so Tom ended up reworking any patches we really wanted. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com

Re: [HACKERS] Lessons from commit fest

-kernel is to include the output of diffstat when you post the patch. That helps people to get an idea of whether their favourite area of the code is being whacked around and it warrants a look. It also helps get a quick overview of what to expect as you start to read the patch proper. -- Gregory

Re: [HACKERS] stack smashing detected

saying. Are you sure you receive that message in psql? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] [COMMITTERS] pgsql: Add pg_terminate_backend() to allow terminating only a single

for sinval processing of having to get a whole bunch of LWLocks though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] pg_terminate_backend() idea

Bruce Momjian [EMAIL PROTECTED] writes: Gregory Stark wrote: It seems to me we could replace all of the above with either SIGINT or USR1 and have a bunch of boolean flags in MyProc. I'm not sure of the implication for sinval processing of having to get a whole bunch of LWLocks though. Keep

Re: [HACKERS] Lessons from commit fest

not that I don't appreciate having you doing all this work but I think it would be a good exercise for us to go through do once. (And you certainly deserve a break!) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent

Re: [HACKERS] Remove lossy-operator RECHECK flag?

of picking up code which was actually compiled with older header files after all, the magic numbers wouldn't match if it's V1 and in any case I would expect it to crash long before any mistaken tuples were returned. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get

Re: [HACKERS] stack depth limit exceeded - patch possible?

send whole serialized objects over. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] stack depth limit exceeded - patch possible?

if you're calling the Postgres code from the original thread which called Java. If you're not in the same thread as Postgres then you're still going to be in trouble. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via

Re: [HACKERS] Separate psql commands from arguments

backslash commands now? I mean. What happens if I do: \encoding 'UTF8' \alias foo select 'あ' from tab; \encoding euc-jp \foo What encoding is the alias itself stored in? Do we have to worry about converting it when you switch client-encodings? -- Gregory Stark EnterpriseDB http

Re: [HACKERS] Commit fest queue

tool. We'll see what info we need there and who needs to fill it in and find out what tool will fit our needs. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Commit fest queue

how it works. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- 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] Commit fest queue

by default, perhaps organized in some way (keywords, milestones, etc) would be more conducive to getting attention to everything. I'm sure you can do something like that in Bugzilla and RT but it sure doesn't seem to be the way it's used in practice. -- Gregory Stark EnterpriseDB http

Re: [HACKERS] Cached Query Plans

for queries, mark plans as being acceptable or not, and even revoke users' permissions to execute queries which aren't already present and marked as being acceptable. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning

Re: [HACKERS] Cached Query Plans

. Unsurprisingly most drivers do precisely what you're describing. In Perl DBI for example you just change $dbh-prepare() into $dbh-prepare_cached() and it does exactly what you want. I would expect the PHP drivers to have something equivalent. -- Gregory Stark EnterpriseDB http

Re: [HACKERS] Index AM change proposals, redux

and push them up several nodes -- even including joins -- before fetching the rest of the attributes from the heap. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers

Re: [HACKERS] Commit fest queue

you want to see the summarized data. Personally I would consider any system without at least these attributes to be unusable: a) Never sends an email without the full content it's notifying you of b) Never sends an email which can't be replied to normally -- Gregory Stark EnterpriseDB

Re: [HACKERS] Concurrent psql API

connection. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- 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] Commit fest queue

. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- 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] Separate psql commands from arguments

matter -- that way lies, uhm, other databases. Let's keep in mind when designing the feature the most long-term use where the design matters most rather than the case where it matters least. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand

Re: [HACKERS] [PATCHES] libpq type system 0.9a

pqtypes errors separate from libpq errors? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Concurrent psql API

now since I originally had it as a prefix command you gave before issuing the sql. As a postfix command, \g, the logic could be a bit simpler. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql

Re: [HACKERS] [PATCHES] libpq type system 0.9a

-- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- 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] Commit fest queue

buried in those 2,000 messages. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] GiST opclass and varlena

in prefix.c? Was it specifically related to a varlena or was it a char or something like that? And was it something gcc -Wall was warning about or somehow was it slipping by? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support

Re: [HACKERS] Commit fest queue

. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Commit fest queue

on his own todo list of patches to take and patches to send upstream though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Separate psql commands from arguments

Decibel! [EMAIL PROTECTED] writes: Am Samstag, 5. April 2008 schrieb Gregory Stark: On Apr 10, 2008, at 7:50 AM, Peter Eisentraut wrote: I also don't see any point in allowing aliases which call other psql commands. Why disallow it? I think it could be very useful. Well I feel like

Re: [HACKERS] none

backends. You could look at these two threads for some more information: http://archives.postgresql.org/pgsql-hackers/2007-05/msg00115.php http://archives.postgresql.org/pgsql-hackers/2007-05/msg00361.php -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [HACKERS] Commit fest queue

things organized and so on. But you have to come up with benefits which outweigh the additional complexities, not claim your favourite software is less complex than just keeping a todo list. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me

Re: [HACKERS] Commit fest queue

Joshua D. Drake [EMAIL PROTECTED] writes: Its about efficiency. If I have to *think* about some kind of process that takes cycles away from other more important and interesting things like algorithms. This thread has already consumed far too many cycles. -- Gregory Stark EnterpriseDB

Re: [HACKERS] [PATCHES] libpq type system 0.9a

function. The built-in data types do, but only as a matter of policy. It's not an error to create a type with no binary i/o functions. So I think you have to support using text mode as an option. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's

Re: [HACKERS] Concurrent psql API

. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] SET TRANSACTION not compliant with SQL:2003

: transaction is read-only postgres=# rollback; ROLLBACK postgres=# set transaction read only; SET postgres=# set transaction isolation level serializable; SET postgres=# create table i (integer i); ERROR: transaction is read-only -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask

Re: [HACKERS] Commit fest queue

so I don't know how accessible these things are to each other. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Commit fest queue

information we want to track I don't see why -- or even how -- we would pick a tool to track it. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Free Space Map data structure

to 8 but first you have to check that its sibling isn't also 9. Again when you get to the grandparnt you have to check that the 4 isn't a 9. As long as you're on one page that's cheap but if it means paging in another page of the FSM that could be annoying. -- Gregory Stark EnterpriseDB

Re: [HACKERS] Patch queue - wiki

in the current format as sublist items under each major bullet point. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] variables for tables and columns?

what you're thinking of would work would help? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] File system snapshots for multiple file systems

on the WAL partition and if so turn it off, clean old WAL segments, and march on. The major concern being that someone might have a bad backup. pg_stop_backup() could scream but they might not notice. Not sure how much more we could do about that. -- Gregory Stark EnterpriseDB http

Re: [HACKERS] Ordered Append Node

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: I've been hacking on the idea of an Append node which maintains the ordering of its subtables merging their records in order. I finally got round to looking at this ... A lot of things to chew on. Thanks very much

Re: [HACKERS] New style of hash join proposal

better off focusing on the patches I've already started rather than starting yet another project though so perhaps I should put this aside until I can construct a good demonstration. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS

Re: [HACKERS] Feature freeze status

thinking we should have a column in the commitfest info reviewer and specifically assign all the patches to someone, preferably distributed over as wide a list as possible. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent

Re: [HACKERS] machine-dependent hash_any vs the regression tests

random regression tests. It seems likely the day that happens will be the day that we provide an SQL standard UNNEST anyways though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent

Re: [HACKERS] Database owner installable modules patch

pretty dirty but on the other hand the idea of having modules consist of a bunch of objects rather than arbitrary SQL actually seems cleaner and more robust. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql

Re: [HACKERS] modules

customers have signed up? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] auto-vacuum conflicting with long running analyze

it for any of those reasons. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] machine-dependent hash_any vs the regression tests

faster than a decent crc32 implementation? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] modules

, something like: /usr/lib/postgresql/modules;/usr/local/lib/postgresql/modules That way users can compile and install their own modules into /usr/local without interfering with modules which come from OS packages. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained

Re: [HACKERS] Patch queue - wiki

for the May commitfest. There are only a handful of lines to put in the May commitfest and I think Alvaro's already put them in. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] modules

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: I would suggest a guc for the safe place and I would suggest it be a list of places. And I would suggest that for OS packagers they really want two locations on that list, something like: /usr/lib/postgresql

Re: [HACKERS] Garbage pad bytes within datums are bad news

create this situation we could have an assertion that calls the constructor a second time (with palloc generating garbage data) and compares the results with datumEqual. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about

Re: [HACKERS] modules

indispensable rather than just be doomed to being forgotten and ignored. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Garbage pad bytes within datums are bad news

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: The alternative seems to be to forbid uninitialized pad bytes within Datums. That's not very pleasant to contemplate either, since it'll forever be vulnerable to sins of omission

Re: [HACKERS] Separate psql commands from arguments

mean that if you try to run a query which doesn't exist you won't accidentally type a real command or get a command not found error. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-hackers mailing

Re: [HACKERS] Separate psql commands from arguments

Brendan Jurd [EMAIL PROTECTED] writes: On Sat, Apr 5, 2008 at 10:00 AM, Gregory Stark wrote: Regardless of whether we go ahead with this (and I'm not fond of it primarily because I want \c to work), Okay, but what on earth is \c and what would you expect it to do when it works? I

Re: [HACKERS] modules

or type make install in some source tree -- but actually log into each customer's database and run an SQL script. That does seem like more work and more risk than a lot of ISPs will be willing to take on. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [HACKERS] Patch queue - wiki

is in. Not coincidentally the lack of that info is also why your list isn't very helpful. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Commitfest patches

wonder if people wouldn't feel more comfortable taking baby steps at first which will have less impact in cases where it's not being heavily used. I think the way it is now is neat and simple and enough for now. Thanks. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get

Re: [HACKERS] Commitfest patches

Greg Smith [EMAIL PROTECTED] writes: On Fri, 28 Mar 2008, Gregory Stark wrote: I described which interfaces worked on Linux and Solaris based on empirical tests. I posted source code for synthetic benchmarks so we could test it on a wide range of hardware. I posted graphs based on empirical

Re: [HACKERS] Patch queue - wiki

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: The hard part is reading the email and figuring out what status the patch is in. Certainly. What we've got to do is make sure that after someone has made that decision, it doesn't cost them a couple of minutes

[HACKERS] psql slash# command

. Better to go our own way with a command that makes sense for psql than to try to turn psql into a traditional command-line shell. [1] http://archives.postgresql.org/pgsql-hackers/2006-12/msg00214.php -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [HACKERS] COPY Transform support

of text. Then copy it all to another table doing transformations. Not impressed. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

[HACKERS] Locale, Collation, ICU patch

but abysmally on most other libc's. From that point forward we would go about adding support for strcoll_l() and other interfaces to handle case (d) on various platforms. For platforms with no reasonable interface we could add a --enable-ICU users or packagers could choose to use. -- Gregory Stark

<    1   2   3   4   5   6   7   8   9   10   >