Philip Yarra wrote:

>On Wed, 26 Oct 2005 08:52 pm, Andrew Sullivan wrote:
>  
>
>>It makes no difference if it's a corner case.  Slony is supposed to
>>provide generic support, which means we _have_ to support this.
>>    
>>
>
>Perhaps we mean different things by "corner case". I mean this:
>http://en.wikipedia.org/wiki/Corner_case
>
>As in, something we don't reasonably expect people to try to do. I think 
>creating table-names in the same DB in the same schema that are 
>differentiated only by the case of the name is unreasonable. 
>  
>
Sure, using case to distinguish between table names (or variable names,
or whatever) is a stupid thing to do.

But it's supported by the SQL standard, and for us to change Slony-I to
make it no longer support that standard would also not be a reasonable
thing to do.

>I'd be happy enough if the solution was simply to allow the perl tools to 
>generate usable output for the common case (and yes, maintain generic support 
>for people who really want account, ACCOUNT and aCcOuNt to describe three 
>different tables).
>  
>
What we'll probably have to do is to ensure the Perl tools quote the
names so that they support the case that you type in.

>>Right.  It appears to me that this is a documentation issue.
>>    
>>
>
>What do you plan to put in the documentation? "Warning: table-names may not be 
>recognised using the same names as you used in your SQL script to create 
>them." 
>  
>
Well, what do you think would help?

Jan once dropped the comment that he thought most of the documentation
was unnecessary because the way Slony-I behaves seemed pretty intuitive
to him.  He's the author, so his "intuition" actually represents "How I
implemented Slony-I" :-).

I have been pretty heavily involved for a long time, so my "intuition"
is, if not as authoritative as Jan's, comprehensive enough that I'd not
miss things the same way you would as a newcomer.

What should go into the documentation is whatever would help YOU, as
you're a relative newcomer, and it's newcomers that will get confused
about this.  Where would you have thought to try to look for this?  I'll
add it in where ever YOU think is preferable.