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'

ODBC Driver 9->11, troubles with dates/NULL...

After long time, i've decided to upgrade ODBC driver from version 09.03.0100
to version 11.01.0000. A big jump, indeed.

I'm using an old application written in Centura, that with 09.03.0100
works as expected.

But with '11.01.0000' no.

Problem with DBLINK from Oracle to Postgresql

Good day,

We have problem with dblink from oracle to postgres
Oracle database 12.2 ptalform HP-UX Itanium
Oracle error
Error : ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
could not get socket error status: Invalid argument
{08001,NativeErr = 101}
ORA-02063: preceding 3 lines from PG1
I attached trace file from oracle

We use unixodbc 2.3.7 and psqlodbc.09.06.0500 (we tried to install almost all drivers with major version 9).
Also we have postgresql 9.4.8 installed on hpux for libpq.

Rockwell FactoryTalk Says 'SQL_TIMESTAMP data type is not supported'

Hi,

* your ODBC driver version

psqlODBC is v11.01.000.

SQL_DRIVER_ODBC_VER reports "3.51"

[6608-0.002] info.c[PGAPI_GetInfo]71: entering...fInfoType=77

[6608-0.002] info.c[PGAPI_GetInfo]1032: p='03.51', len=0, value=0, cbMax=12

* your PostgreSQL database version

v10.9 x86

Running on Windows 10 32-bit

* any error messages you saw on the screen

The client application (Rockwell FactoryTalk), has a button which can automatically create the tables in an existing database.
It created a table successfully that DID NOT have a TIMESTAMP column.

Driver Bug?

Team,

Not sure if this is a bug or known issue. When pulling back results from
GreenPlum into Business objects, some fields that are populated in GP are
coming back as null in BO. This seems to occur with the datatype Varying
Character. Is there a workaround?

Steve

ODBC Compatibility Question II

Hello,

please excuse my rather simple question, but since I have not found an
answer after a long search, I'll contact you.

My question is, if I can always use the latest ODBC driver with older
database server versions. For example, ODBC version 11 with DB Cluster 9.6?

Thanks

Dirk Lindner

Universitaet der Kuenste Berlin

Referat für Planung, Organisation und Datenverarbeitung

Einsteinufer 43-53, 10587 Berlin

