Hello, I am using embedded SQL command for creating the database: EXEC SQL BEGIN DECLARE SECTION; char dbase[32]; EXEC SQL END DECLARE SECTION; ... EXEC SQL CONNECT TO postgres; //the create database cannot be run in transaction block EXEC SQL SET AUTOCOMMIT TO ON; EXEC SQL CREATE DATABASE :dbase;
I get an error during compile with ecpg (/usr/bin/ecpg -I../../include -c source_file.ec) ERROR: syntax error at or near ":dbase" *** Error code 3 When I use literal string like: "EXEC SQL CREATE DATABASE my_dbase;" it is compilable and it works. All other SQL commands work with the variables except for the CREATE DATABASE. I am using the package postgresql-devel-8.1.3-12. Any idea? Thank you! Pavel Krejci
