On Sun, 2010-02-14 at 15:15 -0500, Tom Lane wrote: > Most obviously, we could also get an encoding > conversion failure on the notify condition name --- but we've never > enforced a character set restriction on that, and nobody's ever > complained about it AFAIR.
If the client successfully executed the LISTEN, then it could convert all of the characters in one direction. I suppose some incomplete conversion routine might not be able to convert the same characters in the other direction -- is that what you're referring to? The case of a condition name conversion error seems less problematic to me anyway, because it would happen every time; so there's no danger of making it through testing and then failing in production. > I'm now thinking that we should just drop that restriction. Ok. I'd feel a little better if I understood what would actually happen in the case of an error with NOTIFY. When does the client receive the error? Might the client code confuse it with an error for something synchronous, like a command execution? Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers