Re: [GENERAL] log_line_prefix

2013-11-16 Thread hubert depesz lubaczewski
On sob, lis 16, 2013 at 08:44:52 +0530, Jayadevan M wrote: I was trying different options of log_line_prefix. I am making chnages, doing a pg_ctl reload and checking the output in the log files. For some reason ,the changes seem to have no impact. What am I doing wrong? Here is the output form

[GENERAL] Visibility of table aliases in CTEs

2013-11-16 Thread Raymond O'Donnell
Hello all, In a WITH query, are table aliases within a CTE isolated from the rest of the query? For example, if I do this - with my_cte as ( select * from my_table t ) - can I re-use the alias t elsewhere in the same query? I had a dig through the appropriate section of the

Re: [GENERAL] log_line_prefix

2013-11-16 Thread Jayadevan
hubert depesz lubaczewski-2 wrote It looks like you're using csvlog. log_line_prefix is used only for stderr/syslog logging. Yes, that is right. Thank you. -- View this message in context: http://postgresql.1045698.n5.nabble.com/log-line-prefix-tp5778674p5778688.html Sent from the

Re: [GENERAL] Visibility of table aliases in CTEs

2013-11-16 Thread David Johnston
Raymond O'Donnell wrote Hello all, In a WITH query, are table aliases within a CTE isolated from the rest of the query? For example, if I do this - with my_cte as ( select * from my_table t ) - can I re-use the alias t elsewhere in the same query? I had a dig

Re: [GENERAL] Visibility of table aliases in CTEs

2013-11-16 Thread Raymond O'Donnell
On 16/11/2013 15:48, David Johnston wrote: Raymond O'Donnell wrote Hello all, In a WITH query, are table aliases within a CTE isolated from the rest of the query? For example, if I do this - with my_cte as ( select * from my_table t ) - can I re-use the alias t elsewhere