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


Mon, 07 Jul 2003 22:07:52 +0200
Carlos Guzman Alvarez <carlosga@telefonica.net>
CREATE DATABASE command in Extended Query mode of 3.0 protocol
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

Tue, 08 Jul 2003 01:34:43 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: CREATE DATABASE command in Extended Query mode of 3.0 protocol 
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



Tue, 08 Jul 2003 10:21:49 +0200
Carlos Guzman Alvarez <carlosga@telefonica.net>
Re: CREATE DATABASE command in Extended Query mode of 3.0
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??





-- 
Best regards

Carlos Guzmï¿½n ï¿½lvarez
Vigo-Spain



Wed, 09 Jul 2003 10:20:34 +0200
Carlos Guzman Alvarez <carlosga@telefonica.net>
Re: CREATE DATABASE command in Extended Query mode of 3.0
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

Wed, 09 Jul 2003 11:35:37 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: CREATE DATABASE command in Extended Query mode of 3.0 
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



Wed, 09 Jul 2003 20:08:19 +0200
Carlos Guzman Alvarez <carlosga@telefonica.net>
Re: CREATE DATABASE command in Extended Query mode of 3.0