reset password
Author Message
prajaktas
Posts: 10
Posted 22:15 May 23, 2010 |

Hello Professor,

I am getting the following error while inserting the test data into the database. I tried dropping the tables and inserting the test data again but it still fails.

ERROR:  relation "csns_test_general_sequence" already exists

********** Error **********

ERROR: relation "csns_test_general_sequence" already exists
SQL state: 42P07
 

Thank You

cysun
Posts: 2935
Posted 22:20 May 23, 2010 |

You need to close the query windows (or something like that) before you run csns-test-insert.sql again. The temporal sequences/tables and so on will be automatically removed after a database session terminates.

JHautzinger
Posts: 14
Posted 22:28 May 23, 2010 |

I was figuring this out last night.  You have to close the query window and the connection window.  Basically completely close out of PGAdmin.  For some reason when I was testing things, even if I disconnected and reconnected without closing the PGAdmin main window, for some reason it still maintained the temp sequences and tables.

prajaktas
Posts: 10
Posted 22:31 May 23, 2010 |

It worked. Thanks.