public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adnan Dautovic <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: Failure of postgres_fdw because of TimeZone setting
Date: Fri, 5 Apr 2024 11:39:04 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

Dear Adrian,

Adrian Klaver <[email protected]> wrote:
>Define 'read-only', especially as it applies to the privileges on the 
>public schema.

I am not quite sure which information you are looking for
exactly. According to this [1], I ran the following query:

WITH "names"("name") AS (
   SELECT n.nspname AS "name"
     FROM pg_catalog.pg_namespace n
       WHERE n.nspname !~ '^pg_'
         AND n.nspname <> 'information_schema'
) SELECT "name",
   pg_catalog.has_schema_privilege(current_user, "name", 'CREATE') AS
"create",
   pg_catalog.has_schema_privilege(current_user, "name", 'USAGE') AS "usage"
     FROM "names";

And recieved the following result:

"name"	"create"	"usage"
"public"	true	true

>Per Tom Lane's comments on timezone, log into the remote server and do:
>
>SHOW timezone;
Europe/Berlin

>SET timezone = 'etc/UTC';
ERROR: invalid value for parameter "TimeZone": "etc/UTC"
SQL state: 22023

>SET timezone = 'UTC';
ERROR: invalid value for parameter "TimeZone": "UTC"
SQL state: 22023

However, this lead me to [2] and I find the output very
interesting:

SELECT * FROM pg_timezone_names ORDER BY name;

>"name"	"abbrev"	"utc_offset"	"is_dst"
>"Turkey"	"+03"	"03:00:00"	false
>"UCT"	"UCT"	"00:00:00"	false
>"Universal"	"UTC"	"00:00:00"	false
>"W-SU"	"MSK"	"03:00:00"	false


And then attempting

SET timezone = 'Universal';

>SET
>Query returned successfully in 100 msec.

Any ideas on how to proceed?

Kind regards,

Adnan Dautovic


[1]: https://stackoverflow.com/a/36095257
[2]: https://stackoverflow.com/a/32009497

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Failure of postgres_fdw because of TimeZone setting
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox