Re: [SQL] reply to setting

2004-08-22 Thread Greg Stark
Joe Conway [EMAIL PROTECTED] writes: This is very true. In fact, I get mildly annoyed when people *don't* include the direct reply to me, because I very actively filter/redirect my mail. Replies directly to me are pretty much guaranteed to be seen quickly, but the ones that go to the list

[SQL] pg_dump/pg_restore question

2004-08-22 Thread Worik
Freinds I am new to this list, and this is my first message. I hope this is the correct forum, and the question not too stupid/simple. I have a database on a debian stable system... dpkg -l postgresql [snip] ii postgresql 7.2.1-2woody5 Object-relational SQL database, descended fr When I

Re: [SQL] sleep function

2004-08-22 Thread Greg Stark
John DeSoi [EMAIL PROTECTED] writes: On Aug 10, 2004, at 10:57 AM, Bruce Momjian wrote: I can't think of one, no. I think you will have to use one of the server-side languages and call a sleep in there. This is no good in the real world since it pounds the CPU, but it worked well

Re: [SQL] only last records in subgroups

2004-08-22 Thread Greg Stark
Dino Vliet [EMAIL PROTECTED] writes: x,0 and y,4 but how do I manage this in sql? I was hoping for a keyword LAST or so, where I can specify that when I've ordered my results with order by, I could only get the last of the subgroups (the first one is easy because I could use limit 1)

Re: [SQL] pg_dump/pg_restore question

2004-08-22 Thread Iain
Hi Worik, I can't address the specifics of your problem but I'll give you an example of I do it on a 7.4 db. I dunno if all options are available on your version. To get the backup: pg_dump --format=c -v DBNAME FILENAME.dump To restore you have to create a new DB (drop the old one first if