public inbox for [email protected]
help / color / mirror / Atom feed[PATCH 14/18] doc review: logical decode in prepare
2+ messages / 2 participants
[nested] [flat]
* [PATCH 14/18] doc review: logical decode in prepare
@ 2021-01-24 02:33 Justin Pryzby <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Justin Pryzby @ 2021-01-24 02:33 UTC (permalink / raw)
a271a1b50e9bec07e2ef3a05e38e7285113e4ce6
---
doc/src/sgml/logicaldecoding.sgml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/doc/src/sgml/logicaldecoding.sgml b/doc/src/sgml/logicaldecoding.sgml
index cf705ed9cd..b854f2ccfc 100644
--- a/doc/src/sgml/logicaldecoding.sgml
+++ b/doc/src/sgml/logicaldecoding.sgml
@@ -1214,7 +1214,7 @@ stream_commit_cb(...); <-- commit of the streamed transaction
</para>
<para>
- When a prepared transaction is rollbacked using the
+ When a prepared transaction is rolled back using the
<command>ROLLBACK PREPARED</command>, then the
<function>rollback_prepared_cb</function> callback is invoked and when the
prepared transaction is committed using <command>COMMIT PREPARED</command>,
--
2.17.0
--lc9FT7cWel8HagAv
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment;
filename="0015-doc-review-for-multiranges.patch"
^ permalink raw reply [nested|flat] 2+ messages in thread
* Should timezone be inherited from template database?
@ 2023-11-26 14:47 Anton A. Melnikov <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Anton A. Melnikov @ 2023-11-26 14:47 UTC (permalink / raw)
To: pgsql-hackers
Hello!
Found that if i set a specific time zone for a template database,
it will not be inherited in the database created from that template.
psql (17devel)
Type "help" for help.
postgres=# select now();
now
-------------------------------
2023-11-26 17:24:58.242086+03
(1 row)
postgres=# ALTER DATABASE template1 SET TimeZone = 'UTC';
ALTER DATABASE
postgres=# \c template1
You are now connected to database "template1" as user "postgres".
template1=# select now();
now
-------------------------------
2023-11-26 14:26:09.291082+00
(1 row)
template1=# CREATE DATABASE test;
CREATE DATABASE
template1=# \c test
You are now connected to database "test" as user "postgres".
test=# select now();
now
-------------------------------
2023-11-26 17:29:05.487984+03
(1 row)
Could you clarify please. Is this normal, predictable behavior?
Would be very grateful!
--
Anton A. Melnikov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-11-26 14:47 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-01-24 02:33 [PATCH 14/18] doc review: logical decode in prepare Justin Pryzby <[email protected]>
2023-11-26 14:47 Should timezone be inherited from template database? Anton A. Melnikov <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox