Subject: Re: Calling a function within a function - plpsql - msg#00274

Previous Message by Date: click to view message preview

Re: Backing Up a Postgres database...

On Wed, 2003-09-24 at 13:51, Jonathan Telep wrote: > Hello, I'm not sure who I should be posing this question to but I'm a > System Administrator who has inherited several Debian Linux servers one > of which apparently hosts a rather large Postgres database. One of my > responsibilites is to back that database up each night and be able to > recover it "on the fly" in the event of a problem. I have no idea how > to even check which version of Postgres is loaded on this server, let > alone, be able to back it up. > > Is there anyone who can give me just some basic commands on how to shut > it down each night, back it up, verify that the back up is good and what > to do in the event that I ever have to restore it? I know it seems like > a lot but I'm swamped with a million things to do and would rather not > have to read a couple hundred pages of material if I can avoid it. If Postgresql was installed via apt, then you can start/stop it using /etc/init.d/postgresql. Backup with pg_dump, and restore with pg_restore. http://www.postgresql.org/docs/7.3/static/index.html http://www.postgresql.org/docs/7.3/static/reference-client.html http://www.postgresql.org/docs/7.3/static/app-pgdump.html http://www.postgresql.org/docs/7.3/static/app-pg-dumpall.html http://www.postgresql.org/docs/7.3/static/app-pgrestore.html -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@xxxxxxx Jefferson, LA USA "As the night fall does not come at once, neither does oppression. It is in such twilight that we must all be aware of change in the air - however slight - lest we become unwitting victims of the darkness." Justice William O. Douglas ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx

Next Message by Date: click to view message preview

Re: Concurrency control

Does postgresql implements the FIRST COMMITTER WINS policy of snapshot isolation method? Regards, Radha ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Previous Message by Thread: click to view message preview

Calling a function within a function - plpsql

Hi,   I have created a function(a) that within this function(a) another function(b) is called.  When I execute function(a) I am getting a syntax error near ; message. When I comment out the line of code that calls function(b) then function(a) works fine. When I execute function(b) on its own function(b) works fine.   Does psql support a function calling other functions?      Michael GodshallGMAC Global Relocation Services900 So. Frontage RoadWoodridge, IL 60517630-427-2070 office630-972-2287 faxmichael_godshall@xxxxxxxxxx  

Next Message by Thread: click to view message preview

Re: Calling a function within a function - plpsql

Thank you for the response.  I found the syntax error.  Function(b) was defined to return void so I assumed that when I called function(b) in function(a) that I did not need to assign the result(or lack of in this case) to a variable.  Mike -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Thursday, September 25, 2003 3:10 PM To: Godshall Michael Cc: 'pgsql-novice@xxxxxxxxxxxxxx' Subject: Re: [NOVICE] Calling a function within a function - plpsql Godshall Michael <Michael_Godshall@xxxxxxxxxx> writes: > I have created a function(a) that within this function(a) another > function(b) is called.  When I execute function(a) I am getting a syntax > error near ; message. > When I comment out the line of code that calls function(b) then function(a) > works fine. > When I execute function(b) on its own function(b) works fine.   > Does psql support a function calling other functions?   Certainly.  You're making some syntax error or other, but since you've not shown us your code, we cannot help much.                         regards, tom lane