10 results found
-
Export SQL from Query component with values of the parameters
When you need to debug some SQL, you can save the SQL query to a file and then run it outside of your application to check for any issues with the query. However, you cannot do the same when using parameters. When you try to save SQL.Text to a file, you will get the query with parameter names, such as SELECT * FROM A WHERE Id = :paramname. To debug effectively, I need to see the values of the parameters. Ideally, I want to save the query with the actual parameter values, like SELECT * FROM A WHERE ID =…
3 votes -
Support GENERATED ALWAYS AS XXX STORED-Columns
In Postgres it's possible to create an readonly column,
See
https://www.postgresql.org/docs/current/sql-createtable.htmlGENERATED ALWAYS AS ( generation_expr ) STORED
This clause creates the column as a generated column. The column cannot be written to, and when read the result of the specified expression will be returned.Automatic generated SQL for INSERT OR UPDATE don't handle the column as readonly. If you set UpdateAllFields to true an exception is raised. Also an exception occurs when you change the value of this field an call Post.
The column should be set to readonly an the corresponding field should be excluded from INSERT andUPDATE.
3 votes -
Add PostgreSQL error codes to error message
Currently we are migrating Oracle to PostgreSQL DBExpress. With Oracle, we were able to categorize DBExpress errors based on the message "ORA-XXXXX" and perform appropriate error handling. We had to do this because of the limitation of DBExpress.
With PostgreSQL, we have the problem that we only get the error message. So we would have to parse all error messages individually. Per error code there are 1:n different PostgreSQL error messages!
Therefore our question to you: Would it be possible to set the error code analog to Oracle at the start of the error message?
For example "PG-22023 input string…
1 vote -
Support PostGIS Geometry-Data-Types
The possibility to read/write Geometry-Data-Types of PostGIS (MultiPolygon, Collections etc.) as it is possible with PostGreSQL-Geometry-Data-Types like lseg, polygon etc.
7 votes -
Support inherited tables on the TPgDump component of PgDAC
Actually (v6.2.4), the PgDac TPgDump component does not generate appropriate code for inherited tables, making it useless when inherited tables are used, and we need to get the SQL script to generate the given schema.
TPgDump should support tables inheritance and:
- create base tables before inherited tables
- use the inherits clause within the table creation sql statement
- do not generate insert statements for base tables data, only for inherited tablesThanks,
3 votes -
Support for OpenSSL 1.1
UniDAC currently only supports OpenSSL 1.0.2. This version won't be supported past 2019-Dec-31.
To avoid problems UniDAC should support OpenSSL 1.1
4 votes -
Add refreshquick to PgDAC
The RefreshQuick method (https://www.devart.com/mydac/docs/devart.mydac.tcustommydataset.refreshquick(system.boolean).htm) seems very useful to refresh only the new records from big datasets. Ideally, make it possible to specify the name of the TIMESTAMP field so we don't have to create a duplicate - mine are called "created" for example). Maybe we don't even need the TimeStamp field for Postgresql ?
1 vote -
Support Postgres Advanced Server
Postgres Advanced Server (PAS) is an extended version of PostgreSQL, it supports Stored Procedures, Packages and Aliasses. Currently, PgDAC does not support executing several of the commands available in PAS.
6 votes -
Retrieving Query Results Row-By-Row
PostgreSQL 9.2 has a new feature that allows results sets to be returned row by row instead of the whole result set at once.
This is a huge improvement for larger result sets.
See here for more info:
http://www.postgresql.org/docs/9.2/static/libpq-single-row-mode.html14 votes -
Implement COPY FROM/TO functionality
Implement COPY FROM/TO functionality for PostgreSQL (PgDAC component).
PostgreSQL COPY manual:
http://www.postgresql.org/docs/current/interactive/sql-copy.html103 votes
- Don't see your idea?