[GENERAL] PANIC: ERRORDATA_STACK_SIZE exceeded

hi! i have postgresql 8.3.12 and i got the eror: PANIC: ERRORDATA_STACK_SIZE exceeded This happens after insert 1000 registers on a table every 1 minute during 3 hours. any idea, why this happened??? # - # PostgreSQL configuration file #

[GENERAL] why sometimes checkpoint is too slow????

why sometimes checkpoint is too slow and how can i do to avoid that??? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] undefined symbol PQconnectionNeedsPassword referenced by file pg_ctl.o

Hi, i tried to compile postgres 8.3.13 but i got the next error: Undefined first referenced symbol in file PQconnectionNeedsPassword pg_ctl.o ERROR: Symbol referencing errors. No output written to pg_ctl cc -b elf -O pg_ctl.o -L../..

[GENERAL] about memory size reported by system.

Hi everyone! I have a doubt about the memory consumed by each connection open. suddenly my server, running postgres 8.3.11, began to run too slowly. Checking the process with: ps -adelfo pcpu,vsz,args | more The processes,related to the connection to the db, each one have a consume of m

[GENERAL] Forcing the use of one index instead other.

Hello there! I have two index with a same field into them like this: create index numberfail on Events (numberfail); and create index failtype on Events (numberfail,eventtype); then i ran explain analyze and always took the numberfail index but i wish the failtype index; this is

[GENERAL] Executing \i of psql command using libpq library

Hi! How can i get the same behavior of psql -c "\\i './a_lot_of_sentences'" bd user, using the libpq library??? i tried Pqexec(pgconn,"\\i './a_lot_of_sentences'") but didn't work. :( -- SENSA Control Digital. Ing. Edmundo Robles Lopez. Analista Programador. -- Sent via pgsql-gener

[GENERAL] OFFTOPIC -- pgpool list is down?????

Do you know if the pgpool list is down???, i sent many emails to the pgpool list but since last week i can't receive any mail from pgpool list , i checktheir web site too, but the last message are of june. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To m

[GENERAL] getting the last N tuples of a query

Hi! if a want the first 5,10,N tuples of a query (even without order) i just have to do a: select * from table limit 10; but, What can i do to get the last 10 tuples ??? i try to do: select * from table limit -10; :-D but that query return 0 tuples . So, what is the right way to

[GENERAL] about scape characters

Hi!, maybe is a silly question but... Exists some syntax standard to escape especial characters on querys??? i mean, the notation E'\\ to escape especial characters only works in postgres (8.3.11) or this works on oracle, ms sql server too??? regards, eddie. -- Sent via pgsql-general mai

[GENERAL] Question about SCO openserver and postgres...

Hi! I have a problem with the max postgres connections on SCO Openserver 5.0.7, so ...my boss decided to buy the SCO Openserver 6.0 but this version comes in 2 editions: Starter and Enterprise. If SCO 5.0.7 only allows 95 ( -3 used by superuser) connections to postgres... Do you kno

Re: [GENERAL] Question about SCO openserver and postgres...

On 07/22/2010 05:39 PM, Scott Marlowe wrote: > On Thu, Jul 22, 2010 at 3:24 PM, Edmundo Robles L. > wrote: > >> Hi! >> I have a problem with the max postgres connections on SCO >> Openserver 5.0.7, so ...my boss decided to buy the SCO Openserver 6.0 >&

[GENERAL] Relation raltion_name with OID ##### no longer exists

Hi ! i have the above error when i tried to insert a register, How can i solve this issue???' regards . -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] how many connections can i use????

Hello there! I have a problem with the number of connections on postgres 7.2.1, yeah is a quite older :-) but i have it running on SCO OpenServer 5.0.7 and tried to change the number of connections above 100 but, i only got 100 sometimes 101 but no more. I changed the parameters li

FW: [GENERAL] how many connections can i use????

"Edmundo Robles L." writes: > I have a problem with the number of connections on postgres 7.2.1, -->egad ... the number of known bugs in that would curl your toes. -->Think about an upgrade. Do more than just think about it. yes, maybe the upgrade solve that proble

FW: [GENERAL] lack in psql console

in the psql prompt try this: \! stty sane Ing. Edmundo Robles Lopez. Analista Programador. -- -Original Message- From: pgsql-general-ow...@postgresql.org on behalf of Juan Camilo Marín Sent: Wed 5/13/2009 12:58 PM To: Craig Ringer Cc: pgsql-general@postgresql.org Subject: Re: [GENER