Josh Berkus wrote:
> You may only UPDATE one table at a time, you can't update a JOIN. So when
> selecting from another table to filter or calculate your update, the form is:
> UPDATE orderchanges
> SET orderchargesbilled = {expression}
> FROM orders
> WHERE orders.orderid = ordercharges.orderid
Hi all,
I've noticed for the first time in some 7.1.2 databases that
I use, that somebody/something managed to insert a literal
alpha value of 'invalid' into 'timestamp with timezone' columns.
I tested it myself, and it worked :
test712=# create table bob (field timestamp);
CREATE
test712=# \d bo
Dear friends,
I am working with Postgres 7.3.4 on RH Linux 7.3.
I could manage to take a backup using the following command
and as the user 'postgres'.
$ pg_dump -h 192.168.2.51 -v -u -f
/home/db_repository/test20031103.sql test
But while I try to execute the same command with the user
