Re: [GENERAL] log_line_prefix
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 the log files where you can see the change being accepted (reload) and then the output of a select now(). 2013-11-16 08:24:50.657 IST,,,3186,,5286c0d6.c72,5,,2013-11-16 06:18:22 IST,,0,LOG,0,received SIGHUP, reloading configuration files, 2013-11-16 08:24:50.657 IST,,,3186,,5286c0d6.c72,6,,2013-11-16 06:18:22 IST,,0,LOG,0,parameter log_line_prefix changed to %t , It looks like you're using csvlog. log_line_prefix is used only for stderr/syslog logging. Best regards, depesz signature.asc Description: Digital signature
[GENERAL] Visibility of table aliases in CTEs
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 docs, but the answer wasn't obvious to me there. Thanks, Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] log_line_prefix
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 PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Visibility of table aliases in CTEs
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 through the appropriate section of the docs, but the answer wasn't obvious to me there. This seems like one of those just try it and see what happens kind of question. But since I'm mobile and cannot run SQL I'll just say that such an alias is indeed hidden. No different than: Select * from (tbla as alpha natrual join tblb as beta) as ab natural join tbla as alpha David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Visibility-of-table-aliases-in-CTEs-tp5778687p5778692.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Visibility of table aliases in CTEs
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 in the same query? I had a dig through the appropriate section of the docs, but the answer wasn't obvious to me there. This seems like one of those just try it and see what happens kind of question. But since I'm mobile and cannot run SQL I'll just say that such an alias is indeed hidden. No different than: Select * from (tbla as alpha natrual join tblb as beta) as ab natural join tbla as alpha Thanks David - I did indeed try it, and it seemed to be the case, but as I'm not any kind of expert I wanted to make sure that my empirical results were correct. :-) Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general