Re: [HACKERS] [PROPOSAL] Temporal query processing with range types

uld be simpler with support of the proposed syntax, and some of the most complex business logic would be simplified nearly to the point of triviality. Anyway, that's my $0.02. Thank you, Anton and Peter! -- Mike -- 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] [BUGS] BUG #14682: row level security not work with partitioned table

On Wed, Jun 7, 2017 at 9:49 AM, Mike Palmiotto <mike.palmio...@crunchydata.com> wrote: > One thing that concerns me is the first EXPLAIN plan from regress_rls_dave: > +EXPLAIN (COSTS OFF) SELECT * FROM part_document WHERE f_leak(dtitle); > +

Re: [HACKERS] [BUGS] BUG #14682: row level security not work with partitioned table

On Tue, Jun 6, 2017 at 9:12 PM, Michael Paquier <michael.paqu...@gmail.com> wrote: > On Wed, Jun 7, 2017 at 9:52 AM, Joe Conway <m...@joeconway.com> wrote: >> Thanks Mike. I'll take a close look to verify output correctnes, but I >> am concerned that the new tests are

Re: [HACKERS] [BUGS] BUG #14682: row level security not work with partitioned table

On Tue, Jun 6, 2017 at 4:07 PM, Joe Conway <m...@joeconway.com> wrote: > On 06/06/2017 11:57 AM, Mike Palmiotto wrote: >> On Mon, Jun 5, 2017 at 10:36 AM, Robert Haas <robertmh...@gmail.com> wrote: >>> On Mon, Jun 5, 2017 at 10:20 AM, Joe Conway <m...@joeconw

Re: [HACKERS] [BUGS] BUG #14682: row level security not work with partitioned table

On Mon, Jun 5, 2017 at 10:36 AM, Robert Haas <robertmh...@gmail.com> wrote: > On Mon, Jun 5, 2017 at 10:20 AM, Joe Conway <m...@joeconway.com> wrote: >> Unless Robert objects, I'll work with Mike to get a fix posted and >> committed in the next day or two. > > That

Re: [HACKERS] partitioned tables and contrib/sepgsql

ssion tests before committing, but I expect we'll > have those by end of today and be able to commit the rest tomorrow. Attached are the regression test updates for partitioned tables. Thanks, -- Mike Palmiotto Software Engineer Crunchy Data Solutions https://crunchydata.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] partitioned tables and contrib/sepgsql

On Wed, Apr 5, 2017 at 1:22 PM, Mike Palmiotto <mike.palmio...@crunchydata.com> wrote: > On Wed, Apr 5, 2017 at 1:19 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> Peter Eisentraut <peter.eisentr...@2ndquadrant.com> writes: >>> On 4/5/17 12:04, Tom Lane wrote: >

Re: [HACKERS] partitioned tables and contrib/sepgsql

ery is explained. > > I stand by my previous patch suggestion, except that we can replace > the parenthetical comment with something like "(We don't care if > redefines "true"/"false"; those are close enough.)". > Sounds good. Updated patchset will incl

Re: [HACKERS] partitioned tables and contrib/sepgsql

; far away. :-) > > OBE -- I have scheduled time in 30 minutes from now, after I have gotten > my first cup of coffee ;-) After some discussion off-list, I've rebased and udpated the patches. Please see attached for further review. Thanks, -- Mike Palmiotto Software Engineer Crunchy Da

Re: [HACKERS] partitioned tables and contrib/sepgsql

