[SQL] Table locks

2004-10-06 Thread Jaime Casanova
--- Tom Lane <[EMAIL PROTECTED]> escribió: > Andreas Seltenreich <[EMAIL PROTECTED]> writes: > > Jake Stride writes: > >> I thought of doing: > >> SELECT max(jobno) from jobs where companyid=1; > > > I think SELECT FOR UPDATE should work fine here. > > Nope; he'll get something like > > regres

Re: [SQL] Database Backup

2004-10-06 Thread sklassen
* sreejith s <[EMAIL PROTECTED]> [2004-10-06 08:09:38 +0530]: > Now i am working on Linux database server/Windows Client project. I > have a doubbt. How to take DB backup from my windows client machine > where DB is intsalled at linux server. pg_dump doen't works from > windows client butr its wo

Re: [SQL] Howto turn an integer into an interval?

2004-10-06 Thread Erik Wasser
On Tuesday 05 October 2004 13:44, you wrote: > If you know for sure that you are keeping resend_interval in seconds, > then try as follows: > > foodb=# SELECT (59::text||' secs')::interval; > interval > -- > 00:00:59 > (1 row) Thanks for this solution and the others. It's now working v