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 wri
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 w
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 larg
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
"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 bef
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
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 inse
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
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
>
>
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
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, you'
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
de
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
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 abou
>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
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 to
> 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 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 i
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 with
¡¡
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
¾«Æ·Ð
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 wri
> > > 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__intb
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
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 wid
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 fe
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
"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
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
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
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
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 suppor
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 Financi
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 machine
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 se
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 docum
> "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 shoul
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 postgresql-snap
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
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 UNI
39 matches
Mail list logo