DevHeads.net

Database

Watch 2012 Northern Trust Open Live Online TV Stream golf

Watch 2012 Northern Trust Open Live Online TV Stream golf
2012 0Northern Trust Open
Match Scheduled 16-19th February 2012
Pacific Palisades, California
Purse: $6,600,000
PGA Tour
when will start 2012 Northern Trust Open Live streaming online tv golf match.It will be held on 16th February 2012 and end 19th February 2012.And how can watch 2012 Northern Trust Open online streaming live match.In the world 2012 Northern Trust Open golf streaming PGA Tour are famous to all golf faners.
2012 Northern Trust Open Live Online

Watch Porto vs Manchester City Live Stream Free Soccer Online

Watch Porto vs Manchester City Live Stream Free Soccer Online
Porto vs Manchester City
Match Scheduled 16-02-2012 from 3:05pm (US/Eastern)
Location Estádio Do Dragão (Porto)
UEFA Europa League
Porto vs Manchester City team are known to all soccer faners in the world.UEFA Europa League live streaming soccer match Porto vs Manchester City match is very exciting.
Watch Porto vs Manchester City Live

<a href="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/" title="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/">http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stre...</a>

^^**wAtcH^^**Aston Villa vs Manchester City Live Stream Soccer Online February 12, 2012

wAtcH Barclays Premier League between Aston Villa vs Manchester City live stream
Are you looking for Aston Villa vs Manchester City Free live streaming link? Then you have come to the correct place. You can watch a live online stream of Aston Villa vs Manchester City right here. The is no need to look anywhere else. The links for the event appear above.

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

<a href="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html" title="http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs-manchester-city.html">http://sports-soccerliveonline.blogspot.com/2012/02/watch-aston-villa-vs...</a>

Rule module implementation Bug problem

Hi Dear,
I have a doubt regarding following procedure , it work fine in Article but not
in "Page" creation (I mean the link is not proper), please help me with a
solution , pls follow the steps and try to create an article and basic page
and click the status link , you got my problem .

To display an 'Add More [Content_type]' link after user saves new content, do the following:

1. Go to admin/config/workflow/rules
2. Click Add New Rule
3. At admin/config/workflow/rules/reaction/add, give your new Rule a name, something like

'Add more content link'

Config documentation about PROTOCOL=

The documentation of the PROTOCOL=<value> option in config.html seems out
of sync with the current driver behavior (since 09.05.0100).

As I interpret the code and according to my tests, the driver ignores
anything in <value> before a dash and if there is a dash, then the
following number, parsed via atoi(), is used as the rollback_on_error
setting. Even when using SSL.

This discrepancy has recently caused confusion in a customer project, so I
would like to fix the documentation.

Is the config.html file generated? If so where is the actual source?

Thanks, Jan

Build the PostgreSQL ODBC Driver on Windows

hi developer:
I build the PostgreSQL ODBC Driver on Windows10 X64,but have some trouble.
I download psqlodbc-09.05.0400 to build it with Microsoft Visual Studio 2010.
I use following two methods to build.
1.Use NMAKE.exe to build the driver.
The following error:
Building the PostgreSQL ANSI 3.0 Driver for ...

Using PostgreSQL Include directory: C:\Program Files (x86)\PostgreSQL\9.5\include
Using PostgreSQL Library directory: C:\Program Files (x86)\PostgreSQL\9.5\lib
cd installer && "C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\BIN\nmake.exe" -f installer.mak CFG=Release

Upscene releases Database Workbench 5.3.2

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

“ Database Workbench 5.3.2 “

This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packages and adds several other features.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

"Version 5 included many new features", says Martijn Tonies, founder of Up

more bugs with returning 0 for malloc(0)

Hello, psqlODBC team.

I'm reporting a bug.
This simular to the following bug.

<a href="https://git.postgresql.org/gitweb/?p=psqlodbc.git;a=commit;h=ae12eef5ccb754d1cd9a4f12e8e88e56e0497bc2" title="https://git.postgresql.org/gitweb/?p=psqlodbc.git;a=commit;h=ae12eef5ccb754d1cd9a4f12e8e88e56e0497bc2">https://git.postgresql.org/gitweb/?p=psqlodbc.git;a=commit;h=ae12eef5ccb...</a>