( Tel.

Re: psqlodbc: No memory available to store statement

Hello Hiroshi,

I found a possible approach to overcome this issue.
It is necessary to explicitly specify the path to libpq.so library within
LD_LIBRARY_PATH environment variable before running the configure command.

In this case conftest program finds the desired libpq and in this case the
generated config.h file contains proper defines:
/* The size of `long', as computed by sizeof. */
#define SIZEOF_LONG 8

/* The size of `long int', as computed by sizeof. */
#define SIZEOF_LONG_INT 8

/* The size of `void *', as computed by sizeof.

Fwd: ODBC: SQLGetDescField returns incorrect length for SQL_DESC_COUNT field of APD

Forwarding to correct list ...

------- Forwarded Message

field of APD

Field SQL_DESC_COUNT should fit into a variable of type SQLSMALLINT. But
when retrieving this field of APD SQLGetDescField returns SQLINTEGER
value.

psqlodbc: No memory available to store statement

Hello PostgreSQL Community!

I widely use psqlodb driver with unixODBC manager on my SLES12 linux
machine.
Not very long ago I updated psqlodbc driver from 10.03.0000 to the
latest one 11.01.0000 .
I use unixODBC-2.3.6-7.9.1.x86_64 package installed from YAST setup and
configurational tool and configure, build, and install psqlodbc from the
source code in the same way as for psqlodbc 10.03.0000:

autoreconf -i
./configure --prefix=path_to_install --with-libpq=path_to_pg_config
--with-unixodbc=path_to_odbc_config
make
make install

In my program I use quite common ODBC functions to

configuration of psqlodbc and libpq

Hello!
I have a question.

I built and installed PostgreSQL on my system from the source code from
<a href="https://www.postgresql.org/ftp/source/" title="https://www.postgresql.org/ftp/source/">https://www.postgresql.org/ftp/source/</a> .
Moreover I built psqlodbc from the source code from
<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> .
So psqlodbcw.so library is specified as a Driver in my unixODBC
configuration.

But I have a problem. On the one hand all the PostgreSQL-related
libraries are located in /usr/lib directory. On the other hand libpq5 rpm
package is installed on my machine which locates its libraries in
/usr/lib64 directory.

Compatibility

Hi, ALL,
Is latest ODBC driver for PostreSQL can be run on Windows XP SP3?

If not - what version is compatible? Is it available to download?

Thank you.

PostGres ODBC -- Multiple ordinal parameters ?

PostGres ODBC team,

I'd like to start by thank you for the work that you've done on this
project.

For what it's worth, I'd been tasked by my work with migrating a reporting
server with extensive SSRS projects with PostGres queries using the ODBC
client.

I'm not sure if this is expected behavior or a bug, but I had noticed that
there's an issue in pulling prepared queries with multiple ordinal
parameters.

The old server we are using has the 9.03.03 drivers installed, and allows
multiple ordinal parameters to be passed to a PostGres ODBC prepared
statement ($1, $2, $3...) I confirmed this wi

psqlODBC 11.01.0000 Released

Hi, all.

We are pleased to annouce the release of psqlODBC 11.01.0000.
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.

New to PostgreSql - requires assistance

Good day

I am a VB6 programmer with plenty of MS Access Databasis and applications
and would like to start using PostGreSql instead.

I installed PostGreSql, pgAdmin4 and drivers - not sure if everything
required is now installed.

I successfullly created a database and table in PostgreSql, and now want to
start implimenting it in VB6.

My big problem now is the connection to the database from VB6.

SQLGetInfo

Looking at the code for SQLGetInfo, where it returns data indicating the driver capabilities with respect to the ODBC SQL syntax, it looks like the implementation is lacking.

Specifically, calls to SQL_NUMERIC_FUNCTIONS, SQL_TIMEDATE_FUNCTIONS and SQL_SYSTEM_FUNCTIONS all return 0, even though the convert_escape function in convert.c indicates support for almost all ODBC scalar functions.

Bound parameters in escaped functions

Hello,

I have found a bug in the translation of '?' parameters in escaped ODBC functions.

Where there is an escaped ODBC function within another, for example:

CASE WHEN {fn LENGTH({fn LTRIM(Name || ?))=?

Root certificate not found

Hi, I'm trying to connect Excel to a PostgreSQL table and I ran across the
psqlobdc file. When I attempt to setup the DSN it gives me this error "root
certificate file .../postgresql/root.crt" does not exist.

I'm using a .ca.cert file but your driver is looking for a root.crt file.

How can I setup this up?

Status of binary transmission vs. plaintext (resultFormat)?

Hi there,
using Wirekshark I noticed that UUIDs are transferred in plaintext
between the ODBC driver and the postgreSQL database. For me this is a
big deal since it uses twice as much data as the binary form (36 char
vs. 16 bytes).

I downloaded and analysed the ODBC sources and found that all calls to
PQexecParams and PQexecPrepare use '0' for the 'resultFormat'. IOW, the
ODBC driver explicitly requests all results in plaintext form as opposed
to the binary form.

Postgres 9.1 -> 9.4, ODBC timeout on complex query...

Recently we had a big move from postgres 9.1 to 9.4 on a database.

This database get, nightime, accessed via ODBC driver (version
9.00.02.00), rougly for one simple and long query (a full select on a
view with 1.6 million row).

After upgrading postgres, the system that do the query stop working.
Looking at server logs we see only:

2019-04-30 11:22:28 CEST [6490-4] hegos@sissi10 ISTRUZIONE: SELECT dw_accettazioni.id, dw_accettazioni.operatore_id, dw_accettazioni.data_competenza, dw_accettazioni.ora, dw_accettazioni.cod_fiscale, dw_accettazioni.id_prestazioni, dw_accettazioni.durata, dw_acc

MySQL Connector/ODBC 5.3.13 has been released

Dear MySQL users,

MySQL Connector/ODBC 5.3.13, 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.6.

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

MySQL Cluster 7.6.10 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.6.10 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>

MySQL Cluster 7.4.24 has been released

Dear MySQL Users,

MySQL Cluster is the distributed, shared-nothing variant of MySQL.

Assistance with trigger

Hi All

I am hoping this email finds all well.

I would like to request some assistance with a MySQL trigger please.

We need to implement a trigger that will in short terms make a backup of a row before it gets deleted.

so we have tableA and TableB (backup table).

I added a before delete trigger to insert into TABLEB select from TABLEA...

MySQL Connector/ODBC 8.0.16 has been released

Dear MySQL users,

MySQL Connector/ODBC 8.0.16 is a new version in the MySQL Connector/ODBC
8.0 series,
the ODBC driver for the MySQL Server.

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.

MySQL Connector/Node.js 8.0.16 has been released

Dear MySQL users,

MySQL Connector/Node.js is a new Node.js driver for use with the X
DevAPI.

MySQL Community Server 5.6.44 has been released

Dear MySQL users,

MySQL Server 5.6.44, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.44 is
recommended for use on production systems.

For an overview of what's new in MySQL 5.6, please see

<a href="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html" title="http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html">http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html</a>

Starting with 5.6.11, Microsoft Windows packages for MySQL 5.6
are available both as a "full" installer and as a "web" installer.
The full installer is significantly larger and comes bundled with
the latest software releases available.

MySQL Connector/C++ 8.0.16 has been released

Dear MySQL users,

MySQL Connector/C++ 8.0.16 is a new release version of the MySQL
Connector/C++ 8.0 series.

Connector/C++ 8.0 can be used to access MySQL implementing Document
Store or in a traditional way, using SQL queries.

MySQL Connector/NET 8.0.16 has been released

Dear MySQL users,

MySQL Connector/NET 8.0.16 is the fourth version to support
Entity Framework Core 2.1 and the sixth general availability release
of MySQL Connector/NET to add support for the new X DevAPI, which
enables application developers to write code that combines the
strengths of the relational and document models using a modern,
NoSQL-like syntax that does not assume previous experience writing
traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html" title="http://dev.mysql.com/doc/x-devapi-userguide/en/index.html">http://dev.mysql.com/doc/x-devapi-userguide/en/index.html</a>.

MySQL Community Server 5.7.26 has been released

Dear MySQL users,

MySQL Server 5.7.26, a new version of the popular Open Source Database
Management System, has been released.

MySQL Workbench 8.0.16 has been released

Dear MySQL users,

The MySQL developer tools team announces 8.0.16 as our general available
(GA) for
MySQL Workbench 8.0.

For the full list of changes in this revision, visit
<a href="http://dev.mysql.com/doc/relnotes/workbench/en/news-8-0.html" title="http://dev.mysql.com/doc/relnotes/workbench/en/news-8-0.html">http://dev.mysql.com/doc/relnotes/workbench/en/news-8-0.html</a>
<https://dev.mysql.com/doc/relnotes/workbench/en/news-8-0.html>

For discussion, join the MySQL Workbench Forums:
<a href="http://forums.mysql.com/index.php?152" title="http://forums.mysql.com/index.php?152">http://forums.mysql.com/index.php?152</a>

The release is now available in source and binary form for a number of
platforms from our download pages at:

<a href="http://dev.mysql.com/downloads/tools/workbench/" title="http://dev.mysql.com/downloads/tools/workbench/">http://dev.mysql.com/downloads/tools/workbench/</a>

Enjoy!

Changes in MySQL Workbench 8.0.16 (2019-

MySQL Connector/Python 8.0.16 has been released

Dear MySQL users,

MySQL Connector/Python 8.0.16 is the latest GA release version of the
MySQL Connector Python 8.0 series. The X DevAPI enables application
developers to write code that combines the strengths of the relational
and document models using a modern, NoSQL-like syntax that does not
assume previous experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see
<a href="http://dev.mysql.com/doc/x-devapi-userguide/en/" title="http://dev.mysql.com/doc/x-devapi-userguide/en/">http://dev.mysql.com/doc/x-devapi-userguide/en/</a>.

MySQL Enterprise Backup 8.0.16 has been released

MySQL Enterprise Backup 8.0.16, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle. MySQL Enterprise Backup is a commercial
extension to the MySQL family of products.

MySQL Enterprise Backup 8.0.16 supports only the MySQL Server 8.0.16.
For earlier versions of MySQL 8.0, use the MySQL Enterprise Backup
version with the same version number as the server.

MySQL Router 8.0.16 for MySQL Server 8.0 and 5.7 has been released

Dear MySQL users,

MySQL Router 8.0.16 is a new release for MySQL Router 8.0 series.

MySQL Router 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7.
Please upgrade to MySQL Router 8.0.16.

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 applicat

MySQL Community Server 8.0.16 has been released [part 2]

[This is part 2 of the announcement]

Bugs Fixed, continued

* InnoDB: Write-ahead did not work as expected due to an
incorrectly initialized variable.
Thanks to Yuhui Wang for the contribution. (Bug
#29028838, Bug #93442)

* InnoDB: The base column information for a generated
column was not stored. (Bug #29021730)

* InnoDB: An implicit lock check on secondary indexes
needlessly compared columns using collation rules.

MySQL Community Server 8.0.16 has been released [part 1]

[Due to size limitation, this announcement is split in two. This is part 1]

Dear MySQL users,

MySQL Server 8.0.16, a new version of the popular Open Source
Database Management System, has been released.

SSIS list tables not showing all tables

Hi
I Installed the ODBC driver version 11 both 32 and 64 bit in my computer
Windows 7 Pro 64 bit, When I tried to connect to Postgres DB from SSIS
Visual Studio 2015 version 14.0.25420.01 Update 3 using the postgres ODBC
64 bit I get an error that the architecture is mismatching. So I create a
connection using the 32 bit postgres driver and I was capable to connect to
Postgres DB but my issue that I can't see all tables what I can see just
those in public schema.
Any idea or help
Thank you

Mustapha JIBBOU
514 294 3732

How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

Good evening from Singapore,

Our customer (company name is Confidential/not disclosed) reported that their MySQL database has been found missing or was deleted a few times. They are using Ubuntu 16.04 LTS Linux server with Apache2 Web Server, MySQL and PHP (LAMP).

We responded to these security incidents by changing the passwords of the regular user, root user, and MySQL database user root. We have also examined /var/log/auth.log and think that the hacker could not have come in through ssh or sftp over ssh.

help using your odbc driver

Hello
I've been experiencing failures when attempted to connect DataStage to your db (postgres) using odbc driver.
Therefore I'm wondering if you can provide some guidance or point me to a location where I can get some help

Thanks

Charles Brown | NZ and InfoSphere DBA
530 Great Circle Road | Nashville, TN 37228
Phone: 1.615.564.3415 x56453415 | charles. ... at cigna dot com<mailto:charles. ... at healthspring dot com>
Mobile: 615.491.3307

64 Bit versus 32 Bit

Good afternoon,
I’m not sure if you can help me, but maybe at least shed some light on things. I have a MS-Access database used by 6-7 different users. It mostly uses an MS-Access backend, but there are some connections to a PostgreSQL server as well. It was built with MS-Access 2010 32-bit because we still had a few 32-bit WinXP machines floating around. I used the PostgreSQL Unicode driver, version 9.01.01.00, and configured the connection with Window’s ODBC Data Source Administrator (32-bit).

Postgres ODBC Driver

Good day Team,

I have been trying to install the ODBC driver for Postgres so that i can be
able to connect my excel sheet/csv files to my postgres database but the
installation takes forever to start.

Any help would be greatly appreciated.

Regards
MG

Rename 64bit ODBC driver

Hi all,

would it be possible to rename the 64bit ODBC driver from PostgreSQL ANSI(x64) and PostgreSQL Unicode(x64) to PostgreSQL ANSI and PostgreSQL Unicode (same as the 32bit ODBC drivers)?
If drivers for both 32bit and 64bit were named the same, one could use the same connection string in both environments.

Cheers,
Mirko

Mroonga 9.01 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 9.01 has been released!

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

setLastTid() and currtid()

Hi,

For the tableam work I'd like to remove heapam.h from
nodeModifyTable.c. The only remaining impediment to that is a call to
setLastTid(), which is defined in tid.c but declared in heapam.h.

That doesn't seem like a particularly accurate location, it doesn't
really have that much to do with heap. It seems more like a general
executor facility or something.

How to get error details from Visual Foxpro using latest driver

Latest PostgreSql official psqlODBC driver (version 11.00.0000 , 32 bit)
does not return error details in Microsoft Visual Foxpro.

After error FoxPro commands

AERROR(laerror)
disp memory like laerror

returns same error message in laerror third element:

LAERROR Local A showerror
( 1, 1) N 1526 ( 1526,00000000)
( 1, 2) C "Connectivity error: ERROR: insert or update o
n table "rid" violates foreign key constraint
"rid_yhik_fkey";
Error while executing t

Issue with some Postgresql ODBC drivers in SAS

Hi,

I connect to a Postgresql 9.4 database using Proc Sql in SAS via a Postgresql ODBC driver. When I'm using driver version 9.01.02, variables created using the SAS substring function on Varchar fields are properly set to the length specified. When I use either driver version 9.03.02 or 9.05.01, substringed fields are set to $1024. The length of Varchar fields that are not substringed are not changed.

I haven't been able to find any references to this problem online including on postgresql.org.

ANN: Upscene releases Database Workbench 5.6.0

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

“ Database Workbench 5.6.0 "

This new release brings you the Command Line Data Pump & Favorites feature (Pro Edition) and a few important bugfixes.

Replication and user privileges

I have a question about mysql replication.

I want to know if the ODBC is installed on my computer

Hi!
How I can know, is the ODBC driver installed in my PC or not ?
Thanks!

With kind regards,
Skovorodnikov Aleksey
Analyst ESM solutions
The Department document management systems
LANIT
Phone (mobile) : +7 (904) 235 93 80

Escaped characters in LIKE

PostgreSQL fully supports escaping of %, _ and \ in LIKE clauses, and supports the standard syntax for indicating the use of an escaping character: <a href="https://www.postgresql.org/docs/9.0/functions-matching.html" title="https://www.postgresql.org/docs/9.0/functions-matching.html">https://www.postgresql.org/docs/9.0/functions-matching.html</a>.

The ODBC driver correctly supports the standard ODBC 'escape' syntax for declaring the escaping character: (convert.c, line 5580).

So is there some reason I'm missing why the SQLGetInfo implementation, when asked SQL_LIKE_ESCAPE_CLAUSE, says that the driver doesn't support escaping of LIKE? (info.c, line 309).

Potential Windows ODBC 10.03.0000 Security Vulnerability

Hello all,

In August of 2018, CVE-2018-10915 was found with a CVSS v3 base score of 8.5 against the PostgreSQL libpq library. This affects all PostgreSQL 10 versions of libpq up to version 10.4 and the issue is fixed as of version 10.5. As far as I can tell, the Windows MSI provided by the PostgreSQL ODBC community for ODBC 10.03.0000 is shipping with libpq version 10.4, which would mean it is shipping with these security vulnerabilities.

Are there any plans to upgrade the Windows MSI libpq libraries to PostgreSQL 10.5 or 10.6 so that we can avoid this security issue?

problem with _ character

Hello,

I am using ANSI odbc driver (11.0) on a W10  with a utf8 DB trying to :

SELECT * FROM table WHERE (name = ?);

with a name including a '_' character : '1170332_381-P364'

In the postgresql server logs, I see that it has been replaced with
'1170332[_]381-P364' and my query fails.

How should I do ?

Thanks.

PC

MySQL Enterprise Backup 3.12.4 has been released

Dear MySQL users,

MySQL Enterprise Backup v3.12.4, a new version of the online MySQL backup
tool, is now available for download from the My Oracle Support (MOS) website
as our latest GA release. This release will be available on eDelivery (OSDC)
after the next upload cycle.

Mroonga 9.00 - Fast fulltext search for all languages on MySQL

Hi,

Mroonga 9.00 has been released!

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

mysql V 8.0.12 and mysqdump

Hello list,
i run into an unexpected problem with mysqldump:

mysqldump --version
mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL)

when i try it results in:
mysqldump: Error: 'Lost connection to MySQL server during query' when trying to
dump tablespaces
mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo\_version'': MySQL
server has gone away (2006)

I seems it get stuck in this query:

explain SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE,
ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE
_TYPE = 'UNDO LOG' AND FILE_NAME IS NOT NULL A

Reported lengths of char fields - psqlODBC

Linux Mint 18.3 x64 (base on Ubuntu 16.04 package base)
Postgresql v 9.5.14
unixODBC v2.3.1-4.1
psqlODBC v1:09.03.0300-1

I created a simple table containing one column of type character (n).
When I ask for the width of the column via (ODBC)SQLColAttribute function,
it answers (n*6) , so if defined as character(1) the call reports length 6,
character(2) reports 12, character(4) reports 24, etc.

I see the same kind of results when using a varchar(n) field (character
varying (2), etc ) as well .

Is this expected, or am I doing something wrong?

Thanks,
Bob

PG12 patch

Hello, I use the PostgreSQL-devel server with which the psqlodbc-git
version does not work because the field 'relhasoids' was dropped in
PG12. After applying the patch that I send you, my huge c++ ODBC
application now works again with PostgreSQL-devel server. Vladimir
Koković DP senior(69), Belgrade, Serbia

Syndicate content