Обсуждение: CREATE DATABASE command in Extended Query mode of 3.0 protocol

Hello:

I'm trying to create a database using the extended query mode ( with my 
own implementation of the 3.0 protocol in C# ) but i'm having problem, 
the CREATE DATABASE command seems to be executed well and the answer of 
the server is the expected but the database is never created, if i exec 
the same command with the simple query cycle all works as expected and 
the database is created, is this the correct behavior ??





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Carlos Guzman Alvarez <carlosga@telefonica.net> writes:
> I'm trying to create a database using the extended query mode ( with my 
> own implementation of the 3.0 protocol in C# ) but i'm having problem, 
> the CREATE DATABASE command seems to be executed well and the answer of 
> the server is the expected but the database is never created, if i exec 
> the same command with the simple query cycle all works as expected and 
> the database is created, is this the correct behavior ??

No, it should just work.  Can you give a test case?  Do you see similar
problems with other utility commands, or is it only CREATE DATABASE?
        regards, tom lane

Hello:

> No, it should just work.  Can you give a test case?  Do you see similar
> problems with other utility commands, or is it only CREATE DATABASE?


I have a litlle test more and i have it working now, i have made change 
for send a Sync message instead of a Flush message after execute the 
command and now seems to be working as expected, is this correct or it 
needs to work with the Flush too??



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Hello:
> No, it should just work.  Can you give a test case?  Do you see similar> problems with other utility commands, or is
itonly CREATE DATABASE?
 


I have made a litlle test more and i have it working now, i have made 
change for send a Sync message instead of a Flush message after execute 
the command and now seems to be working as expected, is this correct or 
it needs to work with the Flush too??





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Carlos Guzman Alvarez <carlosga@telefonica.net> writes:
> Hello:
>>> No, it should just work.  Can you give a test case?  Do you see similar
>>> problems with other utility commands, or is it only CREATE DATABASE?

> I have made a litlle test more and i have it working now, i have made 
> change for send a Sync message instead of a Flush message after execute 
> the command and now seems to be working as expected, is this correct or 
> it needs to work with the Flush too??

You do need to use Sync rather than Flush to create transaction
boundaries and error restart points.  I suspect your problem was coming
from having only a Flush and not a Sync between the CREATE DATABASE and
the *prior* command.
        regards, tom lane

Hello:

> You do need to use Sync rather than Flush to create transaction
> boundaries and error restart points.  I suspect your problem was coming
> from having only a Flush and not a Sync between the CREATE DATABASE and
> the *prior* command.


Huummm there are no prior executed commands, the CREATE DATABASE command 
is the first i execute after connect to the server :)




-- 
Best regards
Carlos Guzmán Álvarez
Vigo-Spain