Hello there,
I have a problem using pl/pgsql (distributed in version 6.4.1).
We are using PostgreSQL for an ordering-system as a part of a new data warehouse. At this moment we have about 10K rows
andit works great!
Now we are testing it for a much amount of data (sales report) of about 1.5GB in size.
My first question is: is this the right place to post such bug reports?
Ok, following pl/pgsql statements doesn´t work:
--------
create table t1 (i int, a int, b int);
CREATE
create table t2 (i int, x int, y int);
CREATE
insert into t1 values(1, 1,10);
INSERT 35140214 1
insert into t1 values(1, 2,10);
INSERT 35140215 1
insert into t1 values(2, 3,10);
INSERT 35140216 1
insert into t1 values(2, 4,10);
INSERT 35140217 1
create function func1()
returns int
as 'declarebegin insert into t2 select i, sum(a) as x, sum(b) as y from t1 group by i; return
1;end;
' language 'plpgsql';
CREATE
select func1();
func1
----- 1
(1 row)
select * from t2;
i| x| y
-+--+--
1|20|20
2|20|20
(2 rows)
-------------
Using the insert/select-statement directly (via psql) it works fine.
And one additional (last) question:
In pl/sql writing select * into table2 from table1 ... seems to be interpreted that table2 is a pl/sql-variable and
nota table. So it doesn´t work. Is it a bug or is there an other way to select directly into a (new) table.
Kind regards
Michael Contzen
Dohle Handelsgruppe Systemberatung GmbH,
Germany