drop database fails in .NET

Asked Apr 03 '17 at 21:31

Active Apr 03 '17 at 21:54

Viewed 95 times

My code is

var cn = new NpgsqlConnection("host=localhost;database=dummydb;username=foo;password='bar';");
cn.Open();
var r1 = cn.Execute("drop database foo");
var r2 = cn.Execute("create database foo");

However r1 and r2 is -1. I have no idea why and I don't know how to check what went wrong

edited Apr 03 '17 at 21:54

asked Apr 03 '17 at 21:31

I don't know for sure, but certainly [PostgreSQL has logging](http://stackoverflow.com/q/722221/215552)? – Heretic Monkey Apr 03 '17 at 21:35
@MikeMcCaughan: Unfortunately it appears to be not logged. – Apr 03 '17 at 21:52
See section "Notes": https://www.postgresql.org/docs/current/static/sql-dropdatabase.html – barbsan Apr 04 '17 at 05:54
@barbsan: So how do I execute sql in C# without it being in a transnational block? – Apr 04 '17 at 16:02
Get the error messages and read them. What do they say? – Laurenz Albe Apr 05 '17 at 07:02

drop database fails in .NET

0 Answers0

Linked