Re: [BUGS] BUG #8386: function crosstab(unknown) does not exist
Have you installed the tablefunc extension? please show the \dx results in psql? Jov blog: http:amutu.com/blog http://amutu.com/blog 2013/8/19 pradeep.v.pr...@gmail.com The following bug has been logged on the website: Bug reference: 8386 Logged by: pradeep v Email address: pradeep.v.pr...@gmail.com PostgreSQL version: 9.2.1 Operating system: windows 7 Description: when i execute query SELECT * FROM crosstab( 'SELECT section, status, count FROM t ORDER BY 1,2') AS ct (Section text, Active text, Inactive int); the function crosstab(unknown) does not exist error comes may i know why? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG 5199:ERROR: cannot override frame clause of window xx
http://postgresql.1045698.n5.nabble.com/BUG-5199-Window-frame-clause-wrong-behaviour-td2131492.html tody I hit by this bug and can't find any doc about this, after google I find the bug 5199 reported 4 years ago. it is really nice to improve the error message or doc. Jov blog: http:amutu.com/blog http://amutu.com/blog
[BUGS] BUG #7899: allow key word as alias in subquery but Can't reference it in outer query
The following bug has been logged on the website: Bug reference: 7899 Logged by: jov Email address: am...@amutu.com PostgreSQL version: 9.1.3 Operating system: CentOS 6 Description: xxx=# select 2 from (select 1 as end) t; ?column? -- 2 (1 row) xxx=# select end from (select 1 as end) t; ERROR: syntax error at or near end LINE 1: select end from (select 1 as end) t; ^ xxx=# select version(); version -- PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.5 20110214 (Red Hat 4.4.5-6), 64-bi t (1 row) I think use key word as alias should get a error message such as $key_word is Key Word,should not be used as identifier bla bla,so for some complex query error user can save a lot of time.
Re: [BUGS] BUG #7899: allow key word as alias in subquery but Can't reference it in outer query
I have get the description of this behaviour from doc 7.3.2 http://www.postgresql.org/docs/devel/static/queries-select-lists.html#QUERIES-COLUMN-LABELS . from the error message now,I think syntax error may emmit by the parser,parser error make it hard to get the really condition such as the second token ‘end’ is a select item from a select statement. thanks 2013/2/22 Tom Lane t...@sss.pgh.pa.us =?ISO-8859-1?B?Sm92?= am...@amutu.com writes: xxx=# select end from (select 1 as end) t; ERROR: syntax error at or near end LINE 1: select end from (select 1 as end) t; ^ You need to double-quote the outer use of end, viz regression=# select end from (select 1 as end) t; end - 1 (1 row) In the context with as, Postgres can tell the word is meant as a column identifier not a keyword, but there's no way for it to know that in the outer usage. I think use key word as alias should get a error message such as $key_word is Key Word,should not be used as identifier bla bla,so for some complex query error user can save a lot of time. Well, yours is the first complaint we've ever had in that direction, whereas we used to get a lot of complaints in the opposite direction, back when we didn't allow keywords to be used for column names. So I doubt we'll change it. It is an interesting gotcha though :-( regards, tom lane . -- Jov blog: http:amutu.com/blog http://amutu.com/blog
Re: [BUGS] BUG #7899: allow key word as alias in subquery but Can't reference it in outer query
can we make a cross reference from doc 4.4.1( http://www.postgresql.org/docs/devel/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS ) to doc 7.3.2 ( http://www.postgresql.org/docs/devel/static/queries-select-lists.html#QUERIES-COLUMN-LABELS ) *to mention that “AS” can make a key word to be a identifier?* I have read the doc 4.4.1 and can't find this info from there so I thin it is a bug. 2013/2/22 Jov am...@amutu.com I have get the description of this behaviour from doc 7.3.2 http://www.postgresql.org/docs/devel/static/queries-select-lists.html#QUERIES-COLUMN-LABELS . from the error message now,I think syntax error may emmit by the parser,parser error make it hard to get the really condition such as the second token ‘end’ is a select item from a select statement. thanks 2013/2/22 Tom Lane t...@sss.pgh.pa.us =?ISO-8859-1?B?Sm92?= am...@amutu.com writes: xxx=# select end from (select 1 as end) t; ERROR: syntax error at or near end LINE 1: select end from (select 1 as end) t; ^ You need to double-quote the outer use of end, viz regression=# select end from (select 1 as end) t; end - 1 (1 row) In the context with as, Postgres can tell the word is meant as a column identifier not a keyword, but there's no way for it to know that in the outer usage. I think use key word as alias should get a error message such as $key_word is Key Word,should not be used as identifier bla bla,so for some complex query error user can save a lot of time. Well, yours is the first complaint we've ever had in that direction, whereas we used to get a lot of complaints in the opposite direction, back when we didn't allow keywords to be used for column names. So I doubt we'll change it. It is an interesting gotcha though :-( regards, tom lane . -- Jov blog: http:amutu.com/blog http://amutu.com/blog -- Jov blog: http:amutu.com/blog http://amutu.com/blog