table_name syntax

[Mark Taylor]

Pat,

On Tue, 28 Apr 2015, Patrick Dowler wrote:

> PPS- tap-lint does a test where it quotes a column name it finds in a table in
> the tap_schema. I noted 2-4 query failures per day in our logs caused by this
> test. It broke because in postgresql it subverts the way case-insensitive
> table and column names are implemented (PG just converts everything to lower
> unless you quote them!). My "fix" was simply to strip the quotes in that case
> because I Know they can only break it. While the test is probably technically
> correct, it is really just asking for trouble :-)

hmm - my emerging understanding from this discussion is that
that taplint test is probably technically *incorrrect*,
and needs changing.  Can we have a ruling from Markus
(as our resident delimited-identifier-gotcha expert) on that?

--
Mark Taylor   Astronomical Programmer   Physics, Bristol University, UK
m.b.taylor at bris.ac.uk +44-117-9288776  http://www.star.bris.ac.uk/~mbt/