-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 recent
I just noticed this help wanted on SourceForge:
http://sourceforge.net/people/viewjob.php?group_id=81764job_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
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
enough space
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
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
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
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
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
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?
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.
regards,
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_fermi_prenotati)
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.
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
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 ?
Nope ... this is not
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 this
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 ideas?
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.
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
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
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
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: already aborted
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
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 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 what I'm
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
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
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
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
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
Should pg_get_indexdef return its TABLESPACE clause?
Chris
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
-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
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
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
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 this
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
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
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
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 not more
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 (alvherre[a]dcc.uchile.cl)
El que vive para el futuro es un iluso, y el que vive para el
39 matches
Mail list logo