if you need a scrollable cursor for a prepared statement (to fetch
single rows from huge result sets)
while still being able to execute statements on the same connection
you can do it this way:
PGresult* res = PQprepare( con, "statement1", "declare cu1 scroll
cursor with hold for select * from tab
I'm using PostgreSQL 8.0.0 beta1
I can compile all contrib modules but pgcrypton
i have this error when I execute make
md5.o(.text+0x1ee):md5.c: undefined reference to `bcopy'
md5.o(.text+0x25c):md5.c: undefined reference to `bcopy'
md5.o(.text+0x2ae):md5.c: undefined reference to `bcopy'
md5.o
lect login from people where userid='1';
[ ONLY READ ]
instead of
select login from people where userid='1' for update;
[READ & WRITE]
//
Example 2:
BEGIN WORK;
LOCK TABLE utenti IN SHARE ROW EXCLUSIVE MODE;
select login from peop
calls RelationPhaseInitializePhase2
in heap_openr with RelationName = pg_class at the return r I have the error.
I can't understand whats happen.
Could someone help me ?
Thanks
Maurizio Cauci
.
- Original Message -
From: "Maurizio" <[EMAIL PROTECTED]>
To: "
Message -
From: "Peter Eisentraut" <[EMAIL PROTECTED]>
To: "Maurizio" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, April 02, 2001 6:38 PM
Subject: Re: [HACKERS] QNX : POSSIBLE BUG IN CONFIGURE ?
> Maurizio writes:
>
> > the prob
/data1
datadir=/usr/local/pgsql/share
PGPATH=//1/usr/local/pgsql/bin
TEMPFILE=/tmp/initdb.25146
MULTIBYTE=
MULTIBYTEID=0
POSTGRES_SUPERUSERNAME=maurizio
POSTGRES_SUPERUSERID=100
TEMPLATE1_BKI=/usr/local/pgsql/share/template1.bki
GLOBAL_BKI=/usr/local/pgsql/share/global.bki
Strange. The compiler work with all my old project and also with the old
version of postgresql.
However I will search the problem and I will post the risult.
Maurizio
.
- Original Message -
From: "Peter Eisentraut" <[EMAIL PROTECTED]>
To: "Maurizio" <[
suggestion ?
Thanks
Maurizio CauciDREAMTECH di Cauci
MaurizioVia Ronchetti, 2 - 21013 Gallarate (VA)www.dreamtech-it.com
Config.log
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
^^
Now there is a new line in the table:
|
2001-03-28 | | |0
My question:
How can I resolv my problem? I have a big data file to import where
in the 2nd date field there is '' ins
c warning: cc: cannot find library 'dld'cc warning: cc: cannot find
library 'lc'cc warning: cc: cannot find library 'IPC'cc warning: cc:
cannot find library 'ipc'cc warning: cc: cannot find library 'nsl'cc
warning: cc: cannot find library '
Hi,
I have deleted the include of termios.h in include/port/qnx4.h.
Then I recompiled pgsql and I have compiled a program with ecpg.
All seem to work right.
Thanks
Maurizio
.
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Maurizio" <[
for the Size type?) I send
some e-mails to Dr. Kardos and he tells me that his version working fine.
After the first replay he never didn't replay to me.
Also other QNX users has the same problems I had and send me e-mails to know
if I have compiled successfully PGSQL for QNX. Nobody has had a repl
s me that his version working fine.
After the first replay he didn't replay to me.
Also other QNX users has the same problems I had and send me e-mails to know
if I have compiled successfully PGSQl for QNX. Nobody has had a reply from
Dr. Kardos.
regards
Maurizio Cauci
- Original Messa
pgsql I have changed typedef Size in int insteed
size_t.
regards
Maurizio Cauci
.
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Bruce Momjian" <[EMAIL PROTECTED]>
Cc: "Maurizio" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED
I have tested and works well.
.
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Maurizio" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 7:21 PM
Subject: Re: [HACKERS] 7.1 beta 3 CHANGES FOR QNX
&g
ef
ECHO -OLD
#ifndef
(ECHO ||
defined(__QNX__)) --NEW
Attached are the files
Maurizio CauciDREAMTECH
di Cauci MaurizioVia Ronchetti, 2 - 21013 Gallarate (VA)www.dreamtech-it.com
S_lock.
But, how can I do ?
I have to recall the same routine many times. I tried to prepare and declare
the cursor inside the routine but when I compile with ecpg I receive the
error Cursor already defined.
Maurizio
.
- Original Message -
From: "Michael Meskes" <[EMAIL P
rsion.
Today I also tried POSTGRES 7.0.2 but I obtained the same error.
Please could you give me any other ideas to fix the problem ?
Thanks.
Maurizio Cauci
www.dreamtech-it.com
- Original Message -
From: "Peter Eisentraut" <[EMAIL PROTECTED]>
To: "Maurizio" &
have a
SIGSEGV error.
I don't understand why.
Could someone help me?
Have I to change the configuration of QNX kernel, TCP/IP or postgresql
?
Attached is a log file with the error.
Thanks.
Regards
DREAMTECH
Maurizio Cauci
.
Have I to configure something in POTGRESSQL, in
TCP/IP or in the kernel?
Where I'm wrong?
I have attached a log file with the
error.
Thanks.
DREAMTECH
Maurizio Cauci
server.log
20 matches
Mail list logo
