Mischa Sandberg <[EMAIL PROTECTED]> writes:
> I take it that it is a very reasonable assumption that only a small proportion
> of index records are actually invalid (else Yurk why use the index?).
That's faulty logic, the percentage of tuples that are valid is entirely
independent from the perc
Achtung neue Mail-Adresse !
Neu: vorname.familienname bei gleichem Provider oder rufen Sie uns bitte an (01/977 13
77) und wir werde die neue Adresse mitteilen.
Leider erhalten wir pro Tag mehr als 100 Mails welche wir nicht wollen. Wir haben uns
daher entschieden, eine neue Adresse zu waehlen.
Hi List, I have another error now here:
notice that only one backend is dying, all others are up and working.
Error - Message :
duplicate key violates unique constraint "ferber_rust_params_pkey"
FATAL: block 0 of 1663/19335/476756 is still referenced (local 2)
server closed the connection unexpect
Hi with beta2 i get
leak:relation "pg_largeobject_loid_pn_index" has refcnt 1 instead of 0
while running my script
that's an example throwing this message
UPDATE reports SET r_blob=lo_import('../reports.r_id.'|| CAST(r_id AS
VARCHAR) || '.blob') WHERE r_blob IS NOT NULL
PS : everything seem to be
Hi
Thanks for PostgreSQL Beta 8.0!
I try to use the native Win32 build (http://pgfoundry.org/projects/pginstaller)
(Beta 1) but i get an error during DB startup.
"failed to get token information: 122"
Maybe this is related to
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=cftihc%247u
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] ("Marc G. Fournier") would
write:
> On Sat, 4 Sep 2004, Gaetano Mendola wrote:
>> Hi all,
>> now that Apache Portable Runtime was release why don't
>> use it on Postgres?
>
> Short question: why? what does it give us, other then potential
Centuries ago, Nostradamus foresaw when Murat Kantarcioglu <[EMAIL PROTECTED]> would
write:
> For our research project, I need to implement an encryption support
> for Postgressql. At this current phase, I need to at least support
> page level encryption In other words, each page that belongs to
On Wed, 8 Sep 2004, Tom Lane wrote:
> I wrote:
> > Actually, I'd really like to get it back down to the 7.4 size, which was
> > already too big :-(. That might be a vain hope though.
>
> As long as we're talking about hack-slash-and-burn on this data
> structure ...
>
> The cases where people get
I wrote:
> Actually, I'd really like to get it back down to the 7.4 size, which was
> already too big :-(. That might be a vain hope though.
As long as we're talking about hack-slash-and-burn on this data
structure ...
The cases where people get annoyed by the size of the deferred trigger
list a
Hi,
are you planning to implement WRITABLE cursors
in one of the next releases of pgsql?
If so, do you have some kind of roadmap about that?
We are currently looking for a replacement rdbms for an informix based
application with a duty of over 100 concurrent interactive user sessions.
Therefore w
Greg Stark wrote:
Doug McNaught <[EMAIL PROTECTED]> writes:
Short answer: MVCC tuple visibility status isn't (and can't be) stored
in the index.
Well the "can't" part is false or at least unproven. From prior discussion the
only thing that would be technically challenging would be avoiding dead
Hello, Hackers! I use Nagios – monitoring system. Can you help, please? I
want to compile plugin for Nagios
named ‘check_pqsql’.
Which libraries I need to
compile it successful? Thank you.
On Sep 4, 2004, at 10:07 PM, Christopher Browne wrote:
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Jaime
Casanova) would write:
By the way, will be a way in postgresql 8 to add a
column in a middle of a table. just curious.
What do you mean by "in a middle of a table?" A relation i
[EMAIL PROTECTED] (Rod Taylor) writes:
> On Sun, 2004-09-05 at 13:43, Tom Lane wrote:
>> Rod Taylor <[EMAIL PROTECTED]> writes:
>> > collect2: ld returned 254 exit status
>>
>> That's a fairly unhelpful error message, isn't it?
>>
>> I'm thinking that this may be due to having added the timezone
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Jaime Casanova) would write:
> By the way, will be a way in postgresql 8 to add a
> column in a middle of a table. just curious.
What do you mean by "in a middle of a table?" A relation is simply a
set of attributes that _don't_ forcibly
OK, I am caught up on email now after five days of travel. I have
loaded the patch queue for others to empty. Two weeks to go.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Ro
Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > On the /contrib issue, I am not sure we even have Mingw compiling
> > contrib. What error are you seeing? If I try to compile
> > /contrib/dbsize under Unix I don't see any -lpgport line in the
> > compile:
>
> It doesn't need any. It's loaded i
Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > Peter Eisentraut wrote:
> > > Bruce Momjian wrote:
> > > > There are alot of windows.h includes:
> > >
> > > ... and most of them are redundant because it is already included
> > > via c.h.
> >
> > Right, but we only include windows.h in Mingw.
>
Gaetano Mendola wrote:
Joe Conway wrote:
# python -c "from distutils.sysconfig import get_python_lib as f;
import os; print
os.path.join(f(plat_specific=1,standard_lib=1),'config')"
/usr/lib64/python2.3/config
Any other proposals? If not, any objections to the attached patch?
No one, we have to
Marc G. Fournier wrote:
>
> I have someone that is asking if you can recover some tablespaces in a
> database, but leave the others online ... apparently its a feature of
> tablespaces under Oracle ... I could see it for schemas, but sounds like
> it could cause problems depeending on how you a
Bruce Momjian wrote:
> Peter Eisentraut wrote:
> > Bruce Momjian wrote:
> > > There are alot of windows.h includes:
> >
> > ... and most of them are redundant because it is already included
> > via c.h.
>
> Right, but we only include windows.h in Mingw.
That has nothing to do with my point.
> Do
Bruce Momjian wrote:
> On the /contrib issue, I am not sure we even have Mingw compiling
> contrib. What error are you seeing? If I try to compile
> /contrib/dbsize under Unix I don't see any -lpgport line in the
> compile:
It doesn't need any. It's loaded in the backend, which already has
libp
Devrim GUNDUZ wrote:
[ PGP not available, raw data follows ]
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
> Hi,
>
> AFAIR there was a thread about "SELECT FOR UPDATE NOWAIT" availability in
> {7.5,8.0}, 7-8 months ago.
>
> Now we have LOCK TABLE ... NOWAIT; but I wonder whether we'll
Bruce Momjian <[EMAIL PROTECTED]> writes:
> On the /contrib issue, I am not sure we even have Mingw compiling contrib.
We don't --- apparently the win32 crowd hadn't bothered to try it until
recently. There are a couple of patches in the queue that claim to make
individual modules work, but I dun
Well, glad we are on to real Cygwin issues at least. I know I had
probably broken Cygwin with all the Win32 changes. I actually thought
it would be worse. Glad you were able to help us.
On the /contrib issue, I am not sure we even have Mingw compiling contrib.
What error are you seeing? If I
Andrew Dunstan wrote:
>
>
> Reini Urban wrote:
>
> > Bruce Momjian schrieb:
> >
> >> Peter Eisentraut wrote:
> >>
> >>> Bruce Momjian wrote:
> >>>
> There are alot of windows.h includes:
> >>>
> >>>
> >>> ... and most of them are redundant because it is already included
> >>> via c.h.
> >>
It is really hard to describe all the project in few e-mails.
Obviously, we will not try to run entire database software in that
secure hardware. Also memory limitations are not important.
For example, please check the research on "oblivious RAM" to see even
small memory on such hardware can be l
Our basic claim is to be able to do most of the encryption while we are
reading the page. That is the reason I need the threads. Any suggestion
about the threads are welcome. Thanks.
Murat
Alvaro Herrera wrote:
On Fri, Sep 10, 2004 at 11:
Murat Kantarcioglu <[EMAIL PROTECTED]> writes:
> This piece will be a part of a bigger design and the problems
> mentioned are very real. In the future, our goal is to design a database
> system where the processing is done in a "secure coprocessor"(i.e no one
> will be able to see what is inside)
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Wed, 8 Sep 2004, Tom Lane wrote:
>> Yeah, I had come to the same conclusion after more thought. But we
>> could certainly aggregate all the similar events generated by a single
>> query into a common status structure.
> Definately. The ~20 byte/row
Reini Urban wrote:
Bruce Momjian schrieb:
Peter Eisentraut wrote:
Bruce Momjian wrote:
There are alot of windows.h includes:
... and most of them are redundant because it is already included
via c.h.
Right, but we only include windows.h in Mingw. Does Cygwin need it?
Not really, but it will b
Bruce Momjian schrieb:
Peter Eisentraut wrote:
Bruce Momjian wrote:
There are alot of windows.h includes:
... and most of them are redundant because it is already included via
c.h.
Right, but we only include windows.h in Mingw. Does Cygwin need it?
Not really, but it will be lot of new work, whic
Bruce Momjian schrieb:
I have applied all parts of your patch now.
Thanks. Core builds and works fine now. (plperl IPC problems aside)
But there's are still some more minor SHLIB glitches,
which only affects contrib, because -lpgport is missing for various dll's.
SHLIB_LINK doesn't contain the libs
On Fri, Sep 10, 2004 at 11:52:26AM -0500, Murat Kantarcioglu wrote:
> Can you suggest me a solution to how to do
> this on Postgresql backend?
>
> I am asssuming that somewhere in the code, you are calling a function like
> getPage(Page_id)
> to retrieve the page(I am trying to change backen
Thanks for the comments.
This piece will be a part of a bigger design and the problems
mentioned are very real. In the future, our goal is to design a database
system where the processing is done in a "secure coprocessor"(i.e no one
will be able to see what is inside) and
the small code inside the
Added to TODO:
* Make row-wise comparisons work per SQL spec
---
Tom Lane wrote:
> "Merlin Moncure" <[EMAIL PROTECTED]> writes:
> > http://archives.postgresql.org/pgsql-performance/2004-07/msg00218.php
>
> > Still
I have applied all parts of your patch now.
---
Reini Urban wrote:
> Reini Urban schrieb:
> > [BTW: there's no need to cc all, I'm subscribed to most lists]
> > Reini Urban schrieb:
> >> Bruce Momjian schrieb:
> >>> Andrew D
Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > There are alot of windows.h includes:
>
> ... and most of them are redundant because it is already included via
> c.h.
Right, but we only include windows.h in Mingw. Does Cygwin need it?
--
Bruce Momjian| http://can
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Wed, 8 Sep 2004, Tom Lane wrote:
>> It wouldn't quite work to use just transaction ID as the marker, since
>> the inner SET CONSTRAINTS is very possibly done without using a
>> subtransaction. But command ID or query nesting level or some such
>> woul
Bruce Momjian wrote:
> There are alot of windows.h includes:
... and most of them are redundant because it is already included via
c.h.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: you can get off
Peter Eisentraut wrote:
> Bruce Momjian wrote:
>
> > OK, I am wrong above. Coding assumes WIN32 is only for port named
> > WIN32, which is mingw, and for BCC and VCC. I was not aware Cygwin
> > defined it at all. Are we sure it does in a header file?
>
> The problem is that some pieces of Cygw
Bruce Momjian wrote:
> OK, I am wrong above. Coding assumes WIN32 is only for port named
> WIN32, which is mingw, and for BCC and VCC. I was not aware Cygwin
> defined it at all. Are we sure it does in a header file?
The problem is that some pieces of Cygwin code include windows.h, which
it s
Ok, will do. Thanks.
Tom Lane wrote:
Grant Finnemore <[EMAIL PROTECTED]> writes:
I'm afraid that I did not get a core dump. Sorry.
My normal configure includes both debug and cassert - is there anything
else I should set to ensure core dumps are generated?
Check "ulimit -c" in the postmaster's env
"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> http://archives.postgresql.org/pgsql-performance/2004-07/msg00218.php
> Still, I think the current behavior is wrong...and is exactly the kind
> of trick question that a sql compliance benchmark might ask.
It undoubtedly is wrong. But it has been wr
OK, change made. Thanks.
---
> Most of the ~300 cases are ok for CYGWIN. And probably for MINGW also.
> But I don't do MINGW countertests. I assume you do :)
>
> Just palloc misses some pending fixes for CYGWIN. cvs head d
Grant Finnemore <[EMAIL PROTECTED]> writes:
> I'm afraid that I did not get a core dump. Sorry.
> My normal configure includes both debug and cassert - is there anything
> else I should set to ensure core dumps are generated?
Check "ulimit -c" in the postmaster's environment.
Personally I always
pgman wrote:
> Andrew Dunstan wrote:
> > >>I think Bruce was mostly trying to make all the similar tests look
> > >>alike. Also I agree that "if a && !b" is clearer than "if !b && a";
> > >>the latter requires a bit more thought to parse the extent of the !
> > >>operator...
> > >>
> > >>
> >
Andrew Dunstan wrote:
> >I agree that this is a good idea, partly because I do not care for the
> >assumption that MINGW is the only compilation environment we'll ever
> >support for the Windows-native port.
> >
> >I'm not in a position to work out or test the required changes, but I'll
> >be happy
I'm afraid that I did not get a core dump. Sorry.
My normal configure includes both debug and cassert - is there anything
else I should set to ensure core dumps are generated?
Regards,
Grant
Tom Lane wrote:
Grant Finnemore <[EMAIL PROTECTED]> writes:
TRAP: FailedAssertion("!(((ntp)->t_data)->t_info
> Yes, I found the following thread started by you in the
> pgsql-performance list:
>
> Subject: [PERFORM] best way to fetch next/prev record based on index
> Date: Tue, 27 Jul 2004 06:18:43 -0700
>
> > there were some concerns about backwards compatibility.
>
> IMO 8.0 is a good chance to fix i
Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
Bottom line - this is something of a mess. If we can make sure Cygwin
isn't broken, we can probably live with what have for now. Personally, I
would have configure work out something cleaner, like, say, defining
WINDOWS_ALL for both
Grant Finnemore <[EMAIL PROTECTED]> writes:
> TRAP: FailedAssertion("!(((ntp)->t_data)->t_infomask & 0x0010)", File:
> "catcache.c", Line: 1728)
This seems moderately impossible :-(. Did you get a core dump? If so
please provide a stack backtrace.
regards, tom lane
---
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Bottom line - this is something of a mess. If we can make sure Cygwin
> isn't broken, we can probably live with what have for now. Personally, I
> would have configure work out something cleaner, like, say, defining
> WINDOWS_ALL for both Windows nati
Zeugswetter Andreas SB SD wrote:
>
> > > Personally I don't think that any rename()-usleep loop is necessary.
> > > I'll check the archives.
> >
> > I agree the rename loop seems unnecessary. I kept it in case we hadn't
> > dealt with all the failure places. Should we remove them now or wait
>
Reini Urban wrote:
Andrew Dunstan schrieb:
We
had lots of Cygwin-specific defines in there already so Win32 just
means
both Mingw and Cygwin. You will see only a few cases where we want
Mingw and not Cygwin, but in those case we often also want MSVC and
Borland, so it really is WIN32 && ! __CYGW
Reini Urban schrieb:
[BTW: there's no need to cc all, I'm subscribed to most lists]
Reini Urban schrieb:
Bruce Momjian schrieb:
Andrew Dunstan wrote:
Reini Urban wrote:
FYI: WIN32 is also defined because is included.
(/usr/incluse/w32api/windef.h)
If you want this or that, do proper nesting, and
Andrew Dunstan schrieb:
Bruce Momjian wrote:
Andrew Dunstan wrote:
I'm not sure exactly what Bruce checked, so I just spent a few cycles
making sure that we did not inadvertantly pick up a define of WIN32
from windows.h anywhere else. I *think* we are OK on that. However,
ISTM this is a foot jus
Robert Treat wrote:
Ugh. If I want to see the syntax of my functions, I'd be forced to use the
\df-+ syntax, and I'd argue people spend far more time wanting to see \df+
output on their own functions than they ever do on system functions.
+1. I suspect Tom's use is pretty atypical. If I wan
Bruce Momjian wrote:
Andrew Dunstan wrote:
I'm not sure exactly what Bruce checked, so I just spent a few cycles
making sure that we did not inadvertantly pick up a define of WIN32 from
windows.h anywhere else. I *think* we are OK on that. However, ISTM this
is a foot just waiting to be shot
> > Personally I don't think that any rename()-usleep loop is necessary.
> > I'll check the archives.
>
> I agree the rename loop seems unnecessary. I kept it in case we hadn't
> dealt with all the failure places. Should we remove them now or wait
> for 8.1? Seems we should keep them in and se
Bruce Momjian schrieb:
Reini Urban wrote:
Bruce Momjian schrieb:
OK, care to submit a patch. As I remember the fix for rename/unlink
also includes how the file is opened with flags. Anyway, we spent a lot
of time on this so you will have to go back in the archvies to find it
and determine how it
Reini Urban wrote:
> Bruce Momjian schrieb:
> > OK, care to submit a patch. As I remember the fix for rename/unlink
> > also includes how the file is opened with flags. Anyway, we spent a lot
> > of time on this so you will have to go back in the archvies to find it
> > and determine how it can b
[BTW: there's no need to cc all, I'm subscribed to most lists]
Reini Urban schrieb:
Bruce Momjian schrieb:
Andrew Dunstan wrote:
Reini Urban wrote:
FYI: WIN32 is also defined because is included.
(/usr/incluse/w32api/windef.h)
If you want this or that, do proper nesting, and use #else.
Ugh, yes.
It's happened again, and in both cases seems to be on a call to
VACUUM FULL
Grant Finnemore wrote:
Hi,
I am using a version of PostgreSQL compiled from a CVS update of yesterday,
and compiled with
make clean all
make install
One client connection to the database doing routine and low volume
po
OK, moved and comment documents its location.
---
Reini Urban wrote:
> Bruce Momjian schrieb:
> > Andrew Dunstan wrote:
> >>Reini Urban wrote:
> >>>FYI: WIN32 is also defined because is included.
> >>>(/usr/incluse/w32api/
Zeugswetter Andreas SB SD wrote:
>
> > I think adding 'S' to \df confuses more than it helps.
>
> Why that? Imho it would be consistent.
I thought it was strange to have alphabetic modifiers but I seem to be
the only one who is worried about it so forget my objection.
--
Bruce Momjian
Bruce Momjian schrieb:
Andrew Dunstan wrote:
Reini Urban wrote:
FYI: WIN32 is also defined because is included.
(/usr/incluse/w32api/windef.h)
If you want this or that, do proper nesting, and use #else.
Ugh, yes. A little experimentation shows that __WIN32__ is defined for
MinGW only, but WIN3
Hi,
I am using a version of PostgreSQL compiled from a CVS update of yesterday,
and compiled with
make clean all
make install
One client connection to the database doing routine and low volume population
scripts (using schemas) After several normal runs of the population script, a
run caused th
Robert Treat wrote:
Ugh. If I want to see the syntax of my functions, I'd be forced to use the
\df-+ syntax, and I'd argue people spend far more time wanting to see \df+
output on their own functions than they ever do on system functions.
imho the argument against \dfS is pretty weak. Letters
> > Well, it's easily changed, if all that's needed is a search-and-replace.
> > Suggestions for a better name?
>
> MINGW32
I think that is a bad idea. That symbol sure suggests, that you are using mingw.
Are you expecting someone who creates a VisualStudio project to define
MINGW32 ?
Andreas
> I think adding 'S' to \df confuses more than it helps.
Why that? Imho it would be consistent.
Andreas
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not mat
71 matches
Mail list logo
