Is there any way to compile libpq for Win32 for it to produce output in
UNICODE?
What I want is something like that:
wchar_t* utfbuffer;
...
utfbuffer = PQgetvalue(res, i, j);
wprintf("%s", utfbuffer);
...
and the program produces normal output, not the mess of Chinese/Thai/etc
symb
are
ignored until we ROLLBACK (or COMMIT, or ABORT) this transaction manually.
Then we performed a commit statement. It commited nothing, but it finished
the transaction block.
And finally we SELECT'ed all values from the table foo. As it was expected,
we found no values in it. That means that the first insert statement had
been rolled back though we didn't perform ROLLBACK but COMMIT.
Alex Bolenok.
_fid_seq'), 'Other value'); COMMIT WORK;
BEGIN
NOTICE: t_first_fid_seq.nextval: sequence was re-created
INSERT 252770 1
INSERT 252771 1
COMMIT
peroon=# SELECT * FROM t_first;
fid | finfo
-+
1 | Some value
(1 row)
peroon=# SELECT * FROM t_second;
sid |sinfo
-+-
1 | Other value
(1 row)
Is it what you are looking for?
Alex Bolenok.
en ExecSQL method
is called.
So the question is:
1. Is there any way to avoid calling of BEGIN / END in these components, or
2. Is there any way to create a user inside a transaction block? Direct
writes to pg_shadow don't work too, I have tried.
Thanks,
Alex Bolenok.
help.
>
> Ken Causey
>
>
ikar=# SELECT DATE_PART('epoch', '2 hours 30 minutes'::interval) / 3600;
?column?
--
2.5
(1 row)
Alex Bolenok
1251 codepage format (not a
Linux native KOI-8), and I won't be able to sort the data properly.
Does anybody know how can one handle such a situation?
Sorry for a little offtopic,
Alex Bolenok.
like that:
tgname | relname
+
RI_ConstraintTrigger_22073 | t2
RI_ConstraintTrigger_22075 | t2
RI_ConstraintTrigger_22071 | t1
(3 rows)
Drop these triggers (there is one on the referencing table, and two ones on
the referenced table), and there will be no reference anymore.
Alex Bolenok.
---
>
> why this is so ? can anyone help me out ? thanx in advance.
You may use query loops, such as:
DECLARE
nextrow RECORD;
BEGIN
FOR nextrow IN SELECT * FROM WHERE ORDER BY
LOOP
...
END LOOP;
END;
See postgresql HTML documentation for further info.
Alex Bolenok.