Re: Bug of PL/pgSQL parser

"eutm" <eutm@yandex.ru> writes:
>     Dear Sirs!:)I encounted one small problem,working with 
> PostgreSQL 7.3devel.It can look a
> bit strange,but i have to use whitespaces in names of databases,tables,fields
> and so on(like "roomno jk").It's possible to create them all and work with them
> (INSERT,DELETE,UPDATE),but PL/pgSQL parser(compiler ?) can't execute such 
> statements.

Yeah, this is a known bug: the plpgsql lexer doesn't really handle
quoted identifiers correctly.  (It effectively acts like double-quote
is just another letter, which of course falls down on cases like
embedded whitespace.)  If you have any experience with writing flex
rules, perhaps you'd care to submit a patch.
        regards, tom lane