Some codes consider it error when zero size malloc/calloc return NULL.
I think we should add zero size check codes there.

columninfo.c: CI_read_fields_from_pgres(), CI_set_num_fkields()
convert.c: QB_initialize_copy()
bind.c: create_empty_bindings()
bind.c: create_empty_gdata()

Unexpected SQL execution failures reported on AIX with the latest psqlodbc.

mylog:
[1]about to begin SC_execute
[1]libpq_bind_and

Fail to install psqlodbc due to libpq version incorrect

Hi,

I failed to install psqlodbc on AIX 7.1 (64-bit) since it requires libpq > 9.2 version.
I checked there is libpq in my AIX but I have no idea what the version is and how to upgrade it.

Indeed I need the odbc driver to connect from Oracle -> Oracle Gateway -> unixODBC -> PostgreSQL.
However the driver in unixODBC is too old and so I would like to try psqlodbc.

Hope you can help.

Many thanks,
Joe

This message and any attachment are confidential and it may be a criminal offence for you to disclose or use them without authority.

Mroonga 7.04 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.04 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

Version “psqlodbc_09_06_0300-x64” & “psqlodbc_09_06_0310-x64” not working on Windows system

Hi,

First of all thank you for making this available for the public

Possible sslmode values

Hi,

I'm trying to figure out what the possible values for the sslmode option for psqlODBC are. Are the options for libpq (<a href="https://www.postgresql.org/docs/9.3/static/libpq-ssl.html" title="https://www.postgresql.org/docs/9.3/static/libpq-ssl.html">https://www.postgresql.org/docs/9.3/static/libpq-ssl.html</a>) the same options that may be used with psqlODBC?

Best regards

Re: Something strange here...

2017/06/13 17:42 ... Chris Knipe:

Performance degradation after drop table

Hello list,

I come here with a case I can say very strange.

I explain, we have a db server with mysql version 5.5.49 on debian
jessie. Some
days ago, our workflow allowed us to purge a large table from one of our
db
servers. By large I mean a table which had 350GB in size.

To purge that table, I displayed the table configuration (show create
table
tblname), then dropped that table and recreated it with the informations
from
the show create table command.

UseServerSidePrepare not working on aix

I'm getting an error like the connection was dropped trying to read data.

ERROR: CLI open cursor error: Could not receive the response, communication
down ??

9.6.031 driver using 9.4.12 libpq.

I have to turn off UseServerSidePrepare to get a successful read.

Anyone run into anything like this? I wondering/hoping if it is something simple like a configure option or something at build time.

Thanks,
Keith

QxOrm 1.4.4 and QxEntityEditor 1.2.2 released : boost dependency fully removed (replaced by C++11 features)

Hello,

*QxOrm library 1.4.4* and *QxEntityEditor application 1.2.2* just released (
<a href="http://www.qxorm.com/" title="http://www.qxorm.com/">http://www.qxorm.com/</a>) !

QxOrm library doesn't depend on boost framework anymore (the boost
dependency has been fully removed, replaced by some C++11 features).
So QxOrm library is now a pure Qt library which depends only on QtCore and
QtSql by default.
For backward compatibility, QxOrm library still supports some boost classes
(boost smart-pointers, unordered containers, boost::optional, etc...) : you
have to define _QX_ENABLE_BOOST compilation option to enable these features.

Main advantages are :
- QxOrm

Buy real and fake passports,drivers license,ID cards,birth certificates,Visas,SSN,divorce papers,US

Buy Real fake Documents with Best Quality Novelty real and Fake IDs and
Passports,Marriage certificates
and Drivers license etc buy now high quality-We have the best HOLOGRAMS AND
DUPLICATING MACHINES With over 13million of out documents circulating over
the world.

GSS from windows

Hi there,
I attempted to enable GSS to get authentication against my Linux server by
selecting 'use gssapi for GSS request' in the DSN configuration dialog and
then ran a query using the DSN. It gives an error - 'invalid connection
option "gsslib"'. Looking into it a bit further it looks like Libpq is
compiled without GSS. What would you suggest?
Thanks and regards
Matt

Update

Hello,

