d 8.2.
>
>
> How nice of them not to fix it in ppport.h. I thought this is exactly the
> sort of thing it's for.
It's not so easy to convert
foo = GvCV(bah);
to a
GvCV_set(foo, bar);
with a ppport.h macro automatically.
But yes, the backport GvCV_set => lvalue GvCV shou
Attached is my patch to enable SSPI on cygwin.
--
Reini Urban
http://phpwiki.org/ http://murbreak.at/
--- origsrc/postgresql-8.4.0/configure.in 2009-06-27 02:14:47.0 +0200
+++ src/postgresql-8.4.0/configure.in 2009-07-02 09:02:25.921875000 +0200
@@ -907,7 +907,11 @@ if test
ied to optimize openssl socket handling
equivalent to WIN32.
Please revert that documentation.
The current configure args of the official postgresql packages are:
--enable-nls --with-openssl --with-perl --with-python --with-ldap
The problem is just that SSPI auth does not compile on cygwin.
--
R
Andrew Dunstan schrieb:
Magnus Hagander wrote:
Heh. Maybe not dead, but certainly not really alive either ;-) Given the
evidence in your patch that clearly 8.3 isn't quite up to speed on
cygwin, and nobody has really noticed until now.
AIUI, only the gssapi stuff is broken. Most users are n
Magnus Hagander schrieb:
Reini Urban wrote:
Dave Page schrieb:
On Tue, Jun 24, 2008 at 9:32 AM, Magnus Hagander <[EMAIL PROTECTED]>
wrote:
Yes.
As in the cygwin build does build. Nobody really has verified if the fix
is needed there. But frankly, if you are likely to care about the
e
dap
(but ldap works okay with 8.2.9)
currently testing is: --enable-nls --with-CXX --with-openssl --with-perl
--with-python --with-libxml --with-libxslt
current cygwin patch in testing is attached.
--
Reini Urban
postgresql cygwin maintainer
diff -urN -x CYGWIN-PATCHES -x 'aclocal.
So this is really bad.
--
Reini Urban
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
le d;
char *tail;
int main() {
errno = 0;
d = strtod("-10e400", &tail);
printf("double: %f, errno: %d, tail: '%s', isinf: %d, fabs: %f,
inf>max: %d" ,
d, errno, tail, isinf(d), fabs(d), fabs(d) > DBL_MAX ? 1 : 0);
}
$ gcc test-strtod
sibel karaasma schrieb:
> Hi I'm a new postgresql user. I wrote ACO (ant colony optimazition) and
> want to replace it with GEQO in postres/src/backend/optimizer but I
> don't know how
> to compile and run the source code :(
>
> I installed postgresql-8.1.3 and cygwin but I can not use them to
list.
Most problems are cygwin specific, others are carried in the FAQ_README
and the seperate /usr/share/doc/Cygwin/postgresql-x.x.x.README
If so, I'll write a documentation patch.
--
Reini Urban
http://phpwiki.org/
---(end of broadcast)---
t libraries, and also makes it easier to mix both
(cygwin vs. mingw and msvc) client libs and have both of them in the path.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
http://phpwiki.org/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
other platforms all have
shlib=lib$(NAME)...
For cygwin the normal rule is cyg$(NAME)$(DLSUFFIX),
but the postgresql maintainers refused to changed the prefix for 8.0
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
http://phpwiki.org/
---(end of broa
ng into this.
>>
>
> I'd like somebody else to report the same phenomenon first. Reini?
Why plperl is broken I cannot say yet.
I still have the same general IPC permission problem since about beta3.
Only very few cygwin hackers have this also.
I only got confirmation t
ad is also not really easy to port, but there exist solutions.
But I guess you are only talking about restricting client connections,
which is easy enough.
--
Reini Urban
---(end of broadcast)---
TIP 7: don't forget to increase your free
Andrew Dunstan schrieb:
Reini Urban wrote:
What I also miss is the successful output of the make test step.
Something like the Log in "Details", just behind an additional request.
"Config" =>
Log
Link to "Details"
Without those details one doesn't trust the
Link to "Details"
Without those details one doesn't trust the presented result.
He might think that only the build was successful, and not the make test
step also.
People I redirect to this page from other projects, not reading the
status pages everyd
postgresql-cygwin is working fine. See the testfarm.
Just cygwin itself, cygserver - the IPC daemon - has problems.
On msgctl(IPC_INFO) the internal msg buffer struct msqid_ds *buf is
allocated at a non-writable area, IsBadWritePtr() fails. I suspect it's
a new gcc-3.4 feature, but haven't found
Marc G. Fournier schrieb:
Just as a heads up, I'm going to roll it in about 4hrs (~02:00GMT) ...
I checked a couple of mirrors this morning and only the swedish one got
it so far. (timestamps 03:24 - 03:36)
Maybe it would be better next time to upload it before 0:00 GMT
--
Reini Urban
Marc G. Fournier schrieb:
Just a quick note, since we obviously passed the previous date we were
aiming for ... we're aiming for Sunday evening to roll Beta5 ... all the
major stuff that we felt were outstanding have been committed, and a
*large* # of the smaller patches, but Bruce is working th
if it
will work with the exceptions. And if a simple .def with aliases would
be enough. libgeos is huge.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Thomas Hallgren schrieb:
I have a minor issue with Makefile.shlib. Compiling with win32 it spits
out these warnings (the same is true for Cygwin)
Makefile.shlib:327: warning: overriding commands for target `libpljava.a'
Makefile.shlib:262: warning: ignoring old commands for target
`libpljava
1
rm refint.o autoinc.o timetravel.o moddatetime.o insert_username.o
make[1]: Leaving directory
`/home/adunstan/pgbf/root/HEAD/pgsql.blurfl/contrib/spi'
This was addressed in my patch I sent.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
Index: contrib/sp
prevent the pg_dump/Makefile hack on MinGW too!
Working on a patch now.
---
Bruce Momjian wrote:
Andrew Dunstan wrote:
Reini Urban wrote:
...
>Info: resolving _optarg by linking to __imp__optarg (auto-import)
>Info: res
coLinux to crosscheck on a linux image (faster than vmware,
in fact much faster than
windows)
compile: make + gcc, or nmake + msvc cl.exe
look at the sources: XEmacs or TotalCommander or $ less src
--
Reini Urban
Reini Urban schrieb:
Tom Lane schrieb:
Dunno about the optarg business; it sounds like a DLLIMPORT is needed
someplace, but maybe that is a bug in the Cygwin headers rather than
our bug?
No, that's no bug, just diagnostic messages with the new linker.
>gcc -O2 -Wall -Wmissing-pr
;ll backcheck.
#ifdef BUILDING_DLL
# ifndef __GNUC__
# define __DLL_IMPORT __declspec(dllimport)
# else
# define __DLL_IMPORT __attribute__((dllimport)) extern
# endif
#else
# define __DLL_IMPORT
#endif
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadc
client (Windows Native and/or
Cygwin) that would be awesome.
Sorry, no.
Is there no ISP around, which wants to save some money? :)
Also, if anyone managed to port ccache to Windows that would be huge
too. Using it on Unix has proved to be a major gain.
ccache is available via cygwin at least.
--
R
be
putting the code changes in CVS on pgfoundry soon. Then I will turn to
improving the web interface, moving from the rather severely functional
setup currently used.
Could loris also be used to do the cygwin and MSVC builds?
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban
cked. Does anybody do
the msvc/borland suites?
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
nge in the header files with the
pgport_srv seperation.
Can somebody give me a hint?
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Andrew Dunstan schrieb:
problem area found. see below.
Reini Urban wrote:
Andrew Dunstan schrieb:
Here is some more info. Below is a trace from dropdb. There is a loop
around the rmdir() calls which I have set to time out at 600 seconds.
The call eventually succeeds after around 300 seconds
004-10-26 10:31:09 [2496] WARNING: rmtree: rmdir took 274 secs/loops
2004-10-26 10:31:09 [2496] LOG: disconnection: session time: 0:04:34.11
user=pgrunner database=template1 host=127.0.0.1 port=1918
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broad
i-bin/cvsweb.cgi/winsup/cygwin/syscalls.cc?cvsroot=uberbaum
in short:
if the return status of DeleteFileA() is ERROR_SHARING_VIOLATION, defer
deletion until the end of the process.
but win95 reports ERROR_ACCESS_DENIED and not ERROR_SHARING_VIOLATION as
NT does.
--
Reini Urban
http://xarch.tu-graz.a
:
pl -png -o vbars.png -prefab vbars data=dbt3.data x=1 y=2 barwidth=line
see for example: http://ploticus.sourceforge.net/doc/prefab_vbars.html
or
http://phpwiki.sourceforge.net/phpwiki/PhpMemoryExhausted/Testresults
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban
to me.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
d for /contrib modules, not sure why
+ SHLIB_LINK += -lpgport
endif
ifeq ($(PORTNAME), win32)
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 8: explain analyze is your friend
three columns ( 18! ).
The Bitmap index allows the query executor to use several indexes on the same
operation, comparing them and selecting rows where they "overlap" like a Venn
diagram.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
to other machines.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tom Lane
Sent: Tuesday, October 12, 2004 1:02 AM
To: Bruce Momjian
Cc: Reini Urban; PostgreSQL Developers; [EMAIL PROTECTED]
Subject: Re: [CYGWIN] [HACKERS] open item: tablespace handing in pg_dum
Jason Tishler schrieb:
On Tue, Oct 12, 2004 at 01:37:48AM +0200, Reini Urban wrote:
Bruce Momjian schrieb:
I am curious why Cygwin needs DLLINIT in Makefile.shlib, and Win32
doesn't:
[snip]
The only difference I see is that Cygwin uses $(DLLINIT) while Win32
does not. Is that co
old
pgsql-server as alias to pgsql?
I believe a lot of people checked out with this Repository name.
This will not break everything. The docs should be fixed nevertheless.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
Windows OS during runtime. I don't
think it is worth it.
Agreed. Speed is not a matter for cygwin.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
s to test that on
his WinME laptop.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
rated. But I'll have to test
before you can remove that dir.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 8: explain analyze is your friend
d, in contrary to the existing 100 scheme
implementations, which all do it differently on the corner edges.
(culprit: tiny standard)
Personally I still prefer PHP, because it's a nice package (in contrary
to perl) and I can hire more and cheaper dildo's to maintain it then.
Manager's pre
Tom Lane schrieb:
Bruce Momjian <[EMAIL PROTECTED]> writes:
Reini Urban wrote:
Now that postgres 8.0 is win32 native is it still necessary support the
cygwin ?
FYI: If you drop it I will still provide cygwin packages. I just need it
for testing and writing applications targetted to unix
cygwin ?
FYI: If you drop it I will still provide cygwin packages. I just need it
for testing and writing applications targetted to unix. With win32 this
is not possible.
How do want to support postgis or other extensions on win32?
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban
Bruce Momjian schrieb:
Reini Urban wrote:
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 va
arable due to
they are both best usable for equality expressions.
Sure, and the next will come with musicbrainz.
Why not :)
If you don't want to code that in the app, the database backend is the
solution. The database is the golden hammer.
http://c2.com/cgi/wiki?GoldenHammer
--
Reini Urban
Reini Urban schrieb:
Tom Lane schrieb:
Bruce Momjian <[EMAIL PROTECTED]> writes:
I am confused. CVS has in port.h:
so you should already be calling the junction code on Cygwin.
true. didn't thought of that. very strange.
Yeah, I'm sure he is, but it looks from the regression
Bruce Momjian schrieb:
Andrew Dunstan wrote:
Reini Urban said:
Zeugswetter Andreas SB SD schrieb:
hardlinks and junctions don't work across physical disks, only
symlinks.
Where did you read this? I just looked and can see no such
restriction.
There is no such restriction for junctions, I
ation.
NTFS5 supports volume mount points now too.
But shouldn't we check in configure :) for this filesystem then?
(Ha! ntfs5.m4 for MSVC folks)
--
Reini Urban
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Bruce Momjian schrieb:
Reini Urban schrieb:
Cygwin can do symlinks for directories via the magic .lnk file.
But Cygwin can also do junctions via hardlinks in ln.exe.
I thought link() calls the junction code.
I'll investigate why the libc link() failed, and if ln.exe does some
sifferent
Reini Urban schrieb:
Cygwin can do symlinks for directories via the magic .lnk file.
But Cygwin can also do junctions via hardlinks in ln.exe.
I thought link() calls the junction code.
I'll investigate why the libc link() failed, and if ln.exe does some
sifferent magic, similar to pgsymli
Dave Page schrieb:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Reini Urban
Sent: 04 October 2004 22:17
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [HACKERS] cygwin test package available
FYI:
Soon an experimantal cygwin package will be
f ln.exe does some
sifferent magic, similar to pgsymlink.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
contrib is added to the cygwin package. It was not in 7.4.x.
Name: postgresql-8.0.0cvs-1 (experimental)
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Reini Urban schrieb:
Tom Lane schrieb:
Gavin Sherry <[EMAIL PROTECTED]> writes:
I though this may have been the problem. configure.in defines
HAVE_SYMLINK
to 1 if we are win32. It seems that for Reini's case we are setting our
template (and PORTNAME) to win32 when I suspect it shoul
t any ideas?
What are the prospects of making the junction code work under cygwin?
Somethink like the attached patch is easier.
Just replace symlink() for dirs with link() #ifdef __CYGWIN__
just wait a sec until the tests run through...
(completely fresh build)
--
Reini Urban
http://xarch.tu-graz
Reini Urban schrieb:
no HAVE_SYMLINK defined, though CYGWIN should added -DHAVE_SYMLINK.
oops, sorry for the noise. of course CYGWIN has it defined in pg_config.h.
CYGWIN can only do hardlinks (junctions) on directories of course.
maybe HAVE_SYMLINKS should be extended to HAVE_DIR_SYMLINKS when
Gavin Sherry schrieb:
On Mon, 4 Oct 2004, Reini Urban wrote:
I cannot recreate on Linux. What platform, etc, are you on?
hmm, I'll investigate then.
postgresql latest CVS with 2 minor shlib building patches left
(added -lpgport)
cygwin-1.5.11
gcc-3.4.1
Hmm.. sounds like we're trying
Gavin Sherry schrieb:
On Mon, 4 Oct 2004, Reini Urban wrote:
>>But the regression test fails: (the only failing test against cvs HEAD)
This is not only a pg_dump/pg_restore issue, or?
-- Will fail with bad path
CREATE TABLESPACE badspace LOCATION '/no/such/location';
ERROR
testschema" does not exist
-- Should succeed
DROP TABLESPACE testspace;
+ ERROR: tablespace "testspace" does not exist
==
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Marc G. Fournier schrieb:
> In recognition of his role as lead developer on the internationalization
front, as well as his invaluble work in both the build and release
processes, Peter Eisentraut has been invited, and has accepted, to join
the Core Committee.
Glückwunsch!
--
Reini Urban
h
, which is imho not worth it.
In some places the cygwin section calls WinAPI functions.
It could be worked around by using the posix/cygwin counterparts.
pgsymlink for example.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast
-lpgport
+else
+ SHLIB_LINK += $(BE_DLLLIBS)
+endif
endif
ifdef PG_CPPFLAGS
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister Your
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 ne
loc(Size sz);
extern char *pgport_pstrdup(const char *str);
extern void pgport_pfree(void *pointer);
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
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
[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
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
native in a few places.
Well, it's easily changed, if all that's needed is a search-and-replace.
Suggestions for a better name?
MINGW32
--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/
---(end of broadcast)---
TIP 2: you can get off a
lped me in finding the
problem)
Personally I don't think that any rename()-usleep loop is necessary.
I'll check the archives.
---
Reini Urban wrote:
Bruce Momjian schrieb:
I looked at the APR code to get some idea
Andrew Dunstan schrieb:
Reini Urban said:
Bruce Momjian schrieb:
I looked at the APR code to get some ideas for the Win32 port. Some
of the ideas were good, but in other places like rename they didn't do
very well we were better off doing it ourselves and getting it right.
I remember looki
ions
don't conflict here. here you don't stack two conflicting loops together.
nevertheless cygwin's unlink is much better than pgunlink in case of
locking problems. it does its own sort of delayed removal then.
IMHO port/dirmod.c is a dirty and half-baked hack, which works for min
like to add a simple plperl testcase to the standard
distro. Just the sample from the plperl.sgml would be fine.
Any general objections?
I'll come up with a patch if not, which will check if the postmaster has
plperl support and use it then.
--
Reini Urban
http://xarch.tu-graz.ac.at/home/r
75 matches
Mail list logo
