[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! Messenger http

[GENERAL] missing FROM-clause

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 list archives

[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] 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.

[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

[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. So I

[GENERAL] Last value inserted

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.yahoo.com

[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] Tables and Indexes

PROTECTED] tél : 01 69 29 36 18 -- - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MaRCeLO PeReiRA Sent: jeudi 28 octobre 2004 15:04

[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

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 at 02:49:36PM -0300, MaRCeLO PeReiRA

[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 a

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 requirement is

Re: [GENERAL] Logging all queries

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) executed on a database, in a table?? Regards, Marcelo

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

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??? In which table will it be used to do this log

[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)

Re: [GENERAL] Lock strategies!

On Mon, 2003-11-24 at 08:20, MaRcElO PeReIrA wrote: Hi guys, I have a simple table: teste=# \d forn Table public.forn Column | Type | Modifiers -+-+-- id

Re: [GENERAL] Lock strategies!

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! The biggest problem it that I *can't* have holes in that column, so it was because I used id (serial) and forn_id (integer). All other

[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

. 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? http://www.postgresql.org/docs/faqs

[GENERAL] Language C - Console-based FrontEnd

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

[GENERAL] Select

| 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 ??? Thanks

[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 = number 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, Marcelo Pereira

[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