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

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 <sehr...@jackdb.com> > wrote: > >> Attached is a *very* work in progress patch that adds a >> jsonb_compact(jsonb)::t

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

On Sun, Apr 24, 2016 at 9:27 PM, Stephen Frost <sfr...@snowman.net> 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 prop

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

s 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...). Regards, -- Sehrope Sarkuni Founder & CEO | JackDB, Inc. | https://www.jackdb.com/ diff --g

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

quot; 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.c +++ b/src/bin/psq

Re: [HACKERS] WIP: SCRAM authentication

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 Sarkuni Founder CEO | JackDB

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

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

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] [CORE] Restore-reliability mode

. Fancy building (and maintaining) the auto-packaging system, and managing a mailing list for its users? I don't have much experience in setting things like this up so I'm not one to estimate the work load involved. If it existed though, I'd use it. Regards, -- Sehrope Sarkuni Founder CEO

Re: [HACKERS] mogrify and indent features for jsonb

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/Reference/Global_Objects/JSON/stringify

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

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); mustache --- test: bar (1 row) Regards, -- Sehrope Sarkuni Founder CEO | JackDB, Inc

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

, -- 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 SELECT * FROM some_table; SELECT 0 test=# CREATE VIEW some_view AS SELECT * FROM some_table

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

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