Re: [pgadmin-hackers] find object database form
-Original Message- From: frank_lupo [mailto:[EMAIL PROTECTED]] Sent: 31 January 2003 11:13 To: pgadmin-hackers Subject: [pgadmin-hackers] find object database form I developed a find object database Hi Frank, This is a nice addition to pgAdmin, thanks. There are a couple of changes that would make it better before I add it however: - It is not clear that the comment and sql boxes filter the pre-existing results. It would make more sense for empty fields to be ignored, so you could search just on comment for example. - An option to search for objects with a given OID would be very useful. This would probably work well as a plugin, rather than built into pgAdmin. I might do that myself if you have no objections? Thanks again, Dave. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-hackers] find object database form
-Original Message- From: frank_lupo [mailto:[EMAIL PROTECTED]] Sent: 31 January 2003 11:13 To: pgadmin-hackers Subject: [pgadmin-hackers] find object database form I developed a find object database Hi Frank, This is a nice addition to pgAdmin, thanks. There are a couple of changes that would make it better before I add it however: - It is not clear that the comment and sql boxes filter the pre-existing results. It would make more sense for empty fields to be ignored, so you could search just on comment for example. - An option to search for objects with a given OID would be very useful. This would probably work well as a plugin, rather than built into pgAdmin. I might do that myself if you have no objections? Thanks again, Dave. --- - ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] The option find are in AND (name and comment and sql). If precedente filter is clear the filter is not active. It is not possible to create plugin, because it does not come passed to plugin the reference of all the PgAdmin application, this serves in order to visualize the detail of the object in the listview (event doubleclick). Bye !! Frank Lupo (Wolf) !! /\_ _/\ \ o o / --ooo-ooo--- -- Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f Sponsor: Cerchi l'Eldorado? Entra nella miniera d'oro più ricca del web!!! Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=611d=3-2 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-hackers] find object database form
-Original Message- From: frank_lupo [mailto:[EMAIL PROTECTED]] Sent: 03 February 2003 11:38 To: Dave Page Cc: pgadmin-hackers Subject: Re: [pgadmin-hackers] find object database form The option find are in AND (name and comment and sql). If precedente filter is clear the filter is not active. I couldn't get it to work. I have a table called st_blacklist, with a comment of 'Spamtrap blacklist'. If I search for st_blacklist, it finds the table and a sequence called st_blacklist_st_id_seq. If I add the word 'Spam' to the comment field, I find nothing. If I have only Spam in the comment field I find nothing. It is not possible to create plugin, because it does not come passed to plugin the reference of all the PgAdmin application, this serves in order to visualize the detail of the object in the listview (event doubleclick). Ahh yes, I see. That makes sense. Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[pgadmin-hackers] Editing data.
It seems that while you're editing data, it tries to do an update for all the records matching the first field. This is not what I want at all. The primary key exists of 3 fields, and mostly the first field is the same. Could it be made so that it uses the fields of the primary keys instead of just the first field? Or use the old data if no primary key is available ... Also, I'd like to be able to set a record to NULL in it. Kurt ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-hackers] Editing data.
-Original Message- From: Kurt Roeckx [mailto:[EMAIL PROTECTED]] Sent: 03 February 2003 20:00 To: [EMAIL PROTECTED] Subject: [pgadmin-hackers] Editing data. It seems that while you're editing data, it tries to do an update for all the records matching the first field. This is not what I want at all. The primary key exists of 3 fields, and mostly the first field is the same. Hi Kurt, pgAdmin doesn't blindly use the first field, it looks for a primary key, and if found, uses that, otherwise it builds a query based on the original values of all usable columns. It doesn't currently handle multipart primary keys, and in this case will try to use the first field of the key (not the first field overall). Could it be made so that it uses the fields of the primary keys instead of just the first field? Or use the old data if no primary key is available ... The fix is on the todo list. Also, I'd like to be able to set a record to NULL in it. This can't easily be done because we have no way to know that the user wants null as opposed to an empty string. Of course, it cannot be done for your primary key columns anyway. Regards, Dave. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [pgadmin-hackers] Editing data.
On Mon, Feb 03, 2003 at 10:02:26PM -, Dave Page wrote: Could it be made so that it uses the fields of the primary keys instead of just the first field? Or use the old data if no primary key is available ... The fix is on the todo list. Thanks. Also, I'd like to be able to set a record to NULL in it. This can't easily be done because we have no way to know that the user wants null as opposed to an empty string. Of course, it cannot be done for your primary key columns anyway. Just a button to set it to NULL would be nice, don't try to guess what the user wants. Kurt ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] Editing data.
This can't easily be done because we have no way to know that the user wants null as opposed to an empty string. Of course, it cannot be done for your primary key columns anyway. How about adding a right mouse button menu for the field with an option 'SET NULL'. Display it grey'd out or something... -- Rod Taylor [EMAIL PROTECTED] PGP Key: http://www.rbt.ca/rbtpub.asc signature.asc Description: This is a digitally signed message part
