Hi all,
While testing the 9.3 beta I am unable to get the view definition for
some views.
Because of this I cannot use pg_dump to create a valid dump of the
specified database.
ERROR: unrecognized node type in join alias vars: 309
- I can select from the views and the results are valid.
- The v
On 2013-07-22 13:22:21 +0200, Feike Steenbergen wrote:
> While testing the 9.3 beta I am unable to get the view definition for
> some views.
> Because of this I cannot use pg_dump to create a valid dump of the
> specified database.
Any chance you can post a schema only dump from 9.2 that reproduce
The following bug has been logged on the website:
Bug reference: 8317
Logged by: Rémi
Email address: remi.c...@gmail.com
PostgreSQL version: 9.2.4
Operating system: Ubuntu 12.0.4 32 bits hosted by a VirtualBox
Description:
Hello;
I ran into a strange behaviour.
Initia
On 2013-07-22 09:44:58 +, remi.c...@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8317
> Logged by: Rémi
> Email address: remi.c...@gmail.com
> PostgreSQL version: 9.2.4
> Operating system: Ubuntu 12.0.4 32 bits hosted by a Virtual
2013/7/22 :
> The following bug has been logged on the website:
>
> Bug reference: 8317
> Logged by: Rémi
> Email address: remi.c...@gmail.com
> PostgreSQL version: 9.2.4
> Operating system: Ubuntu 12.0.4 32 bits hosted by a VirtualBox
> Description:
>
> Hello;
> I ran into a
the attached dump can be loaded and results in an error message when
retrieving the view definitions.
On Mon, Jul 22, 2013 at 2:04 PM, Feike Steenbergen
wrote:
> I can reproduce it with the attached dump.
>
>
>
> On Mon, Jul 22, 2013 at 1:26 PM, Andres Freund wrote:
>> only
unrecognized_node_t
Feike Steenbergen writes:
> the attached dump can be loaded and results in an error message when
> retrieving the view definitions.
Thanks for the test case. It looks like I broke this in commit
2ffa740b, as a result of believing the comment in parsenodes.h that says
joinaliasvars lists can only
The following bug has been logged on the website:
Bug reference: 8318
Logged by: G.Bakalarski
Email address: g.bakalar...@icm.edu.pl
PostgreSQL version: 9.1.3
Operating system: Linux Debian 6 (squeezy)
Description:
When doing these kind of statements (this is from log
Hi, thanks for your quick answers.
To close this non-bug :
According to the doc (
http://www.postgresql.org/docs/9.2/static/sql-syntax-lexical.html#SQL-SYNTAX-OPERATORS
)
, multiplication has precedence on division. (I supposed it implicitely)
So anyway the query is parsed as ( 1/ (2*3.2)) and ( 3