We are using psqlodbc to update a Postgresql database from embedded sql
for cobol.
We have a strange behaviour : the first time we update, the update is
correct (sqlcode 0).

Mroonga 7.03 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.03 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

odbc

Which of the pgodbc drivers should I use with delphi 5?

thanks

Which choice of mysql??

I am learning Java and I'd like to use MySQL to create, delete and
update databases using Java. I have done this with C++ SQLite, but now,
as I said, I want to port my code to Java [not easy for a Java nubby].
However, the MySQL installer [mysql-installer-web-community-5.7.18.1]
has several choices of which I am not familiar. I don't use MS-Office at
all, I use OpenOffice, so, when at the "Choosing a Setup Type" window,
'Developer Default' requires some MS products I do not have.

MySQL for Excel 1.3.7 has been released

Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the
release of MySQL for Excel version 1.3.7. This is a maintenance
release for 1.3.x. It can be used for production environments.

MySQL for Excel is an application plug-in enabling data analysts
to very easily access and manipulate MySQL data within Microsoft
Excel.

Need help to choose which ODBC driver to use

Hi,

I am quite new to PostgreSQL and I need some help to choose the ODBC driver
to install on a new 64bit SQL server 2014 standard. It is on a Windows
Server 2012 R2 OS that is recently set up.

I need to set up a ODBC Data Sources and link server on the SQL server to
query data on a 64bit PostgreSQL 9.4.5 server. The PostgreSQL is on a 64bit
Windows Server 2008 R2 Enterprise OS.

I go to this link
<a href="https://www.postgresql.org/ftp/odbc/versions/msi/" title="https://www.postgresql.org/ftp/odbc/versions/msi/">https://www.postgresql.org/ftp/odbc/versions/msi/</a>

and download psqlodbc_09_06_0310-x64.zip

and install it on the SQL server.

restore from Mysql Administrator

I have an SQL file from a Mysql Administrator backup. Database and tables are
encoded in latin1, but the sql file is encoded in utf-8. Fine so far.

However, some varchars have been hexdumped, and strings have been converted to
utf-8 before these hexdumps.

mysqld_multi

I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an aging 5.1 system running on RHEL 5. We run mysqld_multi with multiple instances, each database on its own TCP Port 33xx. I'm having trouble creating a database on the new server in a multi environment.

Can anyone provide a simple example of how to edit /etc/my.cnf file and command line steps necessary for creating a new database running on, for example, port 3311?

Thanks in advance.

matthew

myodbc broken & removed from ubuntu 16.04

I'm trying to install freepbx/asterisk, which has myodbc as a
dependency. ubuntu 16.04

After trying unsuccessfully to pull it from the repos I found these
comments:

*summary*: - myodbc uses internal libmysqlclient functions no longer
exported by 5.7
+ Please remove myodbc from the archive

Remove myodbc:
The package has not been maintained in a while, and there are no
hard dependencies on it.

Network throughput for mysql replication

Hi Guys

I am once again having a weird issue...

MySQL Connector/C++ 1.1.9 has been released

Dear MySQL Users,

A new GA (general availability) version of MySQL Connector/C++ has
been made available: MySQL Connector/C++ 1.1.9 GA. The MySQL
Connector/C++ provides a C++ API for connecting client applications to
the MySQL Server 5.5 or newer.

You can download the production release at:

<a href="http://dev.mysql.com/downloads/connector/cpp/1.1.html" title="http://dev.mysql.com/downloads/connector/cpp/1.1.html">http://dev.mysql.com/downloads/connector/cpp/1.1.html</a>

MySQL Connector C++ (Commercial) will be available for download on the
My Oracle Support (MOS) website.

psqlODBC 09.06.0310 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 09.06.0310.
this is a bugfix release which crashes in MSAccess used by Windows.
please see the notes at:
<a href="https://odbc.postgresql.org/docs/release.html" title="https://odbc.postgresql.org/docs/release.html">https://odbc.postgresql.org/docs/release.html</a>

psqlODBC may be downloaded from in source, Windows Installer,
merge module, and basic zip file formats.

New Windows installer installs both 32-bit and 64-bit driver at once
on 64-bit OS.

Issue with psqlodbc and MSACCESS

