I am using Postgresql 7.3.4.
I have a couple problems when creating tables dynamically using ecpg (embedded SQL in C). More times than not, when I create the table and then commit the changes, I get an error: "Socket command type s unknown" and the table, although it reports the table was created successfully, it was not actually created. Has anyone had this problem before? I cannot find any documentation on this error.
In addition, although I have specified a log file, messages from the database server process seem to be outputted to a socket I am using to communicate with other clients (my C program the contains the embedded SQL is an API between the database and clients wishing to retrieve and alter information within the database), even though I am quite positive I do not have any file descriptors mixed up (the problem ONLY occurs when I dynamically create tables and a NOTICE message is outputted to the log file (the same NOTICE message somehow get outputted to the socket).
If anyone has any insight to my problems please let me know. Thank you.
I have a couple problems when creating tables dynamically using ecpg (embedded SQL in C). More times than not, when I create the table and then commit the changes, I get an error: "Socket command type s unknown" and the table, although it reports the table was created successfully, it was not actually created. Has anyone had this problem before? I cannot find any documentation on this error.
In addition, although I have specified a log file, messages from the database server process seem to be outputted to a socket I am using to communicate with other clients (my C program the contains the embedded SQL is an API between the database and clients wishing to retrieve and alter information within the database), even though I am quite positive I do not have any file descriptors mixed up (the problem ONLY occurs when I dynamically create tables and a NOTICE message is outputted to the log file (the same NOTICE message somehow get outputted to the socket).
If anyone has any insight to my problems please let me know. Thank you.