Re: [BUGS] BUG #5147: DBA can not access view

2009-11-02 Thread Robert Haas
2009/11/2 donniehan : > Hi Tom, > > I agree with Hxli. It may be a good way to add permissions check when create > the view. > > I also find 2 pieces of words in the document about the owner of the object. > > "By default, only the owner of an object can do anything with the object." > > "as th

Re: [BUGS] BUG #5147: DBA can not access view

2009-11-02 Thread donniehan
Hi Robert, Okay i get what you mean, you can finish this thread. Thanks for reply anyway! Regards -Dongni 在2009-11-02?22:56:03，"Robert?Haas"??写道： >2009/11/2?donniehan?: >>?Hi?Tom, >> >>?I?agree?with?Hxli.?It?may?be?a?good?way?to?add?permissions?check?when?create >>?the?view. >> >>?I?also?find?2

[BUGS] BUG #5159: 8.4.1 Segmentation fault

2009-11-02 Thread Sergey Konoplev
The following bug has been logged online: Bug reference: 5159 Logged by: Sergey Konoplev Email address: gray...@gmail.com PostgreSQL version: 8.4.1 Operating system: CentOS release 5.4 (Final) Description:8.4.1 Segmentation fault Details: Hello Contribs: btree_gis

Re: [BUGS] BUG #5159: 8.4.1 Segmentation fault

2009-11-02 Thread Tom Lane
"Sergey Konoplev" writes: > After migration to 8.4.1 from 8.3.7 our server worked normally for half our > and then become falling down continuously with "Segmentation fault". I did > two codedumps and bt on it: > Core was generated by `postgres: mirtesen mirtesen [local] INSERT'. > Progra

Re: [BUGS] BUG #5159: 8.4.1 Segmentation fault

2009-11-02 Thread Sergey Konoplev
Thanx, Tom. So I just need to checkout REL8_4_STABLE and install it to fix my problem, right? On Mon, Nov 2, 2009 at 7:48 PM, Tom Lane wrote: > "Sergey Konoplev" writes: >> After migration to 8.4.1 from 8.3.7 our server worked normally for half our >> and then become falling down continuously w

Re: [BUGS] BUG #5159: 8.4.1 Segmentation fault

2009-11-02 Thread Stefan Kaltenbrunner
Sergey Konoplev wrote: Thanx, Tom. So I just need to checkout REL8_4_STABLE and install it to fix my problem, right? that should work if it is indeed the same issue. Stefan -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postg

Re: [BUGS] BUG #5159: 8.4.1 Segmentation fault

2009-11-02 Thread Sergey Konoplev
On Mon, Nov 2, 2009 at 8:25 PM, Stefan Kaltenbrunner wrote: > Sergey Konoplev wrote: >> >> Thanx, Tom. >> >> So I just need to checkout REL8_4_STABLE and install it to fix my >> problem, right? > > that should work if it is indeed the same issue. > What if I apply this patch to 8.4.1? Would I get

Re: [BUGS] BUG #5159: 8.4.1 Segmentation fault

2009-11-02 Thread Stefan Kaltenbrunner
Sergey Konoplev wrote: On Mon, Nov 2, 2009 at 8:25 PM, Stefan Kaltenbrunner wrote: Sergey Konoplev wrote: Thanx, Tom. So I just need to checkout REL8_4_STABLE and install it to fix my problem, right? that should work if it is indeed the same issue. What if I apply this patch to 8.4.1? Wou

Re: [BUGS] BUG #5159: 8.4.1 Segmentation fault

2009-11-02 Thread Sergey Konoplev
Thank you. Will try. On Mon, Nov 2, 2009 at 8:40 PM, Stefan Kaltenbrunner wrote: > Sergey Konoplev wrote: >> >> On Mon, Nov 2, 2009 at 8:25 PM, Stefan Kaltenbrunner >> wrote: >>> >>> Sergey Konoplev wrote: Thanx, Tom. So I just need to checkout REL8_4_STABLE and install it to

[BUGS] BUG #5160: complex query parsing bug

2009-11-02 Thread Mike Landis
The following bug has been logged online: Bug reference: 5160 Logged by: Mike Landis Email address: mlan...@pnmx.com PostgreSQL version: 1.8.4 Operating system: Vista Description:complex query parsing bug Details: The SQL parser in pgAdmin III v1.8.4 build 7358 thin

Re: [BUGS] BUG #5160: complex query parsing bug

2009-11-02 Thread Tom Lane
"Mike Landis" writes: > The SQL parser in pgAdmin III v1.8.4 build 7358 thinks that there should be > more input at the end of the following multi-join query. I think so too. You have two JOINs and only one ON clause. regards, tom lane -- Sent via pgsql-bugs mailing li