Re: 1 Status of vertical clustered index - 2 Join using (fk_constraint) suggestion - 3 Status of pgsql's parser autonomization

2020-02-16 Thread maxzor
... Thank you will look into it! I'm not really sure what's the point / benefit here. Initially it seemed you simply propose a syntax saying "do a join using the columns in the FK constraint" but it's unclear to me how this implies any writing speedup? This is exactly what I mean. If you know

1 Status of vertical clustered index - 2 Join using (fk_constraint) suggestion - 3 Status of pgsql's parser autonomization

2020-02-16 Thread maxzor
graphical-query-builder plugin for pgModeler, https://github.com/maxzor/plugins/tree/master/graphicalquerybuilder#automatic-join-mode , but I believe such a syntax would be much better in the core! 3. What is the status of making the internal parser of PostgreSQL less coupled to the core, and eas

Re: Patch for "CREATE TABLE ... (LIKE ... INCLUDING COMMENTS)"

2018-12-11 Thread maxzor
...with thunderbird plain-text sorted... $ diff -c parse_utilcmd_old.c parse_utilcmd.c *** parse_utilcmd_old.c 2018-12-11 12:44:52.288309000 +0100 --- parse_utilcmd.c 2018-12-11 12:44:52.208308782 +0100 *** *** 918,923 --- 918,941

Patch for "CREATE TABLE ... (LIKE ... INCLUDING COMMENTS)"

2018-12-11 Thread maxzor
Hello, This candidate patch is kind of a bug-solving patch, it applies to one unique file : src/backend/parser/parse_utilcmd.c, on function transformTableLikeClause. Its aim is to include the "top-level" comment of the object (table, view, matview...) that is being copied ; alongside the lower-le