Hackers,
I think there a bug in the GUC mechanism. The custom variables patch
added several malloc() and a strdup() call, and they are never checked
for an out of memory condition.
--
Alvaro Herrera ()
"El que vive para el futuro es un iluso, y el que vive para el pasado,
un imbécil" (Luis Adle
"Greg Stark" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> Thomas Hallgren <[EMAIL PROTECTED]> writes:
>
> > Try to use a similar construct in a more elaborate OO-language (like
Java, C#,
> > etc.) and you will get an error like:
>
> Just as a point of reference, Java and C# are
Should pg_get_indexdef return its TABLESPACE clause?
Already done.
Cool. I'd considered it before when I was coding psql stuff, but then I
forgot to bring it up again on the list...
Chris
---(end of broadcast)---
TIP 8: explain analyze is your fri
If nothing else comes to mind, a reasonable compromise for 7.5 would be
to forbid moving any system catalog except pg_largeobject and its
indexes ...
Plus pg_dump support for it :/
Chris
---(end of broadcast)---
TIP 1: subscribe and unsubscribe comman
Thomas Hallgren <[EMAIL PROTECTED]> writes:
> Try to use a similar construct in a more elaborate OO-language (like Java, C#,
> etc.) and you will get an error like:
Just as a point of reference, Java and C# are not "more elaborate" object
systems. For Java at least being *less* elaborate was an
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> 2) pg_restore needs to be more tolerant with certain kinds of errors.
> Hmmm, dunno about this - it wasn't on my radar really. I'll experiment
> with it, but I don't think I'm going to have time before June 30th :(
I think we dealt with thi
OK,
I think it might save me some time if I get some guidance on how we
should modify pg_dump to fix the owner/grants issue.
I intend to make new archives created with 7.5 pg_dump have the fix, and
restoring pre 7.5 binary dumps will have exactly the previous
behaviour. The reason for this is
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Should pg_get_indexdef return its TABLESPACE clause?
Already done.
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTE
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> With our new tablespace set up, is it ever possible for someone to move
> pg_largeobject to another tablespace?
Assuming that ALTER TABLE SET TABLESPACE gets in, my preferred answer is
to apply that operation to pg_largeobject.
We do need to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Merlin Moncure wrote:
> I have to jump through hoops to keep track of what statements are
> already prepared to keep from bouncing the current transaction.
Christopher Kings-Lynne wrote:
> * PREPARE OR REPLACE...
>
> This would be an incredibly u
Should pg_get_indexdef return its TABLESPACE clause?
Chris
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
1) When pg_dump 7.4.1 (I have not tested on CVS) pulls a dump from a 7.2
database with confusing dependancies (e.g. functions depend on views which
depend on multiple tables and other views containing other functions), some
objects (almost always functions) still get silently dropped from the du
Of course, OIDs have been removed from a standard pg_dump so different
installations can diff their schemas (and a good thing too).
So - should this information be:
1. Logged nightly via standard logging procedures.
2. Stored in a format=custom dump but not for textual schemas.
3. Stored in a
With our new tablespace set up, is it ever possible for someone to move
pg_largeobject to another tablespace?
Chris
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Part of the problem is that PREPARE has no provision to overwrite an
existing plan (CREATE OR REPLACE). I run into this all the time because
I make heavy use of prepared statements to emulate an ISAM file system.
I have to jump through hoops to keep track of what statements are
already prepared to
Hello,
Just wanted to share some data I've generated with dbt-2 using
tablespaces from a CVS export of PostgreSQL on June 22. I have results
and details on how I have the disks laid out with LVM2 here:
http://www.osdl.org/projects/dbt2dev/results/dev4-006/538/
The performance appears to
Gaetano Mendola wrote:
Thomas Hallgren wrote:
Speaking in generic OO terms, using inheritance, you cannot remove
attributes that are present in the generalisation. If B inherits A, an
instance of B is per definition also an instance of A. Thus, you must
alwasy
be able to cast a B into an A. In sho
"Jeroen T. Vermeulen" <[EMAIL PROTECTED]> writes:
> Even if the spec doesn't help, I think a statement prepared within a
> transaction should definitely be deallocated at the end of the transaction.
Uh, you do realize that Postgres does *everything* within a transaction?
The above proposal would r
On Wed, 23 Jun 2004 15:07:42 -0400
Peter Martini <[EMAIL PROTECTED]> wrote:
> I'm not sure what you mean by breaking blobs transactional integrity.
> Do you mean by allowing filesystem type access, the blobs won't be
> properly locked and updated during a transaction? If so, that's
> exactly wha
Thomas Hallgren wrote:
Speaking in generic OO terms, using inheritance, you cannot remove
attributes that are present in the generalisation. If B inherits A, an
instance of B is per definition also an instance of A. Thus, you must alwasy
be able to cast a B into an A. In short, If you don't want th
I'm not sure what you mean by breaking blobs transactional integrity.
Do you mean by allowing filesystem type access, the blobs won't be
properly locked and updated during a transaction? If so, that's exactly
what I'm trying to achieve - a compromise between forcing the files to
be stored solely
On Jun 23, 2004, at 11:36 AM, Tom Lane wrote:
David Garamond <[EMAIL PROTECTED]> writes:
Alvaro Herrera wrote:
On Mon, Jun 21, 2004 at 09:16:35PM -0400, Alexander Cohen wrote:
Does anyone have any new ways to create clusters without using
initdb
or bootstrap mode? I need to be able to create one w
> Now, here's a scenario that has us worried:
>
> BEGIN
> PREPARE foo AS ...
> ... [error]
> DEALLOCATE foo [fails: already aborted by previous error]
> ABORT
> BEGIN
> PREPARE foo AS ... [fails: foo is already defined!]
> EXECUTE foo [fails: alread
KL-
> Would you be able to specify exactly the deficiences? It's my mission
> at the moment to make pg_dump 7.5 known-issue free :)
Well, since you asked:
(please excuse me if I'm covering old ground. I was off Hackers for almost a
month this spring)
1) When pg_dump 7.4.1 (I have not tested
We were discussing prepared statement support for libpqxx just now (Bruce,
Peter Eisentraut & myself are manning the postgres booth at LinuxTag 2004
in Karlsruhe, Germany), when we ran into a problem that came up two months
ago. That discussion follows:
Post by Alvaro Herrera:
> Hackers,
>
> Is
Peter Martini writes:
Lately I've been planning work on a patch to postgres and linux on my
system to allow access to BLOBs as a virtual filesystem, so I can see
any file I put in there even through network shares while avoiding
duplication / broken link issues. Does this sound like something wo
Tom Lane wrote:
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
pg_dumpall lacks the "-X disable-dollar-quoting" switch.
I can add it - do the other hackers want it?
It should be there --- in general pg_dumpall should be able to pass down
any pg_dump switch that makes sense.
David Garamond <[EMAIL PROTECTED]> writes:
> Alvaro Herrera wrote:
>> On Mon, Jun 21, 2004 at 09:16:35PM -0400, Alexander Cohen wrote:
>>> Does anyone have any new ways to create clusters without using initdb
>>> or bootstrap mode? I need to be able to create one without those 2
>>> things. Any i
Peter Martini <[EMAIL PROTECTED]> writes:
> Lately I've been planning work on a patch to postgres and linux on my
> system to allow access to BLOBs as a virtual filesystem, so I can see
> any file I put in there even through network shares while avoiding
> duplication / broken link issues. Does th
"Gaetano Mendola" <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>
> > Gaetano Mendola <[EMAIL PROTECTED]> writes:
> >
> >>I think a warning is missing if I create a table without OIDS that
> >>inherits from a table with oids:
> >
> >
> >>don't you think a warning shall to be raised here ?
> >
> >
Lately I've been planning work on a patch to postgres and linux on my
system to allow access to BLOBs as a virtual filesystem, so I can see
any file I put in there even through network shares while avoiding
duplication / broken link issues. Does this sound like something worth
doing / is there a b
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Would someone remind me --- is the binary COPY security fix we did for
> 7.4 also needed for earlier releases like 7.3.X?
No, because there is no on-the-wire binary copy before 7.4, and copy
from file is superuser-only anyway.
re
Richard Huxton said:
> Ferruccio Zamuner wrote:
>> Hi,
>>
>> I've following select, and I expect to receive a single record as result
>> from it:
>>
>> select c.id
>> from copie as c
>> where c.enum=46857 and
>> c.condizio_prestito = 'A' and
>> c.id not in (select id_copia from testi
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> pg_dumpall lacks the "-X disable-dollar-quoting" switch.
> I can add it - do the other hackers want it?
It should be there --- in general pg_dumpall should be able to pass down
any pg_dump switch that makes sense.
reg
On Jun 23, 2004, at 10:18 AM, David Garamond wrote:
Alvaro Herrera wrote:
On Mon, Jun 21, 2004 at 09:16:35PM -0400, Alexander Cohen wrote:
Does anyone have any new ways to create clusters without using
initdb or bootstrap mode? I need to be able to create one without
those 2 things. Any ideas?
in
Ferruccio Zamuner wrote:
Hi,
I've following select, and I expect to receive a single record as result
from it:
select c.id
from copie as c
where c.enum=46857 and
c.condizio_prestito = 'A' and
c.id not in (select id_copia from testi_fermi_prenotati) and
c.id not in (select id_co
Alvaro Herrera wrote:
On Mon, Jun 21, 2004 at 09:16:35PM -0400, Alexander Cohen wrote:
Does anyone have any new ways to create clusters without using initdb
or bootstrap mode? I need to be able to create one without those 2
things. Any ideas?
initdb'ing somewhere else and copying the resulting d
Hi,
I've following select, and I expect to receive a single record as result from it:
select c.id
from copie as c
where c.enum=46857 and
c.condizio_prestito = 'A' and
c.id not in (select id_copia from testi_fermi_prenotati) and
c.id not in (select id_copia from prestiti);
There was a recent post on -performance where someone had run
pg_resetxlog and nuked their transaction counter. Whenever someone has
filesystem-level problems like this they need to know:
- "current" transaction ID
- OIDs of system objects
Of course, OIDs have been removed from a standard pg_d
Would someone remind me --- is the binary COPY security fix we did for
7.4 also needed for earlier releases like 7.3.X?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Roa
On Thu, 2004-06-17 at 22:47, Simon Riggs wrote:
> On Wed, 2004-06-16 at 02:49, Tom Lane wrote:
> > Simon Riggs <[EMAIL PROTECTED]> writes:
> > > -finalaction refers to what to do when target is reached - the purpose
> > > of this is to allow recovery of a database to occur when we don't have
> > >
I just noticed this help wanted on SourceForge:
http://sourceforge.net/people/viewjob.php?group_id=81764&job_id=18927
Maybe someone could give them a hand - project is pretty highly rated.
Chris
---(end of broadcast)---
TIP 2: you can get off all list
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf
> Of Laurent Ballester
> Sent: 22 June 2004 23:41
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [pgsql-hackers-win32] initdb regression ?
>
> Hello,
>
> I am compile with msys and running a r
Hi Stefan,
since we have a lot of databases here that suffer from pg_dump's
deficits in 7.3 and 7.4 regarding dependencies, we tried pg_dump from
the upcoming 7.5 release.
Would you be able to specify exactly the deficiences? It's my mission
at the moment to make pg_dump 7.5 known-issue free :)
44 matches
Mail list logo
