generated column cast from timestamptz to timestamp not OK.

CREATE TABLE test_g ( a timestamptz, b timestamp GENERATED ALWAYS AS (a::timestamp) STORED ); then an error occurred. > ERROR: 42P17: generation expression is not immutable > LOCATION: cookDefault, heap.c:2768 > However the following 2 commands is ok. CREATE TABLE test_i ( > a int

Re: generated column cast from timestamptz to timestamp not OK.

On Fri, 13 May 2022 at 12:47, alias wrote: > CREATE TABLE test_g ( > a timestamptz, > b timestamp GENERATED ALWAYS AS (a::timestamp) STORED > ); > then an error occurred. >> ERROR: 42P17: generation expression is not immutable Cast to timestamp uses current session time zone, current ses

Re: Restricting user to see schema structure

Hi all, Thanks for your suggestions, I would like to define my problem a little more. I am using pgAdmin . I have a database 'db' and it has got 2 schemas 'schema1' and 'schema2', I have created some views in schema2 from tables of schema1. I have created a new user and granted connection acces

Re: Restricting user to see schema structure

Hi Bryn, What I meant by 'created a new user' is that I have used the following commands. CREATE USER WITH ENCRYPTED PASSWORD ''; GRANT CONNECT ON DATABASE TO ; GRANT USAGE ON SCHEMA TO ; Thanks & Regards Neeraj On Fri, May 13, 2022, 10:43 Bryn Llewellyn wrote: > *neerajmr12...@gmail.com

Re: Restricting user to see schema structure

On Thu, May 12, 2022 at 11:37 PM Bryn Llewellyn wrote: > *neerajmr12...@gmail.com wrote:* > > *b...@yugabyte.com wrote:* > > What exactly do you mean by "have created a new user and granted > connection access to database"? As I understand it, there's no such thing. > I mentioned a simple test

Re: Restricting user to see schema structure

On 5/12/22 22:03, Neeraj M R wrote: Hi all, Thanks for your suggestions, I would like to define my problem a little more.  I am using pgAdmin . I have a database 'db' and it has got 2 schemas 'schema1' and 'schema2', I have created some views in schema2  from tables of schema1. I have crea

Re: Restricting user to see schema structure

On 5/12/22 22:13, Bryn Llewellyn wrote: /neerajmr12...@gmail.com wrote:/ What exactly do you mean by "have created a new user and granted connection access to database"? As I understand it, there's no such thing. I mentioned a simple test in my earlier email

Logon via GSSAPI from Linux fails, but works from Windows

Hello all We have our analysis users log on to Postgres without a password. Instead we rely on their Windows identity. When the Postgres server is on Windows, we use SSPI. Works great. When the Postgres server is on Linux, we use GSSAPI. Works great. Now, we are introducing Linux for analyst