On Fri, Mar 31, 2017 at 8:23 PM, Robert Haas <robertmh...@gmail.com> wrote: > On Fri, Mar 31, 2017 at 2:14 PM, Mike Palmiotto > <mike.palmio...@crunchydata.com> wrote: >> Attached you will find two patches, which were rebased on master as of >> 156d388 (applied wit

Re: [HACKERS] partitioned tables and contrib/sepgsql

On Fri, Mar 31, 2017 at 2:14 PM, Mike Palmiotto <mike.palmio...@crunchydata.com> wrote: > On Mon, Mar 27, 2017 at 12:09 PM, Mike Palmiotto > <mike.palmio...@crunchydata.com> wrote: >> On Mon, Mar 27, 2017 at 11:46 AM, Robert Haas <robertmh...@gmail.com> wrote: >

Re: [HACKERS] partitioned tables and contrib/sepgsql

On Mon, Mar 27, 2017 at 12:09 PM, Mike Palmiotto <mike.palmio...@crunchydata.com> wrote: > On Mon, Mar 27, 2017 at 11:46 AM, Robert Haas <robertmh...@gmail.com> wrote: >> >> Note that sepgsql hasn't been updated to work with RLS yet, either, >> but we didn't re

Re: [HACKERS] partitioned tables and contrib/sepgsql

On Mon, Mar 27, 2017 at 11:46 AM, Robert Haas <robertmh...@gmail.com> wrote: > On Mon, Mar 27, 2017 at 11:22 AM, Mike Palmiotto > <mike.palmio...@crunchydata.com> wrote: >> On Mon, Mar 27, 2017 at 10:47 AM, Robert Haas <robertmh...@gmail.com> wrote: >>>

Re: [HACKERS] partitioned tables and contrib/sepgsql

-alter hook in StoreCatalogInheritance1. It seems like it may just be an issue of adding the RELKIND_PARTITIONED_TABLE to sepgsql_relation_post_create. -- Mike Palmiotto Software Engineer Crunchy Data Solutions https://crunchydata.com -- Sent via pgsql-hackers mailing list (pgsql-

[HACKERS] Misleading bgworker log message

indeed the case, I wonder if it's possible to ​re phrase the termination message ​so it does not ​ suggest ​an admin was involved. ​ __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR

Re: [HACKERS] partitioned tables and contrib/sepgsql

this. Presumably we'd just extend existing object_access_hooks to cover partitioned tables? > > This is an issue which should be resolved for PG10, so I'll add it to > the open items list. I'll grab it. Thanks. --Mike -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)

Re: [HACKERS] removing tsearch2

D-Pg+3.5.3 __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http://www.rrdonnelley.com <http://www.rr

Re: [HACKERS] application_name in process name?

On Sun, Jul 17, 2016 at 10:34 AM, Tom Lane wrote: > It occurs to me that we could also remove the update_process_title GUC: > what you would do is configure a process_title pattern that doesn't > include the %-escape for current command tag, and the infrastructure > could

[HACKERS] application_name in process name?

be added the process name so as to minimize impact on anything that might be trying to parse that line? __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St

Re: [HACKERS] Fuzzy substring searching with the pg_trgm extension

_string_similarity? > At least for this English speaker, substring_similarity is not confusing even if it's not internally accurate, but English is a strange language. Because I want the bike shed to be blue, how does query_string_similarity sound instead? If that's overly precise, then word_simila

Re: [HACKERS] old bug in full text parser

this by pre-normalizing strings matching /(\d+)-(\d+)/ into two numbers separated by a space instead of a hyphen, but if fixing this bug would remove the need for such a preprocessing step it would be a great help to us. Would such strings be parsed "properly" into lexems of the form o

Re: [HACKERS] Foreign Data Wrapper

the odbcBeginForeignScan() and odbcIterateForeignScan(), and odbcGetQual() functions. Thanks On Fri, Nov 13, 2015 at 1:24 PM, Corey Huinker <corey.huin...@gmail.com> wrote: > On Fri, Nov 13, 2015 at 1:46 PM, Big Mike <newocu...@gmail.com> wrote: > >> Writin

Re: [HACKERS] Re: In-core regression tests for replication, cascading, archiving, PITR, etc.

odern_perl/> chapter 5 covers most of them. ______ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http://www.

[HACKERS] warning: HS_KEY redefined (9.5 beta2)

__ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http://www.rrdonnelley.com <http://www.rrdonnelley.com/> * <mike.blackw...@rrd.com>*

[HACKERS] Foreign Data Wrapper

Writing a Foreign Data Wrapper and interested in isolating the WHERE clause to speed up the access of an indexed file on my filesystem. I'm attempting to understand the inner workings of how the data is retrieved so I'm writing code to just handle one case at the moment: WHERE clause on a single

Re: [HACKERS] Within CF app, "Bug Fixes" should be "Bug Fixes/Refactoring"

under? Or would you expect separate CF entries for the refactoring and the fix?​ ​ ​ ​ ​ __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Av

Re: [HACKERS] perlcritic

​David wrote: ​ > I believe there are ways to get perlcritic to keep quiet about things > we don't find relevant. Maybe that's a better way to use it. > ​There are indeed. A .perlcriticrc file can suppress (or add) either individual rules or groups of rules. I use one to ignore the ones I

Re: [HACKERS] [PROPOSAL] VACUUM Progress Checker.

​Something like that would be helpful. I just had to stop one after an hour and have no idea how much longer it would have taken.​ __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR

Re: [HACKERS] pg_upgrade + Ubuntu

Does pg_config show the correct location? If so, perhaps pg_upgrade could get the .conf location the same way rather than requiring a command line option. __ *Mike Blackwell | Technical Analyst, Distribution Services

Re: [HACKERS] pg_upgrade + Ubuntu

On Fri, Jul 10, 2015 at 2:10 PM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Joshua D. Drake wrote: On 07/10/2015 11:01 AM, Mike Blackwell wrote: Does pg_config show the correct location? Good idea but: postgres@ly19:~$ pg_config You need to install postgresql-server-dev-X.Y

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

A Google search suggests Oracle 9.x supports a unary '?' operator (fuzzy match), so the use of '?' in an operator name is not without precedent. __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout

Re: [HACKERS] Problems with question marks in operators (JDBC, ECPG, ...)

. __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http://www.rrdonnelley.com http://www.rrdonnelley.com/ * mike.blackw...@rrd.com* On Tue, May 19, 2015 at 12:45 PM

Re: [HACKERS] xpath changes in the recent back branches

' is immaterial -- maybe it's a full document, maybe it's a fragment from a previous xpath() call -- and the referenced commit is going to make correct XPATH much more sane, readable, and maintainable. I, for one, welcome it wholeheartedly. HTH, --Mike

Re: [HACKERS] RangeType internal use

On Fri, Feb 13, 2015 at 3:13 PM, Jim Nasby jim.na...@bluetreble.com wrote: If we exclude the issue of needing one or two oddball partitions for +/- infinity, I expect that fixed sized partitions would actually cover 80-90% of cases. ​That would not be true in our case. The data is not at

Re: [HACKERS] Proposal: knowing detail of config files via SQL

​This would default to being available to superusers only, right? Details of the file system shouldn't be available to any random user.​ __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout

Re: [HACKERS] [PATCH] explain sortorder

Tom, Thanks for the comments on what you ended up changing. It helps point out the kind of things I should be looking for. I'll try to let less slip through in the future. Mike __ *Mike Blackwell | Technical

Re: [HACKERS] [PATCH] explain sortorder (fwd)

be acceptable to He​ikki. I'll mark this as ready for committer. Thanks for the patch! Mike

Re: [HACKERS] [PATCH] explain sortorder

and against the style of surrounding code. Multi-line comments should follow the existing format. There are no tests for the ... is LC_COLLATE and COLLATE... cases. Section 14.1 of the documentation may need to be updated. Mike

Re: [HACKERS] [PATCH] explain sortorder

Looking forward to the new patch. I'll give it a more complete testing when you post it. Mike __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St

Re: [HACKERS] Commitfest problems

On Tue, Dec 16, 2014 at 10:15 AM, Mark Cave-Ayland mark.cave-ayl...@ilande.co.uk wrote: Well as I mentioned in my last email, practically all developers will rebase and run make check on their patched tree before submitting to the list. ​Even when this is true, and with people new to the

Re: [HACKERS] [PATCH] explain sortorder

TABLE sortordertest; __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http

Re: [HACKERS] proposal: plpgsql - Assert statement

On 18 November 2014 21:19, Petr Jelinek p...@2ndquadrant.com wrote: Personally, I see this as natural extension of the conditional block control which we already have for loops with CONTINUE WHEN and EXIT WHEN. This basically extends it to any block and it seems quite natural to have it

Re: [HACKERS] Proposed changing the definition of decade for date_trunc and extract

On Fri, 2014-08-01 at 22:28 -0700, Mike Swanson wrote: I'd also argue that the current function basing the logic from definition #2 has limited use even when you want to use it for such. If you want to generate text for '(decades)s' you'd have to do: SELECT extract('year' from date_trunc

[HACKERS] Proposed changing the definition of decade for date_trunc and extract

-- In both the commit message and docs, I made note of the backwards compatibility change. I don't know how much of an impact this would have but I suspect not many applications are really going to be affected by how decades are counted (should be simple to fix on their part, if any are...). -- Mike

Re: [HACKERS] Re: Proposed changing the definition of decade for date_trunc and extract

On Sat, 2014-08-02 at 15:15 +1200, Gavin Flower wrote: Since there was no year zero: then it follows that the first decade comprises years 1 to 10, and the current Millennium started in 2001 - or am I being too logical??? :-) This is pretty much the reason I'm sending this patch, because it

Re: [HACKERS] Congrats Andres Freund, the newest PostgreSQL Commiter!

​Congrats Andres! Mike​ __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http

Re: [HACKERS] tds_fdw for Sybase and MS SQL Server

Excellent! I have an application for this. I'll give it a look. Thanks! Mike __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174

[HACKERS] 9.3.2 Client-only installation per docs fails creating directory.

installing src/bin last works. __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http

Re: [HACKERS] why semicolon after begin is not allowed in postgresql?

. __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http://www.rrdonnelley.com http

Re: [HACKERS] stats for network traffic WIP

. If no one has any objections, I'll mark it ready for committer. Mike __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office

Re: [HACKERS] additional json functionality

(fixed_field,'(.{4})(.{10})(.{5})') ) __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw

