??
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
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
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
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.
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
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 -
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
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
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
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
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
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
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
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
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
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
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
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)
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
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
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
.
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
,
Marcelo Pereira
Programmer
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
| 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
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
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
26 matches
Mail list logo