[GENERAL] Server specs to run PostgreSQL

?? What about memory??? How much??? SCSI Disks and 10/100/1000 netcards, it's ok!! No doubt! It's a medium use server, about 3000 transactions/day. Thanks in advance, Marcelo Pereira __ Fale com seus amigos de graça com o novo Yahoo! Messe

[GENERAL] missing FROM-clause (more)

Hi guys, (1) I change postgresql.conf: add_missing_from = off (2) pg_ctl stop (3) pg_ctl start Without success!! The warning is still there!! :( Any ideas Thanks in advance, Marcelo Pereira __ Fale com seus amigos de graça com o novo

[GENERAL] missing FROM-clause

till there!! Thanks in advance, Marcelo Pereira __ Fale com seus amigos de graça com o novo Yahoo! Messenger http://br.messenger.yahoo.com/ ---(end of broadcast)--- TIP 4: Have you searched our lis

[GENERAL] Log Slow Queries

Hi Guys, Is there a feature in PostgreSQL like "--log-slow-queries"(MySQL) ??? Regards, Marcelo P. ___ Abra sua conta no Yahoo! Mail: 1GB de espaço, alertas de e-mail no celular e anti-spam realmente eficaz. http://br.info.

[GENERAL] Regex

Hi All, Is there a way to execute a regex, inside a SELECT statement, to substitute things? For example: SELECT name FROM mytable; name - john michael robert richard chandler I want to substitute all "r" to "-" SELECT myfunction(name) FROM mytable; name - john michael

[GENERAL] Data type to store latitude and longitude

Hi guys, Is there a data type to store data extracted from a GPS? The only thing I need is store latitude and longitude. Thanks in advance, Regards, Marcelo P Campinas/SP/Brazil ___ Yahoo! Acesso Grátis -

[GENERAL] test

just a test ___ Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra uma conta agora! http://br.info.mail.yahoo.com/ ---(end of broadcast)--- TIP 5: Have you

[GENERAL] Simple function

Hi guys, I have a table with two integer fields (field1 and field2)... I would like to construct a function that perform an operation with this two fiels (field1 + fields2), and return the string value "A" if the sum is <20, "B" if the sum is >=20 or <=50, and finally return "C" if the sum is >50

[GENERAL] Last value inserted

m not able to use the last_value() function on the sequence.) Best Regards, Marcelo Pereira Brazil ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso

Re: [GENERAL] Tables and Indexes

>>---------- > >> > >> > >- > > > > > >> > >> > >> > > > > > >-Original Message- > >From: [EMAIL PROTECTE

[GENERAL] Tables and Indexes

Hi guys, Is there a way I can separate things in PostgreSQL? Putting tables in a disk partition and indexes in another one? Regards, MaRcELo PeReiRa PHP/SQL/PostgreSQL __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection

Re: [GENERAL] Number of Active Connections

Hi Elein, Thanks!! It was exactly what I was looking for!!! Regards, Marcelo Pereira Brasil --- elein <[EMAIL PROTECTED]> escreveu: > select count(*) from pg_stat_activity; > > for detailed info use: > > select * from pg_stat_activity; > > On Mon, Sep 13, 2004 a

[GENERAL] Number of Active Connections

Hi guys, How can I know about the number of active connections?? (not the maximum allowed, but the number of open connections). Regards, Marcelo Pereira Brasil __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around

[GENERAL] On Update (trigger hint)

Hi guys, Please, give me some advices on how to do the following: I have the following table: CREATE TABLE products ( idSERIAL, description TEXT, lastupdatedate ); Well, I would like to update the column "lastupdate" with the value "now()" on every UPDATE executed on

Re: [GENERAL] 7.3.4 freezing

Hi guys, > =?iso-8859-1?q?MaRCeLO=20PeReiRA?= > <[EMAIL PROTECTED]> writes: > > And, yes, I was receiving "connection refused" in > the > > cases when the postmaster was gone! > > You didn't say that, you said it froze. Please be > more accurate about > your bug reports in future. A minimum req

Re: [GENERAL] Logging all queries (almost there)

as I have more than one database, how can I know where the [stuff] table is?? Regards, Marcelo --- MaRCeLO PeReiRA <[EMAIL PROTECTED]> escreveu: > Hi Franco, > > If I set 'log_statement=true', will *all* the > queries > sent to the backend be logged??? >

Re: [GENERAL] Logging all queries

> the configuration > file ($PGDATA/postgresql.conf). > > On Tue, 2004-01-27 at 16:39, MaRCeLO PeReiRA wrote: > > > Hi All, > > > > Is there any way to log (save) "all" the queries > > (select, insert, updade, everything) execute

Re: [GENERAL] Lock strategies!

say this gently, but usually > this requirement > suggests that more thinking is required on the > application end. > > Dave > > > > On Mon, 2003-11-24 at 10:48, MaRcElO PeReIrA wrote: > > Dave, > > > > I actually use just the sequence, as you wrote! &g

Re: [GENERAL] Lock strategies!

one. > > and then do an > > insert into forn (descrip) values ( 'some > description' ); > then select curval('forn_id_seq'); > > forn_id will be populated for you with the value > from curval. > > > Dave > > On Mon, 2

[GENERAL] Lock strategies!

Hi guys, I have a simple table: teste=# \d forn Table "public.forn" Column | Type | Modifiers -+-+-- id | integer | not null default nextval('public.forn_id_seq'::text)

[GENERAL] [off-topic] Bugtracker using PostgreSQL

Hi guys, Do you know any web based bug tracker software that use PostgreSQL??? Somebody has told me about Mantis, but it use MySQL... and I resign to use that! :( Which is the best bug tracker you know???(PHP+PostgreSQL) Thanks in advance and Best Regards, Marcelo Pereira Yahoo! Mail - 6MB

[GENERAL] slow down on UPDATE using IN statements

in the last case I would make a software change. Thanks in advance and Best regards, Marcelo Pereira Brazil Yahoo! Mail - o melhor webmail do Brasil http://mail.yahoo.com.br ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [GENERAL] Language C - Console-based FrontEnd

Thanks, I'll check the sites. See ya, Marcelo Pereira -- Remember that only God and Esc+:w saves. __ (_.\ Marcelo Pereira | / / ___ [EMAIL PROTECTED] | / (_/ _ \__Matematica/99 - Imecc | ___\/_\___)___Unicamp__

[GENERAL] Language C - Console-based FrontEnd

begin. Thanks in advance, Marcelo Pereira Programmer ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Select

4 | Bob |any 5 |David | any 6 | Paul |any Now I would like to select all employees which name begins with the letter "P". > Select * from employee where "name-begin-with-letter-P" :-) How can I do it ???

[GENERAL] Delete Cascade

to delete a 'author' in the author table and also all your books in the book table.   When I run   delete from author where author_cod =   I dont get the row deleted if there is a row referenced by in the book table. How can I delete my rows in cascade ???   Thanks in advance,

[GENERAL] Forein Key

Hi,   I'm a new user and I would like to know if I can create my table using forein key's.     Thanks   Marcelo Pereira Computer Programmer