mysql_fdw is a PostgreSQL foreign data wrapper to access MySQL data from within a PostgreSQL database. Use this tag for questions about SQL queries involving mysql_fdw. Questions about installation or configuration would be better suited for dba.stackexchange.com
Questions tagged [mysql-fdw]
2 questions
2
votes
1 answer
Postgres "ERROR: XX000: cache lookup failed for type 0 LOCATION: format_type_extended, format_type.c:128"?
updated.
I created a test table in MySQL.
CREATE TABLE sizes (
size ENUM('small', 'medium', 'large')
;
insert into sizes values ('small'),('medium'),('medium');
In Postgresql,
CREATE FOREIGN TABLE sizes("size" text) SERVER test_server OPTIONS…
viminal
- 76
- 1
- 5
0
votes
1 answer
Insert into foreign table partition doesn't work
I have some table in mariadb.
I need to create foreign table partition for that table
CREATE TABLE IF NOT EXISTS users (
id serial NOT NULL,
name varchar(30)
) partition by range(id);
CREATE foreign TABLE IF NOT EXISTS users_p
partition…
vantaqada
- 101
- 2
- 6