On 6/12/20 3:56 PM, sekhar chandra wrote:
I am not able to give usage permission to public schema. below are the
steps.
Logged in as super user
created a new user as user1
grant usage on public to user1
Either the above is a cut and paste error or you got an error:
grant usage on public to
Ron writes:
> I'm running amcheck on a set of indices (test machine, not prod) and want to
> track the progress. Is there a SELECT clause that makes rows display as
> they are created, or do I have to explicitly call bt_index_check() from a
> shell script or SQL function in order to see the ou
On Friday, June 12, 2020, Ron wrote:
>
> I'm running amcheck on a set of indices (test machine, not prod) and want
> to track the progress. Is there a SELECT clause that makes rows display as
> they are created,
No
> or do I have to explicitly call bt_index_check() from a shell script or
> S
I'm running amcheck on a set of indices (test machine, not prod) and want to
track the progress. Is there a SELECT clause that makes rows display as
they are created, or do I have to explicitly call bt_index_check() from a
shell script or SQL function in order to see the output as each index
I am not able to give usage permission to public schema. below are the
steps.
Logged in as super user
created a new user as user1
grant usage on public to user1
command completed successfully , but verification statement showing he
doesnt have usage permission.
SELECT rolname, has_schema_privile
Laura Smith wrote:
> ‐‐‐ Original Message ‐‐‐
> On Thursday, 11 June 2020 08:39, Pavel Stehule
> wrote:
>
> > Hi
> >
> > čt 11. 6. 2020 v 9:29 odesílatel Laura Smith
> > napsal:
> >
> > > Hi,
> > >
> > > Just curious if there is a way to switch a function from definer to
> > > invoke
I've had good experiences when working with roles published by geerlingguy,
he's written several Ansible books also:
https://galaxy.ansible.com/geerlingguy/postgresql
On Thu, Jun 11, 2020 at 1:28 PM Chris Stephens
wrote:
> it looks like there are a number of roles available through ansible galax
On 6/12/20 11:45 AM, Ron Clarke wrote:
Hi,
I've got a simple problem, but I'm convinced that there must be an
elegant solution. I'm a refugee from the world of MSSQL, so I'm still
finding some aspects of PostgreSQL alien.
I'm trying to use the /tstzrange /datatype. My issue is correctly
set
On 6/12/20 11:45 AM, Ron Clarke wrote:
Hi,
I've got a simple problem, but I'm convinced that there must be an
elegant solution. I'm a refugee from the world of MSSQL, so I'm still
finding some aspects of PostgreSQL alien.
I'm trying to use the /tstzrange /datatype. My issue is correctly
set
Hi,
I've got a simple problem, but I'm convinced that there must be an
elegant solution. I'm a refugee from the world of MSSQL, so I'm still
finding some aspects of PostgreSQL alien.
I'm trying to use the *tstzrange *datatype. My issue is correctly setting
the bound types when assigning values to
Thank you all very much for your help !!!
Regards,
George
-Original Message-
From: Gilles Darold
Sent: Friday, June 12, 2020 1:50 AM
To: Adrian Klaver ; George Dimopoulos
Cc: pgsql-general
Subject: Re: ora2pg error : DBD::Oracle::db prepare failed: ORA-28110
Le 12/06/2020 à 00:40,
Greetings,
* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
> On 6/9/20 4:15 AM, Stephen Frost wrote:
> >* Adrian Klaver (adrian.kla...@aklaver.com) wrote:
> >>I use pg_backrest, but it does not look promising for running on BSD:
> >>https://fluca1978.github.io/2019/03/04/pgbackrest_FreeBSD.html
12 matches
Mail list logo