[SQL] Using sql statements in file

[Suresh Basandra]

Hi,

 

I would like to do the following using files:

 

1. put create database, create
tables sql statements in a file and execute through prompt

2. insert or update data that is
put in a file

 

Please let me know if there are any examples that lists how sql
statements can be 
put in a file and used.

 

Thanks

Suresh Basandra

[SQL] Using sql statements in file

[Suresh Basandra]

Hi,

 

I would like to do the following using files:

 

1. put create database, create
tables sql statements in a file and execute through prompt

2. insert or update data that is
put in a file

 

Please let me know if there are any examples that lists how
sql statements can be  put
in a file and used.

 

Thanks

Suresh Basandra

[SQL] insert error

[Suresh Basandra]

Hi,

I am getting the following error while executing insert command after I 
have started the erserver. I did not get this error when erserver was 
not started. I installed the latest versions of postgresql (7.3.4) and 
erserver (1.2). Please advise. Thanks

Regards,
Suresh Basandra
pwtestdb=# insert into person (empid) values (1);
FATAL:  Pre-7.3 object file made an elog() call.  Recompile.
server closed the connection unexpectedly
   This probably means the server terminated abnormally
   before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] insert error

[Suresh Basandra]

Hi all,

I am getting the following error while executing insert command
inserting data in master database after I have started the erserver. I
did not get this error when erserver was not started. Also, I am not
getting the error in slave database when inserting as may be the column
_ers_uniq is still not created in tables meant for replication in slave
due to another problem. Please advise as I am stuck. Thanks

Environment:
Linux Red Hat 8.0
Sun JDK 1.3.1
Perl 5.8.0
eRServer 1.2
PostgreSQL 7.3

Regards,
Suresh Basandra

pwtestdb=# insert into person (empid) values (1);
FATAL:  Pre-7.3 object file made an elog() call.  Recompile.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster