Bug report #252

query builder missing for PostGIS

Added by venturato-faunalia-it - about 14 years ago. Updated about 11 years ago.

Status:Closed
Priority:Low
Assignee:Marco Hugentobler
Category:Data Provider
Affected QGIS version: Regression?:No
Operating System:Debian Easy fix?:No
Pull Request or Patch supplied: Resolution:fixed
Crashes QGIS or corrupts data: Copied to github as #:10311

Description

The (very useful) query builder for PostGIS layers does no longer show operators and examples. Only textual SQL queries are now possible.
r5742

querybuilder.jpg (109 KB) venturato-faunalia-it -, 2006-08-31 11:47 PM

test-ticket-252.tar.gz - tiny test project (2.2 KB) Martin Dobias, 2006-12-03 12:10 PM

History

#1 Updated by Gavin Macaulay - about 14 years ago

It shows them for me. Can you attach a screenshot to illustrate?

#2 Updated by venturato-faunalia-it - about 14 years ago

Further testing: samples values are showed (correctly) when I choose the column name. Operators instead are not showed at all. I attached the screenshot.

#3 Updated by Gavin Macaulay - about 14 years ago

What version of qt is your version of qgis compiled against?

#4 Updated by venturato-faunalia-it - about 14 years ago

  1. On the box where QGIS was compiled:
    [email protected]:~$ dpkg --list | grep qt | grep dev
    ii libqt4-dev 4.1.4-1 Qt 4 development files
    ii qt4-dev-tools 4.1.4-1 Qt 4 development tools
  1. On the box running QGIS:
    [email protected]:~$ ldd $(which qgis) | grep -i qt
    libQtCore.so.4 => /usr/lib/libQtCore.so.4 (0xa7d3b000)
    libQt3Support.so.4 => /usr/lib/libQt3Support.so.4 (0xa7a51000)
    libQtGui.so.4 => /usr/lib/libQtGui.so.4 (0xa752c000)
    libQtNetwork.so.4 => /usr/lib/libQtNetwork.so.4 (0xa74d5000)
    libQtXml.so.4 => /usr/lib/libQtXml.so.4 (0xa7490000)
    libQtSvg.so.4 => /usr/lib/libQtSvg.so.4 (0xa744e000)
    libQtTest.so.4 => /usr/lib/libQtTest.so.4 (0xa743e000)
    libQtDesigner.so.4 => /usr/lib/libQtDesigner.so.4 (0xa72ca000)
    libQtSql.so.4 => /usr/lib/libQtSql.so.4 (0xa66b0000)

#5 Updated by Gavin Macaulay - about 14 years ago

Beats me. Is there anything you can do to the dialog box to make the operator appear? Could you try resizing the dialog box, etc?

#6 Updated by venturato-faunalia-it - about 14 years ago

I tried resizing, open/closing the dialog box but nothing appened.
I'm sorry.

#7 Updated by Martin Dobias about 14 years ago

The same dialog is used also for creating queries when searching in attribute table. Please could you check whether also there are missing buttons for operators?

#8 Updated by venturato-faunalia-it - about 14 years ago

Yes, it's the same.

#9 Updated by Redmine Admin almost 14 years ago

On the windows preview2 version it works as expected

#10 Updated by Gavin Macaulay - almost 14 years ago

Are they still missing when qgis is compiled against Qt 4.2.0?

#11 Updated by Redmine Admin almost 14 years ago

Don't know. On Debian testing we still have 4.1.4-1.1

#12 Updated by Martin Dobias almost 14 years ago

It seems that Debian has already Qt 4.2. Please could you retest?

Do you have a possibility to test on another computer to check whether it's a problem also somewhere else?

If you have still the same problem, could you try some older SVN revisions to help us find out where could be the problem?

Martin

#13 Updated by Martin Dobias almost 14 years ago

I've prepared a small project for testing. Download attached tarball (test-ticket-252.tar.gz) and extract it. In that directory try to run:

qmake
make
./test-ticket-252

(Make sure that you're using Qt4 qmake and that you have Qt4 development files)

When you run that compiled binary (test-ticket-252) you should get the postgis builder dialog. Please report whether the buttons are missing or not. If they're missing, the problem will be probably in UI file. If they're shown OK, we'll have to search for other sources of the problem.

#14 Updated by Redmine Admin almost 14 years ago

  • Status changed from Open to Closed
  • Resolution set to fixed

now it works (rev 6160)

#15 Updated by luca-casagrande-gmail-com - over 13 years ago

  • Resolution deleted (fixed)
  • Status changed from Closed to Feedback

This problem happen on both some gentoo machine and a debian one. I tried the test app,deleting 1 button and then recreate it and it's showed.
This problem disappear if use qt4.2.1 (at least on my machine).

#16 Updated by anonymous - over 13 years ago

AFAIK wgis requirers 4.2?

#17 Updated by Martin Dobias over 13 years ago

  • Resolution set to fixed
  • Status changed from Feedback to Closed

Should be fixed in 6483 (0.8 branch) and 6484 (trunk).

#18 Updated by Anonymous about 11 years ago

Milestone Version 0.8 deleted

Also available in: Atom PDF