Discussions

Ask a Question

[42601] ERROR: cannot insert multiple commands into a prepared statement

Hi, I am trying to upload data to my repository from DataGrip but each time, i try running this script CREATE TABLE if not exists "Ngugisenior/parch_posey"."web_events" (id integer,account_id integer,occurred_at timestamp,channel varchar(255)); i keep getting the error [42601] ERROR: cannot insert multiple commands into a prepared statement

Error: cross-database references are not implemented

I am getting the following error when trying to access table data after I am connected in Power BI DataSource.Error: ODBC: ERROR [0A000] ERROR: cross-database references are not implemented: Error while executing the query Details: DataSourceKind=Odbc DataSourcePath=dsn=PostgreSQL35W OdbcErrors=[Table]
ANSWERED

Region for Bit.io data

Hi there, it is not clear from the docs, where bit.io data is stored. I am working on an application where privacy laws may become an issue, if so, does the paid version give the opportunity to change the region or is all data stored in the US?

Connect to Excel - VBA

Hi, I'm tryying to connect my VBA project to a database. My VBA code has been already tested by using a local SQL database. Command I am using is: "Provider=MSDASQL;Driver={MySQL ODBC 8.0 Unicode Driver};Server=" & DB_ServerName & ":" & DB_Port & ";Database=" & DB_Name & ";user=" & DB_UserID & ";password=" & DB_PW & ";" Can you please halp me? Thanks in advance

public databases

Maybe I don't understand something, but can i connect to any public database or only my own? Also, if I logged in with a Google Account, what is my username/password? Thanks
ANSWERED

Creating Postgres Foreign Keys, Functions and Triggers

Are you able to create foreign keys, create functions and/or create triggers. The table creation api on the website only allows for creation of flat tables..

How specify encoding for table?

To use full search I need to find Russian characters and use: ENCODING LC_COLLATE "ru_RU.utf8" LC_CTYPE "ru_RU.utf8";

API /query/ query_string?

how to use the query_string of the api? there is too few information about it in the API Reference, I don't even understand how it does and what it does.
ANSWERED

DROP command not working

DROP TABLE IF EXISTS "alanparadise/nw"."shippers" - This is my SQL statement I am not able to find anything wrong here but it is showing as an unsupported operation. Any reason why this could be happening? I checked the help section of bit.io and the syntax seems to be the same so I'm not understanding what they exactly mean by unsupported operation here.
ANSWERED

petl ETL library insert data

Hi i am trying to load data into my database using petl module but it doesn't work unfortunately. petl.io.todb(data, conn, '\"xxxx/xxx\".\"xx\"') psycopg2.DatabaseError: LOG: Error occurred when processing query: relation "".""xxxx/xxx"."xx"" does not exist (error ID: ab375ee7-621d-456c-b8d7-096f6d3a5a9e) can we use this library or we have to stick to bitdotio library?