Menu

#215 regression: create_view: CREATE VIEW error

closed
nobody
SQL query (126)
5
2012-03-10
2011-07-12
No

template1=# create table aa (a int);
CREATE TABLE
template1=# create view aav as select * from aa where a > 10;
CREATE VIEW
template1=# select * from aav;
ERROR: cache lookup failed for function 0
template1=# explain verbose create view aav as select * from aa where a > 10;
ERROR: syntax error at or near "view"

Discussion

  • Abbas Butt

    Abbas Butt - 2012-03-10
    • status: open --> closed
     
  • Abbas Butt

    Abbas Butt - 2012-03-10

    test=# create table aa (a int);
    CREATE TABLE
    test=# create view aav as select * from aa where a > 10;
    CREATE VIEW
    test=# select * from aav;
    a
    ---
    (0 rows)

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.