[HACKERS] case folding and postgres

2004-04-26 Thread emf
Hello, I have a project I'm moving from mysql to postgresql. It has both a fair amount of code and a moderate amount of data. In MySQL the identifiers are all MixedCase, but the query strings are never quoted. I would like to change the default behaviour of postgresql to not fold the case to lo

Re: [HACKERS] The case for preserving case.

2004-04-24 Thread emf
On Apr 24, 2004, at 11:17, Jan Wieck wrote: I don't think that we will break backward compatibility for existing PostgreSQL specific code in order to gain CamelCase+MySQL porting ease by adopting an even less standard compliant behaviour than we currently have. I understand and agree that breaki

Re: [HACKERS] The case for preserving case.

2004-04-24 Thread emf
On Apr 24, 2004, at 00:48, Tom Lane wrote: You do realize that any such patch would be at least a thousand times larger than that? I am coming from a state of ignorance past the fact that commenting out four lines of code appeared to create the behaviour I desired. I knew that just changing it to

[HACKERS] The case for preserving case.

2004-04-23 Thread emf
Hello, postgresql hackers. I am working with a client with a 20k record MySQL database (that will shortly expand to 100k/1m) and a few thousand lines of PHP code that does a lot of DB interaction. Their application, with a lot of relationships between data and a bunch of data integrity require