Hi.
I use libpq in my program. And I can retrieve int and symbolic fields
as simple as
int unameFN, moneyFN...
char *unamePTR, *moneyPTR...
unameFN = PQfnumber(res, uname);
moneyFN = PQfnumber(res, money);
unamePTR = PQgetvalue(res, 0, unameFN);
moneyPTR = PQgetvalue(res, 0, moneyFN);
themoney
2010/6/16 Tom Lane t...@sss.pgh.pa.us:
But it success only at first time, and then fail with error:
... another command is already in progress
[ PQsendQuery followed by just one PQgetResult ]
IIRC, you need to keep calling PQgetResult until it returns NULL
before the connection is considered
I'm using libpq C Library. I prepared some query and trying to call it
many times.
But it success only at first time, and then fail with error:
... another command is already in progress
Here is my testbed:
int
main (register int const argc, register char *const argv[])
{
PGconn
2010/2/26 Anton Maksimenkov anton...@gmail.com:
When I try it in pgAdmin, first time it show me error:
--
ERROR: value out of range: underflow
CONTEXT: PL/pgSQL function myf_convert_phone18digits line 12 at assignment
--
SECOND (and consequences) time it works and just show result
Hi.
I have a simple function.
CREATE OR REPLACE FUNCTION myf_convert_phone18digits(
in_phone VARCHAR
) RETURNS BIGINT
-- IMMUTABLE
AS $$
DECLARE
t_extent_len BIGINT;
t_phone_18 BIGINT;
t_multiplier BIGINT;
BEGIN
IF in_phone IS NULL OR in_phone = '' THEN
RAISE EXCEPTION 'in_phone[%]
2010/2/10 Martijn van Oosterhout klep...@svana.org:
Can anybody briefly explain me how one postgres process allocate
memory for it needs?
There's no real maximum, as it depends on the exact usage. However, in
general postgres tries to keep below the values in work_mem and
2010/1/28 Scott Marlowe scott.marl...@gmail.com:
related to maximum per-process data space. I don't know BSD very well
so I can't say if datasize is the only such value for BSD, but it'd be
worth checking. (Hmm, on OS X which is at least partly BSDish, I see
-m and -v in addition to -d, so
2010/2/9 Scott Marlowe scott.marl...@gmail.com:
On Tue, Feb 9, 2010 at 3:18 AM, Anton Maksimenkov anton...@gmail.com wrote:
Isn't the usual advice here is to log the ulimit setting from the pg
startup script so you can what it really is for the user at the moment
I think that su is enough
Hi.
Some hours ago there was a power failure with my test machine while
active inserting data. After power back the OS done some fsck, clean
some files (related to postgres working directory). Then I connect to
my DB and see this:
billing=# \d
ERROR: index pg_attribute_relid_attnum_index is
May I ask - how can I do it...? My ordinary startup command (from
rc.local) like this
# su -l _postgresql -c nohup /usr/local/bin/pg_ctl start -D
/var/postgresql/data -l /var/postgresql/logfile -o '-D
/var/postgresql/data'
But I tried
# su -l _postgresql
$ postgres -D /var/postgresql/data/ -P
10 matches
Mail list logo