Re: [HACKERS] stats for network traffic WIP

to be tested: the counts for streaming replication (no replication setup here to test against yet). __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles

Re: [HACKERS] stats for network traffic WIP

Also still to be tested: performance impact. __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818

[HACKERS] RULE regression test fragility?

? ​​ __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http://www.rrdonnelley.com http

Re: [HACKERS] stats for network traffic WIP

I added this to the current CF, and am starting to review it as I have time. __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174

Re: [HACKERS] stats for network traffic WIP

. __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http://www.rrdonnelley.com http

Re: [HACKERS] stats for network traffic WIP

scenarios, etc? __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http

Re: [HACKERS] stats for network traffic WIP

!​ __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http://www.rrdonnelley.com http://www.rrdonnelley.com/ * mike.blackw...@rrd.com* ​

Re: [HACKERS] Commitfest II CLosed

difference. __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http

Re: [HACKERS] CF 2013-09 Wrap Up

On Tue, Oct 15, 2013 at 1:39 AM, Noah Misch n...@leadboat.com wrote: On Mon, Oct 14, 2013 at 01:56:42PM -0500, Mike Blackwell wrote: Any patches marked Needs Review will be automatically moved to the next CF. We will try to make sure that all patches in the current CF have received

[HACKERS] CF 2013-09 Wrap Up

