this ascii_and_mic.so - where can i find this?
patrick
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
8.2.15
Actually I'm a little bit helpless with debugging this error, someon has a
idea what the problem causes? Or a advice what to do, for debbunging??
Kind regards,
Patrick Weimer
--
Sitz / Registergericht: Frankfurt am Main / Amtsgericht Frankfurt am
Hi:
I'm installing postgresql-7.0.2 from ftp.postgresql.org on a clean
redhat 6.2 system.
I'd like to create an alternate data location, similar to that supported
in pgsql 6.3, so,
I do:
$ export ARC_P_DAT_01="/home/httpd/data/arc_p_dat_01"
$ initlocation initlocation $ARC_P_DAT_01
initlocati
the class will be
"org.postgresql.Driver"
I am using postgresql 7.0.2
Thanks for the good work,
Patrick May
The following bug has been logged online:
Bug reference: 2465
Logged by: Patrick Hayes
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Window XP
Description:Installation
Details:
I have installed version 8.1. I am trying to access the
The following bug has been logged online:
Bug reference: 2785
Logged by: Patrick Hayes
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Windows Professional
Description:Exception Issue
Details:
I am defining Exception blocks. When I put
Your name : Patrick
Your email address : Valsecchi
System Configuration
-
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : Linux 2.4.20
PostgreSQL version (example: PostgreSQL-7.3.3
on without RETURNCONTEXT: PL/pgSQL function
"test"
If I just change EXIT LOOP1 to EXIT ->
everything is OK
Regards,
Patrick
------
Your name : Patrick Clery
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : Intel
Operating System (example: Linux 2.4.18) : FreeBSD 4.10-stable
PostgreSQL version (example: PostgreSQL
The following bug has been logged online:
Bug reference: 1539
Logged by: Patrick Boulay
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.5
Operating system: Unix Solaris
Description:Suggestion
Details:
Sometime I do transaction and I do a couple of commands
I have a partial index that contains a predicate to check for whether the
field deleted is false or not:
CREATE INDEX people_essays_any_essaytype_idx
ON people_essays (person_id)
WHERE NOT deleted;
The following query does NOT use the index:
EXPLAIN ANALYZE
SELECT *
FROM people_essays
W
The following bug has been logged online:
Bug reference: 1997
Logged by: Patrick Kik
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.5
Operating system: SLES 9
Description:Grammar error in phpPgAdmin 3.1
Details:
In Dutch, after deleting a column the text
The following bug has been logged online:
Bug reference: 2225
Logged by: Patrick Rotsaert
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.2
Operating system: Linux
Description:Backend crash -- BIG table
Details:
Situation:
-
Database with 1 table
on 31/01/2006 16:18 Tom Lane wrote :
"Patrick Rotsaert" <[EMAIL PROTECTED]> writes:
At the time of the crash, the server logs:
LOG: server process (PID 21815) was terminated by signal 9
You're running on a Linux machine with memory overcommit e
Tom Lane wrote:
Patrick Rotsaert <[EMAIL PROTECTED]> writes:
on 31/01/2006 16:18 Tom Lane wrote :
http://www.postgresql.org/docs/8.1/static/kernel-resources.html#AEN18105
But /proc/sys/vm/overcommit_memory reads `0', so my gu
Is there some reason you can't add more swap space?
Yes, disk space. I have about 2 GB of swap space enabled.
How do you know it is Postgres that is using lots of memory? The OOM killer
doesn't just kill of memory hogs, so you can't just assume the processes
being killed tells you which pr
0 means overcommit is enabled. You want to set it to something other
than 0 to prevent overcommitting and the consequent suprising process
deaths. Exactly what other values are accepted varies, but 0 isn't the
one for you.
I do not understand how 0 could mean overcommit is enabled. I do
One question is what does the explain (without analyze) plan look like for
the above and are the row estimates valid in the case of one of the hash
plans.
pointspp=# explain select trid, count(*) from pptran group by trid
having count(*) > 1;
QUERY PLAN
--
Hmm, if you do an enable_hashagg=false and then run the query (without
explain) does it work then?
pointspp=# set enable_hashagg = false;
SET
pointspp=# select trid, count(*) from pptran group by trid having
count(*) > 1;
ERROR: could not write block 661582 of temporary file: No space left
The problem is that the HashAgg will have to maintain a counter for
every distinct value of trid, not just those that occur more than
once. So if there are a huge number of one-time-only values you could
still blow out memory (and HashAgg doesn't currently know how to spill
to disk).
One-tim
The following bug has been logged online:
Bug reference: 2334
Logged by: Patrick Narkinsky
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Mac OS X
Description:WHERE IN (SUBSELECT) fails when column is null
Details:
This may be expected
The following bug has been logged online:
Bug reference: 2386
Logged by: Patrick Headley
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.4 +
Operating system: Windows XP
Description:pg_restore doesn't restore large objects
Details:
I have been tryi
ught I would let you know.
If you are unable to reproduce the problem by simply attempting to restore a
backup of a database that has some LO data stored in it, let me know and
I'll start from scratch and send you all the details that I can come up
with.
Patrick Headley
Linx Consulting, Inc.
(303
large objects and
then proceeded to restore other items in the database.
Hope that provides some insights into the cause of the problem.
Patrick Headley
Linx Consulting, Inc.
(303) 916-5522
[EMAIL PROTECTED]
www.linxco-inc.com
-Original Message-
From: Andreas Pflug [mailto:[EMAIL PROTECTED]
t;:
Et du coup la partie antivirus du proxy ne fonctionne pas
Database access module initialization failed, please check the setting in
Database tab.
Et l'accès http à trend micro iwss ne fonctionne pas non plus
Voila
Pouvez vous me venir en aide.
Patrick Pileri
patrick.pil...@fr.loomis.com
<>
BTW I'm using postgresql-9.1-901.jdbc4.jar
Thanks again,
Pat
On Wed, Jul 11, 2012 at 2:10 PM, Patrick Tucker wrote:
> Interesting, the test case that I ran was performing a simple SQL
> statement like the following: select "a" from table
>
> I wonder if the versi
Interesting, the test case that I ran was performing a simple SQL statement
like the following: select "a" from table
I wonder if the version of the driver I am using needs to be updated or
even the database?
Thanks,
Pat
On Wed, Jul 11, 2012 at 1:43 PM, Tom Lane wrote:
> tucker...@gmail.com writ
27 matches
Mail list logo
