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
PostgreSQL
Last Comment
Dave Baldwin
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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/