Re: [HACKERS] Add jsonb_compact(...) for whitespace-free jsonb to text

2016-04-28 Thread Sehrope Sarkuni
On Wed, Apr 27, 2016 at 7:09 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Sun, Apr 24, 2016 at 3:02 PM, Sehrope Sarkuni > wrote: > >> Attached is a *very* work in progress patch that adds a >> jsonb_compact(jsonb)::text function. It generates a tex

Re: [HACKERS] Add jsonb_compact(...) for whitespace-free jsonb to text

2016-04-25 Thread Sehrope Sarkuni
On Sun, Apr 24, 2016 at 9:27 PM, Stephen Frost wrote: > * Andrew Dunstan (and...@dunslane.net) wrote: > > On 04/24/2016 06:02 PM, Sehrope Sarkuni wrote: > > >AFAIK, there's also no guarantee on the specific order of the > > >resulting properties in the tex

[HACKERS] Add jsonb_compact(...) for whitespace-free jsonb to text

2016-04-24 Thread Sehrope Sarkuni
;: 1}} | {"a":{"b":1}} (4 rows) There aren't any tests yet but I'd like to continue working on it for inclusion in 9.7. I'm posting it now to see if there's interest in the idea and get some feedback on the approach (this is my first real patch...).

[HACKERS] Tab Completion for CREATE DATABASE ... TEMPLATE ...

2016-02-16 Thread Sehrope Sarkuni
ABASE ... TEMPLATE " completion to match what the command actually allows. Regards, -- Sehrope Sarkuni Founder & CEO | JackDB, Inc. | https://www.jackdb.com/ diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index 5f27120..fc1edb0 100644 --- a/src/bin/psql/tab-complete

Re: [HACKERS] WIP: SCRAM authentication

2015-08-08 Thread Sehrope Sarkuni
; question. Having a last used at timestamp for each auth mechanism (per user) would be useful. I'm not sure how updates should work when connecting to a read-only slave though. It would need some way of letting the master know that user X connected using credentials Y. Regards, -- Sehrope Sarku

Re: [HACKERS] Entities created in one query not available in another in extended protocol

2015-06-12 Thread Sehrope Sarkuni
ver's logic to avoid it here: https://github.com/pgjdbc/pgjdbc/blob/7c0655b3683efa38cbe0d029385d8889f6392f98/org/postgresql/core/v3/QueryExecutorImpl.java#L300 Regards, -- Sehrope Sarkuni Founder & CEO | JackDB, Inc. | https://www.jackdb.com/

Re: [HACKERS] [CORE] Restore-reliability mode

2015-06-06 Thread Sehrope Sarkuni
the developers didn't have to build or > maintain the auto-packager) and therefore any return (however small) would > make it worthwhile. > Fancy building (and maintaining) the auto-packaging system, and managing a > mailing list for its users? I don't have much experience in

Re: [HACKERS] [CORE] Restore-reliability mode

2015-06-06 Thread Sehrope Sarkuni
ey definitely won't find any bugs if they don't test at all. If it's possible to have automated packaging, even for just a subset of platforms, I think that'd be useful. Regards, -- Sehrope Sarkuni Founder & CEO | JackDB, Inc. | https://www.jackdb.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] mogrify and indent features for jsonb

2015-02-15 Thread Sehrope Sarkuni
): CREATE OR REPLACE FUNCTION jsonb_stringify(obj jsonb, space text) CREATE OR REPLACE FUNCTION jsonb_stringify(obj jsonb, space int) Having json_stringify versions of these would be useful as well. Regards, -- Sehrope Sarkuni [1]: https://developer.mozilla.org/en-US/docs/Web/JavaScript

Re: [HACKERS] Fw: [GENERAL] PLV8 and JS exports / referencing

2014-11-08 Thread Sehrope Sarkuni
TABLE STRICT AS $BODY$ var exports = {}; // Copy/paste https://raw.githubusercontent.com/janl/mustache.js/master/mustache.js var Mustache = exports; return Mustache.render(template, view); $BODY$; test=> SELECT mustache('test: {{foo}}', '{"foo": "bar"}'::json)

Re: [HACKERS] Materialized views don't show up in information_schema

2014-10-10 Thread Sehrope Sarkuni
with mviews without additional code changes. Regards, -- Sehrope Sarkuni -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Materialized views don't show up in information_schema

2014-10-10 Thread Sehrope Sarkuni
bles or views. If this sound fine I can put together a patch for this. Regards, -- Sehrope Sarkuni postgres@vagrant-ubuntu-trusty-64:~$ psql test psql (9.4beta3) Type "help" for help. test=# CREATE TABLE some_table (x text); CREATE TABLE test=# CREATE MATERIALIZED VIEW some_mview AS S