! Mike Blackwell

Re: [HACKERS] Patch for reserved connections for replication users

I'd received an email from Gibheer suggesting it be move due to lack of time to work on it. I can certainly move it back if that's no longer the case. On Oct 9, 2013, at 23:25, Amit Kapila amit.kapil...@gmail.com wrote: On Thu, Oct 10, 2013 at 3:17 AM, Gibheer gibh...@zero-knowledge.org

Re: [HACKERS] File_fdw documentation patch to clarify OPTIONS clause

Robert, Thanks for the reply. I have no objections to clarifying the note. Attached is a patch with the text you suggested. Mike​ __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management

[HACKERS] File_fdw documentation patch to clarify OPTIONS clause

is a patch to add a note to the docs mentioning this fact. __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818

[HACKERS] [REVIEW] row level security (v3)

will be looking at that. __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http

Re: [HACKERS] Performance Improvement by reducing WAL for Update Operation

The only environment I have available at the moment is a virtual box. That's probably not going to be very helpful for performance testing. __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout

Re: [HACKERS] [v9.4] row level security

__ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http://www.rrdonnelley.com http://www.rrdonnelley.com/ * mike.blackw

Re: [HACKERS] Performance Improvement by reducing WAL for Update Operation

'wal_update_compression_ratio'? __ *Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley* 1750 Wallace Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http

Re: [HACKERS] [ADMIN] after 9.2.4 patch vacuumdb -avz not analyzing all tables

On further review this particular server skipped from 9.2.2 to 9.2.4. This is my most busy and downtime sensitive server and I was waiting on a maintenance window to patch to 9.2.3 when 9.2.4 dropped and bumped up the urgency. However, I have 3 other less busy production servers that were all

Re: [HACKERS] [ADMIN] after 9.2.4 patch vacuumdb -avz not analyzing all tables

