Joost Kraaijeveld wrote:
Is it possible to find out the parameters used with initdb on an old
database or is this a matter of deduction?
TIA
pg_controldata - display control information of a PostgreSQL database
cluster
pg_controldata [ datadir ]
brian
---(end of
On Oct 22 02:33, Uwe C. Schroeder wrote:
On Sunday 22 October 2006 12:32, Volkan YAZICI wrote:
If I were you, I'd ask psycopg2 developers to implement parameters that
are natively supported by PostgreSQL. With parameters, you won't mess up
with any escaping or injection related issue.
Jeff Davis wrote:
I have a UTF8 encoded database. I can do
= SELECT '\xb9'::text;
But that seems to be the only way to get an invalid utf8 byte sequence
into a text type.
[...]
So, if I were to sum this up in a single question, why does cstring
not
accept invalid utf8 sequences? And if
Hi,Is there a way to check how many records where affected by a delete or update sentence in a trigger function ??thanksHugo
On 10/6/06,
Hugo [EMAIL PROTECTED] wrote:
OK, thanks, I'm porting a lot of sybase storedprocedures, and there are lots of if
sqlstate.. statements that i need to translate
Hi List !
I am trying to remove accents from a string. I found a nice
solution for this on postgresqlfr, using the to_ascii()
function.
Now, the problem I have is :
mydb=# SELECT to_ascii(convert('abcdef', 'LATIN9'));
ERROR: encoding conversion from UTF8 to ASCII not supported
Why is the
Hello
I've downladed postgresql-python-3.8.1-3PGDG.i686.rpm from the
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/redhat/rhel-es-4/
to install on a CentOS 4.4 and get this error :
# rpm -Uvh postgresql-python-3.8.1-3PGDG.i686.rpm
error: Failed dependencies:
python(abi) =
On 10/22/06, Tom Lane [EMAIL PROTECTED] wrote:
Joshua D. Drake [EMAIL PROTECTED] writes: Ron Johnson wrote: That implies malice.The people at OpenCRX apparently really believe what they wrote.
I believe they probably do believe it and it was probably driven by a complete lack of understanding of
This message came across [EMAIL PROTECTED]
I can't seem to find any information about the security release mentioned.
Are there any specific security issues that have been addressed?
Begin forwarded message:
Date: Sun, 22 Oct 2006 18:15:27 -0700
From: David Fetter [EMAIL PROTECTED]
To:
Bill Moran [EMAIL PROTECTED] writes:
I can't seem to find any information about the security release mentioned.
Are there any specific security issues that have been addressed?
There are a couple of coredump conditions fixed --- they don't really
amount to security issues unless you let
I have an 8.1.4 autovac process running on HP-UX 11.23 IA64 and
repeatedly failing with the following error:
ERROR: failed to re-find parent key in audit_idx1
Will a reindex or drop index make this problem go away?
Is there anything I can do to help identify the underlying issue?
you didn't reference the table replica... this should work:
UPDATE model_timemap
SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN replica =
32191 THEN 5739 ELSE -1 END, 1161642129, map)
FROM replica
WHERE replica.replica_id = model_timemap.replica AND replica.proxy = 32189
On Monday October 23 2006 4:03 pm, Ed L. wrote:
I have an 8.1.4 autovac process running on HP-UX 11.23 IA64
and repeatedly failing with the following error:
ERROR: failed to re-find parent key in audit_idx1
Will a reindex or drop index make this problem go away?
BTW, it'd be nice
I could have my developer do this if it would be useful to someone
else. But in general I think my time would be much better served
fixing my backup situation and monitoring them so that this CAN'T
happen again. It shouldn't have happened this time.
On Oct 19, 2006, at 8:35 AM, Ray Stell
13 matches
Mail list logo