Re: regression in 8.8.2 [was Re: [GENERAL] Very strange error]

On Tue, Feb 06, 2007 at 01:19:28PM -0500, Bruce Momjian wrote: > This is a known bug in 8.2.2 and we are discussing methods of > distributing the fix as quickly as possible. Ok great! Take your time, thanks. ---(end of broadcast)--- TIP 3: Have you

Re: regression in 8.8.2 [was Re: [GENERAL] Very strange error]

On Tue, Feb 06, 2007 at 03:23:29PM -0300, Alvaro Herrera wrote: > The fix is already in the REL8_2_STABLE branch, so Andrea can certainly > update and confirm if his problem is fixed. Confirmed, after the last cvs checkout it works fine. thanks! ---(end of bro

[GENERAL] Newby Help needed

om only archive-status directory... Some one can help in understanding these ?? Many thanks in advance to any one will post an answer.. --Andrea -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

pgsql-general@postgresql.org

ot locate a valid checkpoint record LOG: startup process (PID 22672) was terminated by signal 6 LOG: aborting startup due to startup process failure LOG: logger shutting down . Someone can help in understanding where is the problems ??? Thanks in advance, --Andrea -- Sent via

pgsql-general@postgresql.org

ot locate a valid checkpoint record LOG: startup process (PID 22672) was terminated by signal 6 LOG: aborting startup due to startup process failure LOG: logger shutting down . Someone can help in understanding where is the problems ??? Thanks in advance, --Andrea -- Sent via

[GENERAL] Help needed in PITR

a valid checkpoint record LOG: startup process (PID 22672) was terminated by signal 6 LOG: aborting startup due to startup process failure LOG: logger shutting down . Someone can help in understanding where is the problems ??? Thanks in advance, --Andrea -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

regression in 8.8.2 [was Re: [GENERAL] Very strange error]

On Tue, Feb 06, 2007 at 10:09:16AM -0500, Michael Slattery wrote: > When does this error crop up? What is the query? Does this select > involve more than one table, or does it involve any homemade > functions? Or overriden functions? My application broke in a big way with the security updat

[GENERAL] Pgpool-II and Slony-I : query lag, sequences and stored procedures need help

the pgpool mailing list, but so far no answer. Thanks in advance! Regards, Andrea Moretto Andrea Moretto [EMAIL PROTECTED] --- CONFIDENTIALITY NOTICE This message and its attachments are addressed solely to the persons above and may conta

[GENERAL] Query planner issue

(co_id)::text) = '010076015372010076015372'::text) Same thing if I try to trick it using a view or a stored procedure. Query planner is not easy to trick! My question is : is there a way to use the index or isn't it possible? Thanks in advance. Andrea Moretto Andrea Moretto

Re: [GENERAL] Query planner issue

Dear Richard, you are right. So Postgres takes a lot of time to get out an impossible result! The query I wrote is just a test, the concatenation is only a dummy. On 19/set/08, at 12:33, Richard Huxton wrote: Andrea Moretto wrote: I've got a table called DETAILS, the primary k

[GENERAL] Adding "quota user limit" using triggers

ave a confirm and if there is some documentation or information on this problem available. Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù -

[GENERAL] Adding "quota user limit" using triggers

>on 06/08/11 11:14 PM, Andrea Peri wrote: >Hi, > > >Is possible the limit the size of an user (quota user) as space allocated in a tablespace ? >I don't find this option in the 9.0 version of PG, >so I think it is not available. > >Perhaps it should be possib

[GENERAL] Problem with temporary tables

Hello. I am trying to use temporary tables inside a stored procedure, but I get a rather puzzling error. I am currently using PostgreSQL 8.2.7 and this is my stored procedure: CREATE OR REPLACE FUNCTION test() RETURNS bigint AS $$ DECLARE v_oid bigint; BEGIN -- create tmp-table used to ma

Re: [GENERAL] Problem with temporary tables

>> Am I doing something wrong or is this a bug? > > The plan is cached, to avoid this problem, use dynamic SQL. In your > case: > > EXECUTE 'CREATE TEMPORARY TABLE idmap ...' Nice idea, but the problem persists, see log below. I am beginning to mentally place this into the 'bug' area :) CREATE

Re: [GENERAL] Problem with temporary tables

> You need to use EXECUTE for the INSERT statement as well per error: > > CONTEXT:  SQL statement "INSERT INTO idmap (oldid, type, newid) VALUES(1, >  1, 1)" PL/pgSQL function "test" line 16 at SQL statement Thanks, this works and solves my problem. Still, I find this behaviour to be rather quirk

[GENERAL] PG 9.1.1 - availability of xslt_process()

Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù -

[GENERAL] make[2]: *** [psql] Error 1

when I compile postgres 6.3.2 under linux I have this error with "make all" and "make install": from make install: /usr/lib/libreadline.a(terminal.o): In function `_rl_enable_meta_key': terminal.o(.text+0x7ce): undefined reference to `tputs' /usr/lib/libreadline.a(terminal.o): In function `_rl

Re: [GENERAL] make[2]: *** [psql] Error 1

>|/usr/lib/libreadline.a(terminal.o): In function `_rl_enable_meta_key': >|terminal.o(.text+0x7ce): undefined reference to `tputs' >|/usr/lib/libreadline.a(terminal.o): In function `_rl_control_keypad': >|terminal.o(.text+0x7fb): undefined reference to `tputs' >|terminal.o(.text+0x822): undefine

Re: [GENERAL] make[2]: *** [psql] Error 1

On 13-Oct-98 Marc G. Fournier wrote: >> > This is a compiler option that will tell the linker to link in the ncurses >> > routines. >> > >> > Hope this helps...james >> > >> >> >> >> >> Ok, now the question is: where? >> >> I add it in Makefile.global, but nothig. > > ave you patch

[GENERAL] Lock record

an entire table. I'm using ADO, and it seem possible to lock a record by opening a recordset on it (with a proper query) and keeping that recordset open (I think that it's the cursor that keeps the lock on the db). Anyone knows a different/better method? Thanks Andrea

[GENERAL] count & distinct

... ;-) Thanks in advance Andrea PS: well, of course I can open a cursor on a "select distinct column from table" and then loop over the cursor couting how many values there are, but it seem a bit ugly...

[GENERAL] PostgreSQL on NT: new cygwin?

... is there anyone who has experience on that kind of installation? I've tried to download http://www.s34.co.jp/~luster/pgsql/cygwin32_ipc-1.03-bin-patched.tar.bz2 but bzip2 keeps telling me that this package is corrupted. Anyone has some experience? Bye Andrea

[GENERAL] NT + cygipc + postgresql = boom!

es... Joost was right, it seems to be cygipc fault, the above error message is raised from sem.c in cygipc sources... Is there anyone who knows how to solve this problem? Andrea

[GENERAL] Need the binary of PG9.0 for Windows 32bit

Hi, I need to download the build of Postgres 9.0 compiled for win32bit. I see there is available the 9.0.1 version. But I'm searching specifically the 9.0 for a test. There some link with old binaries ? Thx, Andrea Peri. -- Sent via pgsql-general mailing list (pgsql-general@postgresq

[GENERAL] [PHP] unsubscribe

unsubscribe LIBIA ANDREA RAMOS SÁNCHEZ INGENIERO DE SISTEMAS ESCUELA COLOMBIANA DE INGENIERIA CEL. 3103271242 OFC. 5452799 - 2550469 CMN-Consulting _ Charla con tus amigos en línea mediante MSN Messenger: http