[BUGS] BUG #6021: There is no difference between default and empty access privileges with \dp

2011-05-11 Thread psql dp showing empty Access privileges column for {}
The following bug has been logged online: Bug reference: 6021 Logged by: psql \dp showing empty Access privileges column for {} Email address: gszpetkow...@gmail.com PostgreSQL version: 9.0.4 Operating system: Debian Squeeze Description:There is no difference between

Re: [BUGS] BUG #5994: Can't excute DBI->connect to oracle by client site

2011-05-11 Thread 李紅兵
yes,I am sure that I connect to the same database and same machine. because I run my test code at the linux server with telnet. As you said,it likes some security modules inhibit to make a new connection. My server is Redhat Linux Enterprice version with typical installation.and I don't know ab

Re: [BUGS] BUG #5994: Can't excute DBI->connect to oracle by client site

2011-05-11 Thread 李紅兵
addendum ,I can run my test code on a windows postgreSQL(8.4) with tcp/ip connection. - Original Message - From: "Craig Ringer" To: "李紅兵" Cc: "John R Pierce" ; Sent: Wednesday, May 11, 2011 2:17 PM Subject: Re: [BUGS] BUG #5994: Can't excute DBI->connect to oracle by client site

Re: [BUGS] BUG #5994: Can't excute DBI->connect to oracle by client site

2011-05-11 Thread Craig Ringer
On 05/11/2011 03:13 PM, 李紅兵 wrote: yes,I am sure that I connect to the same database and same machine. because I run my test code at the linux server with telnet. As you said,it likes some security modules inhibit to make a new connection. My server is Redhat Linux Enterprice version with typica

Re: [BUGS] BUG #5994: Can't excute DBI->connect to oracle by client site

2011-05-11 Thread 李紅兵
I found this problem two weeks ago in a project,and then go to other team.Environment and machine has been changed after. so I cannot test now.Colleague told me this problem has been resolved by other pepole. I read the config of selinux.It changed as you said. SELINUX=enforcing changed to SELI

Re: [BUGS] BUG #6019: invalid cached plan on inherited table

2011-05-11 Thread Maxo EtDirloth
No big deal to me, I just couldn't verify that it may occur only within single transaction - not even in documentation. thanks for the answer .et. On Wed, May 11, 2011 at 6:17 AM, Tom Lane wrote: > "" writes: > > Cached execution plan of SQL stored procedure (which select from > inherited > >

[BUGS] BUG #6022: Postgre84+RHEL6+Veritas file system?

2011-05-11 Thread Manoranjan Reddy
The following bug has been logged online: Bug reference: 6022 Logged by: Manoranjan Reddy Email address: m...@manosoftlive.com PostgreSQL version: 8.4 Operating system: RHEL6 Description:Postgre84+RHEL6+Veritas file system? Details: Do this config work well? PostGre

Re: [BUGS] Changed behaviour of \'

2011-05-11 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Tom Lane wrote: > >> Hmm ... considering that's the first thing in the release notes, I'm > >> surprised Martin missed it. Maybe he was looking for something > >> mentioning backslashes ... should we add a bit that specifically says > >> that backslashe

Re: [BUGS] BUG #6020: Wrong data type returned after CAST in FROM

2011-05-11 Thread Tom Lane
"Skylar Hawk" writes: > I noticed a strange nuance. When I do a regular select on data that I CAST > as a CHAR(), the data I am returned is of type character() as I would > expect. For example: > SELECT > CAST('abcd' AS CHAR(4)) AS data > This returns 'abcd' where the type is character(4). >

Re: [BUGS] BUG #6020: Wrong data type returned after CAST in FROM

2011-05-11 Thread Tom Lane
Skylar Hawk writes: > I got the similar results when I ran similar queries from a ruby > script using the 'postgres' gem as well, which notified me of the > difference through the error message. That's actually what alerted me > to it first. The script calls a plpsql function which expects a > CHA

Re: [BUGS] BUG #6020: Wrong data type returned after CAST in FROM

2011-05-11 Thread Tom Lane
Skylar Hawk writes: > My apologies too. Now that I look at it I wasn't accurately describing > how I was doing things after all. In the script I do pass on the data > I get back from that query into another function, but after looking > again, it looks like I have the script pull the data from thi

[BUGS] collation problem on 9.1-beta1

2011-05-11 Thread Marc Cousin
Hi, I've been starting to work on a 'what's new in 9.1' like i did last year, and am faced with what I feel is a bug, while building a demo case for collation. Here it is: SELECT * from (values ('llegar'),('llorer'),('lugar')) as tmp order by 1 collate "es_ES.utf8"; ERROR: collations are not s

Re: [BUGS] Changed behaviour of \'

