On 06/29/2010 10:19 AM, Adrian Klaver wrote:
On Tuesday 29 June 2010 7:47:32 am erobles wrote:
Hi!, thanks for your answer
How many results are being returned for id=72 vs other ids?
the tuples returned for id=72 are 91 (is too short :-( ), for id=71
are 94 for id=10
Hi!
I have 3 pc's:
pc 'A' with postgres 7.2 running
pc 'B' and 'C' connected to 'A'
You should upgrade as quickly as possible. 7.2 is ancient. Even 8.1 will
hit end-of-life soon.
We are testing postgres 8.3.11 to detect any problem when we migrate
from 7.2 :
Original Message
Subject:Re: [GENERAL] Weird trouble with select
Date: Tue, 29 Jun 2010 09:13:14 -0500
From: erobles
Organization: SENSA Control Digital
To: Joshua Tolley
On 06/29/2010 08:59 AM, Joshua Tolley wrote:
On Tue, Jun 29, 2010 at 08:44:35AM
Hi!
I have 3 pc's:
pc 'A' with postgres 7.2 running
pc 'B' and 'C' connected to 'A'
if i made the next query on 'B' or 'C' : "select * from detail with
id=72"; takes too long time to return the data, near of 10 minutes
more or less.
if i made the next query on 'B' or 'C' : "sele
On 06/07/2010 07:44 AM, Joshua Tolley wrote:
What does it say when it refuses connections above 94? Also, when you
connect:
This is the message:
LOG: could not fork new process fro connection: Resource temporarily
unavailable...
and those are the kernel's resources values:
NODE"srvr8
Hello! I have postgres running on SCO OpenServer 5.0.7
and I've noticed that only accepts up to 94 connections, no more ...
I modified the values in postgresql.conf
max_connections from 100 to 128
shared_buffers from 24 to 48 MB
postgres is started with:
su - postgres -c "/usr/local/pgsql83/
On 05/28/2010 04:58 PM, Adrian Klaver wrote:
On Friday 28 May 2010 1:34:24 pm erobles wrote:
On 05/28/2010 03:18 PM, alvherre wrote:
Excerpts from erobles's message of vie may 28 16:08:23 -0400 2010:
it did'nt work :-( , because the script is for pg 8.2 and
On 05/28/2010 03:34 PM, erobles wrote:
On 05/28/2010 03:18 PM, alvherre wrote:
Excerpts from erobles's message of vie may 28 16:08:23 -0400 2010:
it did'nt work :-( , because the script is for pg 8.2 and i have pg
7.2 and the table pg_cast doesn't exist. whatever is a
On 05/28/2010 03:18 PM, alvherre wrote:
Excerpts from erobles's message of vie may 28 16:08:23 -0400 2010:
it did'nt work :-( , because the script is for pg 8.2 and i have pg
7.2 and the table pg_cast doesn't exist. whatever is a good idea but i
need to know the table or tables
On 05/28/2010 02:04 PM, erobles wrote:
On 05/28/2010 01:51 PM, Adrian Klaver wrote:
On 05/28/2010 11:45 AM, erobles wrote:
On 05/28/2010 01:26 PM, Adrian Klaver wrote:
On 05/28/2010 11:20 AM, erobles wrote:
hi!
only for ask, there is a way to deactivate type validation, so i
can do
On 05/28/2010 02:16 PM, Tom Lane wrote:
Gary Fu writes:
Nilesh Govindarajan wrote:
Could you please explain a little more what you want to do actually ?
I have the following problem to run 'configure' when building pgpool
2.3.3 with libpq from normal built of postgreSQ
On 05/28/2010 01:51 PM, Adrian Klaver wrote:
On 05/28/2010 11:45 AM, erobles wrote:
On 05/28/2010 01:26 PM, Adrian Klaver wrote:
On 05/28/2010 11:20 AM, erobles wrote:
hi!
only for ask, there is a way to deactivate type validation, so i
can do
select rtrim(number_field) from table
On 05/28/2010 01:26 PM, Adrian Klaver wrote:
On 05/28/2010 11:20 AM, erobles wrote:
hi!
only for ask, there is a way to deactivate type validation, so i can do
select rtrim(number_field) from table ; with no error and the message:
"You might need to explicit type casts"
this i
hi!
only for ask, there is a way to deactivate type validation, so i can do
select rtrim(number_field) from table ; with no error and the
message: "You might need to explicit type casts"
this is postgres 8.3.1.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
On 05/27/2010 10:29 AM, Craig Ringer wrote:
On 27/05/2010 10:42 PM, erobles wrote:
hi,
i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7
Possibly stupid question: Why?
Do you need the Pg server to run on SCO OpenServer?
Yes, i need it :-P
Before i have running pg 7.2 after we
i have been using gcc 2.95.2 to compile
On 05/27/2010 10:02 AM, Tom Lane wrote:
erobles writes:
i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7, but ...
when the xlog.o is being compiled i have the next error:
/usr/tmp/ccihgiYL.s: 1113: syntax error at name
was deleted...
What can i do to solve this? by the way i've compiled postgres 8.3.1
and i don't have problem.
Regards,erobles.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
is no need to clean WAL
files after recovery. where exactly is the problem ?
regards
andreas
erobles wrote:
PITR recovery
On 05/21/2010 03:04 PM, Andreas Schmitz wrote:
erobles wrote:
which is the right procedure to clean wal files after a recovery ??
what kind of recovery ?
regards
an
raint matching given keys for referenced
table "table_name'"
there is a way to solve this?? what can i do ??
regards, erobles
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
PITR recovery
On 05/21/2010 03:04 PM, Andreas Schmitz wrote:
erobles wrote:
which is the right procedure to clean wal files after a recovery ??
what kind of recovery ?
regards
andreas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
which is the right procedure to clean wal files
after a recovery ??
hi !
I have running postgres 8.3.1 and a dump file from postgers 7.2
:-P , but when i tried to restore the dump i have the next
message:
(by the way i made the dump file using pg_dump of postgresql 8.3)
CREATE CONSTRAINT TRIGGER "valida_ent_a_sal" AFTER DELETE ON "ent_a"
IN
i forgot, the version of postgresql is 8.3.1
througth pg_ctl or postmaster or postgres ??
erobles wrote:
Which
is the best way to start postgres
througth pc_ctl or postmaster
--
La información contenida en este correo electrónico es confidencial de
Sensa
Which is the best way to start postgres
througth pc_ctl or postmaster
--
La información contenida en este correo electrónico es confidencial de Sensa
Control Digital, S.A. de C.V. Está dirigido solamente a la dirección de correo
señalada. El acceso a este correo electrónico por cual
hi!
i compiled Postgres 8.4.0 on SCO Openserver but when i want install it
, i got the follow error:
./zic: wild compilation-time specification of zic_t
what can i do to fix that error???
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscr
Hi! i have an error when i try to add/create a plpgsql language in
Postgresql 8.3.1 on SCO Openserver 5.0.7
createlang: langauge installation failed: ERROR could not access file
"$libdir/plpgsql": No such file or directory.
But, the file plpgsql.so exists in the directory, please,could you
Hi! i have an error when i try to add/create a plpgsql language in
Postgresql 8.3.1 on SCO Openserver 5.0.7
createlang: langauge installation failed: ERROR could not access file
"$libdir/plpgsql": No such file or directory.
But, the file plpgsql.so exists in the directory, please,could you
Hi i have been compiling the Postgres 8.4 on SCO OpenServer 5.0.7 but
when the pg_config is linking i got the next error:
Undefined
symbol
get_html_path
first referenced in file pg_config.o
where can i find this function to make a success compiling of postgres???
by the way i search
erobles wrote:
Hi!
In postgresql 7.2 i can use this kind of querys:
select table.* ;
select * from table1 where table1.key=othertable.key;
but in postgresql 8.3 i have an error like this:
ERROR: missing FROM-clause entry for table ...
what should i do to solve this
Hi!
In postgresql 7.2 i can use this kind of querys:
select table.* ;
select * from table1 where table1.key=othertable.key;
but in postgresql 8.3 i have an error like this:
ERROR: missing FROM-clause entry for table ...
what should i do to solve this? :-)
hi !
While i'm searching on google :-P , to find a software to replicate
a postgres database, i love read your suggestion about the
replication, so i can shrink my research, no matter if the replication
software isn't free, by the way the version of postgres is 8.2.
i don't w
cachable" string the fucntion was created succesfully.
erobles wrote:
erobles wrote:
Hello there!
i tried to create an functional index like this:
create index estdistfecha on estadist (date(fecha));
but only get the next message:
ERROR: DefineIndex: index function must be marked
erobles wrote:
Hello there!
i tried to create an functional index like this:
create index estdistfecha on estadist (date(fecha));
but only get the next message:
ERROR: DefineIndex: index function must be marked iscachable.
So, How can i mark the date function iscachable ? :-)
i hope
Mark Watson wrote:
*>De :* pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] *De la part de* Andrew
Maracini
>*Envoyé :* 3 août 2009 11:46
>*À :* pgsql-general@postgresql.org
>*Objet :* [GENERAL] \copy command error
>
>hi,
>
>I can't seem to get the \copy comm
34 matches
Mail list logo
