obadiah87 / dbkiss

Automatically exported from code.google.com/p/dbkiss
0 stars 0 forks source link

Error while searching database in PostgreSQL #2

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
"attributes" is a view in information schema and it shouldn't be searched when 
searching whole database for a keyword.

Error Message:
------------------------------------

Searching 132 tables for: produkt

Warning: pg_query(): Query failed: BŁĄD: kolumna "udt_catalog" nie istnieje 
LINE 1: SELECT COUNT(*) FROM attributes WHERE udt_catalog ILIKE '%pr... ^ in 
/var/www/ on line 538 Warning: pg_fetch_row() expects parameter 1 to be 
resource, boolean given in /var/www/ on line 649

Original issue reported on code.google.com by czarek.t...@gmail.com on 10 May 2012 at 10:35

GoogleCodeExporter commented 8 years ago
Version of dbkiss for which it was reported: 1.06

Original comment by czarek.t...@gmail.com on 10 May 2012 at 10:38

GoogleCodeExporter commented 8 years ago
Views shouldn't be searched at all, we already search through all tables and 
views just duplicate that data.

Original comment by czarek.t...@gmail.com on 11 May 2012 at 5:11