Re: Deferred constraint trigger semantics

2022-05-16 Thread Bryn Llewellyn
> laurenz.albe@cybertec.atwrote: > >> b...@yugabyte.com wrote: > >> >> …I tried this: >> >> create table t( >> k serial primary key, >> v int not null, >> constraint t_v_unq unique(v) initially deferred); Here's a better test: -- BLUE session start transaction isolation level read commi

RE: Need to install Postgres Version 14 in Linux server with Client and migration steps.

2022-05-16 Thread Rajamoorthy-CW, Thirumurugan 8361
What is the helpdesk email address ? please let me know. Regards Thirumurugan Rajamoorthy – Biometrics Support From: Sandeep Kumar Jakkaraju Sent: Monday, May 9, 2022 12:08 PM To: Rajamoorthy-CW, Thirumurugan 8361 Cc: pgsql-general@lists.postgresql.org Subject: Re: Need to install Postgre

Re: Restricting user to see schema structure

2022-05-16 Thread Bryn Llewellyn
> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com 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

Re: Restricting user to see schema structure

2022-05-16 Thread Adrian Klaver
On 5/16/22 2:04 PM, Bryn Llewellyn wrote: /adrian.kla...@aklaver.com wrote:/ /b...@yugabyte.com wrote:/ /neerajmr12...@gmail.com wrote:/ ... What exactly do you mean by "have created a new user a

Re: Restricting user to see schema structure

2022-05-16 Thread David G. Johnston
On Mon, May 16, 2022 at 2:04 PM Bryn Llewellyn wrote: > « > To connect to a particular database, a user must not only pass > the pg_hba.conf checks, but must have the CONNECT privilege for the > database. If you wish to restrict which users can connect to which > databases, it's usually easier to

[no subject]

2022-05-16 Thread Rama Krishnan
Hi All, How to install pg_repack and use? Thanks RamaKrishnan

Re:

2022-05-16 Thread David G. Johnston
On Monday, May 16, 2022, Rama Krishnan wrote: > > > How to install pg_repack and use? > Two questions best answered by reading its documentation. David J. p.s. please remember to include a subject line in future emails.

Re:

2022-05-16 Thread Amul Sul
On Tue, May 17, 2022 at 9:12 AM Rama Krishnan wrote: > > Hi All, > > How to install pg_repack and use? Check this: https://reorg.github.io/pg_repack/ Regards, Amul

Re: Restricting user to see schema structure

2022-05-16 Thread Bryn Llewellyn
> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >>> adrian.kla...@aklaver.com wrote: >>> b...@yugabyte.com wrote: > neerajmr12...@gmail.com wrote: > > ... What exactly do you mean b