Hello

I have done a test upgrade of psqlodbc to 9.6.300 running on Windows 10 and I now find my Microsoft access database which is using it crashes as soon as it tries to use the odbc connection.

The PostgreSQL database version is 9.4.11

I have enable the mylog driver option but do not get a mylog_????.log file created

I have pasted an error that is the event log related to the issue

Faulting application name: MSACCESS.EXE, version: 16.0.7668.2074, time stamp: 0x588def7a
Faulting module name: psqlodbc35w.dll, version: 9.6.3.0, time stamp: 0x590f2975
Exception code: 0xc0000005
Fault offset

Ssd vs mix of ssd and spinning disk

Hello,
We have traditionally setup our mysql database servers with a mix of ssd and spinning disk drives.

We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the spinning disks (15 sas in Raid-1) for the index data, etc.

I am wondering if going forward we should simply put all of the data on the ssd drives.

tcmalloc mysql 5.7.14

Hi Guys

I hope this mail finds everyone well.

We are having an issue with memory allocations on mysql 5.7.14 whereby
mysql is not releasing the memory that is being allocated during
mysqldump processes.

This has been logged as a bug with mysql dev team however they do not
see this as a bug and suggested we test using another malloc library
such as tcmalloc.

However from what I can see, this is no longer included in mysql 5.7
and thus I am trying to find out if anyone can tell me how to enable /
install this and how to tell mysql to use this library.

I need to do some tes

psqlODBC 09.06.0300 Released

Hi, all.

We are release of psqlODBC 09.06.0300. this is a some bugfix release.
please see the notes at:
<a href="https://odbc.postgresql.org/docs/release.html" title="https://odbc.postgresql.org/docs/release.html">https://odbc.postgresql.org/docs/release.html</a>

psqlODBC may be downloaded from in source, Windows Installer,
merge module, and basic zip file formats.

New Windows installer installs both 32-bit and 64-bit driver at once
on 64-bit OS.

SQL_QUERY_TIMEOUT

Hi,

I found that in psqlODBC 09.05.0300 Release was implemented
SQL_QUERY_TIMEOUT.
How it works?
I need to set up odbc connection in Debian, that send me error(disconnet
dead connection) after defined time, but I can`t find how can I setup
SQL_QUERY_TIMEOUT in odbc.ini.
I have installed latest odbc driver(09.06.0200)

Regards

PostgreSQL, and ODBC statement handles

I am running a benchmark (TPCx-V) with a single process on the client system handing all the load. Each connection to the server is in a separate thread with its own connection to PGSQL, and its own connection handle and statement handle. I am facing a contention problem with ODBC on the client side. strace and perf top show we are serializing over what appears to be accesses to the ODBC statement handlepgsq.

Error 1837

Hi,

On a fresh new master-slave very simple setup with just a Magento 1.5 DB
under MySQL 5.6.35, I'm getting this error with a memory table:

2017-05-03 07:08:37 1109 [Note] Slave I/O thread: connected to master
' ... at 10 dot 0.15.183:3306',replication started in log 'FIRST' at
position 4
2017-05-03 11:38:18 1109 [ERROR] Slave SQL: Error 'When
@@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a
different value after a COMMIT or ROLLBACK. Please check GTID_NEXT
variable manual page for detailed explanation.

MySQL Community Server 5.5.56 has been released

Dear MySQL users,

MySQL Server 5.5.56 is a new version of the 5.5 production release
of the world's most popular open source database. MySQL 5.5.56 is
recommended for use on production systems.

Binary packages for MySQL 5.5.56 are identical to those for MySQL 5.5.55,
except for the version number. The change in 5.5.56 for Bug #25942414 is
applicable only to those who build from source.

MySQL 5.5 includes several high-impact enhancements to improve the
performance and scalability of the MySQL Database, taking advantage of
the latest multi-CPU and multi-core hardware and operating systems.

MySQL Connector/ODBC 5.3.8 has been released

Dear MySQL users,

MySQL Connector/ODBC 5.3.8, a new version of the ODBC driver for
the MySQL database management system, has been released.

The available downloads include both a Unicode driver and an ANSI
driver based on the same modern codebase. Please select the driver type
you need based on the type of your application - Unicode or ANSI.
Server-side prepared statements are enabled by default. It is suitable
for use with any MySQL version from 5.5.

This is the fourth release of the MySQL ODBC driver conforming to the
ODBC 3.8 specification.

Mroonga 7.02 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 7.02 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready.

MySQL Connector/J 5.1.42 has been released

Dear MySQL Users,

MySQL Connector/J 5.1.42, a maintenance release of the production 5.1
branch has been released. Connector/J is the Type-IV pure-Java JDBC
driver for MySQL.

MySQL Connector Java is available in source and binary form from the
Connector/J download pages at
<a href="http://dev.mysql.com/downloads/connector/j/5.1.html" title="http://dev.mysql.com/downloads/connector/j/5.1.html">http://dev.mysql.com/downloads/connector/j/5.1.html</a>
and mirror sites as well as Maven-2 repositories.

MySQL Connector Java (Commercial) is already available for download on the
My Oracle Support (MOS) website.

Re: Can not add foreign key constraint

Hello,

Here's the create table sand error message.

root@localhost [(none)]> use mail;
Database changed
root@localhost [mail]> CREATE TABLE IF NOT EXISTS `lastauth` (
-> `user` varchar(40) NOT NULL,
-> `remote_ip` varchar(18) NOT NULL,
-> `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP,
-> PRIMARY KEY (`user`),
-> FOREIGN KEY (user) REFERENCES virtual_users(user) ON DELETE CASCADE
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ERROR 1215 (HY000): Cannot add foreign key constraint

