forum

Quick fixes

Playing with pgedit some more... I'm using the Mac version.

* Could you fix the "Do you want to save changes to..." dialog so the buttons have the standard Mac labels and ordering: Don't save, Cancel, Save.

* \d doesn't work. In psql, \d will display a list of all tables, views, and so forth. Instead, pgedit says "ERROR: relation "pg_catalog.pg_roles" does not exist"

* As I scroll through the output using the arrow keys or my scroll wheel, the scrollbar changes size. Kind of reminds me of that stretchy goo I used to play with as a kid. :)

* Would it be possible to add icons for the various Execute methods it the toolbar? Or at least make them available in the Customize Toolbar palette.

Feature request: interleave SQL with output

I teach an SQL class at a community college. We use PostgreSQL as the database for the learning. The students have always used the Unix command line to access the database. For me, it's an excellent pedagogical tool.

* Everyone can use it, no matter if they have Mac, Windows, or Linux. All they need is an SSH app.
* There's no hand-holding. No query builders. No table builders. The students must write their own SQL.
* Easy to import data using the \copy command.
* Easy to copy-and-paste the output for hard copy. I have the students do a dozen or so queries per assignment. They turn in a printout showing the query they typed followed by the first few lines of output to show that it worked. In a terminal window, they just copy-and-paste into a text editor such as Notepad or TextEdit.

Forum fixed

Bad management on my part for not looking at the logs more closely. There was a bug in Drupal which prevented most users from posting new topics to the forum. Really, it was only partially Drupal's fault. The rest of the blame goes to MySQL for accepting an empty string as an acceptable input for the integer zero. PostgreSQL was rightly not accepting it.

Welcome

Welcome to the pgEdit forum. Topics open for discussion include pgEdit design, development, support, and feature requests. Anything about pgEdit is fair game :)