Re: [BUGS] BUG #2579: initcap should not capitalize letter
On Thu, 17 Aug 2006, Dan Franklin wrote:
> Date: Thu, 17 Aug 2006 15:34:41 -0400
> From: Dan Franklin <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #2579: initcap should not capitalize letter
>
> Good point. It is probably not possible to get
> it perfect. But I think that possessives and
> contractions occur more often in a typical body
> of text than Irish names. So it would be right
> more often, even if it is still wrong some of the time.
>
> Dan Franklin
Two thoughts:
1) In English at least, it's only at the trailing end of a word that the
non-capitalization is clear (contractions, possessive, etc).
2) Proper names are unknowable as to what's appropriate and I posit that
there is no algorithm that works for names.
This leads to a conclusion: Never add capitalization inside a string of
letters.
Rgds,
Richard
>
> At 03:08 PM 8/17/2006, [EMAIL PROTECTED] wrote:
> >-BEGIN PGP SIGNED MESSAGE-
> >Hash: SHA1
> >
> >On Wed, Aug 16, 2006 at 09:03:08PM +, Dan Franklin wrote:
> > >
> > > The following bug has been logged online:
> > >
> > > Bug reference: 2579
> > > Logged by: Dan Franklin
> > > Email address: [EMAIL PROTECTED]
> > > PostgreSQL version: 8.1.4
> > > Operating system: GNU/Linux Fedora Core 5
> > > Description:initcap should not capitalize letter after apostrophe
> > > Details:
> > >
> > > The statement
> > > select initcap('John''s Parents');
> > > returns
> > > John'S Parents
> > >
> > > The capital "S" after the apostrophe is incorrect. initcap should
> > > consider
> > > the apostrophe to be a word-constituent for the purpose of identifying
> > > word
> > > boundaries at which to start capitalizing.
> >
> >Hmm. And what about Flann O'Brien?
> >
> >Tough thing, this.
> >
> >Regards
> >- -- tomás
> >-BEGIN PGP SIGNATURE-
> >Version: GnuPG v1.4.1 (GNU/Linux)
> >
> >iD8DBQFE5L60Bcgs9XrR2kYRArkQAKCBI9uYSUckPWL6jzB3PFBXNAlwSgCeOoJx
> >NIBRgQZYqRajtx8HrUnW1Hs=
> >=GI/E
> >-----END PGP SIGNATURE-
>
> Dan Franklin
> Family Education Network
> Pearson Education
> 617-671-3799
>
>
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>match
>
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
[EMAIL PROTECTED], http://ScienceTools.com/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Re: [BUGS] error in upper()
Hi Klaus,
I must have missed the bug submitted about this, but as a student of
German I took particular interest in your post.
I'm unaware of any upper case or lower case for 'ß', just as there is no
upper or lower case for '@'. So, I'd expect the function to pass it
through. It's not - or shouldn't be - the business of upper() or lower()
to translate your characters for you which haven't got an appropriate
upper or lower case version...
Rgds,
Richard
On Fri, 18 Aug 2006, Klaus Ita wrote:
> Date: Fri, 18 Aug 2006 09:44:27 +0200
> From: Klaus Ita <[EMAIL PROTECTED]>
> To: pgsql-bugs@postgresql.org
> Subject: [BUGS] error in upper()
>
> I know that tom is going to say this is not a bug in pg and he is probably
> right. but still i want to state, that in pg 8.1 the
>
> select lower(upper('ß'))
>
> does not return 'ss'. because the upper('ß') does not return 'SS' in the
> first place. I know, german is a terrible language, but still - we are using
> it :-)
>
> thx,
> klaus
>
> and tom. there is no offence at all! I love Pg and the work you are doing.
> thank you!
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>
--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
[EMAIL PROTECTED], http://ScienceTools.com/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Re: [BUGS] BUG #2648: I can not create table name with capital and
Asaf, quote them and it will work. Richard On Sun, 24 Sep 2006, Asaf Avraham wrote: > Date: Sun, 24 Sep 2006 06:18:38 GMT > From: Asaf Avraham <[EMAIL PROTECTED]> > To: pgsql-bugs@postgresql.org > Subject: [BUGS] BUG #2648: I can not create table name with capital and > small characters > > > The following bug has been logged online: > > Bug reference: 2648 > Logged by: Asaf Avraham > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.4.2 > Operating system: win > Description:I can not create table name with capital and small > characters > Details: > > I have table that contain name with capital and small characters (ex. > tblEmp). In the columns is the same (ex. EmpID). > > In Creating table postgres add inverted commas on the name > > When I'm running any query on this table i get: > 1. select * from tblEmp >Get: ERROR: relation "tblemp" does not exist > 2. select * from "tblEmp" >Get: Resulted > > Thanks > > ---(end of broadcast)--- > TIP 9: In versions below 8.0, the planner will ignore your desire to >choose an index scan if your joining column's datatypes do not >match > -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [BUGS] BUG #2695: Randomly repeated query execution
On Mon, 16 Oct 2006, Jakub wrote: > > The following bug has been logged online: > > Bug reference: 2695 > Logged by: Jakub > Email address: [EMAIL PROTECTED] > PostgreSQL version: Postgres 7.4 > Operating system: Linux > Description:Randomly repeated query execution > Details: > > Sometimes, randomly single query execution is repeated twice or more in > 2-5 second. > > Thanks, > Jakub > Jakub, I've seen this type of thing before, but it wasn't Postgres' fault. In the examples I've seen (on many different occasions, in differing circumstances) the application was actually issuing the query multiple times and usually the cause of that was improper (multiple) event handling by the application's GUI. In particular, if the language is Java, look for errant event-handling methods. I've also seen this type of error caused by error handling packages that attempt to auto-recover based on various errors when they have a bug regarding what kinds of errors are recoverable and which are not. As examples, a lost network link may be recoverable, but an attribute not existing in a table/relation is not. Try some very careful coding around the suspect queries to log in your own code whether queries are being repeated or not. Regards, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [BUGS] BUG #2731: Cannot install PostgreSQL server on WinXP
On Sat, 4 Nov 2006, Harald Armin Massa wrote: > > Leonid, > > It is strange but after I gave postmaster.exe process access to the Internet > > (changed my personal firewall settings), PostgreSQL service starts OK. Why > > does postmaster.exe need access to the Internet? > > > > PostgreSQL / postmaster.exe do not need to connect to the Internet. But > communication is done via TCP/IP; and PostgreSQL needs to open Port 5432 > (standard) and listen for requests. So when your firewall forbids PostgreSQL > to listen on Port 5433 for incoming requests, it may commit suicide, because > it cannot do any usefull work anymore. > > Best wishes, > > Harald Windows has another bug; they don't include a proper loopback function with the standard distribution _and_ they have some asenine view that if there's no physical network connection available, they tear down the network stack! This means that anything that connects with TCP/IP can't work, even if it's to the local machine. I consider this idiocy, but, there's windows for you in a nutshell... However, you _can_ find a proper "loopback driver", I think they call it - software, of course. Also, I carry in my laptop case a special HARDWARE loopback connector! It's an RJ45 that has the wires crossed over. I use it when I'm at a customer site or otherwise "away from home" and my customer doesn't have the software loopback - plug my loopback connector into any "twisted pair ethernet" socket and suddenly the TCP/IP software works fine! Oh the joys of dealing with Windows. Richard P.S. You can't get one of these RJ45 loopback connectors commercially, I don't think, but I can send you directions - or make one for you if you send me a tenner! -smile- RT -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
