Services
24×7×365 Technical Support
Migration to PostgreSQL
High Availability Deployment
Database Audit
Remote DBA for PostgreSQL
Products
Postgres Pro Enterprise
Postgres Pro Standard
Cloud Solutions
Postgres Extensions
Resources
Blog
Documentation
Webinars
Videos
Presentations
Community
Events
Training Courses
Books
Demo Database
Mailing List Archives
About
Leadership team
Partners
Customers
In the News
Press Releases
Press Info
Services
24×7×365 Technical Support
Migration to PostgreSQL
High Availability Deployment
Database Audit
Remote DBA for PostgreSQL
Products
Postgres Pro Enterprise
Postgres Pro Standard
Cloud Solutions
Postgres Extensions
Resources
Blog
Documentation
Webinars
Videos
Presentations
Community
Events
Training Courses
Books
Demo Database
Mailing List Archives
About
Leadership team
Partners
Customers
In the News
Press Releases
Press Info
Facebook
Downloads
Home
>
mailing lists
A problem about LEAKPROOF of postgresql - Mailing list pgsql-bugs
From
qiumingcheng
Subject
A problem about LEAKPROOF of postgresql
Date
September 8, 2022
05:04:25
Msg-id
9f1ec18e-23fb-47fe-b83a-7b996aaddc2e.qiumingcheng@aliyun.com
Whole thread
Raw
List
pgsql-bugs
Tree view
你好,专家,请教个关于postgresql(代码所在分支:master,代码所在文件:
selfuncs.c
)源码的问题,代码如下。按照我的理解,在优化器阶段,下方红线框中的代码是可以去掉的,否则可能会影响影视图响执行计划路径选择:
一个用户A创建了视图,并将该视图授权给他用户B(B用户只有视图权限,没有该视图对应的表权限),那么在A用户下查询这个视图,可以看到执行计划路径会选择索引路径,但是在B用户实行该视图,他不会选择索引路径,我知道这
是一个关于
LEAKPROOF的问题,我的参考链接如下:
https://www.2ndquadrant.com/en/blog/how-do-postgresql-security_barrier-views-work/
请帮忙解答一下:在优化器阶段,这段代码没啥不能去掉?或者说,如果我去掉下方红线框中的代码会带来啥问题。
另外,我
Attachment
temp4cj.png
pgsql-bugs
by date:
Previous
From:
Ming
Date:
08 September 2022, 02:02:51
Subject:
Postgres offset and limit bug
Next
From:
"qiumingcheng"
Date:
08 September 2022, 05:12:03
Subject:
A problem about LEAKPROOF of postgresql
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
I confirm that I have read and accepted PostgresPro’s
Privacy Policy
.
I agree to get Postgres Pro discount offers and other marketing communications.
✖
×
×
Everywhere
Documentation
Mailing list
List:
all lists
pgsql-general
pgsql-hackers
buildfarm-members
pgadmin-hackers
pgadmin-support
pgsql-admin
pgsql-advocacy
pgsql-announce
pgsql-benchmarks
pgsql-bugs
pgsql-chat
pgsql-cluster-hackers
pgsql-committers
pgsql-cygwin
pgsql-docs
pgsql-hackers-pitr
pgsql-hackers-win32
pgsql-interfaces
pgsql-jdbc
pgsql-jobs
pgsql-novice
pgsql-odbc
pgsql-patches
pgsql-performance
pgsql-php
pgsql-pkg-debian
pgsql-pkg-yum
pgsql-ports
pgsql-rrreviewers
pgsql-ru-general
pgsql-sql
pgsql-students
pgsql-testers
pgsql-translators
pgsql-www
psycopg
Period
anytime
within last day
within last week
within last month
within last 6 months
within last year
Sort by
date
reverse date
rank
Services
24×7×365 Technical Support
Migration to PostgreSQL
High Availability Deployment
Database Audit
Remote DBA for PostgreSQL
Products
Postgres Pro Enterprise
Postgres Pro Standard
Cloud Solutions
Postgres Extensions
Resources
Blog
Documentation
Webinars
Videos
Presentations
Community
Events
Training Courses
Books
Demo Database
Mailing List Archives
About
Leadership team
Partners
Customers
In the News
Press Releases
Press Info
By continuing to browse this website, you agree to the use of cookies. Go to
Privacy Policy
.
I accept cookies