For the table it's referencing

Can not add foreign key constraints

Hello,

I'm trying to add a table to an existing database. I'm wanting it to get
one of it's fields from an already existing table. I've done this
before in this database.

Handling the case where character conversion fails

Hello,

I think the attached patch is necessary to handle the case where msgtowstr() fails to convert the character data. Could you check this?

Regards
Takayuki Tsunakawa

behavior and documents conflict for SELECT LAST_INSERT_ID()

Dear friends,

1. <a href="https://bugs.mysql.com/bug.php?id=78934" title="https://bugs.mysql.com/bug.php?id=78934">https://bugs.mysql.com/bug.php?id=78934</a>

2.
<a href="https://dev.mysql.com/doc/refman/5.7/en/information-functions.html#function_last-insert-id" title="https://dev.mysql.com/doc/refman/5.7/en/information-functions.html#function_last-insert-id">https://dev.mysql.com/doc/refman/5.7/en/information-functions.html#funct...</a>

The document (2) says that LAST_INSERT_ID() will not be changed if no rows
are inserted successfully. But (1) says that it's undefined when no rows
are inserted successfully, which is in real case.

What is the problem? the document or the code?

Best Regards,
Chenxi Li

Upscene releases Database Workbench 5.3

Upscene Productions is proud to announce the availability of
the next version of the popular multi-DBMS development tool:

" Database Workbench 5.3 "

This release includes a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3 Stored Functions and Packges and adds several other features.

Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you!

"Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions.

Re: [ODBC] Problem with postgres 9.6 ODBC drivers

Team,

Can you please help us on this, as we were not able to continue our further testing with 09.06 Windows ODBC drivers.

Thanks,
Jegan

Hi Postgres ODBC team,

