can not create database!!!!

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: can not create database!!!!
Date: 2001-06-15 02:51:14
Message-ID: 200106150251.f5F2pEn65331@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

scott cao (scottc(at)cs(dot)ucla(dot)edu) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
can not create database!!!!

Long Description
Can not create database!!!!
I don't have an explicit transaction block in progress.
ERROR: CREATE DATABASE: may not be called in a transaction block
This code work with 6.XX but does't work with 7.xx

Sample Code
#include <stdio.h>
#include <stdlib.h>
#include <string.h>

int main(void)
{
exec sql connect to template1 user postgres;
exec sql create database test1234;
exec sql commit;
}

No file was uploaded with this report

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-06-15 02:58:27 sqlca.sqlcode doesn't work in 7.xx
Previous Message Arcady Genkin 2001-06-14 17:02:58 Re: PHP's pg_connect() and non-standard location of the socket (was: REPOST: redefining location of the socket file /tmp/.s.PGSQL.5432)