=?UTF-8?Q?Marcin_Barczy=C5=84ski?= writes:
> Why can a user access a table from a forbidden schema if the table is
> explicitly specified in the definition of a view in an allowed schema? And
> not if the table is accessed by a function used in the view.
(1) Whether a view can access a table is d
Hello,
Why can a user access a table from a forbidden schema if the table is
explicitly specified in the definition of a view in an allowed schema? And
not if the table is accessed by a function used in the view.
Example:
```
DROP SCHEMA IF EXISTS forbidden_schema CASCADE;
DROP SCHEMA IF EXISTS a
Hi,
Le lun. 1 août 2022 à 15:10, Rory Campbell-Lange
a écrit :
> Apologies for the rather naive question.
>
> I have a psql migration script to call a looping procedure which commits
> batches of data along the following lines:
>
> set search_path = a, b c;
> \set AUTOCOMMIT on
> --
Apologies for the rather naive question.
I have a psql migration script to call a looping procedure which commits
batches of data along the following lines:
set search_path = a, b c;
\set AUTOCOMMIT on
-- call procedure with nested transactions
CALL c.pr_my_procedure(debug=>true);
On 2022-08-01 04:06, Adrian Klaver wrote:
2022-08-01T00:20:18.530Z Connection-1 finer] Created socket
[2022-08-01T00:20:18.532Z Connection-1 fine] Opening connection to
port 5432 on host localhost
2022-08-01 01:20:18.534308+0100 TestPostgres[10654:120173]
dnssd_clientstub ConnectToServer: conne
Am Mon, Aug 01, 2022 at 11:22:33AM +0200 schrieb Matthias Apitz:
> testdb=# DROP DATABASE IF EXISTS SRP-27097 WITH FORCE;
> ERROR: syntax error at or near "-"
> ZEILE 1: DROP DATABASE IF EXISTS SRP-27097 WITH FORCE;
>
> Why is this?
Please try: DROP DATABASE IF EXISTS "SRP-27097" WITH FORCE;
Hi,
On Mon, Aug 01, 2022 at 11:22:33AM +0200, Matthias Apitz wrote:
>
> This is with 14.1 on Linux. I have created a new database with
>
> $ createdb -U sisis -T template0 SRP-27097
>
> I can connect to it, created tables and fill them with SQL:
>
> but I can not drop the database:
>
> $ psql -Usi
Hello,
This is with 14.1 on Linux. I have created a new database with
$ createdb -U sisis -T template0 SRP-27097
I can connect to it, created tables and fill them with SQL:
$ psql -Usisis -dSRP-27097
psql (14.1)
Geben Sie »help« für Hilfe ein.
SRP-27097=# select count(*) from sisisinst;
cou
Requirement is to use only ca.crt and connect to postgres
Server.crt, Server.key and ca.crt are configured at the postgres server for
tls connection.
Connection successful while using
psql ‘host=172.29.21.222 dbname=test user=postgres sslmode=verify-ca
sslcert=/tmp/server.crt sslkey=/tmp/server.k
Hi,
We're using asynchronous streaming replication together with WAL archiving and
recovery (we've set these parameters: archive_command, restore_command,
recovery_target_timeline=latest).
To manage backup and recovery, we're using pg_probackup.
We have a 3-node cluster managed by Patroni on Raft
10 matches
Mail list logo
