The following bug has been logged online:
Bug reference: 5147
Logged by: Dongni
Email address: donnie...@126.com
PostgreSQL version: 8.4.0
Operating system: WindowsXP 32bit
Description:DBA can not access view
Details:
Please fyi the following test case
postgres=# c
The following bug has been logged online:
Bug reference: 5146
Logged by: xqzhang
Email address: zxq230...@163.com
PostgreSQL version: 8.3.3
Operating system: linux 32
Description:After granting all select privelges on view to user, who
still can not select the view
De
"Dongni" writes:
> Description:DBA can not access view
This is not a bug. The view is owned by user1 and what the view can
access is determined by user1's permissions, independently of who is
calling it.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pg
"xqzhang" writes:
> Description:After granting all select privelges on view to user, who
> still can not select the view
You have a fundamental misconception about how that works. The
privilege checks for each view are applied with respect to the owner
of that view, not the current sessi
Bernt Marius Johnsen escreveu:
> The below query generated by the Random Query Generator
> (https://launchpad.net/randgen) causes a segfault. It was caused running
>
Could you get a core dump and post the gdb backtrace?
$ ulimit -c unlimited
$ pg_ctl start
$ psql -c "" mydb
$ gdb /path/to/postgre
Hello PostgreSQL developers,
https://launchpad.net/bugs/458020 reports a small syntax error in
./src/include/fmgr.h:338:
extern int no_such_variable
The trailing semicolon is missing:
"I had to make the changes in the attached patch file in order to use
the PG_MODULE_MAGIC macro.
From a q
Martin Pitt writes:
> https://launchpad.net/bugs/458020 reports a small syntax error in
> ./src/include/fmgr.h:338:
> extern int no_such_variable
> The trailing semicolon is missing:
This is not a bug. You are supposed to write a semicolon after the
call of PG_MODULE_MAGIC. If we put a semi
Martin Pitt wrote:
> Hello PostgreSQL developers,
>
> https://launchpad.net/bugs/458020 reports a small syntax error in
> ./src/include/fmgr.h:338:
>
> extern int no_such_variable
>
> The trailing semicolon is missing:
The guy forgot to add a trailing semicolon on the line where he uses the
m
Euler Taveira de Oliveira wrote (2009-10-29 12:17:36):
> Bernt Marius Johnsen escreveu:
> > The below query generated by the Random Query Generator
> > (https://launchpad.net/randgen) causes a segfault. It was caused running
> >
Checkout the latest RQG from launchpad and run ./gentes
Bernt M. Johnsen wrote:
Euler Taveira de Oliveira wrote (2009-10-29 12:17:36):
Bernt Marius Johnsen escreveu:
The below query generated by the Random Query Generator
(https://launchpad.net/randgen) causes a segfault. It was caused running
Checkout the latest RQG from launchpad and run ./gent
Stefan Kaltenbrunner writes:
> I can easily reproduce the segfault on 8.4 and 8.5a2:
Doesn't crash here ... could we see the specific test data being used,
please?
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your
On Thu, Oct 29, 2009 at 2:14 PM, Stefan Kaltenbrunner
wrote:
> ExecHashJoinSaveTuple (tuple=0xb49c8870, hashvalue=3316173823,
> fileptr=0x96185a8) at nodeHashjoin.c:775
> 775 BufFile *file = *fileptr;
>
That back trace doesn't make much sense. That function only has one
call site a
Tom Lane wrote:
Stefan Kaltenbrunner writes:
I can easily reproduce the segfault on 8.4 and 8.5a2:
Doesn't crash here ... could we see the specific test data being used,
please?
uploaded a dump of the dataset here:
http://www.kaltenbrunner.cc/files/rand_gen_data.sql
and the query that cau
In document£¬, it said:
It should be noted that database superusers can access all objects
regardless of object privilege settings. This is comparable to the rights of
root in a Unix system. As with root, it's unwise to operate as a superuser
except when absolutely necessary.
But Dongni's test
14 matches
Mail list logo
