That's on my TODO list to write, but I haven't had the
time yet. The
basic is that if you disable everything in the config.pl
file, you
can run with almost no external dependencies. You'll need
flex+bison
if buliding off CVS.
Oh, and it requires Visual C++ 2005. Should work
IIRC there is no real SIGINT on Windows, so it can only come
from a postgres program. The windows shutdown could be
calling pg_ctl to stop the service, of course.
Well, not quite that, but it will send a service command to the running
pg_ctl (which is our service supervisor), which *will*
On Mon, 2 Oct 2006, Tom Lane wrote:
Jeremy Drake [EMAIL PROTECTED] writes:
I grabbed flex and bison from GNUwin32
(http://gnuwin32.sourceforge.net/packages/bison.htm)
This appears to not work out well. If I copy the generated files from
bison from a linux box, then they are ok, but if
On Mon, 2 Oct 2006, Magnus Hagander wrote:
This appears to not work out well. If I copy the generated
files from bison from a linux box, then they are ok, but if I
try to use ones generated using that version of bison, it
does not compile. I'll look around for a different one.
That's
On Sun, 1 Oct 2006, Jeremy Drake wrote:
On Mon, 2 Oct 2006, Magnus Hagander wrote:
If you do build solution it should build all project sin the correct
order - there are dependency references set between them that should
take care of this automatically.
If I do build solution it tells
If you do build solution it should build all project sin the
correct order - there are dependency references set between them
that should take care of this automatically.
If I do build solution it tells me Project not selected to
build for
this solution configuration for all
Hi.
I think that it has forgotten for VS2005-express to add path of SDK by myself.
http://www.winpg.jp/~saito/VS2005/VS2005_Include.png
http://www.winpg.jp/~saito/VS2005/VS2005_Library.png
Do I mistake your meaning?
Regards,
Hiroshi Saito
I switched to short paths in the INCLUDE env var, but
Can we have the beta1 binaries for Win32 with --with-ldap?
On Windows, the LDAP library is part of the OS, so we won't
incur any undesirable dependencies.
Yours,
Laurenz Albe
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Can we have the beta1 binaries for Win32 with --with-ldap?
On Windows, the LDAP library is part of the OS, so we won't incur
any undesirable dependencies.
Oops, that's an oversight, it's supposed to be there. --with-ldap will
be enabled in beta2. Sorry 'bout that.
//Magnus
Ühel kenal päeval, E, 2006-10-02 kell 01:30, kirjutas Tom Lane:
Jim C. Nasby [EMAIL PROTECTED] writes:
... place a limit on the number of transactions that can be live in a table
at once.
Urk, well maybe, but ...
you could shrink all the visibility info to 1 byte if you
wanted to.
On Friday 29 September 2006 20:02, Andrew Sullivan wrote:
At the beginning of the month, in
http://archives.postgresql.org/pgsql-hackers/2006-09/msg00453.php,
I said that I'd be willing to try to do any sort of co-ordination,
document writing, c. for a project that might define common back-end
Now, I still twist my head around the lines:
if ((fd = _open_osfhandle((long) h, fileFlags O_APPEND)) 0
||
(fileFlags (O_TEXT | O_BINARY) (_setmode(fd, fileFlags
(O_TEXT
| O_BINARY)) 0)))
Without having studied it closely, it might also highlight a bug
on
failure of the
Hi,We are trying to introduce access control. For this we have to rewrite the input query by replacing each relation by its corresponding authorized view. Which part of the code should we modify for this. Till now we have thought of the following:
1. We take as input the parse tree generated by
Magnus Hagander [EMAIL PROTECTED] writes:
I agree that this code is both wrong and unreadable (although in
practice the _setmode will probably never fail, which is why our
attention hasn't been drawn to it). Is someone going to submit a
patch? I'm hesitant to change the code myself since I'm
Shaunak Godbole wrote:
Hi,
We are trying to introduce access control. For this we have to rewrite
the input query by replacing each relation by its corresponding
authorized view.
This sounds like a pretty ugly hack. There are already extensive access
controls available in postgres. What
Andrew Dunstan [EMAIL PROTECTED] writes:
Shaunak Godbole wrote:
We are trying to introduce access control.
This sounds like a pretty ugly hack.
Perhaps more to the point, it's already been done:
http://veil.projects.postgresql.org/
regards, tom lane
Magnus Hagander [EMAIL PROTECTED] writes:
Certainly not --- we work with both of those (I have 1.875 on one
of my devel machines and 2.1 on two others).
Well, it *does* break with 2.1 on win32-native. Could be something
simple, could be that it's just generating msvc-incompatible code.
Hm,
Tom Lane [EMAIL PROTECTED] writes:
Jim C. Nasby [EMAIL PROTECTED] writes:
... place a limit on the number of transactions that can be live in a table
at once.
Urk, well maybe, but ...
you could shrink all the visibility info to 1 byte if you
wanted to.
... 256 of 'em is surely
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
Shaunak Godbole wrote:
We are trying to introduce access control.
This sounds like a pretty ugly hack.
Perhaps more to the point, it's already been done:
http://veil.projects.postgresql.org/
Ah,
Jeremy Drake [EMAIL PROTECTED] writes:
The errors I got on this file were:
1bootparse.tab.c(1065) : error C2449: found '{' at file scope (missing
function header?)
I looked at this. Line 1065 is the left brace starting yyparse(). On
my Fedora Core 5 box with Bison 2.1 installed, the stuff
Mark,
Thanks for attaching the C code for your test. I ran a few tests on a 3Ghz
Intel Xeon Paxville (dual core) system. I hope the formatting of this table
survives:
Method Size N=1024*1024 N=1
MEMCPY 63 6964927 us 582494 us
MEMCPY 32 7102497 us 582467 us
Tom,
Josh, you don't know what you're talking about. The backend's
capabilities for this have not moved an inch since 8.1 (transient bugs
in its error checking do not represent an advance in capability),
Hmmm ... was this an unapplied patch? We certainly had it working on the
benchmark
Josh Berkus josh@agliodbs.com writes:
Oh, no, what should happen is that the outer join portion of the query
doesn't
get locked, rather than a fatal exception. That behavior is expected by the
J2EE certification, so it's at least somewhat industry-standard.
Really? Please cite chapter
On Mon, 2006-10-02 at 11:38 -0400, Tom Lane wrote:
Chris Dunlop [EMAIL PROTECTED] writes:
I'm not sure if this is a bug or if it's displaying my ignorance
of this corner of SQL...
update a set name = (
select name
from temp.a
where temp.a.id = a.id
)
Postgres treats FROM
unsubscribepgsql-hackers
[EMAIL PROTECTED] writes:
Here is the cache hit case including your strlen+memcpy as 'LENCPY':
$ gcc -O3 -std=c99 -DSTRING='This is a very long sentence that is expected
to be very slow.' -DN=1 -o x x.c y.c strlcpy.c ; ./x
NONE:696157 us
MEMCPY: 825118 us
STRNCPY:7983159
Mark,
On 9/29/06 2:59 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Here are results over 64 Mbytes of memory, to ensure that every call is
a cache miss:
On my Mac OSX intel laptop (Core Duo, 2.16 GHz, 2GB RAM, gcc 4.01):
Luke-Lonergans-Computer:~/strNcpy-perf-test lukelonergan$ gcc -O3
Thanks for the results on your machines Dave, Luke, and Tom. Interesting.
On Mon, Oct 02, 2006 at 02:30:11PM -0400, Tom Lane wrote:
It appears that these results are a bit platform-dependent; on my x86_64
(Xeon) Fedora 5 box, I get
*nod*
Anyway, I looked at glibc's strncpy and determined
Mark, Tom,
Just the test on IA64 (Itanium2, 1.6Ghz, 8Gb memory). The results seem to
be quite different:
[EMAIL PROTECTED]:~/test$ gcc -O3 -std=c99 -DSTRING='This is a very long sentence that is
expected to be very slow.' -DN=(1024*1024) -o x x.c y.c strlcpy.c ; ./x
NONE:825671 us
Sergey E. Koposov [EMAIL PROTECTED] writes:
Just the test on IA64 (Itanium2, 1.6Ghz, 8Gb memory). The results seem to
be quite different:
What libc are you using exactly? Can you try it with the unrolled
strlcpy I posted?
In glibc-2.4.90, there seem to be out-of-line assembly code
Are people ready for me to run pgindent?
--
Bruce Momjian [EMAIL PROTECTED]
EnterpriseDBhttp://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---(end of broadcast)---
TIP 5: don't forget to increase
Are we ready to think about a beta2? Seems beta1 was quiet.
--
Bruce Momjian [EMAIL PROTECTED]
EnterpriseDBhttp://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---(end of broadcast)---
TIP 9: In
On Mon, 2 Oct 2006, Tom Lane wrote:
Sergey E. Koposov [EMAIL PROTECTED] writes:
Just the test on IA64 (Itanium2, 1.6Ghz, 8Gb memory). The results seem to
be quite different:
What libc are you using exactly? Can you try it with the unrolled
strlcpy I posted?
glibc 2.3.5 , gcc 3.4.4
my
I did a couple more tests using x86 architectures. On a rather old
Pentium-4 machine running Fedora 5 (gcc 4.1.1, glibc-2.4-11):
$ gcc -O3 -std=c99 -DSTRING='This is a very long sentence that is expected to
be very slow.' -DN=(1024*1024) -o x x.c y.c strlcpy.c
NONE:786305 us
MEMCPY:
Strong, David [EMAIL PROTECTED] writes:
Obviously, different copy mechanisms suit different data sizes. So, I
added a little debug to the strlcpy () function that was added to
Postgres the other day. I ran a test against Postgres for ~15 minutes
that used 2 client backends and the BG writer -
Tom,
Yes, the clients are using the V3 protocol and prepared statements.
David
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 10/2/2006 2:09 PM
To: Strong, David
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Faster StrNCpy
Strong, David
Hello,
I carefully check all mail threads of Re:
On-disk bitmap index patch
http://secure.linuxports.com/pgsql-hackers/2006-07/msg01514.php
I am testing 8.2 postgresql features
and wonder if on-disk bitmap indexes are included in beta version. It could be
great to test their
Radovan Jablonov wrote:
Hello,
I carefully check all mail threads of Re:
http://secure.linuxports.com/pgsql-hackers/2006-07/msg01507.php
On-disk bitmap index patch
http://secure.linuxports.com/pgsql-hackers/2006-07/msg01514.php
I am testing 8.2 postgresql features and wonder if on-disk
I'm looking at how NULLs are handled in relation to plpgsql row types.
Looking at exec_assign_value, it appears that we're supposed to be able
to handle setting a row variable to NULL:
if (*isNull)
{
/* If source is null, just assign nulls to
Is this a TODO item?
---
Greg Sabino Mullane wrote:
[ There is text before PGP section. ]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
When initdb is given an invalid (possibly mistyped) locale name, it just
Hi,
I'm happy that the rather verbose timestamp with time zone has the
much nicer alias timestamptz, however it seems that this alias is not
documented, neither at
http://developer.postgresql.org/pgdocs/postgres/datatype-datetime.html
nor at
On Mon, 2 Oct 2006, Tom Lane wrote:
Jeremy Drake [EMAIL PROTECTED] writes:
The errors I got on this file were:
1bootparse.tab.c(1065) : error C2449: found '{' at file scope (missing
function header?)
I looked at this. Line 1065 is the left brace starting yyparse(). On
my Fedora Core
I added the citeseer URL as an SGML comment. Neil is trying to contact
the author.
---
Tom Lane wrote:
Neil Conway [EMAIL PROTECTED] writes:
I agree the link should be fixed, but I can't see another canonical
location
Bruce Momjian [EMAIL PROTECTED] writes:
Are people ready for me to run pgindent?
I don't see a reason to hold off. There aren't any more pending patches
we intend to apply before 8.2 ...
regards, tom lane
---(end of
Thanks for the analysis. I have removed mention of the -fast option
from the Solaris FAQ.
---
Kenneth Marshall wrote:
On Wed, Sep 27, 2006 at 04:09:18PM +0200, Zdenek Kotala wrote:
Tom Lane napsal(a):
Zdenek Kotala
Is this a TODO? I don't see how it is a new problem, meaning it
probably is for 8.3.
---
Tom Lane wrote:
As per a recent discussion in pgsql-admin,
http://archives.postgresql.org/pgsql-admin/2006-09/msg00297.php
libpq
Tom Lane wrote:
Neil Conway [EMAIL PROTECTED] writes:
A wholesale replacement of strncpy() calls is probably worth doing --
replacing them with strlcpy() if the source string is NUL-terminated,
and I suppose memcpy() otherwise.
What I'd like to do immediately is put in strlcpy() and hit
On Mon, 2 Oct 2006, Jeremy Drake wrote:
In the bison 2.2 generated code, the #if check is
#if (defined __STDC__ || defined __C99__FUNC__ \
|| defined __cplusplus || defined _MSC_VER)
which looks like they figured out that they needed to check for MicroSoft
C explicitly. I have no idea
I now get things to compile, but now I get linker errors on any dll which
needs to access symbols from postgres.exe via postgres.lib. For example:
1-- Build started: Project: autoinc, Configuration: Release Win32 --
1Generate DEF file
1Not re-generating AUTOINC.DEF, file already exists.
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.
---
Documentation patch applied. Thanks. Your documentation changes can be
viewed in five minutes using links on the developer's page,
http://www.postgresql.org/developer/testing.
---
Simon Riggs wrote:
On Tue,
Bruce Momjian [EMAIL PROTECTED] writes:
Is this a TODO? I don't see how it is a new problem, meaning it
probably is for 8.3.
It's definitely not a new problem, but we hadn't recognized it before,
so it qualifies as a new bug. The question at hand was whether anyone
was excited enough about it
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Is this a TODO? I don't see how it is a new problem, meaning it
probably is for 8.3.
It's definitely not a new problem, but we hadn't recognized it before,
so it qualifies as a new bug. The question at hand was whether anyone
was
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
You'll notice that it iterates once per char. Between that and the
strlen() call in Tom's version, not sure which is the lesser evil.
Yeah, I was wondering that too. My code would require two scans of the
source string (one inside
Tom,
FWIW, Tom Daly did some SpecJAppserver runs on the latest snapshot and
didn't show any reduction in text parsing overhead. Unfortunately, he's
gone on vacation now so I can't get details.
I'm going to try to set up some tests using TPCE to see if it's affected.
--Josh
Can someone confirm this features works or fails?
---
Pavel Stehule wrote:
Hello,
I try 8.2 features. I tested to_char from doc, but without success.
postgres=# select to_char(now(), 'TMDay, DD TMMonth ');
My guess is that we are going to have to live with the warnings for 8.2
and save this issue for 8.3.
---
Tom Lane wrote:
With the latest Apple developers' tools, I get some warnings that
weren't there before:
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Can someone confirm this features works or fails?
It works if you have NLS translations for Thursday, September,
etc ... which none of the backend .po files do yet.
But they will when we have the po files updated for this release, I
On Mon, 2 Oct 2006, Bruce Momjian wrote:
Can someone confirm this features works or fails?
As I see from the original commit:
http://groups.google.com/group/pgsql.committers/browse_frm/thread/4ba64c906fca7211/0e3b4d495ec7ecf8?lnk=gstq=to_charrnum=8#0e3b4d495ec7ecf8
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
It works if you have NLS translations for Thursday, September,
etc ... which none of the backend .po files do yet.
But they will when we have the po files updated for this release, I
suppose.
We should probably list translation updates
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
It works if you have NLS translations for Thursday, September,
etc ... which none of the backend .po files do yet.
But they will when we have the po files updated for this release, I
suppose.
We should probably
On Oct 2, 2006, at 8:41 PM, Bruce Momjian wrote:
David E. Wheeler wrote:
On Sep 28, 2006, at 16:39, Jim C. Nasby wrote:
+1. I was just at a client today that had run into this problem.
Actually, I'm in favor of refusing to start if autovac is on but the
proper stats settings aren't. I'd
Jim Nasby wrote:
On Oct 2, 2006, at 8:41 PM, Bruce Momjian wrote:
David E. Wheeler wrote:
On Sep 28, 2006, at 16:39, Jim C. Nasby wrote:
+1. I was just at a client today that had run into this problem.
Actually, I'm in favor of refusing to start if autovac is on but the
proper stats
Magnus Hagander wrote:
Now, I still twist my head around the lines:
if ((fd = _open_osfhandle((long) h, fileFlags O_APPEND)) 0
||
(fileFlags (O_TEXT | O_BINARY) (_setmode(fd, fileFlags
(O_TEXT
| O_BINARY)) 0)))
Without having studied it closely, it might also highlight
On Oct 2, 2006, at 6:28 PM, Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
However, the test right above that means that we'll fail if the user
tries something like row_variable := NULL;:
The patch you seem to have in mind would allow
row_variable := int_variable;
to succeed
On Oct 2, 2006, at 6:22 PM, AgentM wrote:
On Oct 2, 2006, at 18:15 , Markus Schaber wrote:
I'm happy that the rather verbose timestamp with time zone has the
much nicer alias timestamptz, however it seems that this alias
is not
documented, neither at
On Oct 2, 2006, at 9:17 PM, Bruce Momjian wrote:
Jim Nasby wrote:
On Oct 2, 2006, at 8:41 PM, Bruce Momjian wrote:
David E. Wheeler wrote:
On Sep 28, 2006, at 16:39, Jim C. Nasby wrote:
+1. I was just at a client today that had run into this problem.
Actually, I'm in favor of refusing to
Looks like the gendef script is failing. Check the contents of
release\postgres\postgres.def - it should have thousands of symbols, but
I'm willing to bet it's empty...
//Magnus
-Original Message-
From: Jeremy Drake [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 03, 2006 1:28 AM
Jeremy Drake [EMAIL PROTECTED] writes:
The errors I got on this file were:
1bootparse.tab.c(1065) : error C2449: found '{' at file scope
1(missing function header?)
I looked at this. Line 1065 is the left brace starting
yyparse(). On
my Fedora Core 5 box with Bison 2.1
69 matches
Mail list logo