On Mon, 4 Jun 2001, Tom Lane wrote:
On hub, in /home/projects/pgsql/ftp/pub/dev I see
*.tar.gz.md5postgresql-opt-snapshot.tar.gz
doc postgresql-opt-snapshot.tar.gz.md5
postgresql-base-snapshot.tar.gz
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Am I misunderstanding how the mechanism works, or is this a big, not
easily
solved, problem?
The latter. Check the list archives for previous debates about this.
It's not real clear whether an inherited primary key should be
Greetings,
I need to implement a full write audit trail (every write access needs to be
logged as a complete SQL statement with timestamp, user and host) in our
database.
Which is the most efficient way to do this on the server side in Postgres? I
tried to find something relevant in the
Hi all,
I'm not a postgres hacker, but I' think that you must be the most
appropriate person to give me a pointer about this question sorry for
any possible mistake.
Now I'm trying to use postgresql plus the pgbench like a
first test to stress the interconnection system in a parallel
I can help translating it to Spanish, just tell me :-)
Diego Naya
OSEDA
Sistemas
[EMAIL PROTECTED]
- Original Message -
From: Alessio Bragadini [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 05, 2001 9:38 AM
Subject: [HACKERS] Re: FYI: status of native language support
Vince Vielhaber [EMAIL PROTECTED] writes:
On Mon, 4 Jun 2001, Tom Lane wrote:
Also, some of the mirrors claimed to be up-to-date by
http://www.postgresql.org/index.html aren't. Fr instance,
download.sourceforge.net doesn't have 7.1.1 nor 7.1.2.
What is it you find missing about 7.1.2? What
On Tue, 5 Jun 2001, Tom Lane wrote:
Vince Vielhaber [EMAIL PROTECTED] writes:
On Mon, 4 Jun 2001, Tom Lane wrote:
Also, some of the mirrors claimed to be up-to-date by
http://www.postgresql.org/index.html aren't. Fr instance,
download.sourceforge.net doesn't have 7.1.1 nor 7.1.2.
Valentin Puente [EMAIL PROTECTED] writes:
Ok...well I'm running this benchmarks in different SMP machines (SGI with 4
to 8 processors and the results are odd). The best performance is achieved
with just one backend (1 client). When I try to run more clients the tps
falls quickly.
What scale
I'm trying to import data from a sybase bcp (tab separated dump) and am
encountering a really odd datetime type:
Mar 27 1994 12:00:00:000AM
I've been looking in the books but haven't found anything yet and see
nothing in any of the PostgreSQL docs. Anyone have any idea how I can
bring this
I would love to find a way to get a bitmap like index native to Postgres. I
[skip]
We could implement bitmap handling functions based on one dimentional arrays of
integers. That's how my stuff deals with them, and postgres already manages
them.
look at contrib/intarray. gist__intbig_ops
Hello, All!
I had PostgreSQL 7.0.3 (7.1 now) and one nice day I've noticed that much
number of my BLOBs are broken! Although they seems to be with good content
in file system (xinv[0-9]+ files) I was not able to get them via
lo_export... After spending some time trying to fix it, I decided to
¡¡
I can realize this function in the SYBase,but How can i do it in the PostgreSQL?
/SQL***/
if not exists(select id from test) insert into test(id) values (280);
/*/
_
ÊýÂë²úÆ·ÐÂÉÏÊУ¬¿á http://shopping.263.net/category21.htm
I just got bit by the identifier name is too long and will be truncated
limitation in Postgresql.
AFIAA there is a limit of 64 characters for identifiers (names of
tables, sequences, indexes, etc...)
I had just started to get in the habit of using serial data types until
I made to tables
Hi all,
I'm not a postgres hacker, but I' think that you must be the most
appropriate person to give me pointer about this question. Thus... sorry for
any possible mistake.
Now I'm trying the posibibility to use postgresql plus the pgbench like a
first test to stress the interconnection system
Until we fix that (maybe for 7.2, maybe not) your existing hack is
probably pretty reasonable. You could save some cycles by avoiding
conversion to text, though --- instead return an opaque datum that is
pointer-to-tuple-slot and let the dblink_tok function extract fields
from the tuple.
Hi All,
I'm developing (currently in pre-alfa stage) a Acucobol interface for the
Postgresql.
The Acucobol runtime have a generic FS API interface that handle the work
with the
record oriented files, defining the open, close, read, write and so on low
level function I can
extend the runtime
It's relatively straightforward to allow check constraints to be inherited -
but is it really possible to ever do the same with primary, unique or even
foreign constraints?
You would either have to check each index in the hierarchy or else have
a single index across the whole hierarchy and
I know we're not in the business of copying mySQL,
but the REPLACE INTO table (...) values (...) could be
a useful semantic. This is a combination INSERT or
UPDATE statement. For one thing, it is atomic, and
easier to work with at the application level. Also
if the application doesn't care
Hi there,
I see that pgsql replication is on TODO list.
I wonder whether there is related sites about this issue or some developed
resources.
Thanks.
Ruke Wang
Software Engineer
Servgate Technologies, Inc.
(408)324-5717
Could I ask a huge favour of the experienced PostgreSQL hackers to make a
simple page on the postgreSQL.org website listing TODO items that newbie
hackers can get stuck into? I was thinking of doing elog() myself, but then
again, I'm not experienced enough in PostgreSQL to do something that the
I know that BLOBs are on the TODO list, but I had an idea.
I think the storage of a BLOB outside of the table is an elegant
solution and keeps table sizes down without the bloat of the stored
object. Granted, if you are searching with a regular expression or
using like or ilike clauses,
Roberto Fichera [EMAIL PROTECTED] writes:
My first think was to bypass the SQL translation and use the Postgresql low
level routines.
I need to see the tables as record oriented archive, so I can scan
sequentially (forward and
backward) each record, lock/unlock it, insert and delete it and
Ruke:
check out http://www.greatbridge.org/genpage?replication_top
for a project on PostGres replication and related info
Mauricio
From: Ruke Wang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [HACKERS] database synchronization
Date: Tue, 29 May 2001 11:36:13 -0700
Hi there,
Hi All,
This is my first post, so I hope I'm in the right
area and doing it correctly.
We are having MAJOR URGENT problems with
Postresql occaisonly corrupting tables on insert. I had a quick look
through your archive and couldn't find anything.It seems to happen mostly
on large inserts
Thomas Swan [EMAIL PROTECTED] writes:
I know that BLOBs are on the TODO list, but I had an idea.
I think you just rediscovered TOAST.
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Bruce Irvine [EMAIL PROTECTED] writes:
We are having MAJOR URGENT problems with Postresql occaisonly corrupting =
tables on insert.
Can't help you with that much information.
What Postgres version is this? (If your answer is not 7.0.3 or
7.1.2, I'm going to tell you to upgrade before
How 'bout posting what version of pgsql you're running, and we'll start
back at square one :)
-d
Bruce Irvine wrote:
Hi All,
This is my first post, so I hope I'm in the right area and doing it
correctly.
We are having MAJOR URGENT problems with Postresql occaisonly
Currently, if the client application dies (== closes the connection),
the backend will observe this and exit when it next returns to the
outer loop and tries to read a new command. However, we might detect
the loss of connection much sooner; for example, if we are doing a
SELECT that outputs
Hi,
I had PostgreSQL 7.0.3 (7.1 now) and one nice day I've noticed that much
number of my BLOBs are broken! Although they seems to be with good content
in file system (xinv[0-9]+ files) I was not able to get them via
lo_export... After spending some time trying to fix it, I decided to write
Peter Eisentraut wrote:
language supported in the next release, this would be a good time to
gather up and volunteer for translation.
I can help with Italian translation if no one else is volunteering (or
coordinating a team)
--
Alessio F. Bragadini[EMAIL PROTECTED]
APL
On Tue, Jun 05, 2001 at 04:16:06PM +0800, Christopher Kings-Lynne wrote:
Hi Bruce,
I was just looking at the TODO list and noticed my name in it - cool! (You
spelled it wrong - but hey :) )
Just thought you might like to add
* ALTER TABLE ADD PRIMARY KEY
* ALTER TABLE ADD UNIQUE
On Tue, Jun 05, 2001 at 11:07:03AM +0200, Pascal Scheffers wrote:
On Mon, 4 Jun 2001, Bruce Momjian wrote:
Because several people want this patch, Tom has withdrawn his
objection. Jan also stated that the elog(NOTICE) was good enough for
him.
Patch applied.
Wonderful! Thank you
okay, just removed the .hidden directory from the ftp server, which should
correct that ... I had setup that .hidden directory to be excluded though,
not sure why it was bothering things :(
On Mon, 4 Jun 2001, bpalmer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
However, it seems
Oleg Bartunov [EMAIL PROTECTED] writes:
The best plan I've got eliminating IN predicate:
select msg_prt.tid as mid from msg_prt
where exists (select idx.tid from idx where msg_prt.tid=idx.tid
and idx.did=1 and idx.lid = 1207 and idx.lid=59587 )
Surely that returns zero rows?
Oleg Bartunov [EMAIL PROTECTED] writes:
should be
select msg_prt.tid as mid from msg_prt
where exists (select idx.tid from idx where msg_prt.tid=idx.tid
and idx.did=1 and ( idx.lid = 1207 or idx.lid=59587 ));
but this is not a big win.
Shouldn't be any win at all: the IN
On Tue, 5 Jun 2001, Christopher Kings-Lynne wrote:
Just thought you might like to add
* ALTER TABLE ADD PRIMARY KEY
* ALTER TABLE ADD UNIQUE
And what
ALTER TABLE DROP PRIMARY KEY
ALTER TABLE DROP UNIQUE
BTW, it's a little cosmetic feature if we have
Oleg Bartunov [EMAIL PROTECTED] writes:
select msg_prt.tid as mid from msg_prt
where exists (select idx.tid from idx where msg_prt.tid=idx.tid
and idx.did=1 and idx.lid in (1207,59587) )
NOTICE: QUERY PLAN:
Seq Scan on msg_prt (cost=0.00..119090807.13 rows=69505 width=4)
Peter Eisentraut [EMAIL PROTECTED] writes:
In PQexec() and also in parseInput() (both fe-exec.c) there is a provision
for, if more than one result set is returned, to concatenate the error
messages (while only returning the last result set). My question is how a
backend can return more than
On Wed, 6 Jun 2001, Christopher Kings-Lynne wrote:
Those two points are already mentioned - I have another 90%
patch ready to
go that will add that functionality as well...
As a question, are you doing anything to handle dropping referenced unique
constraints or are we just
39 matches
Mail list logo