Kevin Barnard wrote:
The basic idea of my proposal would be to have a function that checks
for the existence of C libraries. The next piece I would need would
be a mechanism for psql to halt the restore SQL script if these
checks failed. Finally I would need to add a switch to tell pg_dump
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Surely, I've created one (nickname: Nikolay) and are
trying to do things being logged in :-)
You should be able to edit now with the Nikolay account.
If anyone else is having problems, please send me an email.
I'll
On Fri, Jan 26, 2007 at 10:10:20PM +0100, Magnus Hagander wrote:
I would like to build pg on VC2005. How do I use pthreads that is
mentioned in the README file. Do I need the DLL? Sources? LIB?
Where do I install or copy them..
Err, pthreads is a threads library for Unix, I don't think
Joachim Wieland wrote:
On Fri, Jan 26, 2007 at 10:10:20PM +0100, Magnus Hagander wrote:
I would like to build pg on VC2005. How do I use pthreads that is
mentioned in the README file. Do I need the DLL? Sources? LIB?
Where do I install or copy them..
Err, pthreads is a threads library for
Hi there,
I want to center a content of table's cell
(ex. http://mira.sai.msu.su/~megera/pgsql/lockmatrix/c2.html),
but jade seems doesn't generate a right html code.
sgml code looks like:
table id=lock-matrix frame=topbot pgwide=1
titleLock Matrix/title
tgroup cols=10 align=center
Simon Riggs [EMAIL PROTECTED] writes:
In a thread in July last year, I raised the possibility of transforming
a query to allow functional indexes to be utilised automatically.
http://archives.postgresql.org/pgsql-hackers/2006-07/msg00323.php
This idea can work and has many benefits, but
David Fetter wrote:
On Sat, Jan 27, 2007 at 09:49:25PM -0800, Joshua D. Drake wrote:
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
So what are we thinking here? Along with my suggestion of
extensions / contrib that we modify initdb to load an extensions
schema with all extensions
Gregory Stark [EMAIL PROTECTED] writes:
I've thought further about this and I believe the problem is simpler than we
were thinking previously. All we need is one boolean flag on the equality
operator for the data type (or perhaps it would be more convenient to have it
on the operator class)
Oleg Bartunov wrote:
I want to center a content of table's cell
Put the align attributes into the entry elements.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hello
SQL/PSM standard defines language for stored procedures. PL/pgPSM is
postgresql's implementation of SQL/PSM. I uploaded first version, which can
be tested without patching core files. Simply download and compile it. Some
samples you can find on
On Sun, 28 Jan 2007, Peter Eisentraut wrote:
Oleg Bartunov wrote:
I want to center a content of table's cell
Put the align attributes into the entry elements.
I'm wonderin why global setting tgroup cols=10 align=center doesn't
work. Specifying that fro each entry element looks very
Seems the UUID patch broke Windows builds.
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=snakedt=2007-01-28%2018:30:01
uuid_t is defined to UUID in the win32 platform SDK header files. I
would suggest we use pguuid_t or something like that instead.
//Magnus
---(end
On Sun, 2007-01-28 at 20:47 +0100, Magnus Hagander wrote:
uuid_t is defined to UUID in the win32 platform SDK header files. I
would suggest we use pguuid_t or something like that instead.
We could possibly try to workaround it by #undef'ing any existing uuid_t
definitions before we supply our
It seems a general solution would involve having dependency.c take
exclusive locks on all types of objects (not only tables) as it scans
them and decides they need to be deleted later. And when adding a
pg_depend entry, we'd need to take a shared lock and then recheck to
make sure the
Stefan Kaltenbrunner [EMAIL PROTECTED] writes:
FWIW - I removed --with-tcl from quagga's configuration about two weeks
ago and it has not failed(for that reason) again. So the issue most
definitly looks like plptcl related ...
I poked around a bit in the Tcl sources, and as far as I can tell
Oleg Bartunov wrote:
I'm wonderin why global setting tgroup cols=10 align=center
doesn't work.
It's not implemented. Feel free to code it. :)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 1: if
On Sun, Jan 28, 2007 at 10:10:14AM -0800, Joshua D. Drake wrote:
David Fetter wrote:
On Sat, Jan 27, 2007 at 09:49:25PM -0800, Joshua D. Drake wrote:
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
So what are we thinking here? Along with my suggestion of
extensions / contrib
Michael Glaesemann wrote:
On Jan 28, 2007, at 11:25 , Joshua D. Drake wrote:
David Fetter wrote:
Not so great. SQL:2003 has a special meaning for the word module.
Yeah I saw mention of that in another thread, but I really didn't like
the word plugins. Do you have another thought?
On Sun, Jan 28, 2007 at 04:52:27PM -0500, Andrew Dunstan wrote:
Michael Glaesemann wrote:
On Jan 28, 2007, at 11:25 , Joshua D. Drake wrote:
David Fetter wrote:
Not so great. SQL:2003 has a special meaning for the word module.
Yeah I saw mention of that in another thread, but I
Well to me that gets a little messy. I mean:
pg_catalog,public,user schemas,xml2,ltree (just to get a could
functions?) etc...
Not as messy as trying to drop or re-create a package when there are
already 500 functions in the public schema.
I am not sure I understand the correlation. I am
I don't mind this term, BUT, what we need to get across is not just that
these are extensions, but that they are *standard* extensions, supplied
with PostgreSQL core code and supported by the PostgreSQL core team.
This would be analogous with, say, the standard perl modules (like
On Sun, Jan 28, 2007 at 01:58:38PM -0800, Joshua D. Drake wrote:
Well to me that gets a little messy. I mean:
pg_catalog,public,user schemas,xml2,ltree (just to get a could
functions?) etc...
Not as messy as trying to drop or re-create a package when there
are already 500
I don't think all or nothing is a good way to do this. 500
functions in a schema called extensions isn't much more helpful than
500 in public. There's a reason namespaces were invented long ago,
and this is classic use case for same. :)
I disagree, see my post previously about
On Sun, Jan 28, 2007 at 02:14:36PM -0800, Joshua D. Drake wrote:
I don't think all or nothing is a good way to do this. 500
functions in a schema called extensions isn't much more helpful
than 500 in public. There's a reason namespaces were invented
long ago, and this is classic use case
David Fetter wrote:
I think it's necessary to get each in its own schema whether we have
an initdb flag or not.
In any case, the initdb flag idea is about as much a nonstarter as the
configure flag idea, for the same (packaging) reasons.
--
Peter Eisentraut
--enable-extension=earthdistance
And have to parse for each extension?
I don't see this as a big problem.
Well I am not really interesting in this. Someone else is welcome
to try that.
It's really not hard, even for a C n00b like me. :)
I didn't say it was hard. I said I wasn't interested
Peter Eisentraut wrote:
David Fetter wrote:
I think it's necessary to get each in its own schema whether we have
an initdb flag or not.
In any case, the initdb flag idea is about as much a nonstarter as the
configure flag idea, for the same (packaging) reasons.
I don't see your point but
Tom Lane wrote:
Would a simple constant value be workable, or do we need some more
complex model (and if so what)?
Consider:
ANALYZE myfunc(integer) ON (SELECT myfunc(7)) WITH RATIO 0.03;
ANALYZE myfunc(text,text) ON (SELECT myfunc(mt.a,mt.b) FROM mytable mt) WITH
RATIO 1.071;
ANALYZE
Mark Dilger [EMAIL PROTECTED] writes:
Tom Lane wrote:
Would a simple constant value be workable, or do we need some more
complex model (and if so what)?
Consider:
ANALYZE myfunc(integer) ON (SELECT myfunc(7)) WITH RATIO 0.03;
...
It seems to me that the above system would work perfectly
Tom Lane wrote:
Mark Dilger [EMAIL PROTECTED] writes:
Tom Lane wrote:
Would a simple constant value be workable, or do we need some more
complex model (and if so what)?
Consider:
ANALYZE myfunc(integer) ON (SELECT myfunc(7)) WITH RATIO 0.03;
...
It seems to me that the above system would
This is a proposal for archive log compression keeping physical log in WAL.
In PotgreSQL 8.2, full-page_writes option came back to cut out physical
log both from WAL and archive log. To deal with the partial write
during the online backup, physical log is written only during the online
backup.
31 matches
Mail list logo
