gregfthompson
asked on
postgresql problem - script to create tables does not run
In postgresql 9.6 (running under Windows 7 64), I attempted to run a script to create tables but it showed this error:
ERROR: table "street_locality_point" does not exist
********** Error **********
ERROR: table "street_locality_point" does not exist
SQL state: 42P01
The problem is that "street_locality_point" does exist in lines 14, and 333 and 334.
What is causing this error?
create_tables_ansi.sql
ERROR: table "street_locality_point" does not exist
********** Error **********
ERROR: table "street_locality_point" does not exist
SQL state: 42P01
The problem is that "street_locality_point" does exist in lines 14, and 333 and 334.
What is causing this error?
create_tables_ansi.sql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Pawan and Dave,
I ran Pawan's solution and received this result:
"Query returned successfully with no result in 512 msec."
I am unable to see what is wrong with this script?
Greg
I ran Pawan's solution and received this result:
"Query returned successfully with no result in 512 msec."
I am unable to see what is wrong with this script?
Greg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No tables created.
ASKER
Thanks heaps.
ASKER
Oops. It appears one of my messages was not posted. The tables were created after I clicked on the tables name. Thanks so much for your help.
Glad you got it working. In my copy of PostGreSQL, I had to replace 'REM' with '--' to get the DROP TABLE statements to work.
DROP TABLE IF EXISTS STREET_LOCALITY_POINT;
http://www.postgresqltutorial.com/postgresql-drop-table/