So to be clear, neither connections or cursors should be shared between threads. One thread per connection is mandatory now. This has been done for performance reasons, and to simplify the code. Rather than reading results from the server in batches, pg now always downloads them in one go. This avoids portal closed errors and makes things a bit quicker, but now one has to avoid downloading too many rows in a single query. Attempts to return something informative if the returned PostgreSQL timestamp value is outside the range of the Python datetime.
The cursor now has a context manager, so it can be used with the with keyword. Thanks to Ildar Musin. Thanks to vadv for the contribution. Fix warnings from PostgreSQL "not in a transaction", when calling. Thanks to jamadden for the contribution. It used to be that if the 'user' parameter to the connection function was 'None', then pg would try and look at environment variables to find a username.
Fixed bug where if a str is sent as a query parameter, and then with the same cursor an int is sent instead of a string, for the same query, then it fails.
Under Python 2, a str type is now sent 'as is', ie. Dropped and added support for Python versions. Now pg supports Python 2. Dropped and added support for PostgreSQL versions. Now pg supports PostgreSQL 9. We used to include it as a file in the pg source code. The reason for doing this is that package maintainers for OS distributions prefer unbundled libaries. Removed testing for PostgreSQL 9. If the server returns an error, we used to initialize the ProgramerException with just the first three fields of the error.
Now we initialize the ProgrammerException with all the fields. User and database names given as bytes. The user and database parameters of the connect function are now passed directly as bytes to the server. If the type of the parameter is unicode, pg converts it to bytes using the uft8 encoding. See the example in the Quickstart. Remove option to set a connection timeout. For communicating with the server, pg uses a file-like object using socket.
Remove the old pg DBAPI namespaces. For example, now only pg Parse server version string with LooseVersion. This should solve the problems that people have been having when using versions of PostgreSQL such as 9. Message if portal suspended in autocommit. Give a proper error message if the portal is suspended while in autocommit mode. The error is that the portal is closed when the transaction is closed, and so in autocommit mode the portal will be immediately closed.
Make executemany set rowcount. Previously, executemany would always set rowcount to Now we set it to a meaningful value if possible. If any of the statements have a -1 rowcount then then the rowcount for the executemany is -1, otherwise the executemany rowcount is the sum of the rowcounts of the individual statements.
Support for password authentication. Fixed bug in reporting unsupported authentication codes. Have a default for the user paramater of the connect function. Before PostgreSQL 8.
Until PostgreSQL 8. Remember prepared statements. Now prepared statements are never closed, and pg remembers which ones are on the server, and uses them when a query is repeated. For performance reasons, pg never closed portals explicitly, it just let the server close them at the end of the transaction. Fixed bug where unicode arrays failed under Python 2. This is in accordance with the protocol docs, and ensures the server sends back its responses straight away.
The PostgreSQL interval type is now mapped to datetime. Previously the PostgreSQL interval type was always mapped to the pg Interval type. However, to support the datetime. If months are needed then the fall-back is the pg Fixed bug in executemany where a new prepared statement should be created for each variation in the oids of the parameter sets. We used to ask the server for a description of the statement, and then ask for a description of each subsequent portal.
We now only ask for a description of the statement. Fixed warning in Python 3. Caching of prepared statements. This should speed things up significantly in most cases. Added support for the PostgreSQL inet type. Now the Python value datetime. Fixed a bug where 'portal does not exist' errors were being generated.
Some queries that should have been run in a transaction were run in autocommit mode and so any that suspended a portal had the portal immediately closed, because a portal can only exist within a transaction.
Removed warn calls for next and iter. Nonetheless, that theoretical bug is now fixed. Fixed a bug in cursor. Fixed a bug where with Python 2, a parameter with the value Decimal ' This has been fixed by sending decimal types as text rather than binary.
Fixed incompatibility with PostgreSQL 8. Everything functions, properties, classes is now available under the pg namespace.
So for example:. Use collections. This is O n for a list but O 1 for a deque. Return row as a list for better performance. At the moment result rows are turned into a tuple before being returned. Simplify the event loop. This follows the suggestion in the Postgres protocol docs. Using pre-compiled struct objects. Pre-compiled struct objects are a bit faster than using the struct functions directly. It also hopefully adds to the readability of the code.
Add facility for turning auto-commit on. This follows the suggestion of funkybob to fix the problem of not be able to execute a command such as 'create database' that must be executed outside a transaction.
Now you can do conn. Fix empty array issue. Fix scale on numeric types. Thanks to Gavin Sherry for the patch. Start transactions on execute or executemany, rather than immediately at the end of previous transaction. Thanks to Ben Moran for the patch. Thanks to Benjamin Schweizer for the patch. Thanks to Bob Ippolito for the original patch. Thanks again to Bob Ippolito for the original patch.
New support permits both sending and receiving these values. If a record type is received, it will be translated into a Python dict object. Fixed potential threading bug where the socket lock could be lost during error handling. Reading a timestamptz field results in a datetime.
Sending a datetime. Fix up open connection when an unexpected connection occurs, rather than leaving the connection in an unusable state. Fix CursorWrapper. Make interface. Cursor class use unnamed prepared statement that binds to parameter value types.
Separate pg There should be no need for a client to change how pg is imported. Fix bug in fetchmany dbapi method that did not properly deal with the end of result sets.
Add callback event handlers for server notices, notifications, and runtime configuration changes. Add types. Add support for parameter output types: NULL value, timestamp value, python long value. Add new error handling code and tests to make sure connection can recover from a database error. Fixed bug where timestamp types were not always returned in the same binary format from the PG backend.
Text format is now being used to send timestamps. Fixed bug where large packets from the server were not being read fully, due to socket. It was a lazy-coding bug. First public release. Although fully functional, this release is mostly lacking in production testing and in type support. Windows 11 Upgrade Guide. Machine was in very bad condition so I saved few parts. Looking at the motherboard specs at the link below, that motherboard should run W10 just fine without any BIOS updates necessary.
You should be able to determine the exact model PC the board is from by booting into the BIOS and on the system information window, there should be either the model of the PC or the product of the PC. Once you have that info, you can go to the support and driver page for the model PC the system board came from. Microsoft installs a WDDM driver during install that gives good video resolutions x or better but carries with it no acceleration or rendering for games. World of Warcraft runs great!
Hope this helps! Didn't find what you were looking for? Learn more. All titles streaming on HBO Max for 31 days from theatrical release. Movies and release dates subject to change. Dig into every season of the most obsession-worthy series, plus the legendary TV everyone still talks about. Cue up the biggest premieres of , plus timeless classics, quotable comedies, and action-packed adventures.
Stream thousands of hours of movies and series, starring your kids' favorite characters in new and classic adventures. Just click here and we'll guide you through it, and you'll be streaming HBO Max by the time your popcorn is ready. Click here for more info.
The following devices are supported by HBO Max. If a device is supported, you'll find the HBO Max app in the app store. Depending on your provider, you may be able to choose a subscription plan With Ads or Ad-Free and either monthly or annual billing.
Here are the plans:. Click here to learn more about plans. You can expect to see about 4 minutes of ads per hour. Click here to learn more about ads on HBO Max.
Weichai gas EIC protocol is updated with new data readings. EIC transmission rate stability is improved. PM compatibility: 1. Added support for Isuzu EIC protocol. Added new parameter "Not running delay". Can be used as a hysteresis if the running feedback unexpectedly falls under the running detection level. Added support for Kohler EIC protocol. Added four new M-Logic alarms with extended delay in menu Added Event log entry when the application setup changes. Added keyswitch for Diesel engine.
Added new controller type 'Engine Drive'. Changes: Default views for DG are changed. Fuel pump logic is available for Stand-alone and Core software versions. The SunSpec identifying information shown in the display is improved.
PV protocols are listed in alphabetic order in the display and the USW. Minimum timer for AC busbar alarms is decreased from 0. Text is changed in the shortcut menu. Corrections: Menu for GB close delay is no longer available when the application is power management.
Corrected that strange texts sometimes were shown in the USW log. Power factor set point on Modbus is now correctly initialized after power-up. Ph-ph voltage will not saturate before the hardware limit is reached. Correct behavior of dfdt is now ensured when the number of periods are set above If Sunspec initialization is not compatible, reinitialization starts in 20 seconds.
Corrections: Secured mode now works when Fuel optimisation is in use. Priority update now works when more than 16 gensets or more than 16 mains are present in a plant configuration. PMS priority data is properly maintained internally in all genset controllers.
0コメント