Re: [HACKERS] proposal: schema variables
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Erik Rijkers <er@xs4all.nl>
Cc: Artur Zakirov <a.zakirov@postgrespro.ru>,
Dean Rasheed <dean.a.rasheed@gmail.com>, Fabien COELHO <coelho@cri.ensmp.fr>,
Gilles Darold <gilles.darold@dalibo.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2018-12-31T17:33:30Z
Lists: pgsql-hackers, pgsql-performance
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Move WAL sequence code into its own file
- a87987cafca6 19 (unreleased) cited
-
Add ExplainState argument to pg_plan_query() and planner().
- c83ac02ec730 19 (unreleased) cited
-
Don't include access/htup_details.h in executor/tuptable.h
- 1a8b5b11e48a 19 (unreleased) cited
-
Refactor to avoid code duplication in transformPLAssignStmt.
- b0fb2c6aa5a4 19 (unreleased) cited
-
Avoid including commands/dbcommands.h in so many places
- 325fc0ab14d1 19 (unreleased) cited
-
Restrict psql meta-commands in plain-text dumps.
- 71ea0d679543 19 (unreleased) cited
-
Split func.sgml into more manageable pieces
- 4e23c9ef65ac 19 (unreleased) cited
-
Fix squashing algorithm for query texts
- 0f65f3eec478 18.0 cited
-
EXPLAIN: Always use two fractional digits for row counts.
- 95dbd827f2ed 18.0 cited
-
Preliminary refactoring of plpgsql expression construction.
- a654af21ae52 18.0 cited
-
plpgsql: pure parser and reentrant scanner
- 7b27f5fd36cb 18.0 cited
-
Add some sanity checks in executor for query ID reporting
- 24f520594809 18.0 cited
-
Fix misleading error message context
- 4af123ad45bd 18.0 cited
-
Add macros for looping through a List without a ListCell.
- 14dd0f27d7cd 17.0 cited
Attachments
- schema-variables-20181231-02.patch.gz (application/gzip) patch
Hi po 31. 12. 2018 v 16:40 odesílatel Erik Rijkers <er@xs4all.nl> napsal: > On 2018-12-31 14:23, Pavel Stehule wrote: > > st 21. 11. 2018 v 8:24 odesílatel Pavel Stehule > > <pavel.stehule@gmail.com> > > > [schema-variables-20181231-01.patch.gz] > > Hi Pavel, > > I gave this a quick try-out with the script I had from previous > versions, > and found these two errors: > > ------------ > drop schema if exists schema1 cascade; > create schema if not exists schema1; > drop variable if exists schema1.myvar1; --> error 49 > create variable schema1.myvar1 as text ; > select schema1.myvar1; > let schema1.myvar1 = 'variable value ""'; > select schema1.myvar1; > alter variable schema1.myvar1 rename to myvar2; > select schema1.myvar2; > create variable schema1.myvar1 as text ; > let schema1.myvar1 = 'variable value ""'; > select schema1.myvar1; > alter variable schema1.myvar1 rename to myvar2; --> error 4287 > select schema1.myvar2; > ------------ > > > The above, ran with psql -qXa gives the following output: > > drop schema if exists schema1 cascade; > create schema if not exists schema1; > drop variable if exists schema1.myvar1; --> error 49 > ERROR: unrecognized object type: 49 > create variable schema1.myvar1 as text ; > select schema1.myvar1; > myvar1 > -------- > > (1 row) > > let schema1.myvar1 = 'variable value ""'; > select schema1.myvar1; > myvar1 > ------------------- > variable value "" > (1 row) > > alter variable schema1.myvar1 rename to myvar2; > select schema1.myvar2; > myvar2 > ------------------- > variable value "" > (1 row) > > create variable schema1.myvar1 as text ; > let schema1.myvar1 = 'variable value ""'; > select schema1.myvar1; > myvar1 > ------------------- > variable value "" > (1 row) > > alter variable schema1.myvar1 rename to myvar2; --> error 4287 > ERROR: unsupported object class 4287 > select schema1.myvar2; > myvar2 > ------------------- > variable value "" > (1 row) > > Should be fixed now. Thank you for report Pavel > > thanks, > > > Erik Rijkers > > >