[BUGS] BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error

2013-01-22 Thread Jan-Peter . Seifert
The following bug has been logged on the website: Bug reference: 7820 Logged by: Jan-Peter Seifert Email address: jan-peter.seif...@gmx.de PostgreSQL version: 9.1.7 Operating system: Windows 7 64-bit Description: The statement: 'CREATE EXTENSION uuid-ossp' just gives

Re: [BUGS] BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error

2013-01-22 Thread Heikki Linnakangas
On 22.01.2013 15:31, jan-peter.seif...@gmx.de wrote: The statement: 'CREATE EXTENSION uuid-ossp' just gives me a syntax error: ERROR: syntax error at or near "-" LINE 1: CREATE EXTENSION uuid-ossp ^ ** Fehler ** ERROR: syntax error at or near "-"

Re: [BUGS] BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error

2013-01-22 Thread Vik Reykja
On Tue, Jan 22, 2013 at 2:31 PM, wrote: > The statement: > 'CREATE EXTENSION uuid-ossp' > > just gives me a syntax error: > > ERROR: syntax error at or near "-" > LINE 1: CREATE EXTENSION uuid-ossp > ^ > ** Fehler ** > > ERROR: syntax error at or near

Re: [BUGS] BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error

2013-01-22 Thread Marc Balmer
Am 22.01.2013 um 14:31 schrieb jan-peter.seif...@gmx.de: > The following bug has been logged on the website: > > Bug reference: 7820 > Logged by: Jan-Peter Seifert > Email address: jan-peter.seif...@gmx.de > PostgreSQL version: 9.1.7 > Operating system: Windows 7 64-bit > De

Re: [BUGS] BUG #7819: missing chunk number 0 for toast value 1235919 in pg_toast_35328

2013-01-22 Thread Pius Chan
Hi Tom, Yes, we start seeing this ERROR after upgrade to 9.1.7. The ERROR is from the "cluster jms_messages" command. Last night, the ERROR happened three times: (1) at 00:20:01 ERROR: missing chunk number 0 for toast value 1239124 in pg_toast_35328 (2) at 00:25:01 ERROR: missing chunk numb

Re: [BUGS] BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error

2013-01-22 Thread Tom Lane
Heikki Linnakangas writes: > On 22.01.2013 15:31, jan-peter.seif...@gmx.de wrote: > Try: > CREATE EXTENSION "uuid-ossp" Although this isn't a bug, it does seem like a usability fail. Did we make a conscious decision not to call the extension uuid_ossp? I can't remember one way or the other. It's

Re: [BUGS] BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error

2013-01-22 Thread Jan-Peter Seifert
Am 22.01.2013 14:47, schrieb Marc Balmer: > no. Your syntax is wrong. Well - it's not exactly 'my' syntax - see: uuid-ossp--1.0.sql uuid-ossp--unpackaged--1.0.sql >> I had to replace the hyphen in file names and in the scripts to make the >> module work. >> > That is the wrong "fix". The hyphe

Re: [BUGS] BUG #7814: Rotation of the log is not carried out.

