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
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
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
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
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
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
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
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
(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
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
ave a confirm and if there
is some documentation or information on this
problem available.
Thx,
--
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
>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
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
>> 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
> 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
Thx,
--
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
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
>|/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
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
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
... ;-)
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...
...
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
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
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
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
25 matches
Mail list logo