Re: [GENERAL] SQL Standards Compliance With Case

2006-07-13 Thread Scott Marlowe
On Wed, 2006-07-12 at 22:26, Tom Lane wrote: > Rich Shepard <[EMAIL PROTECTED]> writes: > >I'm trying to assist the XRMS developers port their application to > > postgres (8.1.x on), and it's almost there. One (perhaps the only) stumbling > > block is case for table and column (relation and att

Re: [GENERAL] SQL Standards Compliance With Case

2006-07-12 Thread Rich Shepard
On Wed, 12 Jul 2006, Tom Lane wrote: It's probably worth pointing out here that the MySQL behavior they seem to be expecting is considerably further from the spec than Postgres's behavior. If I'm reading between the lines correctly, they are expecting foo and Foo (both written without double-qu

Re: [GENERAL] SQL Standards Compliance With Case

2006-07-12 Thread Tom Lane
Rich Shepard <[EMAIL PROTECTED]> writes: >I'm trying to assist the XRMS developers port their application to > postgres (8.1.x on), and it's almost there. One (perhaps the only) stumbling > block is case for table and column (relation and attribute) names. > Apparently MySQL allows for mixed ca

Re: [GENERAL] SQL Standards Compliance With Case

2006-07-12 Thread Rich Shepard
On Wed, 12 Jul 2006, Joshua D. Drake wrote: Likley, not ever ;)... Hi, Josh! That's fine with me. As long as postgres works, I'm happy. ERROR: relation "role_id" already exists AHA! I see what is happening... you can't have an index name the same as a table name. Tell them just to chang

Re: [GENERAL] SQL Standards Compliance With Case

2006-07-12 Thread Stephan Szabo
On Wed, 12 Jul 2006, Rich Shepard wrote: >I'm trying to assist the XRMS developers port their application to > postgres (8.1.x on), and it's almost there. One (perhaps the only) stumbling > block is case for table and column (relation and attribute) names. > Apparently MySQL allows for mixed c

Re: [GENERAL] SQL Standards Compliance With Case

2006-07-12 Thread Joshua D. Drake
On Wednesday 12 July 2006 17:33, Rich Shepard wrote: >I'm trying to assist the XRMS developers port their application to > postgres (8.1.x on), and it's almost there. One (perhaps the only) > stumbling block is case for table and column (relation and attribute) > names. Apparently MySQL allows

[GENERAL] SQL Standards Compliance With Case

2006-07-12 Thread Rich Shepard
I'm trying to assist the XRMS developers port their application to postgres (8.1.x on), and it's almost there. One (perhaps the only) stumbling block is case for table and column (relation and attribute) names. Apparently MySQL allows for mixed case, while postgres wants only lower case. One of