[ADMIN] 7.1.3 -> 7.3.2

2003-12-28 Thread Сизых Павел Леонидович
Hi, All! Sorry for my english. Try to upgrade 7.1.3 -> 7.3.2 In 7.1.3 pg_dump -o abon_koi > backup In 7.3.2 createdb abon_koi psql -d abon_koi -f backup Run user application, try to "select * from towns"; postgres.log: ERROR: i.oid: no such attribute Why?? -- /grf -

Re: [ADMIN] CREATE USER system privilege?

2003-12-28 Thread Tom Lane
Oli Sennhauser <[EMAIL PROTECTED]> writes: >> You need to use EXECUTE to construct this query as a string. > Facit: pgplsql does not work for my problem, execute does not work problem. I didn't think I would have to spell it out in gory detail ... regression=# create or replace function cruser(t

Re: [ADMIN] CREATE USER system privilege?

2003-12-28 Thread Oli Sennhauser
Hello Tom You need to use EXECUTE to construct this query as a string. Utility statements in general don't handle parameters. Ok. I tried out: PREPARE create_user(varchar) AS SELECT $1; ok EXECUTE create_user('otto'); ok DEALLOCATE create_user; ok PREPARE create_user(varchar) AS CREATE USER $1