Simple Syntax Error in PostgreSQL

Question

Several times now I've gotten the error "ERROR: syntax error at or near CREATE". I've played around with the formatting but can't seem to fix it. I'm hoping it's something minor someone can point out to me. Thanks in advance for the help!

-- View: mock_tool_cal

-- DROP VIEW mock_tool_cal;

CREATE OR REPLACE VIEW mock_tool_cal AS 
 SELECT toolcal."control#" AS old_control_number
   FROM staging.agg_staging_toolcal toolcal

ALTER TABLE mock_tool_cal
  OWNER TO postgres;

Did you try CREATE VIEW mock_tool_cal AS SELECT toolcal."control#" AS old_control_number FROM staging.agg_staging_toolcal toolcal — A l w a y s S u n n y
– A l w a y s S u n n y, Commented Jun 12, 2014 at 18:36
There is no error in your view create query (see this demo here sqlfiddle.com/#!15/0625b). It must be somewhere else. Show what you have before CREATE OR REPLACE VIEW. — Rahul
– Rahul, Commented Jun 12, 2014 at 18:40
@sany2k8 I just tried that out too, and no luck. I'm beginning to wonder if maybe it's a problem with the SQL admin program I'm using. — Greg
– Greg, Commented Jun 12, 2014 at 18:43
@Rahul I think that SQLFiddle confirms my suspicion. And I don't have anything in the ddl prior to "Create or Replace View" — Greg
– Greg, Commented Jun 12, 2014 at 18:45

Clodoaldo Neto · Accepted Answer · 2014-06-12 18:49:43Z

2

You need a semicolon between the CREATE and ALTER commands

CREATE OR REPLACE VIEW mock_tool_cal AS 
SELECT toolcal."control#" AS old_control_number
FROM staging.agg_staging_toolcal toolcal

;

ALTER TABLE mock_tool_cal
OWNER TO postgres;

answered Jun 12, 2014 at 18:49

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Greg · Accepted Answer · 2014-06-12 18:58:40Z

0

Found the solution! As it turns out it was a problem with PGAdmin3. I was writing out the entire DDL, but hadn't realized it was already inserting "Create View mock_tool_cal". This meant I had two "Create View mock_tool_cal" lines hence the syntactical error.

answered Jun 12, 2014 at 18:58

Greg

2,0192 gold badges18 silver badges27 bronze badges

Collectives™ on Stack Overflow

Simple Syntax Error in PostgreSQL

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related