sqlite_fdw
sqlite_fdw copied to clipboard
pgspider
SQLite Foreign Data Wrapper for PostgreSQL
Hi, 2.4.0 fails to build against PostgreSQL 17. v17 beta2 is already out. Can you please take a look? Thanks, Devrim > gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute...
SQLite error diagnostics codes by default belongs to legacy enumeration, so called _primary result code list_, where there is no detailed semantics for a reason of error. After adding [`sqlite3_extended_result_codes`](https://www.sqlite.org/c3ref/extended_result_codes.html)...
This PR implements PostgreSQL `macaddr` and `macaddr8` columns support as possible mixed affinity column in SQLite. The nearest affinity selected as `integer` because of there are many fast operations in...
This is a quick patch for https://github.com/pgspider/sqlite_fdw/issues/108 * add `isInfinity` function * add warning about ∞ values with `text` affinity if no normalization mode is used * test for described...
SQL `RETURNING` have been [introduced in SQLite 3.35.0](https://www.sqlite.org/lang_returning.html). > SQLite's syntax for RETURNING is modelled after [PostgreSQL](https://www.postgresql.org/). I haven't noticed any special behaviour for `RETURNING` in SQLite not mapped to...
Based on storage conventions, discussed on [SQLite forum thread](https://sqlite.org/forum/forumpost/ccd48c9556). Default affinity of IPv4 - `integer`. Default affinity of IPv6 - `blob`, because other compact forms are impossible. Storage convention for...
PGDG apt support group propose me to try adding `debian` directory with [content according official instruction](https://salsa.debian.org/postgresql/postgresql-common/-/blob/master/doc/postgresql-debian-packaging.md) to the repository. After some iterations we will can provide metadata for source code...
say i have a table like this in sqlite: ``` sqlite> .schema states CREATE TABLE IF NOT EXISTS "states" ( state_id INTEGER NOT NULL, entity_id CHAR(0), state VARCHAR(255), attributes CHAR(0),...
Hi, sqlite_fdw 2.5.0 fails to build against PostgreSQL 18 beta 2. The errors are below. Can you please take a look? Thanks! Devrim ``` gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla...