Hi,
I'm starting up a datawarehouse with patitioning.
my etl processes write directly into the corresponding partitions instead of
using triggers.
The reports I run in the datawarehouse are stored in a cache within the same
database.
Now I'd like to store besides the results the dependencies to t
On Sunday, July 10, 2011 11:54:10 am Uwe Bartels wrote:
> Hi,
>
> I'm starting up a datawarehouse with patitioning.
> my etl processes write directly into the corresponding partitions instead
> of using triggers.
>
> The reports I run in the datawarehouse are stored in a cache within the
> same d
Hello
2011/7/10 Uwe Bartels :
> Hi,
>
> I'm starting up a datawarehouse with patitioning.
> my etl processes write directly into the corresponding partitions instead of
> using triggers.
>
> The reports I run in the datawarehouse are stored in a cache within the same
> database.
> Now I'd like t
Hi Adrian,
yes. but this is not the cause for the syntax error.
thanks,
Uwe
On 10 July 2011 21:20, Adrian Klaver wrote:
> On Sunday, July 10, 2011 11:54:10 am Uwe Bartels wrote:
> > Hi,
> >
> > I'm starting up a datawarehouse with patitioning.
> > my etl processes write directly into the co
Hi Pavel,
I don't believe it. the second answer on sunday evening within half an hour.
and it works. excellent!!!
best regards,
Uwe
On 10 July 2011 21:20, Pavel Stehule wrote:
> Hello
>
>
>
> 2011/7/10 Uwe Bartels :
> > Hi,
> >
> > I'm starting up a datawarehouse with patitioning.
> > my etl
Hi Pavel,
is it posible to get this running even with dynamic sql?
I didn't write that. I'm using execute to run this create table
best regards,
Uwe
On 10 July 2011 21:20, Pavel Stehule wrote:
> Hello
>
>
>
> 2011/7/10 Uwe Bartels :
> > Hi,
> >
> > I'm starting up a datawarehouse with pat
2011/7/10 Uwe Bartels :
> Hi Pavel,
>
> is it posible to get this running even with dynamic sql?
> I didn't write that. I'm using execute to run this create table
>
probably yes
postgres=# do $$
declare x text;
begin
execute e'explain(format yaml) select * from data where value = \'a\'' int