Looks like psql vacuum (verbose, analyze) is not reflecting in pg_stat_user_tables as well in some cases. In this scenario I run the command, it outputs all the deleted pages etc (unlike the vacuumdb -avz analyze that seemed to be skipped in the log), but it does not update pg_stat_user_tables.

Re: [HACKERS] Show type in psql SELECT

| Modifiers -+---+--- g | geometry(Polygon) | st_centroid | geometry | -Mike

[HACKERS] Show type in psql SELECT

: numeric(6,3) | 3.220 Has anyone else thought this was a missing feature? -Mike

Re: [HACKERS] Re: [GENERAL] pg_dump incredibly slow dumping a single schema from a large db

:) yah that makes sense no big deal. i'll probably just push this head buiild of pg_dump onto the production machines till it comes out. Thanks again! On Sat, Mar 31, 2012 at 3:44 PM, Tom Lane t...@sss.pgh.pa.us wrote: Mike Roest mike.ro...@replicon.com writes: Any idea when 9.1.4

[HACKERS] Re: [GENERAL] pg_dump incredibly slow dumping a single schema from a large db

in the DB, looks like our schema currently has about 115 sequences per tenant. --Mike

[HACKERS] Re: [GENERAL] pg_dump incredibly slow dumping a single schema from a large db

I'm just pulling another backup using the stock 9.1.1 pg_dump to ensure the backups are equivalent. Schema data are identical between the 2 backups. the new backup passes all our tests for validating a tenant. Thank you again for the quick response! --Mike

Re: [HACKERS] JSON for PG 9.2

as XPath is would be even better. Just my $0.02... even if I'm a bit late to the conversation. Thanks! Mike

[HACKERS] Function argument names in pg_catalog

in the source. Thanks for your thoughts, -Mike [1] http://www.postgresql.org/docs/current/static/functions-admin.html [2] http://www.postgresql.org/docs/current/static/sql-createfunction.html [3] http://www.postgresql.org/docs/current/static/sql-syntax-calling-funcs.html -- Sent via pgsql

Re: [HACKERS] [GENERAL] Creating temp tables inside read only transactions

I like Darren's proposal. It is elegant. Date: Fri, 8 Jul 2011 18:38:59 +1200 From: gavinflo...@archidevsys.co.nz To: dar...@darrenduncan.net CC: pg...@j-davis.com; guilla...@lelarge.info; mbee...@hotmail.com; pgsql-gene...@postgresql.org; pgsql-hackers@postgresql.org Subject: Re:

Re: [HACKERS] smallserial / serial2

Yup- it's attached. Mike From: Brar Piening [mailto:b...@gmx.de] Sent: Tuesday, June 07, 2011 6:58 PM To: Mike Pultz Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] smallserial / serial2 On Wed, 20 Apr 2011 21:27:27 -0400, Mike Pultz mailto:m...@mikepultz.com m

Re: [HACKERS] smallserial / serial2

Sorry, forgot the documentation- I guess that stuff doesn't magically happen! New patch attached. Mike From: Brar Piening [mailto:b...@gmx.de] Sent: Tuesday, June 07, 2011 6:58 PM To: Mike Pultz Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] smallserial / serial2 On Wed

Re: [HACKERS] smallserial / serial2

has ~700 million rows right now. And yes- I guess there's nothing to stop me from using a smallint in the data table (thus getting the size savings), and reference a int in the stuff table, but it seems like bad form to me to have a foreign key constraint between two different types. Mike

[HACKERS] smallserial / serial2

I use tables all the time that have sequences on smallint's; I'd like to simplify my create files by not having to create the sequence first, but I also don't want to give up those 2 bytes per column! Can this be added? Mike --- postgresql-9.0.4/src/backend/parser

Re: [JDBC] [HACKERS] JDBC connections to 9.1

was stable. Regards, -- Mike Fowler Registered Linux user: 379787 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [JDBC] [HACKERS] JDBC connections to 9.1

for 1.4, one for 1.5 and one for 1.6. It's been a while since I've had an excuse to write some Perl! I can't guarantee when I'll have it done as I'm away for a little over a week from Wednesday and I'm not allowed internet access! Regards, -- Mike Fowler Registered Linux user: 379787 -- Sent via

Re: [JDBC] [HACKERS] JDBC connections to 9.1

