[GENERAL] drop user / role if exists

Hi,How under postgreSQL 7 do the equivalent as DROP USER / ROLE  IF EXISTS ?my web provider only support postgreSQL 7 :-(thanks a lot,Maileen Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice.

Re: [GENERAL] drop user / role if exists

On Sun, May 21, 2006 at 02:08:38AM -0700, P.M wrote: > Hi, > > How under postgreSQL 7 do the equivalent as DROP USER / ROLE IF EXISTS ? > my web provider only support postgreSQL 7 :-( Do the DROP USER and ignore the error if it doesn't exist. -- Martijn van Oosterhout http://svana.org/klep

Re: [GENERAL] drop user / role if exists

Thanks Martijn, but i'm currently working on the SQL script to create the full database. Not on some stored procedure.And when i run the SQL script, PostgreSQL stops just on first errorso if user does not exist, my script is not any longer run :-(do you have any idea how to pass over this issue

Re: [GENERAL] drop user / role if exists

On Sun, May 21, 2006 at 02:25:44AM -0700, P.M wrote: > Thanks Martijn, but i'm currently working on the SQL script to create the > full database. Not on some stored procedure. > > And when i run the SQL script, PostgreSQL stops just on first > errorso if user does not exist, my script is not

Re: [GENERAL] drop user / role if exists

To run the script i use :under psql command line, i load my SQL script file via :psql -i myfile;Martijn van Oosterhout wrote: On Sun, May 21, 2006 at 02:25:44AM -0700, P.M wrote:> Thanks Martijn, but i'm currently working on the SQL script to create the full database. Not on some stored procedure.

Re: [GENERAL] drop user / role if exists

On Sun, May 21, 2006 at 02:59:25AM -0700, P.M wrote: > To run the script i use : > > under psql command line, i load my SQL script file via : > > psql -i myfile; Don't know what -i does, it's not a supported option, perhaps you mean -f? In any case, my version of postgres 7.4.7 works fine: $ c

Re: [GENERAL] drop user / role if exists

Hi, On Sun, 2006-05-21 at 02:25 -0700, P.M wrote: > And when i run the SQL script, PostgreSQL stops just on first > errorso if user does not exist, my script is not any longer > run :-( I think you are running your query inside a transaction. Remove the BEGIN and COMMIT parts... -- The Pos

Re: [GENERAL] drop user / role if exists

first of all, it's not -i as i wrote but \ii work under windows OS.and my script is working now.thanks for your helpMartijn van Oosterhout wrote: On Sun, May 21, 2006 at 02:59:25AM -0700, P.M wrote:> To run the script i use :> > under psql command line, i load my SQL script file via :> > psql -i m

Re: [GENERAL] advice on schema for multilingual text

Daniel McBrearty wrote: > Hi > > I have a website that has multilingual text stored in the database. > Currently I just have a flat table (lets called it "translations"), one > row per text item, one column per language. This works OK, for now, but > I am looking at a redesign. Mostly I want to ke

Re: [GENERAL] advice on schema for multilingual text

On Sun, May 21, 2006 at 06:55:18PM +0200, Tino Wildenhain wrote: > > I have a website that has multilingual text stored in the database. > > Currently I just have a flat table (lets called it "translations"), one > > row per text item, one column per language. This works OK, for now, but > > I am

Re: [GENERAL] SQL & Binary Data Questions

Some pointers could help. & any arguments pro/against saving bin data in db? Thanks, Sia ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] another seemingly simple encoding question

kmh496 wrote: > this is a forward of my problem from April. > I have this time gone all the way and re-inited a DB from scratch, > created a new database, documented the import procedure, set the locale > to match but I am still having problems. > For example, look at this match count~ > mod=# se

[GENERAL] PostgreSQL internals. Help needed

Hello all, as part of an University assignment, a group friends and I have to research in PostgreSQL internals (i.e. parsing, optimizing, execution planning, etc) and compare it with other DBMS (an educational oriented one called MiniBase). I would like to know is you can point us to a place where

Re: [GENERAL] PostgreSQL internals. Help needed

Please read the developer's FAQ on our web site. In fact the entire developers section will help you. --- Federico Petronio wrote: > Hello all, > > as part of an University assignment, a group friends and I have to > resea

Re: [GENERAL] SQL & Binary Data Questions

On Fri, May 19, 2006 at 12:21:28 -0700, Siah <[EMAIL PROTECTED]> wrote: > Some pointers could help. & any arguments pro/against saving bin data > in db? If you want transactional semantics you want the data in the DB. If not, then you will probably get better perfomance if it isn't. ---

[GENERAL] "make check" fails over NFS or tmpfs

Hi, We've encountered failures of "make check", when we put PostgreSQL data directory on a NFS filesystem or a tmpfs filesystem. It doesn't always fail, but fails occasionally. Is this expected behavior of PostgreSQL? If it's expected, what is the reason of this symptom? I grep'ed the source cod

Re: [GENERAL] "make check" fails over NFS or tmpfs

SODA Noriyuki <[EMAIL PROTECTED]> writes: > We've encountered failures of "make check", when we put PostgreSQL > data directory on a NFS filesystem or a tmpfs filesystem. > It doesn't always fail, but fails occasionally. Is the NFS filesystem mounted fail-soft? As a rule, database people will tel

Re: [GENERAL] "make check" fails over NFS or tmpfs

Thanks for the reply. > On Mon, 22 May 2006 01:05:38 -0400, Tom Lane <[EMAIL PROTECTED]> said: > SODA Noriyuki <[EMAIL PROTECTED]> writes: >> We've encountered failures of "make check", when we put PostgreSQL >> data directory on a NFS filesystem or a tmpfs filesystem. >> It doesn't always f

Re: [GENERAL] PostgreSQL internals. Help needed

It'd be great if on completion, you can publish the furnished ERD of the catalog structure, and other representation of the planner, optimizer etc.   Luckys.  On 5/22/06, Bruce Momjian wrote: Please read the developer's FAQ on our web site.  In fact the entiredevelopers se