[BUGS] BUG #8511: some of object dont drop

2013-10-08 Thread shahtejas2811
The following bug has been logged on the website: Bug reference: 8511 Logged by: Tejas Email address: shahtejas2...@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: Linux Description: cache lookup failed for relation 421062806 -- Sent via pgsql

Re: [BUGS] BUG #8511: some of object dont drop

2013-10-08 Thread John R Pierce
On 10/8/2013 1:02 AM, shahtejas2...@gmail.com wrote: The following bug has been logged on the website: Bug reference: 8511 Logged by: Tejas Email address: shahtejas2...@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: Linux Description: cache lookup faile

Re: [BUGS] BUG #8511: some of object dont drop

2013-10-08 Thread Pavan Deolasee
On Tue, Oct 8, 2013 at 1:32 PM, wrote: > The following bug has been logged on the website: > > Bug reference: 8511 > Logged by: Tejas > Email address: shahtejas2...@gmail.com > PostgreSQL version: Unsupported/Unknown > Operating system: Linux > Description: > > cache lookup f

Re: [BUGS] Installing/Upgrading PostgreSQL 9.1.6 to 9.3 known bugs?

2013-10-08 Thread Bruce Momjian
On Mon, Oct 7, 2013 at 08:07:42AM -0700, fburg...@radiantblue.com wrote: > Bruce, Proposed Steps. Do they look feasible? > > 1.) pg_dump -h localhost -p 5432 -U postgres -Fc -b -v -f "/somepath/ > testdb.backup" testdb > 2.) CREATE DATABASE newdb TEMPLATE=template_postgis; > 3.) perl ../postgis-p

Re: [BUGS] Installing/Upgrading PostgreSQL 9.1.6 to 9.3 known bugs?

2013-10-08 Thread fburgess
We shouldn't have a problem with using pg_upgrade with the hard link option to upgrade from postgreSQL 9.1.6 after I get the spatial component upgraded to postgis 2.1, then straight to postgreSQL 9.3, Right? thanks Original Message Subject: Re: [BUGS] Installing/Upgrading Postgr

Re: [BUGS] BUG #8467: Slightly confusing pgcrypto example in docs

2013-10-08 Thread Bruce Momjian
On Wed, Oct 2, 2013 at 12:00:44PM -0400, Bruce Momjian wrote: > Based on your report, I have developed the attached doc patch which > clarifies when MD5 hash is being referenced, and when MD5 crypt is. I > have also added your other suggestions. Patch applied, and backpatched to 9.3.X. Thanks f

[BUGS] BUG #8512: Can't use columns I can't read in the where clause of a select

2013-10-08 Thread kurt
The following bug has been logged on the website: Bug reference: 8512 Logged by: Kurt Roeckx Email address: k...@roeckx.be PostgreSQL version: 9.0.6 Operating system: Linux Description: Hi, When I read the documentation for GRANT, I see: SELECT Allows SELECT f

Re: [BUGS] BUG #8512: Can't use columns I can't read in the where clause of a select

2013-10-08 Thread Stephen Frost
* k...@roeckx.be (k...@roeckx.be) wrote: > Allows SELECT from any column, or the specific columns listed, of the > specified table, view, or sequence. Also allows the use of COPY TO. This > privilege is also needed to reference existing column values in UPDATE or > DELETE. > > > I read that a

[BUGS] Re: BUG #8512: Can't use columns I can't read in the where clause of a select

2013-10-08 Thread David Johnston
Stephen Frost wrote > * > kurt@ > ( > kurt@ > ) wrote: >> Allows SELECT from any column, or the specific columns listed, of the >> specified table, view, or sequence. Also allows the use of COPY TO. This >> privilege is also needed to reference existing column values in UPDATE or >> DELET

[BUGS] win8

2013-10-08 Thread Mátyás Milos
Dear Support, I would like to install the newest postgresql to win 8 but something wrong with that... At the end I got a message about some problem and I don't know why. The problem is the postgresql can not connect to the host ( 127.0.0.1 ). How can I fix it? Thanks!