Re: [SQL] Update is very slow on a bigger table

Tom, Yes. it looks like there was some locking condition in the database. in the meantime it disappeared and the updates run quickly. thanks for your help. this is the first time i'm working with PostgreSQL and wasn't sure where to look for possible causes of the problem. thanks, dimitar On T

[SQL] Querying two databases

Hi, I am new to postgres and I need to do a query which joins two tables from different databases. Can you please advice me on how to achieve this in postgres. Thanks! Pallav ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [SQL] Querying two databases

hi, its not possible to join cross database tables . you may keep tables in different schemas instead of databases. you may also try contrib/dblink to use tables from different database. Regds mallah. Pallav Kalva wrote: Hi, I am new to postgres and I need to do a query which joins two table

Re: [SQL] Update is very slow on a bigger table

Hi guys, I would like to create a trigger that execute some programs, is there a way to create a plpgsql function that execute shell command or any other way to run a program? Thanks for your help. Yudie ---(end of broadcast)--- TIP 2: you can get

[SQL] run application from trigger?

Hi guys, I would like to create a trigger that execute some applications, is there a way to create a plpgsql function that execute shell command or any other way to run an application? Thanks for your help. Yudie ---(end of broadcast)--- TIP 8: exp