Re: Problem in 'select' from temp table with Perl/DBI

samik(at)cae(dot)wisc(dot)edu (Samik Raychaudhuri) writes:
> $query="select date_part('month', date) as month, date_part('year',
> date) as year into temp counter from weblogs;
> select month || '-' || year, count(*) from counter group by
> month, year;
> ";

> When I run this code, I get the following error message:
> DBD::Pg::st execute failed: ERROR: Relation 'counter' does not exist
> at counter.pl line 56.

You didn't say what postgres version you are using, but on older
versions I think it'd be necessary to issue those commands as two
separate statements. PG used to try to parse all the commands in
a querystring before executing any of them.

regards, tom lane