Rick Gigger <[EMAIL PROTECTED]> writes:
To make a long story short lets just say that I had a bit of a
hardware failure recently.
If I got an error like this when trying to dump a db from the mangled
data directory is it safe to say it's totally hosed or is there some
chance of recovery?
Why
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
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
"Ed L." <[EMAIL PROTECTED]> writes:
> 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?
Probably.
> Is there anythi
m == [EMAIL PROTECTED] writes:
m> you didn't reference the table "replica"... this should work:
m> UPDATE model_timemap
m> SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN replica =
m> 32191 THEN 5739 ELSE -1 END, 1161642129, map)
m> FROM replica
m> WHERE replica.replica_id
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
-
Just upgraded to 8.1.5 and the following UPDATE causes the "missing
FROM-clause entry" error:
UPDATE model_timemap
SET map = updatemap( CASE WHEN replica = 32188 THEN 328787 WHEN replica =
32191 THEN 5739 ELSE -1 END, 1161642129, map)
WHERE replica.replica_id = model_timemap.replica
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?
(
http://incubator.apache.org/cayenne/
Check googlethis is the first result for cayenne
dfx wrote:
Hi,
somebody knows if it is possible to find on the internet
documentation, articles or books (also in bookstore) about cayenne?
Thank you
Domenico
---(end
Hi,
somebody knows if it
is possible to find on the internet documentation, articles or books (also in
bookstore) about cayenne?
Thank
you
Domenico
On 10/22/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Ron Johnson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 10/22/06 06:45, Thomas Hallgren wrote:
>> Joshua D. Drake wrote:
>>> Tomi NA wrote:
I was just reading http://www.opencrx.org/faq.htm where RDBMS engines
a
On Sun, 2006-10-22 at 08:12 -0700, Joshua D. Drake wrote:
> Ron Johnson wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > On 10/22/06 06:45, Thomas Hallgren wrote:
> >> Joshua D. Drake wrote:
> >>> Tomi NA wrote:
> I was just reading http://www.opencrx.org/faq.htm where RDB
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 un
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: Post
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 und
Albe Laurenz a écrit :
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
> 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 i
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) = 2.
Marc,
We are working on making the port to PostgreSQL ... may be for the end of this
month.
We have wrote to the Wordpress team ... but without any answer for the
moment ... :o(
When it'll be ready from our part, I'll inform you.
Best regards,
Le dimanche 22 octobre 2006 00:58, Marc G. Fournie
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 c
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 transl
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?
Joost Kraaijeveld wrote:
On Mon, 2006-10-23 at 02:11 -0400, brian wrote:
pg_controldata - display control information of a PostgreSQL database
cluster
pg_controldata [ datadir ]
I was hoping for the actual command but this suggests deduction ;-)
That is it.
given:
PG_DIR=/usr/local/pg
Peter Bauer wrote:
Hi all,
for further investigation we seperated the sub-SELECT from the DELETE
statement and it looks like the SELECT is usually finished in some 100
milliseconds but after some minutes it suddenly takes some minutes.
Explain analyzes before and after should give some insight
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.
25 matches
Mail list logo