Our application is failing with the latest windows odbc (postgres) drivers, because it's not updating sequence table at al.
So we will always get the same id when we try to create any new object, ending up in unique constraint violation error.
Debugged postgres odbc driver code (<a href="https://ww" title="https://ww">https://ww</a>

DATETIME vs CHAR for "timestamp"

I have creation date/time fields in my script that are formatted as YYYY|MM|DD|hh|mm|ss. Short of changing the script, should I set the field type in MySQL to DATETIME, or would it be better in terms of speed and efficiency to set it as char(19)? Or would it not make a difference?

Thanks,
Frank

Server Closed the connection unexpectedly

Hello,
I downloaded odbc driver for mongodb from site("psqlodbc_09_06_0200-x64"), i try to connect to my mongodb server via this odbc server(on Windows) but the error which is attached screen shot this email
was occured. while this trying, i can see openned connection on my mongodb server.
I try to find solution on web forums, but I didn't find.

Could you help me for this situation?

Best Regards

Mehmet Keles

PGAPI_ProcedureColumns and no support for table output arguments

Hi Everyone,

While debugging the driver, I've noticed that there is no support for table output arguments (proargmodes = 't').

Is this intentional or is it a simple omission or even a bug?

Regards,
Matej Mihelič.

MySQL Shell 1.0.9 GA has been released

Dear MySQL Users,

This is the first GA version of MySQL Shell (a component of the MySQL
Server). The MySQL Shell is provided under Oracle's dual-license.

MySQL Shell is an interactive JavaScript, Python and SQL console
interface, supporting development and administration for the MySQL
Server.

MySQL Router 2.1.3 GA has been released

Dear MySQL users,

MySQL Router 2.1.3 GA is the first GA release for MySQL Router 2.1.

The MySQL Router is a new building block for high availability
solutions based on MySQL InnoDB clusters.

By taking advantage of the new Group Replication technology,
and combined with the MySQL Shell, InnoDB clusters provide an
integrated solution for high availability and scalability for
InnoDB based MySQL databases, that does not require advanced MySQL
expertise.

The deployment of applications with high availability requirements
is greatly simplified by MySQL Router.

Automated SQL checker?

Is there a way, perhaps with a script or a service, that one can check MySQL code to see about making it more efficient? I maintain an open source shopping cart written in Perl and it’s been awhile since the SQL has been worked on, so I want to see if it could use some updating.

Thanks,
Frank

<a href="http://www.surfshopcart.com" title="http://www.surfshopcart.com">http://www.surfshopcart.com</a>

MySQL Cluster 7.5.6 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geographic replication

- 99.999% High Availability with no single point of failure
and on-line maintenance
- NoSQL and SQL APIs (including C++, Java, http, Memcached
and JavaScript/Node.js)

MySQL Cluster 7.5.6, has been released and can be downloaded from

<a href="http://www.mysql.com/down" title="http://www.mysql.com/down">http://www.mysql.com/down</a>

Problem with postgres 9.6 ODBC drivers

Hi Postgres ODBC team,

Our application is failing with the latest windows odbc (postgres) drivers, because it's not updating sequence table at al.
So we will always get the same id when we try to create any new object, ending up in unique constraint violation error.
Debugged postgres odbc driver code (<a href="https://www.postgresql.org/ftp/odbc/versions/src/" title="https://www.postgresql.org/ftp/odbc/versions/src/">https://www.postgresql.org/ftp/odbc/versions/src/</a>) and found the below:

File: results.c
Method: static void KeySetSet(const TupleField *tuple, int num_fields, int num_key_fields, KeySet *keyset)
Problematic change: keyset->status = 0;

We will execute all queries with status 1024, now for some

MySQL Cluster 7.2.28 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:

- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geographic replication
- 99.999% High Availability with no single point of failure
and on-line maintenance
- NoSQL and SQL APIs (including C++, Java, http and Memcached)

MySQL Cluster 7.2.28, has been released and can be downloaded from

<a href="http://www.mysql.com/downloads/cluster/" title="http://www.mysql.com/downloads/cluster/">http://www.mysql.com/downloads/cluster/</a>

w

MySQL Community Server 8.0.1-dmr has been released (part 3/3)

[This is part 3 of the announcement]

* JSON: When a JSON value consisted of a large sub-document
wrapped in many levels of JSON arrays, objects, or both,
serialization of the JSON value sometimes required an
excessive amount time to complete. (Bug #23031146)

* JSON: When a NULL value existed in a JSON column, the
result from a query using GROUP_CONCAT() together with
the ORDER BY clause was not always correct.

MySQL Community Server 8.0.1-dmr has been released (part 2/3)

[ This is part 2 of the announcement ]

Functionality Added or Changed

* InnoDB: By default, InnoDB reads uncommitted data when
calculating statistics.

MySQL Community Server 8.0.1-dmr has been released (part 1/3)

Dear MySQL users,

MySQL Server 8.0.1-dmr (Milestone Release) is a new version of the world's
most popular open source database. This is the second public milestone
release of MySQL 8.0.

[Due to file size limitations, the announcement is split in 3
parts.

Syndicate content