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
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
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
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
Bruce Momjian schrieb:
Andrew Dunstan wrote:
Reini Urban wrote:
FYI: WIN32 is also defined because windows.h 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
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
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 windows.h is included.
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
[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 windows.h is included.
(/usr/incluse/w32api/windef.h)
If you want this or that, do proper nesting, and use #else.
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 be
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
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 see if we
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
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
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
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 !
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
for 8.1?
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 native
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
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
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 it. Maybe
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_infomask
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 to apply a
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...
Right, just consistency.
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 put
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
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 wrong
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
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
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 Cygwin code
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
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
would work. I
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|
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
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 backend)
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 windows.h is included.
(/usr/incluse/w32api/windef.h)
If you want this or that, do proper
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 Dunstan
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
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,
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
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 gain for
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) and
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
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
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.
Right, but we only include windows.h in
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
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 dunno
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 have the
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
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.
Does Cygwin need
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 are
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
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.
That has nothing to do
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 in the
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
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
[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
library to the
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 is
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.
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
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
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
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 annoyed
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 a
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
reliance
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
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 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
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
69 matches
Mail list logo