Re: [BUGS] ERROR: syntax error in tsquery - for high-unicode whitespace

2013-03-14 Thread Tom Lane
hubert depesz lubaczewski writes: > $ select to_tsquery('english', E'a\xe2\x80\x86a'); > ERROR: syntax error in tsquery: "a a" > the 3-byte utf8 character is SIX-PER-EM SPACE (based on info from > http://www.fileformat.info/info/unicode/char/2006/index.htm) AFAICS, that behavior is correct, i

Re: [BUGS] BUG #7943: plpgsql parsing bug

2013-03-14 Thread Tom Lane
rik...@ngs.hr writes: > The following bug has been logged on the website: > Bug reference: 7943 > Logged by: Rikard Pavelic > Email address: rik...@ngs.hr > PostgreSQL version: 9.2.1 > Operating system: Windows 7 > Description: > ERROR: "_t1" is not a scalar variable

Re: [BUGS] BUG #7942: Timestamp "19991231 240000" should not be out of range

2013-03-14 Thread Tom Lane
georg.kinderm...@gmx.at writes: > select cast('19991231 24' as timestamp); > --Produces >ERROR: timestamp out of range< Oddly enough, I just fixed that last week: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=542eeba26992305d872be699158cb3ab1c2be6e6 Weird how a bug can go

[BUGS] ERROR: syntax error in tsquery - for high-unicode whitespace

2013-03-14 Thread hubert depesz lubaczewski
hi it was tested on 9.1 and 9.3. Interestingly - it worked without error in 8.2. $ select to_tsquery('english', E'a\xe2\x80\x86a'); ERROR: syntax error in tsquery: "a a" the 3-byte utf8 character is SIX-PER-EM SPACE (based on info from http://www.fileformat.info/info/unicode/char/2006/index.htm)

Re: [BUGS] Questions about PostgreSQL Setup License

2013-03-14 Thread Daniel Farina
On Thu, Mar 14, 2013 at 9:42 AM, DUBILLOT Aurelien wrote: > I read on your website that PostgreSQL source code is free for use and > modification, but in my case I am working on a project where we are > generating our own setup and we would like to integrate PostgreSQL setup > within it. This isn

Re: [BUGS] Questions about PostgreSQL Setup License

2013-03-14 Thread Peter Geoghegan
On 14 March 2013 16:42, DUBILLOT Aurelien wrote: > Are we also allowed to do that ? Why are you posting this to the -bugs mailing list? The answer is yes, though IANAL, and that does not constitute legal advice. However, there are a number of fairly prominent full commercial forks, so I think yo

[BUGS] BUG #7943: plpgsql parsing bug

2013-03-14 Thread rikard
The following bug has been logged on the website: Bug reference: 7943 Logged by: Rikard Pavelic Email address: rik...@ngs.hr PostgreSQL version: 9.2.1 Operating system: Windows 7 Description: ERROR: "_t1" is not a scalar variable LINE 12: for _i1, _i2, _t1, _t2, _t3,

[BUGS] BUG #7942: Timestamp "19991231 240000" should not be out of range

2013-03-14 Thread georg . kindermann
The following bug has been logged on the website: Bug reference: 7942 Logged by: Georg Kindermann Email address: georg.kinderm...@gmx.at PostgreSQL version: 9.1.8 Operating system: Debian Wheezy Description: select cast('19991231 24' as timestamp); --Produces >ERR

[BUGS] Questions about PostgreSQL Setup License

2013-03-14 Thread DUBILLOT Aurelien
Hello, I read on your website that PostgreSQL source code is free for use and modification, but in my case I am working on a project where we are generating our own setup and we would like to integrate PostgreSQL setup within it. Are we also allowed to do that ? Thanks in advance for your resp

Re: [BUGS] BUG #7913: TO_CHAR Function & Turkish collate

2013-03-14 Thread Devrim GÜNDÜZ
Hi, On Tue, 2013-03-05 at 13:08 -0500, Tom Lane wrote: > > I think it's a bug that should be backpatched. > > Done. In addition to day/month names, I found that there were > case-folding hazards for timezone abbreviations ('tz' format) > and Roman numerals for numbers ('rn' format) ... though,

Re: [BUGS] BUG #7940: Auto increment issue

2013-03-14 Thread Josh Kupershmidt
On Wed, Mar 13, 2013 at 4:01 AM, wrote: > Hi, > I'm using PostgreSQL 9.0.1 and driver PostgreSQL 9.0 JDBC4 and my OS > is Ubuntu.I'm using serial type for auto-incrementing column id in my table > everything works fine .when i stop my application and restart the > application its fine but