[ADMIN] Create Procedure syntax

2000-10-26 Thread Sivagami .
Hi,   I have 3 simple questions:   1.  What is the exact syntax to create a procedure?   2.  How can I print something to my screen ,e..g, the value of a variable in a stored procedure. Something similar to DBMS_OUTPUT.PUT_LINE in Oracle??   3.  Also, is there any dynamic discussion foru

Re: [ADMIN] disable auto-commit

2000-10-26 Thread John McKown
Well, you could start a transaction. But the record will be deleted once you do a COMMIT. Is that what you want? If you want some way to "delete" an entry, but then to later "undelete" it, there really isn't a way. I have heard of other systems where things were "logically deleted", but recoverabl

[ADMIN] Building in a different directory

2000-10-26 Thread Ian Lance Taylor
I sent a message along these lines yesterday, but never saw a copy. Apologies if this is a repeat. I normally prefer to build packages in directory other than the source directory. When I get a package, I normally do something like this: tar -xzvf foo-1.0.tar.gz mkdir foo-objdir cd f

Re: [ADMIN] disable auto-commit

2000-10-26 Thread Alfred Perlstein
* Joel Pang <[EMAIL PROTECTED]> [001026 04:27] wrote: > In psql, once I delete an entry, it's gone permanently. How do I disable > such auto-commit behavior? by beginning a transaction, just type: "BEGIN;" then with 'COMMIT;' (to commit) or 'ROLLBACK' (to rollback). -- -Alfred Perlstein -

Re: [ADMIN] pg_user, changing priviliges

2000-10-26 Thread Oliver Elphick
Marcin Mazurek wrote: >I'm trying to give a createuser privilige by changing pg_users, i'm logged >in as a superuser. > >mtldb=# select count(*) from pg_user where usename='mtluser'; > count >--- > 1 >(1 row) > >mtldb=# update pg_user set usesuper=true, usecatupd=true

[ADMIN] Re: [SQL] pg_atoi: error in "template1": can't parse "template1"

2000-10-26 Thread Tom Lane
Dronamraju Rajesh <[EMAIL PROTECTED]> writes: >I have installed postgres 6.5.1 on my RedHat Linux > box. The installation went smooth without any > problems. Now when i run initdb I got errors. > Adding template1 database to pg_database... > ERROR: pg_atoi: error in "template1": can't parse

[ADMIN] possible bug in CREATE FUNCTION

2000-10-26 Thread Michel Decima
hello everybody, I was trying playing with the CREATE FUNCTION statement in psql when I made a copy/paste mistake : the function body was empty. The error message was strange: guanabara:~> psql Password: Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distrib

Re: [ADMIN] pg_user, changing priviliges

2000-10-26 Thread Peter Eisentraut
Marcin Mazurek writes: > I'm trying to give a createuser privilige by changing pg_users, i'm logged > in as a superuser. You need to change pg_shadow. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

Re: [ADMIN] pg_user, changing priviliges

2000-10-26 Thread Ross J. Reedstrom
On Thu, Oct 26, 2000 at 08:24:56AM +0200, Marcin Mazurek wrote: > I'm trying to give a createuser privilige by changing pg_users, i'm logged > in as a superuser. > > > Why I can't do it? > reedstrm=> \d pg_user View= pg_user ... Because pg_user is a view on pg_shadow. Can't update a view.

[ADMIN] pg_user, changing priviliges

2000-10-26 Thread Marcin Mazurek
I'm trying to give a createuser privilige by changing pg_users, i'm logged in as a superuser. mtldb=# select count(*) from pg_user where usename='mtluser'; count --- 1 (1 row) mtldb=# update pg_user set usesuper=true, usecatupd=true where usename='mtluser'; UPDATE 0 Why I can't do it

[ADMIN] pg_atoi: error in "template1": can't parse "template1"

2000-10-26 Thread Dronamraju Rajesh
Dear all, I have installed postgres 6.5.1 on my RedHat Linux box. The installation went smooth without any problems. Now when i run initdb I got errors. I have seen the Postgres FAQ also and have ensured that all the directories i,e /usr/local/pgsql, /home/postgres etc are owned by postgres su