and hash
functions, which pretty much amounts to what we need for cross-type
operator classes now.
But I think people are getting tired of me going on about collate and I
should just go implement it :)
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent
enough that 8.2 is ancient (first release it could
possibly appear in) it won't get a lot of usage.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
so I
posted an update. There's no particular point reviewing the old patch
since psql changed quite a bit between now and then.
If you somehow mark the held queue so people look at that email and the
new patch rather than the old one, that'd be great.
Have a nice day,
--
Martijn van Oosterhout
. Since
-core seems uninterested, I think this would be the best way to go.
Have a nice day,
[1]
http://ftp.debian.org/debian/pool/main/p/postgresql-common/postgresql-common_43.tar.gz
[2] http://archives.postgresql.org/pgsql-hackers/2006-02/msg00942.php
--
Martijn van Oosterhout kleptog@svana.org
. If someone writes it all
themselves then they can send a patch. OTOH if several people want to
collaborate on a solution, something like pgfoundary is useful.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration
at a time to get
any meaningful work done. The quick turnaround you get on a whiteboard
simply doesn't exist.
Don't take it personally. One effect of this system is the first-mover
advantage. The first person to implement gets the biggest say in the
final result.
Have a ncie day,
--
Martijn van
everybody to be running in a transaction, so vacuum does too...
At least, that's what I thought,
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
solve the
issue of how to display the database names to users. Maybe define a
cluster encoding for the shared catalogs...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool
On Tue, Feb 28, 2006 at 12:05:17PM -0300, Alvaro Herrera wrote:
Martijn van Oosterhout wrote:
This may be the only solution. Converting everything to UTF-8 has
issues because some encodings are not roundtrip-safe (Enc - UTF8 - Enc
gives you a different string than you started
On Tue, Feb 28, 2006 at 11:19:02AM -0500, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
This may be the only solution. Converting everything to UTF-8 has
issues because some encodings are not roundtrip-safe
Is this still true?
I beleive so. If use the ICU Converter
been
AND/OR'd with other bitmaps and only at the end checking visibility.
But maybe that already happens...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5
of handling this task, such as a developer tool
that I didn't find?
In the include/catalog directory there are two script, unused_oids and
duplicate_oids. It tells you whats available.
Have a ncie day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5
it will be the uncommon case.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
and if you forget to update them you get strange
numbers instead.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting
that you couldn't use vacuum on the toast
table anymore. Or teach vacuum that everytime it moves a tuple it needs
to update the original table (sequential scan). What exactly are you
trying to save here?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent
) (fillfactor = 70, option = blah);
CREATE INDEX foo ON bar (x) fillfactor = 70, option = blah;
All without creating any new keywords. You could also place them
before/after the USING clause although there would be some grammer
conflicts there.
Would this be better?
--
Martijn van Oosterhout
precedence than my + operator. For now I have to use parenthesis to avoid
ambiguity. I would prefer being able to define implicit precedence.
Sorry, not possible. :( You pretty much have to choose operators whose
precedence matches what you want.
Have a nice day,
--
Martijn van Oosterhout
?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
/* Normal def */
#endif
The actual code never gets executed but it would give gcc and any other
tools the info they need to handle this situation.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration
On Tue, Mar 07, 2006 at 05:39:18PM -0500, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
#ifdef STATIC_ANALYSIS
#define ereport(elevel, rest) \
(errstart(elevel, __FILE__, __LINE__, PG_FUNCNAME_MACRO) ? \
(errfinish rest) : (void) 0), (elevel = ERROR
the binary a bit. Not
sure whether people care enough about that.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
signature.asc
Description: Digital
algorithm to rely on that caching?
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
argument of that but it
expands to something similar to:
errstart(X), errfinish()
if X = ERROR in the call to errstart, errfinish doesn't return.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration
...
pg_dump is the only way.
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
other libraries like
ssl or kerberos be prepared to add a lot more.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting
explain output.
Obviously it won't work in situations where the system is completely
broken.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
On Thu, Mar 16, 2006 at 10:07:52AM -0500, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
Has anyone considered something like reportbug in Debian which
collects a certain amount of information about the system and then
creates an email with the information included
. glibc does this
automatically sometimes.
Though you have to be careful, continuous mmap()/munmap() is more
expensive than malloc()/free() because mmap()ed memory must be zerod
out, which costs cycles...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog
wished.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
how to find out exactly what it's for.
Not sure what else to say. Perhaps tracing the context each allocation
is done in might help.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent
type input functions.
I'd like it to be considered for inclusion. If the interest is there I
can make any changes people suggest.
Have a nice day,
---
Martijn van Oosterhout wrote:
-- Start of PGP signed section
can come up with more.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you
On Tue, Mar 21, 2006 at 04:10:21PM -0500, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
I'd like it to be considered for inclusion.
The description page lists sufficiently many unresolved issues that
I'd have to call it not ready for prime time ... even assuming
that handle these new types in a
generic way and user can write little pl/pgsql wrappers to customise
the output.
Have a ncie day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5
van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
signature.asc
Description: Digital
that is if both the type and the backing table
are included in the standard distribution and we forbid user changes.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5
or pl/pgsql functions.
While it may not be critical to the use of then, it's an extremely
handy feature. Half the point of a currency type would be the
formatting, no? The information needs to be stored somewhere...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http
.
- Character sets for CHAR types still fall outside the system.
- Some other changes in behaviour
I'm not sure if much has changed since that discussion.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration
context and does a RETURN NEXT. Once
it has returned them it can free it, or reset the context if it
prefers. The caller is always responsible for copying (since it isn't
often needed).
Have you read the executor/README ?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http
details..
1) Test suits that i could get to test my code..
2) How can I put back my fix into postgres src code.. (or) What is the
procedure that I should follow at this stage??
Post the patch to pgsql-patches. The regression test is the test suite.
Have a nice day,
--
Martijn van Oosterhout
. So the question, which context are you
allocating in?
Hope this clarifies it,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting
been pointed out before that the code actually divides by the
wrong number (it uses GetTimerFrequency() rather than
QueryPerformenceFrequency()). If you can find the values of these two
functions on your machine, see how it compares to your actual clock
speed.
Have a nice day,
--
Martijn van
come with static versions these days...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do
because cvsup is simply not an option for me.
Any particular reason why straight CVS doesn't work for you? Are you
that interested in having the log comment locally?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration
/documentation/Darwin/Reference/ManPages/man1/otool.1.html
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else
about the segment but the postmaster should start. I
thought the tsearch guys had an approach using a co-process. I don't
know how they start it up but they connected via pipes.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5
day.
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
signature.asc
Description
etc etc
This mean that the more often a node is executed, the less often you
actually time it. Note, we store ntuples as a doulbe so the mod
operation won't work...
How does this sound?
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration
On Sat, Mar 25, 2006 at 04:24:05PM +0100, Martijn van Oosterhout wrote:
I agree. However, if it's the overhead of calling gettimeofday() that
slows everything down, perhaps we should tackle that end. For example,
have a sampling mode that only times say 5% of the executed nodes.
EXPLAIN
On Sat, Mar 25, 2006 at 05:38:26PM +, Simon Riggs wrote:
On Sat, 2006-03-25 at 16:24 +0100, Martijn van Oosterhout wrote:
I agree. However, if it's the overhead of calling gettimeofday() that
slows everything down, perhaps we should tackle that end. For example,
have a sampling mode
tell, ICU is under a BSD like licence.
http://dev.icu-project.org/cgi-bin/viewcvs.cgi/*checkout*/icu/license.html
Perhaps they are compatable.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration
on relibility and flexibility and
still have a way out for functions that *must* be high-performance.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
now is because (as Tom said) we only do
the lookup once. But can trigger it if you're careful.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
in COPY
The code formerly prohibited COPY TO, where it should prohibit COPY FROM.
COPY FROM STDIN is copying FROM the user TO the database
COPY TO STDIN is copying TO the user FROM the database
Does that help?
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog
compatability modules:
http://pgfoundry.org/projects/oracompat/
http://pgfoundry.org/projects/orafce/
I'm sure there's many more if you look...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing
this issue because we always store the length,
so everywhere that needs to know already does.
If your not worried about the length field you could code this up in an
afternoon. In fact, it's probably already been done...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n
...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
backends, because it's process local.
The stats collector doesn't have any open handles for the backend, it's
just a way for backends to identify themselves. It appears that process
handles are not up to the task either...
Do we have a plan C?
--
Martijn van Oosterhout kleptog@svana.org http
if process still there
kill -TERM 1234
process still there, damn it!
kill -9 1234
There gone. With no quick PID reuse I can be sure I won't kill the
wrong one. This is presumably why recent versions of windows don't reuse
pids quickly either... It for *users* not programs.
--
Martijn van Oosterhout
.
Nice work though, I hadn't thought of this approach.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else
and it is a new type
of index that perfectly complements the existing types.
Neat stuff,
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
much benefit these buffer cache hacks
actually produce.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
it hasn't happened yet is because nobody's coded it.
How about when you select from a table with OIDs that it shows the OID
column? That would be the final step, wouldn't it?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration
but requires a fair bit more infrastructure.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other
calculating redundant
clauses if it doesn't need to, but you can't rely on it.
Fixing your underlying issue with the aggregate should solve everything
for you.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95
doesn't require
it, we're not going to write large chunks of code to avoid a small
amount of processing that nobody is going to notice anyway. i.e. you
can't *rely* on this behaviour, but improvement is merely an
optimisation, not a feature or a bug fix.
Have a nice day,
--
Martijn van Oosterhout
it meantioned, didn't know they'd got it working. However,
none of my database servers have a 3D graphics anywhere near the power
they suggest in the article.
Is this of practical use for run-of-the-mill video cards?
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n
?
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
signature.asc
Description
change should
be avoided imho. And 2 or 4 could cause chaos for Windows users if
different DLL builds get mixed up.
Hmm, may I ask what it uses it for? Just to get information, or
something more substantial?
Thanks in advance,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog
a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
signature.asc
?
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
signature.asc
Description
in the attributes they
want and we don't have to deal with the endless variations. I don't
however know enough to know if this (with a function to get OIDs by
index) is sufficient to extract all the information from the
certificate.
Presumably OpenSSL can do this too...
--
Martijn van Oosterhout
is.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them
you use PQsocket get the socket and
continue from there.
Unorthodox usage, but it should work.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
)
ispending (is there stuff to do)
release (for when you're finished)
Is there anything else you might need?
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting
the wait-for-whole-resultset-before-returing issue? Or
maybe better notice handling? What is it that's so deficient?
Or maybe it's portability? Like DBI PgPP module?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95
jump through all sorts of hoops everytime a new
protocol version is created.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around
with a proposal (whether it'll get
implemented is another issue entirely).
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around
On Thu, Apr 13, 2006 at 08:32:34AM -0400, Stephen Frost wrote:
* Martijn van Oosterhout (kleptog@svana.org) wrote:
Hmm, the simplest improvement I can think of is one where you
register a callback that libpq calls whenever it has received a new
tuple.
You wouldn't want it on every tuple
On Thu, Apr 13, 2006 at 09:34:10AM -0400, Stephen Frost wrote:
* Martijn van Oosterhout (kleptog@svana.org) wrote:
Except in the case of psqlODBC, it wants to be able to malloc/free()
each field, which your method doesn't solve. Also, it doesn't solve the
duplicate memory use, nor
-blocking you can even go off and do other things while
waiting. No need for temporary space...
Does this seem too complex?
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
signature.asc
people are
writing their own wire-protocol parsers. To find out the deficiency in
libpq that prevents them using it.
I agree, for what you're talking about I don't think a callback is at
all relevent.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog
to solve is also important, it would be nice
to find a good solution to that. I'm just not sure if it was relevent
to the decision to bypass libpq.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration
on any of
this. So we dont want to set anything in stone until we know it would
solve their problem...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
provides a way to get these small bits of the unparsed stream in a
protocol independant way, then that problem goes away.
There are a number of other (primarily driver) projects that would
benefit from being able to bypass the PGresult structure for storing
data.
Have a nice day,
--
Martijn van
On Fri, Apr 14, 2006 at 04:53:53PM +0200, Martijn van Oosterhout wrote:
Sounds really good.
snip
There's a message on the pgsql-odbc mailing list[1] with some reasons
for not using libpq:
1. The driver sets some session default parameters(DateStyle,
client_encoding etc) using start-up
...
That doesn't change the fact that it's a nice idea, just definite
benificiaries are harder to find.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work
On Fri, Apr 14, 2006 at 01:05:11PM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
Perhaps a far easier approach would be to indeed just have a hijack
interface that provides read/write over whatever protocol libpq
negotiated.
Well, there's a precedent to look
,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
signature.asc
Description: Digital
the concept of commenting out. Disabling
a rule without removing it. And you havn't dealt with the central
administration aspect (farm out config files).
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration
even write my own backup solution.
I must be missing something obvious, but why don't we compress the
xlogs? They appear to be quite compressable (75%) with standard gzip...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95
.
For simple systems then you could have a short pg_hba.conf to limit the
IP addresses users can connect on, and the DB stores what databases
they have access to...
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent
to post of -patches sometime soon, once some of the kinks have
been ironed out.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around
a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
signature.asc
() function currently anyway. You can't ask the SSL library
easily if we provided a certificate during authentication. libpq knows
this easily.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent
the situations were SSL makes sense and if you fall
outside of that you shouldn't be using SSL.
All I'm asking for is that libpq be made SSL-library *agnostic* so that
users like psqlODBC can just *use* the connection with having to jump
through hoops.
Have a nice day,
--
Martijn van Oosterhout kleptog
On Mon, Apr 17, 2006 at 12:24:40PM -0400, Stephen Frost wrote:
* Martijn van Oosterhout (kleptog@svana.org) wrote:
Seriously, if people want to do really sophisticated things with the
SSL library, they should setup s_tunnel instead. If we wanted to let
I certainly agree with all the rest
error messages and a
description of what you are doing.
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other
401 - 500 of 1563 matches
Mail list logo
