Jan Wieck [EMAIL PROTECTED] writes:
IIRC the patch only provides the syntax for CURSOR to
PL/pgSQL. Not real cursor support on the SPI level. So it's
still the same as before, the backend will try to suck up the
entire resultset into the SPI tuple table (that's
Dear friends,
PgAdmin provides new features for dropping/creating functions, triggers and
views and relinking the whole system without restarting PostgreSQL.
By now, this new feature is only available as a patch to PgAdmin
http://www.greatbridge.org/project/pgadmin/patch/patchlist.php.
If you
On Wed, 25 Apr 2001, The Hermit Hacker wrote:
On Wed, 25 Apr 2001, Vince Vielhaber wrote:
On Wed, 25 Apr 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Autoconf has a 'LOADAVG' check already, so what is so problematic about
using that to enabled/disable that
On Thu, 26 Apr 2001, Vince Vielhaber wrote:
On Wed, 25 Apr 2001, The Hermit Hacker wrote:
On Wed, 25 Apr 2001, Vince Vielhaber wrote:
On Wed, 25 Apr 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Autoconf has a 'LOADAVG' check already, so what is so
On Thu, 26 Apr 2001, The Hermit Hacker wrote:
On Thu, 26 Apr 2001, Vince Vielhaber wrote:
On Wed, 25 Apr 2001, The Hermit Hacker wrote:
On Wed, 25 Apr 2001, Vince Vielhaber wrote:
On Wed, 25 Apr 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Folks:
I'm planning a port of Postgres to a multiprocessor
architecture in which all nodes have both local memory
and fast access to a shared memory. Shared memory it more
expensive than local memory.
My intent is to put the shmem lock structures in
shared memory, but use a
I am getting a bit concerned about Postgres 7.1 performance with multiple
connections. Postgres does not seem to scaling very well. Below there is a list
of outputs from pgbench with different number of clients, you will see that
postgres' performance in the benchmark drops with each new
Nathan Myers wrote:
On Mon, Apr 23, 2001 at 03:09:53PM -0300, The Hermit Hacker wrote:
Anyone thought of implementing this, similar to how sendmail does it?
If
load n, refuse connections?
...
If nobody is working on something like this, does anyone but me feel
that
it has merit to
Hi,
I think the pg_log file of my postgreSQL is corrupted.
I can;t access to tables in my database now.
The error message appear when I tried to list all tables is as below :
cannot flush block 8 of pg_log to stable store
Anybody know how can I restore back the pg_log file.
Thanks.
Emmanuel
Is anyone else seeing this?
I have the current CVS sources and make check ends up with one
failure. My regression.diffs shows:
*** ./expected/join.out Thu Dec 14 17:30:45 2000
--- ./results/join.out Mon Apr 23 20:23:15 2001
***
*** 1845,1851
-- UNION JOIN isn't implemented
Tom Lane wrote:
A less dangerous way of approaching it might be to have an option
whereby the postmaster invokes 'uptime' via system() every so often
(maybe once a minute?) and throttles on the basis of the results.
The reaction time would be poorer, but security would be a whole lot
Please disregard this. This message was held by Majordomo for a couple
of days and I have already resent it.
Tom Lane has already solved my problem (I had a miscompiled version of
bison in my machine).
Regards to all,
Fernando
Fernando Nasser wrote:
Is anyone else seeing this?
I have
I want to extract tables schema information, i've looked at
src/bin/psql/describe.c but i cannot determine the datatype
'serial' and
'references' from pg_*, i understand that triggers are generated for
serial
and references, so how i can understand from my perl application the
full
schema ?
Jan Wieck wrote:
Just discussed it with Tom Lane while he'd been here in
Norfolk and it's even more ugly. We couldn't even pull out
the FK's column defaults at this time to check if we are
about to delete the corresponding PK because they might call
all
If someone wants to run the A4 docs through a PDF converter, send 'em to
me and I'll post them too.
I just did the userA4 pdf from hub with this:
$ gzcat userA4.ps.gz | ps2pdf - userA4.pdf
Do you want me to do the rest of them? Or we can probably have the
makindex script do it for us.
mlw [EMAIL PROTECTED] writes:
I am getting a bit concerned about Postgres 7.1 performance with
multiple connections. Postgres does not seem to scaling very
well. Below there is a list of outputs from pgbench with different
number of clients, you will see that postgres' performance in the
Jan Wieck [EMAIL PROTECTED] writes:
I don't object if we can be sure that it's implementing the
syntax a final version with *real* cursor support will have.
Can we?
I don't know, and I don't know what the decision criteria are.
I intentionally implemented the Oracle cursor
Tom Lane wrote:
mlw [EMAIL PROTECTED] writes:
I am getting a bit concerned about Postgres 7.1 performance with
multiple connections. Postgres does not seem to scaling very
well. Below there is a list of outputs from pgbench with different
number of clients, you will see that postgres'
Jan Wieck [EMAIL PROTECTED] writes:
What'd be easy is this:
- We already have two entry points for INSERT/UPDATE on FK
table, but the one for UPDATE is fortunately unused.
- We change analyze.c to install the RI_FKey_check_upd
trigger if the constraint
Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
What'd be easy is this:
- We already have two entry points for INSERT/UPDATE on FK
table, but the one for UPDATE is fortunately unused.
- We change analyze.c to install the RI_FKey_check_upd
On Thu, 26 Apr 2001, V. M. wrote:
ok for serials, now i can extract from psql (\d tablename).
But i'm not able to extract foreign keys from the schema.
Yes you can. Read my tutorial on Referential Integrity in the top section
at techdocs.postgresql.org.
--
Joel Burton [EMAIL PROTECTED]
Ian Lance Taylor wrote:
Jan Wieck [EMAIL PROTECTED] writes:
I don't object if we can be sure that it's implementing the
syntax a final version with *real* cursor support will have.
Can we?
I don't know, and I don't know what the decision criteria are.
I intentionally
ok for serials, now i can extract from psql (\d tablename).
But i'm not able to extract foreign keys from the schema.
From: Joel Burton [EMAIL PROTECTED]
To: V. M. [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: unanswered: Schema Issue
Date: Thu, 26 Apr 2001 13:51:26 -0400 (EDT)
On
read it,
but i can determine only the related tables and not the fields of these
tables that are related.
valter
From: Joel Burton [EMAIL PROTECTED]
To: V. M. [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: [HACKERS] Re: unanswered: Schema Issue
Date: Thu, 26 Apr 2001 14:42:31 -0400 (EDT)
On
On Thu, Apr 26, 2001 at 05:20:53PM +0200, Peter Eisentraut wrote:
will trillich writes:
i know password can be used in creating/altering user
information (as used via GRANT and REVOKE) but is there any
facility within postgres to CRYPT() a value?
See contrib/pgcrypto for hashing
perhaps adding t.tgargs to your view enable me to extract parameters
that are the related fields
---
CREATE VIEW dev_ri
AS
SELECT * t.tgargs , t.oid as trigoid,
c.relname as trig_tbl,
When I create a table
create table test (a bit(4));
and insert a value
insert into test values (b'11');
the zpbit_in() function gets an atttypmod (arg 2 (of 2)) of -1. Is there
somewhere the system needs to be told that this type uses the atttypmod
field?
--
Peter Eisentraut
Marko Kreen [EMAIL PROTECTED] writes:
A general question: what is the status on patch acceptance
now, after 7.1 is successfully released? I did not
want to fuzz around with new code when 7.1 was in freeze,
but what is the status now?
We're still in bug-fixes-only mode. I think the plan is
Peter Eisentraut [EMAIL PROTECTED] writes:
When I create a table
create table test (a bit(4));
and insert a value
insert into test values (b'11');
the zpbit_in() function gets an atttypmod (arg 2 (of 2)) of -1. Is there
somewhere the system needs to be told that this type uses the
A couple {days,weeks} ago, someone sent an email to one of the pgsql-*
lists asking if anybody had thought about implementing the glue to use PAM
as authentication method for PostgreSQL. Having thought about being able
to easily drop in various external authentication agents, I've been
thinking
Is there any discussion before I submit the patch to -patches?
Since we can, or should be able to, run postgres as a backend to ldap,
this seems to give a wonderfully circular system (which probably works
just fine). Just a comment...
- Thomas
On Thursday 26 April 2001 23:36, Barnes, Sandy (Sandra) wrote:
We are currently calling 'vacuum' from within our code, using the psql++
PgDatabase ExecCommandOk() to send the SQL statement 'vacuum'. I seems
to work when we only have one process running, but when two processes
(both
Hi,
There's a report of startup recovery failure in Japan.
Redo done but ...
Unfortunately I have no time today.
regards,
Hiroshi Inoue
KAMI wrote:
DEBUG: database system shutdown was interrupted at 2001-04-26 22:15:00 JST
DEBUG: CheckPoint record at (1, 3923829232)
DEBUG: Redo record
How does 7.1 work now with the vacuum and all?
Does it go for indexes by default, even when i haven't run a vacuum at all?
Does vacuum lock up postgres? It says the analyze part shouldn't, but how's
that for all of the vacuum?
An 7.0.3 db we have here we are forced to run vacuum every hour to
There's a report of startup recovery failure in Japan.
Redo done but ...
Unfortunately I have no time today.
Please ask to start up with wal_debug = 1...
Vadim
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
On Thu, 26 Apr 2001, V. M. wrote:
(moving this conversation back to pgsql-general, followups to there)
perhaps adding t.tgargs to your view enable me to extract parameters
that are the related fields
At SCW, we use a naming convention for RI triggers, to allow
us to easily extract that, and
On Tue, 24 Apr 2001, Thomas Lockhart wrote:
If someone wants to run the A4 docs through a PDF converter, send 'em to
me and I'll post them too.
I just did the userA4 pdf from hub with this:
$ gzcat userA4.ps.gz | ps2pdf - userA4.pdf
Do you want me to do the rest of them? Or we can
We are currently calling 'vacuum' from within our code, using the psql++
PgDatabase ExecCommandOk() to send the SQL statement 'vacuum'. I seems to
work when we only have one process running, but when two processes (both
invoking the vacuum) are running it immediately hangs. Some postgres
38 matches
Mail list logo