[BUGS] BUG #7786: select from view is computing columns not selected
The following bug has been logged on the website: Bug reference: 7786 Logged by: Douglas Toltzman Email address: d...@oakstreetsoftware.com PostgreSQL version: 9.2.2 Operating system: Linux CentOS Description: in the interest of simplicity, I've got a view that calls a stored procedure to compute a value ... create view testv as select tt.field1, tt.intfield, compute_val(tt.field1) AS compute1 from tt; If compute_val() selects sum(intfield) from the testv view, compute_val() is called again when selecting records from testv (even though compute1 was not selected), resulting in infinite recursion (stack overflow). In retrospect, I realize this may have been a bad thing to do, but it worked in version 8.1.x. I recently upgraded to 9.2.2 and I had to create a 2nd view that didn't include the computed values, so I could use that view in the stored procedures. It seems like a performance problem to compute all columns in a view when selecting only specific columns. I've already fixed my stack overflow, so I'll let you decide if this is a bug or a feature. If you're interested in reproducing this and you don't understand my description, I'd be happy to provide a test case. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #3678: Folder Windows Don't Open Properly
The following bug has been logged online: Bug reference: 3678 Logged by: Doug Bedell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Mac OSX 10.4.10 Description:Folder Windows Don't Open Properly Details: Just downloaded 8.2.5. Attempting to look through it, when I open a folder, such as "Client," it snaps to the side of the desktop with only the edge showing. When I attempt to pull it back, if the cursor is on the edge of an icon in the folder, it destructs it, with the Mac "cloud" appearing as when you move something from the Dock to the trash. The first time this happened, when I clicked on the disk image to open a new one, it didn't work. I have now downloaded 8.2.5 for the third time, and this last disk image appears to be working. But what about these "snappy" folders? Also, can I use my laptop, or a 16 gig external hard drive I have, as a server? Can I load the Client and Server folders on the same machine (assuming they are accessible and working)? ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[BUGS] BUG #2226: Can't delete elements from Enterprise Architect diagram when using PostgreSQL ANSI ODBC driver
The following bug has been logged online: Bug reference: 2226 Logged by: Doug Scott Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows XP Pro Description:Can't delete elements from Enterprise Architect diagram when using PostgreSQL ANSI ODBC driver Details: Sparx, makers of EA, allows many DBMSs such as Postgres DBMS to be a backend repository for this UML modeling tool. PostgreSQl ANSI ODBC driver found in file psqlodbc-08_01_0102.zip does not permit diagram elements in Enterprise Architect (v. 6.1) to be deleted. Adds, updates work, but deletes do not. Get msg "Enterprise Architect has encountered a problem and will close now." when attempt to delete elements (eg. classes, activities) from a UML (eg. class, activity) model. When version found in psqlodbc-08_00_0101.zip was used instead, deletes worked fine. ---(end of broadcast)--- TIP 1: 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
