josh@agliodbs.com (Josh Berkus) writes:
Overall, though, I think we should really wait until 8.3 for core merge and
API improvements. Wasn't Tom just complaining about last-minute features,
and not enough code reviewers?
He may have worked through enough of the backlog that he's ready to
What's up there? It has been down all week.
We're trying to get the Slony-I 1.2 release out, so we can then
migrate over to pgFoundry. But that doesn't working terribly well
when gBorg's down...
--
let name=cbbrowne and tld=acm.org in String.concat @ [name;tld];;
[EMAIL PROTECTED] (Tom Lane) writes:
Chris Browne [EMAIL PROTECTED] writes:
If I touch preproc.y and pgc.l, the .c files get regenerated, and all
is well.
If I don't, they get left alone, and I see compilation errors.
It seems to me you need to rebuild the C files and commit them
[EMAIL PROTECTED] (elein) writes:
Also people trying to download slony have to do some
hunting to find things. The source only tar is not
available on pgfoundry.
The source tarball for version 1.1.5 is now in place:
http://pgfoundry.org/frs/download.php/1063/slony1-1.1.5.tar.bz2
We may as
[EMAIL PROTECTED] (Magnus Hagander) writes:
Also people trying to download slony have to do some hunting
to find things. The source only tar is not available on pgfoundry.
All gborg *downloads* are available on:
http://www.postgresql.org/ftp/projects/gborg/
Seems Slony hasn't released
with this (lots...:)
Bye, Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
[EMAIL PROTECTED] (Michael Meskes) writes:
On Tue, Aug 29, 2006 at 03:35:14PM -0500, Jaime Casanova wrote:
Ah. So this would have caused a bunch of problems in compiling
src/interfaces/ecpg/test/connect/test1.pgc???
Not the compilation errors I would think.
i'm seeing this error when
[EMAIL PROTECTED] (Tom Lane) writes:
[EMAIL PROTECTED] (Michael Meskes) writes:
Second try committing the path changes.
Ah, this looks better. I get clean passes on both HPPA in-tree and
Fedora x86_64 VPATH builds, so I think you've finally fixed all the
issues. Congrats!
Ah. So this
a variable introduce a difference between \g and ;.
[goes benchmarking...]
Bye, Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
, but then again, I'm
not a cycle counter type of programmer *cough* Java *cough* ;)...
Opinions?
Bye, Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe
to retrieving big data
where a strtol doesn't matter anyway. The overhead comes from scanning
the linked list for nothing in the normal case (when it's not set).
I don't know how the other uses factor in here, but I see it's called
at least twice more on average calls to SendQuery.
Bye,
Chris
, consistently.
If we find we can't live with the performance overhead of that
if(FETCH_COUNT), it is still not clear why we would be better
off moving it into the \g code path only.
Is it because presumably \g is used less often in existing psql scripts?
Bye, Chris.
--
Chris Mair
http://www.1006
[EMAIL PROTECTED] (Jeff Davis) writes:
On Wed, 2006-08-23 at 13:36 +0200, Markus Schiltknecht wrote:
Hannu Krosing wrote:
But if you have very few writes, then there seems no reason to do sync
anyway.
I think there is one: high-availability. A standby-server which can
continue if your
[EMAIL PROTECTED] (Peter Eisentraut) writes:
Am Mittwoch, 16. August 2006 14:10 schrieb Robert Treat:
I'm not sure I follow this, since currently anyone can email the bugs list
or use the bugs - email form from the website. Are you looking to
increase the barrier for bug reporting?
Only a
a single char I wanted a single char one
too. The c for cursor was taken already, so i choose the u (second
char in cursor). If somebody has a better suggestion, let us know ;)
Bye, Chris.
PS: I'm traveling Fri 18th - Fri 25th and won't check mail often.
--
Chris Mair
http://www.1006.org
diff
Replying to myself...
Patch with fix against current CVS is attached.
Alvaro Herrera sent two fixes off-list: a typo and
at the end of SendQueryUsingCursor I sould COMMIT, not ROLLBACK.
So, one more version (6) that fixes these too is attached.
Bye, Chris.
PS: I'm keeping this on both lists
Patch with fix against current CVS is attached.
Forgot the attachment... soory.
--
Chris Mair
http://www.1006.org
diff -rc pgsql.original/doc/src/sgml/ref/psql-ref.sgml pgsql/doc/src/sgml/ref/psql-ref.sgml
*** pgsql.original/doc/src/sgml/ref/psql-ref.sgml 2006-08-17 16:50:58.0
to existing code paths. Also the other \pset options are somewhat
orthogonal to this one. Just my two EUR cents, of course... :)
Bye, Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 1: if posting/reading through Usenet
it as a modifyer to \g? Yea, that works, but it doesn't work for
';' as a 'go' command, of course, which is perhaps OK.
Yes, it was intended to differentiate this command from ';';
Bye, Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast
[EMAIL PROTECTED] (Paul Silveira) writes:
Does anyone have any good examples of implementing snapshot
replication. I know that PostgreSQL does not have snapshot
replication and that Slony-I is the recomended replication senario
but I've configured it and it seems rather advanced for a shop
[EMAIL PROTECTED] (Bruce Momjian) writes:
Christopher Browne wrote:
Make postmater and postgres options distinct so the postmaster -o
option is no longer needed | Alvaro | Confirmed | 09/20/06
Notice the sequence of events. I am not saying the specific statuses are
the way to go but
[EMAIL PROTECTED] (Tom Lane) writes:
Joshua D. Drake [EMAIL PROTECTED] writes:
Well if an initdb was not required, I think that would be a huge feature
;) (I know it may not work release over release)
If someone had started working on pg_upgrade six months ago, we might
have that for 8.2
[EMAIL PROTECTED] (Andrew Dunstan) writes:
Joshua D. Drake wrote:
As a protection against malice, yes. I think Rod was more
interested in some protection against stupidity.
Maybe the real answer is that Slony should connect as a
non-superuser and call security definer functions for the
[EMAIL PROTECTED] (moises) writes:
html xmlns:o=urn:schemas-microsoft-com:office:office
xmlns:w=urn:schemas-microsoft-com:office:word
xmlns=http://www.w3.org/TR/REC-html40;
head
meta http-equiv=Content-Type content=text/html; charset=us-ascii
meta name=Generator content=Microsoft Word 11
Robert Hansen did a talk at OSCON on a compressed annealing framework
called Djinni: http://sixdemonbag.org/Djinni/
It's a framework to use compressed annealing (a derivative of
simulated annealing) for finding approximate solutions to NP-complete
problems such as the TSP with time windows. Note
[EMAIL PROTECTED] (Jim C. Nasby) writes:
There are other transactions to consider: user transactions that will
run a long time, but only hit a limited number of relations. These are
as big a problem in an OLTP environment as vacuum is.
Rather than coming up with machinery that will
[EMAIL PROTECTED] (Peter Eisentraut) writes:
Chris Browne wrote:
In support of PG 8.2, we need to have the log trigger function do the
following:
- Save value of standards_conforming_string
- Set value of standards_conforming_string to FALSE
- proceed with saving data to sl_log_
[EMAIL PROTECTED] (Tom Lane) writes:
Chris Browne [EMAIL PROTECTED] writes:
Unfortunately (perhaps) standards_conforming_strings does not appear
to be exported, so I'm not sure how to do this otherwise.
Perhaps your problem is one of spelling? It's
standard_conforming_strings, and it's
In support of PG 8.2, we need to have the log trigger function do the
following:
- Save value of standards_conforming_string
- Set value of standards_conforming_string to FALSE
- proceed with saving data to sl_log_?
- Recover value of standards_conforming_string
The variable,
that PostgreSQL only has
some of the raw materials that could be used to architect such a thing.
Thanks!
- Chris
[1] http://www.postgresql.org/docs/8.1/interactive/backup-online.html
---(end of broadcast)---
TIP 4: Have you searched our list
Looks like gBorg has gone down...
The Slony-I project does plan to move to pgFoundry, once 1.2 is released...
http://slony-wiki.dbitech.ca/index.php/Move_to_PgFoundry_Checklist
But we need to get to that point (1.2) first. Alas, gBorg being down
today doesn't help :-(.
--
(format nil [EMAIL
Hi All,
I've been working on a small module that I will be pluging into my
local PostreSQL 8.x database and am in need of doing some table locking.
At this time, I've used various other examples to no avail and was
wondering what the proper method for aquiring a table lock within the
module
kleptog@svana.org (Martijn van Oosterhout) writes:
On Thu, Jul 13, 2006 at 01:26:30PM -0400, Tom Lane wrote:
The right way to proceed is what was mentioned in another message:
work harder at educating packagers about which non-core projects
are worth including in their packages. I have to
I understand that we have an issue, with Slony-I, concerning the new
standards_conforming_strings option in 8.2.
Slony-I uses the legacy quoting conventions, which, such as it is,
is fine.
If a particular server is set to standards_conforming_strings=on, this
will presumably lead to certain bits
, but needs some performance
improvment and double checking. Which I won't do before getting
some feedback that what I'm doing does make any sense at all ;)
Bye, Chris
[1] http://neilconway.org/talks/hacking/
[2] http://www.1006.org/tmp/psql_cursor-3.patch
---(end
[EMAIL PROTECTED] (David Fetter) writes:
On Fri, Jul 07, 2006 at 05:33:14AM -0500, Andrew Dunstan wrote:
Christopher Browne said:
The notion: Plenty of libraries out there like Pg, DBI::Pg, and such
make you specify connections in the form:
host=my.db.host.example.org port=5678
failures vs OS
(as the first poster said) or failures vs gcc version or timings vs.
arch / RAM or gcc version, etc. For the timings I guess there are
some timestamps embedded that might be extracted...
But I didn't really think about it, before posting (classic
mailing list syndrome ;)
Bye,
Chris
currval().
Check out the CREATE FUNCTION documentation:
http://www.postgresql.org/docs/8.1/interactive/sql-
createfunction.html
- Chris
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Thanks for the stats Andrew. Out of interest, can you easily tabulate
the number of failures against OS?
Or, more generally, even put a dump of the DB (without personal infos
of course :) somewhere?
Bye, Chris.
PS: and don't say you're running it in MySQL
[EMAIL PROTECTED] (Marc Munro) writes:
As you see, slony is attempting to enter one tuple
('374520943','22007','0') two times.
Each previous time we have had this problem, rebuilding the indexes on
slony log table (sl_log_1) has fixed the problem. I have not reindexed
the table this time as
[EMAIL PROTECTED] (Csaba Nagy) writes:
[...]
There has to be a more linear way of handling this scenario.
So vacuum the table often.
Good advice, except if the table is huge :-)
... Then the table shouldn't be designed to be huge. That represents
a design error.
Here we have for
[EMAIL PROTECTED] (Robert Lor) writes:
For DTrace, probes can be enabled using a D script. When the probes
are not enabled, there is absolutely no performance hit whatsoever.
That seems inconceivable.
In order to have a way of deciding whether or not the probes are
enabled, there has *got* to
;
UPDATE very_important_table SET important_column = 'Smith' WHERE
true;
Would such a patch ever be accepted?
Thanks!
- Chris
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
kleptog@svana.org (Martijn van Oosterhout) writes:
On Tue, Jun 13, 2006 at 05:23:56PM -0400, Christopher Browne wrote:
[3]
http://www.intelligententerprise.com/010327/celko_online.jhtml;jsessionid=NDIHEWXGL4TNKQSNDBNSKHSCJUMEKJVN
The sample problem in [3] is one that shows pretty nicely
[EMAIL PROTECTED] (Andreas Pflug) writes:
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andreas
Pflug
Sent: 31 May 2006 16:41
Cc: Tom Lane; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Possible TODO item: copy to/from pipe
, and the
combination of the two.
Thanks In Advanced.
Chris
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
[EMAIL PROTECTED] (Mark Woodward) writes:
Jim C. Nasby wrote:
Maybe a compatability layer isn't worth doing, but I certainly
think it's very much worthwhile for the community to do everything
possible to encourage migration from MySQL. We should be able to
lay claim to most advanced and most
[EMAIL PROTECTED] (Marc G. Fournier) writes:
To give someone a running chance at migrating it to PostgreSQL, a
'MySQL compatibility module' would allow them to just plug the
existing DB in, and then work at improving sections of the code over
time ...
Hell, if done well, the module should be
[EMAIL PROTECTED] (Larry Rosenman) writes:
Gentlepeople,
Now that the patch is out for keeping the last
autovacuum/vacuum/analyze/autoanalyze
timestamp in the stats system is pending, what's the consensus view on
what, if any,
logging changes are wanted for autovacuum?
I have the
[EMAIL PROTECTED] (Tom Lane) writes:
Larry Rosenman [EMAIL PROTECTED] writes:
I'd like to see a more concrete definition of what we
want Autovacuum to output and at what levels.
I would argue that what people typically want is
(0) nothing
(1) per-database log
[EMAIL PROTECTED] (Gevik Babakhani) writes:
This may be a dumb question but please bear a moment with me. About
the TODO item %Allow pg_hba.conf settings to be controlled via
SQL: If in the future we could configure the settings by SQL
commands, assuming the settings are saved in an internal
[EMAIL PROTECTED] (Tom Lane) writes:
If your pg_hba.conf looks like
hostall all 0.0.0.0/32 md5
there's not much call to update it dynamically ...
There's one case, where .pgpass got hosed, and you didn't have a
backup of it, and need to assign new passwords...
I once
[EMAIL PROTECTED] (Andrew Dunstan) writes:
We don't have the luxury of being able just to throw out old stuff
because we think it might be neater to do it another way. The current
rules for HBA are order dependent. The issue raised as I understood it
was not to invent a new scheme but to be
[EMAIL PROTECTED] (Dhanaraj M - Sun Microsystems) writes:
Hi all,
I have recented joined and working on postgres. I fixed a bug that I
saw in the mailing list. I ran the regression test that is available
in postgres. It was successful and now I need the following details..
1) Test suits
[EMAIL PROTECTED] (Markus Bertheau) writes:
2006/3/17, Bruce Momjian pgman@candle.pha.pa.us:
Peter Eisentraut wrote:
Bruce Momjian wrote:
The psql manual pages for 8.1 now has:
\set HISTFILE ~/.psql_history- :DBNAME
Any reason psql doesn't do this by default? It is
[EMAIL PROTECTED] (Greg Stark) writes:
Christopher Browne [EMAIL PROTECTED] writes:
Letter of Invitation for Countries Whose Citizens Require a
Temporary Resident Visa to Enter Canada
I missed that this was happening up here in Canada. How exclusive is
the guest list for this? Like, are
[EMAIL PROTECTED] (Robert Treat) writes:
On Tuesday 14 February 2006 16:00, Martijn van Oosterhout wrote:
I would like to suggest that we increase substantially the FAQ entries
relating to patch submission. By we, I actually mean please could the
committers sit down and agree some
kleptog@svana.org (Martijn van Oosterhout) writes:
On Sat, Feb 04, 2006 at 01:54:52AM +0100, Peter Eisentraut wrote:
I took a first swing at this and rearranged some of these calls.
ld -- On AIX at least this seems to be some magic library but doesn't
have an obvious testable symbol.
a composite type for the return value
Basically, better performance and easier administration.
Thanks!
- Chris
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
have most of the features I want (only missing
the ability to pass arguments), so it's a shorter distance to the
goal than by starting with functions.
Thanks!
- Chris
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
that's why I keep
coming back to it.
Thanks!
- Chris
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
[EMAIL PROTECTED] (Mark Woodward) writes:
The port aspect is troubling, it isn't really self
documenting. The application isn't psql, the applications are custom
code written in PHP and C/C++.
Nonsense. See /etc/services
Using the /etc/hosts file or DNS to maintain host locations for is
a
to. Basically working like
a proxy.
- Chris
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
something new every day. I'm still using 7.4 for most of my day
job, and I can't do this without supplying a column definition list:
ERROR: a column definition list is required for functions returning
record
I hereby withdraw my proposal for CREATE SQL FUNCTION.
Thanks!
- Chris
FUNCTION and CREATE SQL FUNCTION commands (as described) in the
grammar? :)
Thanks!
- Chris
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's
used above would be problematic: how would
it distinguish that from a call to a sales_figures() function? Any
comments about alternative syntax would be welcome, too!
Thanks!
- Chris
smime.p7s
Description: S/MIME cryptographic signature
overlook my bad example because
they've had the need for a view with arguments tool in their own
work, and the conversation would just be about how it could be
implemented. :)
I'll try to distill a better example from some of the projects I'm
working on.
Thanks!
- Chris
matthew@zeut.net (Matthew T. O'Connor) writes:
Legit concern. However one of the things that autovacuum is supposed to
do is not vacuum tables that don't need it. This can result in an overal
reduction in vacuum overhead. In addition, if you see that autovacuum is
firing off vacuum commands
[EMAIL PROTECTED] (Alvaro Herrera) writes:
Chris Browne wrote:
It strikes me as a slick idea for autovacuum to take on that
behaviour. If the daily backup runs for 2h, then it is quite futile
to bother vacuuming a table multiple times during that 2h period when
none of the tuples obsoleted
[EMAIL PROTECTED] (Tom Lane) writes:
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm, yeah, sounds useful. There's one implementation issue to notice
however, and it's that the autovacuum process dies and restarts for each
iteration, so there's no way for it to remember previous state unless
[EMAIL PROTECTED] writes:
On Thu, Jan 19, 2006 at 09:37:12AM -0500, Pollard, Mike wrote:
Martijn van Oosterhout wrote:
Please provides natural keys for any of the following:
- A Person
- A phone call: (from,to,date,time,duration) is not enough
- A physical address
- A phone line:
Lukas Smith [EMAIL PROTECTED] writes:
Bruce Momjian wrote:
* Flush cached query plans when the dependent objects change,
when the cardinality of parameters changes dramatically, or
when new ANALYZE statistics are available
Wouldn't it also make sense to flush a cached
[EMAIL PROTECTED] (Gustavo Tonini) writes:
But, wouldn't the performance be better? And wouldn't asynchronous
messages be better processed?
Why do you think performance would be materially affected by this?
The MAJOR performance bottleneck is normally the slow network
connection between
. You'll also need to send it to
postgresql-8.1-int.msi - this is also documented on the page above.
//Magnus
Excellent!
Thanks for the info!
-- chris
and
installation directory. Is this feasible?
Hopefully this is the right list, if not if someone could direct me to
the correct one, I'd appreciate it.
Please CC me as I am not currently subscribed to this list.
thanks
-- chris
---(end of broadcast
[EMAIL PROTECTED] (Gavin Sherry) writes:
Hi,
On Tue, 14 Nov 2005 [EMAIL PROTECTED] wrote:
Gavin Sherry:
Grouping sets
Recursive queries
The recursive queries is a long-awaited feature. Does the fact that
the feature is listed for Gavin Sherry mean that Gavin is
[EMAIL PROTECTED] (Tom Lane) writes:
The 8.1 supported-platforms list is looking pretty good, I think -- we
don't have updates for every single combination of OS and hardware,
but we have updates for every OS and at least one instance of all
supported CPU types.
Not to pester overly...
AIX
[EMAIL PROTECTED] (Jim C. Nasby) writes:
On Tue, Nov 01, 2005 at 11:23:55AM -0300, Alvaro Herrera wrote:
Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
AFAIK they're not using subtransactions at all, but I'll check.
Well, yeah, they are ... else you'd never have seen this
[EMAIL PROTECTED] (Jim C. Nasby) writes:
AFAIK they're not using subtransactions at all, but I'll check.
Are they perchance using pl/PerlNG?
We discovered a problem with Slony-I's handling of subtransactions
which was exposed by pl/PerlNG, which evidently wraps its SPI calls
inside
[EMAIL PROTECTED] (Alvaro Herrera) writes:
Chris Browne wrote:
[EMAIL PROTECTED] (Jim C. Nasby) writes:
On Tue, Nov 01, 2005 at 11:23:55AM -0300, Alvaro Herrera wrote:
Tom Lane wrote:
Jim C. Nasby [EMAIL PROTECTED] writes:
AFAIK they're not using subtransactions at all, but I'll
[EMAIL PROTECTED] (Tom Lane) writes:
Stefan Kaltenbrunner [EMAIL PROTECTED] writes:
hmm well -HEAD(and 8.0.4 too!) is broken on AIX 5.3ML3:
http://archives.postgresql.org/pgsql-hackers/2005-10/msg01053.php
[ shrug... ] The reports of this problem have not given enough
information to fix it,
[EMAIL PROTECTED] (Andreas Pflug) writes:
Tom Lane wrote:
Andreas Pflug [EMAIL PROTECTED] writes:
So postmaster doesn't clean up pg_listener,
It never has. If you're complaining about this patch
http://archives.postgresql.org/pgsql-committers/2005-10/msg00073.php
you ought to say so,
that they are the same
length before performing the comparison.
Understood, but what gain do you have in a case like this that might
justify the effort that would go into making it, say, an initdb option?
How often does this behavior cause problems?
Best Wishes,
Chris Travers
Metatron Technology
other cases.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
[EMAIL PROTECTED] (Hannu Krosing) writes:
It also seems that Slony can be modified to not use LISTEN/NOTIFY in
high load situations (akin to high performance network cards, which
switch from interrupt driven mode to polling mode if number of packets
per second reaches certain thresolds).
[EMAIL PROTECTED] (Steve Atkins) writes:
We started our upgrade from 7.2 to 7.4 about 20 months ago and finished it
about 10 months ago, skipping 7.3 entirely.
We did similar; there was only one system deployed in a timeframe
where 7.3 was relevant, and the big systems skipped over 7.3 much as
[EMAIL PROTECTED] (Marc G. Fournier) writes:
On Mon, 26 Sep 2005, Josh Berkus wrote:
Tom,
Or, as you say, we could take the viewpoint that there are commercial
companies willing to take on the burden of supporting back releases, and
the development community ought not spend its limited
[EMAIL PROTECTED] (Joshua D. Drake) writes:
Hans-Jürgen Schönig wrote:
no because a new is not a heap ...
Why not use a function with a temporary table?
That way you can pass a table parameter that
is the temporary table with a select statement
that you can populate the temp table with.
[EMAIL PROTECTED] (huaxin zhang) writes:
not sure where to put this.
I run two queries:
1. select count(*) from table where indexed_column10;
2. select * from table where indexed_column10;
the indexed column is not clustered at all. I saw from the trace
that both query runs through
On Mon, 2005-09-05 at 15:27 -0400, Tom Lane wrote:
Chris Traylor [EMAIL PROTECTED] writes:
1.) Is anyone else currently working on this?
No, and AFAIR no one has ever even asked for it. I'm a little dubious
about doubling the storage requirements for geometry data and likely
creating
On Mon, 2005-09-05 at 20:40 -0400, Tom Lane wrote:
Chris Traylor [EMAIL PROTECTED] writes:
On Mon, 2005-09-05 at 15:27 -0400, Tom Lane wrote:
I'd suggest keeping these as separate private types rather
than expecting that a patch to replace the 2D types will be accepted.
What do you
be more readable, and probably more useful, but it would more than likely be more work initially.
6.) Are there any objections to breaking up geo_ops.c into separate sources?
7.) Can anyone think of any issues that I'm missing?
Chris
--
Sometimes I wonder whether the world is being run
On Sun, 2005-09-04 at 21:45 -0700, Paul Ramsey wrote:
Chris,
PostGIS already has 4d geometry, though few functions that work with
that fourth dimension (how far is 8am, in Paris from 4pm in
London?). Have you checked if there is some room to meet your needs
with some PostGIS
[EMAIL PROTECTED] (David Parker) writes:
The slony log trigger saves execution plans, so any given connection
that has been used with a slony schema installed will have cached OIDs
referring to the sl_log_1 table. When you drop the schema, those OIDs
obviously go away. When you re-create the
[EMAIL PROTECTED] (Alvaro Herrera) writes:
On Tue, Aug 30, 2005 at 12:45:18PM -0400, Chris Browne wrote:
[EMAIL PROTECTED] (David Parker) writes:
The slony log trigger saves execution plans, so any given
connection that has been used with a slony schema installed will
have cached OIDs
[EMAIL PROTECTED] (Alvaro Herrera) writes:
Or, slightly different, what are people's most wanted features?
- Vacuum Space Map - Maintain a map of recently-expired rows
This allows vacuum to target specific pages for possible free
space without requiring a sequential scan.
- Deferrable
[EMAIL PROTECTED] (Alvaro Herrera) writes:
On Thu, Aug 25, 2005 at 02:45:02PM -0700, Joshua D. Drake wrote:
If y'all would like, I can eliminate the anti-virus/anti-spam checks and
just let it all go through though ... *evil grin*
Would not bother me in the least. I have protective
someone to commit to helping me on the contest, so that PostgreSQL can
participate.
What is involved in this? Maybe if you give specifics one of us can
commit to helping :-)
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast
Just ran into a fascinating edge case. One of our folks was building
a stored function, and ran into an odd error when trying to COPY to
stdout.
Here's a characteristic example:
create or replace function build_table (integer) returns integer as '
begin
execute ''copy foo to stdout;'';
Hi All,
I've been doing a code audit (review) for my own personal use of the
7.4.x series code base and have come across something that I'd like to get
more details on, if it is possible to do so.
I've been going over the communications section and am curious how this
segment of code is
301 - 400 of 489 matches
Mail list logo