database version I build and the tests running JDKs 1.4.2_19, 1.5.0_22 and 1.6.0_2. All on 32-bit. Regards, -- Mike Fowler Registered Linux user: 379787 Index: doc/pgjdbc.xml === RCS file: /cvsroot/jdbc/pgjdbc/doc/pgjdbc.xml,v

Re: [HACKERS] PG 9.0.3. How to select rows from xml

.html. Regards, -- Mike Fowler Registered Linux user: 379787 -- 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 keywords in 9.1

and necessary AFAICT I can confirm that I added the three keywords as described in the SQL/XML standard (section 8.4). Apologies for the delayed confirmation, I missed the thread when it was started and only noticed when your commit message arrived. Regards, -- Mike Fowler Registered Linux user

Re: [HACKERS] Native XML

/2011-02/msg01878.php). However if Tom does mean that xpath is the culprit, it may be with the way the libxml2 library works. It's a very messy singleton. If I'm wrong, I'm sure I'll be corrected! Regards, -- Mike Fowler Registered Linux user: 379787 -- Sent via pgsql-hackers mailing list

Re: [HACKERS] First patch proposal

this is a feature that will just make life a little more pleasant for command line junkies like me. Regards, -- Mike Fowler Registered Linux user: 379787 -- 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] Re: [HACKERS] XML schema validation

design you could share on how you would go about adding schema validation? Regrads, -- Mike Fowler Registered Linux user: 379787 -- 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] First patch proposal

this is a feature that will just make life a little more pleasant for command line junkies like me. Regards, -- Mike Fowler Registered Linux user: 379787 NB: Post attmpt two, yesterday's was never delievered to hackers so apologies if Alastair and Hitoshi have seen this message once already. -- Sent via

Re: [HACKERS] standby registration (was: is sync rep stalled?)

standbys to be named in this fashion.   This role could be provided on connect of the standby is more-or-less tangential to the specific registration issue. Big +1 FWIW. -- Mike Rylander -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] patch: General purpose utility functions used by the JSON data type

instructions can be found at http://wiki.postgresql.org/wiki/Regression_test_authoring Regards, -- Mike Fowler Registered Linux user: 379787 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] review: xml_is_well_formed

xml_is_well_formed(); just dropping it doesn't seem like a helpful choice. As a project management note, this CommitFest is over in 4 days, so unless we have a new version of this patch real soon now we need to defer it to the September 15th CommitFest Yes. Mike, are you expecting to submit a new

Re: [HACKERS] Initial review of xslt with no limits patch

On 09/08/10 04:07, Tom Lane wrote: Robert Haasrobertmh...@gmail.com writes: On Sun, Aug 8, 2010 at 11:36 AM, Mike Fowlerm...@mlfowler.com wrote: 1) XML2 is largely undocumented, giving rise to the problems encountered. Since the module is deprecated anyways, does it make more sense to get

Re: [HACKERS] Initial review of xslt with no limits patch

resolving too... Regards, -- Mike Fowler Registered Linux user: 379787 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: Review: Re: [PATCH] Re: [HACKERS] Adding xpath_exists function

On 06/08/10 20:55, Peter Eisentraut wrote: On fre, 2010-08-06 at 09:04 +0100, Mike Fowler wrote: If the patch is to be committed, does it make sense for me to refine it such that it uses the new xpath internal function you extracted in the xmlexists patch? Yes, you can probably shrink

Re: [HACKERS] review: xml_is_well_formed

On 06/08/10 21:55, Peter Eisentraut wrote: On fre, 2010-08-06 at 14:43 +0100, Mike Fowler wrote: Or perhaps it could return a string instead of a boolean: content, document, or NULL if it's neither. I like the sound of that. In fact this helps workaround the IS DOCUMENT and IS CONTENT

Re: Review: Re: [PATCH] Re: [HACKERS] Adding xpath_exists function

in the xmlexists patch? Regards, -- Mike Fowler Registered Linux user: 379787 -- 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] review: xml_is_well_formed

'); xml_is_well_formed t (1 row) with the inverse for DOCUMENTS? To me this makes the most sense as it makes the function behave much more like the other xml functions. -- Mike Fowler Registered Linux user: 379787 -- Sent via pgsql-hackers mailing list (pgsql-hackers

  1   2   3   4   5   >