Re: [BUGS] BUG #7712: pgsql2shp should set Language Driver ID (LDID) header in .dbf

2012-11-30 Thread Markus Wanner
Hello Francois, On 11/29/2012 06:32 AM, francois.bon...@gmail.com wrote: > The dumper tool pgsql2shp should set this header, as PostreSQL knowns what > encoding it is writing to. I think that belongs to the separate PostGIS project. Please find their issue tracker here: http://trac.osgeo.org/p

Re: [BUGS] BUG #7710: Xid epoch is not updated properly during checkpoint

2012-11-30 Thread Sergey Burladyan
Hi all. We also have reproduced this behaviour of txid wraparound. pg version 9.0.5. We have done some test. We are using hot standby and our chekpoint interval is closly to one hour (actually, our pg does chekpoints all time). So probability of intersection active chekpoint and getting max txid

[BUGS] BUG #7715: hstore "exists" should use same index as "?" operator

2012-11-30 Thread ian . dees
The following bug has been logged on the website: Bug reference: 7715 Logged by: Ian Dees Email address: ian.d...@gmail.com PostgreSQL version: 9.1.6 Operating system: Ubuntu 11.04 Description: Currently the hstore documentation [0] says "hstore has GiST and GIN index

[BUGS] BUG #7716: Only owner can drop trigger?

2012-11-30 Thread keith
The following bug has been logged on the website: Bug reference: 7716 Logged by: Keith Fiske Email address: ke...@omniti.com PostgreSQL version: 9.2.1 Operating system: Any Description: This is documented in the DROP TRIGGER section of the documentation, but it doesn'

Re: [BUGS] BUG #7716: Only owner can drop trigger?

2012-11-30 Thread Jeff Davis
On Fri, 2012-11-30 at 23:41 +, ke...@omniti.com wrote: > The following bug has been logged on the website: > > Bug reference: 7716 > Logged by: Keith Fiske > Email address: ke...@omniti.com > PostgreSQL version: 9.2.1 > Operating system: Any > Description: > > Thi

Re: [BUGS] BUG #7716: Only owner can drop trigger?

2012-11-30 Thread Keith Fiske
On Fri, Nov 30, 2012 at 7:02 PM, Jeff Davis wrote: > On Fri, 2012-11-30 at 23:41 +, ke...@omniti.com wrote: >> The following bug has been logged on the website: >> >> Bug reference: 7716 >> Logged by: Keith Fiske >> Email address: ke...@omniti.com >> PostgreSQL version: 9.2.

Re: [BUGS] BUG #7716: Only owner can drop trigger?

2012-11-30 Thread Jeff Davis
On Fri, 2012-11-30 at 20:08 -0500, Keith Fiske wrote: > So then don't give that other role trigger permissions if you don't > want them to be able to drop a trigger. I'm actually thankful for the > trigger permission since it allows the extension I'm working on to > create triggers on tables the ro