2013-01-22 Thread Jeff Janes
On Tue, Jan 22, 2013 at 4:42 AM, Tsunezumi wrote: > Thank you. > > I send the picture of a screen. > Thanks. For what it is worth, I can reproduce this on Windows 7, using the 9.2.2 and 9.1.7 windows 64 installers from EDB (i.e. http://www.enterprisedb.com/postgresql-922-installers-win64?ls=Cros

Re: [BUGS] BUG #7820: Extension uuid-ossp cannot be installed on Windows - getting syntax error

2013-01-22 Thread Daniel Farina
On Tue, Jan 22, 2013 at 10:26 AM, Tom Lane wrote: > Heikki Linnakangas writes: >> On 22.01.2013 15:31, jan-peter.seif...@gmx.de wrote: >> Try: >> CREATE EXTENSION "uuid-ossp" > > Although this isn't a bug, it does seem like a usability fail. > Did we make a conscious decision not to call the exte

Re: [BUGS] BUG #7814: Rotation of the log is not carried out.

2013-01-22 Thread Tom Lane
Jeff Janes writes: > For what it is worth, I can reproduce this on Windows 7, using the > 9.2.2 and 9.1.7 windows 64 installers from EDB (i.e. > http://www.enterprisedb.com/postgresql-922-installers-win64?ls=Crossover&type=Crossover), > with completely default installation (EDB changes the default

Re: [BUGS] BUG #7819: missing chunk number 0 for toast value 1235919 in pg_toast_35328

2013-01-22 Thread Tom Lane
Pius Chan writes: > Hi Tom, > Yes, we start seeing this ERROR after upgrade to 9.1.7. The ERROR is from the > "cluster jms_messages" command. Last night, the ERROR happened three times: > (1) at 00:20:01 > ERROR: missing chunk number 0 for toast value 1239124 in pg_toast_35328 > (2) at 00:25

Re: [BUGS] BUG #7814: Rotation of the log is not carried out.

2013-01-22 Thread Jeff Janes
On Tuesday, January 22, 2013, Tom Lane wrote: > Jeff Janes > writes: > > For what it is worth, I can reproduce this on Windows 7, using the > > 9.2.2 and 9.1.7 windows 64 installers from EDB (i.e. > > > http://www.enterprisedb.com/postgresql-922-installers-win64?ls=Crossover&type=Crossover > ), >

[BUGS] BUG #7822: PGDG packaged postgresql92 binaries do not find their libraries

2013-01-22 Thread georgi-georgiev-pgsql
The following bug has been logged on the website: Bug reference: 7822 Logged by: Georgi Georgiev Email address: georgi-georgiev-pg...@japannext.co.jp PostgreSQL version: 9.2.2 Operating system: CentOS 6.3 Description: The postgresql92 package would configure the postg

[BUGS] BUG #7823: PGDG packaged pgadmin3_92 removes its /usr/bin/pgadmin3 link

2013-01-22 Thread georgi-georgiev-pgsql
The following bug has been logged on the website: Bug reference: 7823 Logged by: Georgi Georgiev Email address: georgi-georgiev-pg...@japannext.co.jp PostgreSQL version: 9.2.2 Operating system: CentOS 6.3 Description: Updating pgadmin3_92 removes the /usr/bin/pgadmin3

[BUGS] BUG #7824: documentation bug: Extract DOW

2013-01-22 Thread tim . romano
The following bug has been logged on the website: Bug reference: 7824 Logged by: Tim Romano Email address: tim.rom...@yahoo.com PostgreSQL version: 9.2.2 Operating system: Windows 7 x64 Description: Documentation seems to indicate that only a Timestamp value is a vali

[BUGS] BUG #7825: pgAdmin III won't allow unchecking superuser

2013-01-22 Thread rboudwin
The following bug has been logged on the website: Bug reference: 7825 Logged by: Randy Boudwin Email address: rboud...@automatedlogic.com PostgreSQL version: 9.2.2 Operating system: Win 7 64 Description: When I attempt to uncheck the superuser permission on a user I c

[BUGS] BUG #7821: constant disconnection with external network

2013-01-22 Thread alessandro
The following bug has been logged on the website: Bug reference: 7821 Logged by: Alessandro Linguanoto Email address: alessan...@nwsoftware.com.br PostgreSQL version: 9.0.6 Operating system: Windows Description: I use PostgreSQL 9.0.6 and I´m with a problem using Post

Re: [BUGS] BUG #7824: documentation bug: Extract DOW

2013-01-22 Thread Pavan Deolasee
On Wed, Jan 23, 2013 at 2:10 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 7824 > Logged by: Tim Romano > Email address: tim.rom...@yahoo.com > PostgreSQL version: 9.2.2 > Operating system: Windows 7 x64 > Description: > > Documentation see