Thread: 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