2011-05-11 Thread Magnus Hagander
On Wed, May 11, 2011 at 16:25, Bruce Momjian wrote: > Tom Lane wrote: >> Bruce Momjian writes: >> > Tom Lane wrote: >> >> Hmm ... considering that's the first thing in the release notes, I'm >> >> surprised Martin missed it.  Maybe he was looking for something >> >> mentioning backslashes ... sho

Re: [BUGS] collation problem on 9.1-beta1

2011-05-11 Thread Tom Lane
Marc Cousin writes: > I've been starting to work on a 'what's new in 9.1' like i did last > year, and am faced with what I feel is a bug, while building a demo case > for collation. > Here it is: > SELECT * from (values ('llegar'),('llorer'),('lugar')) as tmp > order by 1 collate "es_ES.utf8";

Re: [BUGS] [GENERAL] postgresql-8.4 error -> BUG

2011-05-11 Thread Robert Haas
On Wed, Mar 30, 2011 at 8:03 AM, fhaegele wrote: > Additional: if i start postgresql with user postgres then I got the the > following message: > > postgres@delta ~ $ /usr/lib/postgresql/8.4/bin/pg_ctl start > /usr/lib/postgresql/8.4/bin/pg_ctl: symbol lookup error: > /usr/lib/postgresql/8.4/bin/p

Re: [BUGS] BUG #5962: Problem Acessing Network Path

2011-05-11 Thread Robert Haas
On Fri, Apr 1, 2011 at 6:04 AM, Sumit wrote: > > The following bug has been logged online: > > Bug reference:      5962 > Logged by:          Sumit > Email address:      sam141...@gmail.com > PostgreSQL version: 8.3 > Operating system:   win 7 > Description:        Problem Acessing Network Path >

Re: [BUGS] BUG #5980: Installation can't running

2011-05-11 Thread Robert Haas
On Thu, Apr 14, 2011 at 8:40 PM, M709199 wrote: > > The following bug has been logged online: > > Bug reference:      5980 > Logged by:          M709199 > Email address:      m709...@yandex.ru > PostgreSQL version: 9.0.3-2 > Operating system:   Windows 7 > Description:        Installation can't ru

Re: [BUGS] BUG #5984: Got FailedAssertion("!(opaque->btpo_prev == target)", File: "nbtpage.c", Line: 1166)

2011-05-11 Thread Robert Haas
On Mon, Apr 18, 2011 at 5:16 AM, BORSCHNECK Pascal wrote: > Because I noticed that doing a pause to a VM (to make a VM copy for example) > often creates duplicates key problems error in the logs. That's kind of surprising, but I can't help wondering if it's a bug in what virtualization tool you a

Re: [BUGS] help

2011-05-11 Thread Robert Haas
On Tue, Apr 19, 2011 at 4:40 AM, anij ninan wrote: >> i install posgresql in remote server linux(centos).when i changed the >> configuration. >> and it has not working.could you help me please how to config pg_bha.cnf >> in a remote server.our ip address is 67.23.238.200. >> I would be thankful to

Re: [BUGS] BUG #5996: CURRENT_TIMESTAMP uses often undesired TRANSACTION_TIMESTAMP, instead of STATEMENT_TIMESTAMP

2011-05-11 Thread Robert Haas
On Thu, Apr 28, 2011 at 3:33 PM, Brian S. Krug wrote: > > The following bug has been logged online: > > Bug reference:      5996 > Logged by:          Brian S. Krug > Email address:      bk...@usatech.com > PostgreSQL version: 9.0.3 > Operating system:   Solaris > Description:        CURRENT_TIMES

Re: [BUGS] BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install

2011-05-11 Thread Robert Haas
On Wed, May 4, 2011 at 4:39 PM, Tom Lane wrote: > "Daniel Grace" writes: >> Bug reference:      6005 >> Logged by:          Daniel Grace >> Email address:      dgr...@wingsnw.com >> PostgreSQL version: 9.1-beta1 >> Operating system:   Win7 x64 (x86 postgres) >> Description:        ALTER ROLE ...

Re: [BUGS] BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install

2011-05-11 Thread Tom Lane
Robert Haas writes: > On Wed, May 4, 2011 at 4:39 PM, Tom Lane wrote: >> "Daniel Grace" writes: >>> ALTER ROLE foo WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN >>> NOREPLICATION VALID UNTIL 'infinity'; >> Hmm, cannot duplicate this here ... can anyone else?  Windows-specific >> issu

Re: [BUGS] BUG #6005: ALTER ROLE ... VALID UNTIL 'infinity' crashes postmaster on a fresh install

2011-05-11 Thread Tom Lane
Robert Haas writes: > Will commit 2e82d0b396473b595a30f68b37b8dfd41c37dff8 have possibly fixed this? This should now be fixed as of HEAD, but it wouldn't be a bad idea for someone to check that it really works on Windows. Look at whether the timezone_abbreviations GUC has a sane value and you ca