Good day folks.
Error:
INSERT into " public.best!Tab le@Ever2$%^&()_+{}:'""?/.>,<~ 4" ("
(id)$mipublic.lk'","""""''""""2--","not$%^&()
_+{}:'""?/.>,<~nice","""""""""3'","""""''""""++") VALUES (?, ?, ?, ?, ?)
DBD::Pg::db last_insert_id failed: Could not find the table " public.best!Tab
le@Ever2$%^&*()_+{}\:'""?/.>,<~ `4" [for Statement "
SELECT i.indisprimary,
COALESCE(
-- this takes the table name as text, not regclass
pg_catalog.pg_get_serial_sequence(
-- and pre-8.3 doesn't have a cast from regclass to text,
-- and pre-9.3 doesn't have format, so do it the long way
quote_ident(n.nspname) || '.' || quote_ident(c.relname),
---- snip
---------------
The issue seems to be that since I have double quotes in the table name, I have
to "double up" the double quotes for the insert statement but you folks may
need to replace all "" in the table name to " before running your query.
$table_name_for_query = $table_name; $table_name_for_query =~ s/["]{2}/"/g;
Maybe In Pg.pm?:
my $table_for_query = $table;
$table_for_query =~ s/["]{2}/"/g;
my @Args<https://github.com/Args> = ($table_for_query);
------------------
Thank you in advance for your responses.
Joseph
