a wrote:
Hi,
Is it have any tools or control let delphi can direct connet to postgresql
not only use odbc?
Thank!!
Gary
take a look at
www.zeoslib.net
www.microolap.com/dac/postgresdac.htm
dbexpress :
www.vitavoom.com
Daniel
---(end of
Hi list,
i tried a bit with errorhandling and found the following :
(i want to ignore the dublicate key exception)
CREATE OR REPLACE FUNCTION test() RETURNS VARCHAR AS'
BEGIN
BEGIN
INSERT INTO table a dublicate key (primary);
EXCEPTION
WHEN OTHERS THEN ROLLBACK;
END;
RETURN ''test'';
Hi with beta2 i get
leak:relation pg_largeobject_loid_pn_index has refcnt 1 instead of 0
while running my script
that's an example throwing this message
UPDATE reports SET r_blob=lo_import('../reports.r_id.'|| CAST(r_id AS
VARCHAR) || '.blob') WHERE r_blob IS NOT NULL
PS : everything seem to be
Hi List, I have another error now here:
notice that only one backend is dying, all others are up and working.
Error - Message :
duplicate key violates unique constraint ferber_rust_params_pkey
FATAL: block 0 of 1663/19335/476756 is still referenced (local 2)
server closed the connection
Hi list,
is it is known that postgres 8.0 (beta1 and beta2 both same behavoir)
will eat tons of memory on Windows under heavy load?
Scenario:
I have a big delete with about 56000 rows. (DELETE FROM mytable;)
There are triggers (after delete) updating 2 or 3 other tables. (there
are triggers on
Tom Lane schrieb:
Can you provide a concrete test case?
houres later I'v located the problem. Its not heavy load but
subtransactions in Triggers. It's very easy to recreate:
the problem is this Syntax :
CREATE OR REPLACE FUNCTION do_standard_mgc() RETURNS TRIGGER AS'
BEGIN
BEGIN
--prob also
Tom Lane schrieb:
Yeah, I ran into that earlier today while trying to reproduce your
problem. It's fixed by this pending patch. I didn't see any freeze-up
of the system after running out of lock memory, though. It seemed to
release the locks just fine.
Yeah this error is away now.
Now i got the
Tom Lane schrieb:
Can I see a stack trace from that? Or at least the verbose form of the
error message?
actually i dunno know how to create a stack trace. I will do some
research. Verbose output (debug5)
TEST=# UPDATE art SET ak_res=0;
WARNING: out of shared memory
CONTEXT: PL/pgSQL
Tom Lane schrieb:
Had you been running the server for very long before forcing the error,
I don't think this would have happened, because the buffer hashtable
would have already expanded to its full working size.
Yes, you are right - this was a fresh started pgserver.
Once we fix subxacts to not
Hy,
my PostgreSQL 8.0.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
crashes when
SELECT * FROM pg_stat_activity WHERE datname=COALESCE(NULL, NULL);
I had an mistake in a stored procedure so COALESCE got 2 NULL values but
a crash is not nice here ;-)
workaround :
SELECT * FROM
Hi List,
there seem to be a bug in the 8.0 Rule System if I update a view and
does not give a column an value.
example
TEST=# \d abzu_ruletest
View public.abzu_ruletest
Column | Type| Modifiers
+---+---
abz_txt| character
Bruce Momjian schrieb:
OK, so it seems we need:
C static/private functions for schemas
C static/private variables for schemas
Are private variables implemented via the temporary per-session schema?
nested schemas
What does the standard say?
Is that it?
Yeah,
that would
Hi,
here is a testcase:
CREATE OR REPLACE FUNCTION testseq()
RETURNS void AS
$BODY$
BEGIN
CREATE TEMP SEQUENCE test;
PERFORM testseq1();
DROP SEQUENCE test;
RETURN;
END; $BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION testseq() OWNER TO postgres;
CREATE OR REPLACE FUNCTION testseq1()
A nice workaraound because
EXECUTE 'select nextval(''test'')' INTO I;
doesnt work in 8.0 seems to be:
myid:=nextval('stvtrsid_seq'::TEXT);
This seems to work in every case.
Daniel
Jaime Casanova schrieb:
try this way:
CREATE OR REPLACE FUNCTION testseq() RETURNS void AS
$BODY$
BEGIN
.
LINE 1: SELECT 1 LIKE '1';
^
template1=# SELECT version();
version
-
PostgreSQL 8.4.0, compiled by Visual C++ build 1400, 32-bit
(1 row)
thanks a lot.
--
Daniel Schuchardt
/Softwareentwicklung
15 matches
Mail list logo