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
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
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
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
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
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
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