postgres table query not getting all names

Dr. Hawkins dochawk at gmail.com
Sat Jul 15 00:48:39 CEST 2017


Sometime  ago, I wrote my own getTableNames() because
revDatabaseTableNames() would consistently fail to find them all.

Now, it to is filing.

It is, in essence,

*put* "SELECT table_name FROM information_schema.tables ;" \

& cr into dcmd

*put* revDataFromQuery(,cr,db,dcmd) into tabList

*return* tabList

I have another chunk of code which is now acting up:

*put* getTableNames(dhbkSrvrDb) into dhSrvTbls

*put* "dhStatTbl" into dhtbl_stat

*if* dhtbl_stat is not among the words of dhSrvTbls *then*

*put* "CREATE TABLE " & dhtbl_stat  . . . blah blah blah


table dhStatTbl already exists, yet the conditional is reached.  It
executes, and throws an error because this table is already there.


This is, to be mild, a brutal bug.

Might there be something I'm missing?

-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462


More information about the use-livecode mailing list