Bruce Momjian <[EMAIL PROTECTED]> writes:
> !             "WHERE  n.nspname NOT LIKE 'pg_temp_%%' OR\n"

You forgot that '_' is a special character for LIKE.  You need some
backslashes there (4 apiece, I think).

Also, there had better be parentheses around the whole OR clause;
else I'm not sure that the precedence will work correctly if
processNamePattern plasters an AND phrase after this.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to