[GENERAL] howto escape my string

2009-11-24 Thread Jean-Yves F. Barbier
Hi list, I'm using Gambas to access a PG DB (only through views and functions) and I can't find a way to escape my string to fit into a BYTEA field; does anybody have an idea about this? JY -- Don't drop acid -- take it pass/fail. -- Seen in a Ladies' Room at Harvard -- Sent vi

Re: [GENERAL] howto escape my string

2009-11-24 Thread Jean-Yves F. Barbier
Brian Modra a écrit : The PB comes from Gambas: I think I'm gonna throw the towel and back to Python (too bad, boa is a real piece of shit compared to gambas GUI builder :( > 2009/11/24 Jean-Yves F. Barbier <12u...@gmail.com>: >> Hi list, >> >> I'm using G

Re: [GENERAL] limiting resources to users

2009-11-25 Thread Jean-Yves F. Barbier
Gauthier, Dave a écrit : > Hi: > > > > Is there a way in Postgres to limit how much cpu, memory, other > resources a certain DB gets? A MySQL DB that I’m now replacing with PG > has been having problems with run-away users that pound one DB with > intense processes running periodically in cron

Re: [GENERAL] limiting resources to users

2009-11-25 Thread Jean-Yves F. Barbier
Bill Moran a écrit : > In response to "Gauthier, Dave" : > >> Hi: >> >> Is there a way in Postgres to limit how much cpu, memory, other resources a >>certain DB gets? A MySQL DB that I'm now replacing with PG has been having >>problems with run-away users that pound one DB with intense processe

[GENERAL] transparently log a right error

2009-11-26 Thread Jean-Yves F. Barbier
Hi list, How could I transparently log an error where user miss a right, I know how to write a RULE, but not this way: ie: * user don't have a direct access to tables but to procedures that manipulates tables. * He try to make a: SELECT * FROM table5 which normally returns: "ERROR: right

Re: [GENERAL] Postgres security article

2009-11-28 Thread Jean-Yves F. Barbier
Colin Streicher a écrit : > FYI > I thought it was a good read, hope someone else finds it useful > > http://www.ibm.com/developerworks/opensource/library/os- > postgresecurity/index.html > > Colin Very nice page indeed, Colin, Thanks! -- Aliquid melius quam pessimum optimum non est. -- Se

Re: [GENERAL] What packages I need to install to get Postgres working

2009-12-06 Thread Jean-Yves F. Barbier
Andre Lopes a écrit : > Hi, > > Thanks for your reply. > > I have installed postgresql 8.3, and now, what I need to do to get > things working? Install PGAdmin? Or there are other steps I need to do Daemons are active as soon as installation is completed. > to get things working? For example,

Re: [GENERAL] logs de postgres en debian

2009-12-08 Thread Jean-Yves F. Barbier
oscar arocha a écrit : > Good morning, i write you because, i need know where is log's postgres > into debian lenny, i've read > /var/log/postgresql/postgresql-8.1-main.log, but only could see > > 009-12-06 07:36:02 VET LOG: autovacuum: procesando la base de datos > «postgres» > 2009-12-06 07:37:

Re: [GENERAL] [General] beginner!!!

2009-12-09 Thread Jean-Yves F. Barbier
Joana Camacho a écrit : ... > > su - postgres > createuser radius --no-superuser --no-createdb --no-createrole -P ^^ > createdb radius --owner=radius ^^ There's a slight contradiction... -- *** *** *

Re: [GENERAL] [General] beginner!!!

2009-12-09 Thread Jean-Yves F. Barbier
John R Pierce a écrit : > Jean-Yves F. Barbier wrote: >> Joana Camacho a écrit : >> ... >> >>> su - postgres >>> createuser radius --no-superuser --no-createdb --no-createrole -P >>> >>

[GENERAL] type of field

2010-01-18 Thread Jean-Yves F. Barbier
Hi list, I've got to store many small videos; to make things simple (backup/restore, because users don't know very much about IT) I've choosen BYTEA + EXTERNAL, is it the right choice? JY -- Wait for that wisest of all counselors, Time. -- Pericles -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] type of field

2010-01-18 Thread Jean-Yves F. Barbier
Greg Stark a écrit : > On Mon, Jan 18, 2010 at 8:24 PM, Jean-Yves F. Barbier <12u...@gmail.com> > wrote: >> I've got to store many small videos; to make things simple (backup/restore, >> because users don't know very much about IT) I've choosen BYTEA + EXTER

Re: [GENERAL] pg_dump issues

2010-02-02 Thread Jean-Yves F. Barbier
DM a écrit : > Hi All, > > I have a database with only one schema with 5 tables > > nspname | relname | size > -+-+- > sch | job1 | 211 MB > sch | job2 | 5611 MB > sch |

[GENERAL] dumb but existential question

2006-05-08 Thread Jean-Yves F. Barbier
Hi list, I plan to write an ERP program using Postgresql (with embedded procédures) & Tcl/Tk for the GUI. My question is: how can I recover each column value from an embedded procedure that return a RECORD type? Thanks in advance, Jean-Yves ---(end of

Re: [GENERAL] Arguments Pro/Contra Software Raid

2006-05-09 Thread Jean-Yves F. Barbier
Hi Hannes, Hannes Dorbath a écrit : > Hi, > > I've just had some discussion with colleagues regarding the usage of > hardware or software raid 1/10 for our linux based database servers. > > I myself can't see much reason to spend $500 on high end controller > cards for a simple Raid 1. Naa, you