- 15 6月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
reason is that it's required (more or less) in order to build the latest DBD::Pg code and I was testing that out under MSVC. Andrew Dunstan
-
由 Bruce Momjian 提交于
part of service principal. If not set, any service principal matching an entry in the keytab can be used. NEW KERBEROS MATCHING BEHAVIOR FOR 8.1. Todd Kover
-
- 14 6月, 2005 9 次提交
-
-
由 Bruce Momjian 提交于
> o -Allow PL/PgSQL's RAISE function to take expressions
-
由 Tom Lane 提交于
if geqo_rand() returns exactly 1.0, resulting in failure due to indexing off the end of the pool array. Also, since this is using inexact float math, it seems wise to guard against roundoff error producing values slightly outside the expected range. Per report from bug@zedware.org.
-
由 Teodor Sigaev 提交于
recovery after crash (power loss etc) it may say that it can't restore index and index should be reindexed. Some refactoring code.
-
由 Neil Conway 提交于
instead of just scalar variables. Add regression tests and update the documentation. Along the way, remove some redundant error checking code from exec_stmt_perform(). Original patch from Pavel Stehule, reworked by Neil Conway.
-
由 Tom Lane 提交于
constraint while determining whether the index sort order matches the query's ORDER BY. This for example allows an index on (x,y) to match ... WHERE x = 42 ORDER BY y; It only works for btree indexes, but since those are the only ones we currently have that are ordered at all, that's good enough for now. Per popular demand.
-
由 Bruce Momjian 提交于
> * -Use index to restrict rows returned by multi-key index when used with
-
由 Bruce Momjian 提交于
Lorne Sunley
-
由 Neil Conway 提交于
fix two grammatical errors, and print the INTO target of EXECUTE INTO if one is specified.
-
由 Tom Lane 提交于
nonconsecutive columns of a multicolumn index, as per discussion around mid-May (pghackers thread "Best way to scan on-disk bitmaps"). This turns out to require only minimal changes in btree, and so far as I can see none at all in GiST. btcostestimate did need some work, but its original assumption that index selectivity == heap selectivity was quite bogus even before this.
-
- 13 6月, 2005 3 次提交
-
-
由 Neil Conway 提交于
mode to only affect the presentation of normal query results, not the output of psql slash commands. Documentation updated. I also made some unrelated minor psql cleanup. Per suggestion from Stuart Cooper.
-
由 Neil Conway 提交于
reference page for SQL commands, so that the link text is italicized.
-
由 Tom Lane 提交于
a descriptor that uses the current transaction snapshot, rather than SnapshotNow as it did before (and still does if INV_WRITE is set). This means pg_dump will now dump a consistent snapshot of large object contents, as it never could do before. Also, add a lo_create() function that is similar to lo_creat() but allows the desired OID of the large object to be specified. This will simplify pg_restore considerably (but I'll fix that in a separate commit).
-
- 12 6月, 2005 3 次提交
-
-
由 Tom Lane 提交于
configure options are documented. Per Michael Glaesemann.
-
由 Neil Conway 提交于
syntax for database connection parameters. It has been inside an #ifdef NOT_USED block since 2001 or so and is marked as "broken", so I don't think it is likely to be rehabilitated any time soon.
-
由 Neil Conway 提交于
patch adds missing checks to the call sites of malloc(), strdup(), PQmakeEmptyPGresult(), pqResultAlloc(), and pqResultStrdup(), and updates the documentation. Per original report from Volkan Yazici about PQmakeEmptyPGresult() not checking for malloc() failure.
-
- 11 6月, 2005 6 次提交
-
-
由 Tom Lane 提交于
in its own right. As proposed by Simon Riggs, but with some editorializing of my own.
-
由 Tom Lane 提交于
code beautification too.
-
由 Tatsuo Ishii 提交于
-
由 Bruce Momjian 提交于
Andreas Seltenreich
-
由 Neil Conway 提交于
-
由 Neil Conway 提交于
These contain the SQLSTATE and error message of the current exception, respectively. They are scope-local variables that are only defined in exception handlers (so attempting to reference them outside an exception handler is an error). Update the regression tests and the documentation. Also, do some minor related cleanup: export an unpack_sql_state() function from the backend and use it to unpack a SQLSTATE into a string, and add a free_var() function to pl_exec.c Original patch from Pavel Stehule, review by Neil Conway.
-
- 10 6月, 2005 17 次提交
-
-
由 Bruce Momjian 提交于
Andreas Seltenreich
-
由 Bruce Momjian 提交于
history customizable through a variable named HISTFILE, analogous to psql's already implemented HISTCONTROL and HISTSIZE variables, and bash's HISTFILE-Variable. The motivation was to be able to get psql to maintain separate histories for separate databases. This is now easily achievable through a line like the following in ~/.psqlrc: \set HISTFILE ~/.psql_history-:DBNAME Andreas Seltenreich
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
to a subquery if the outer query is simple enough that the LIMIT can be reflected directly to the subquery. This didn't use to be very interesting, because a subquery that couldn't have been flattened into the upper query was usually not going to be very responsive to tuple_fraction anyway. But with new code that allows UNION ALL subqueries to pay attention to tuple_fraction, this is useful to do. In particular this lets the optimization occur when the UNION ALL is directly inside a view.
-
由 Bruce Momjian 提交于
file. Andrew Dunstan
-
由 Tom Lane 提交于
if the limit were directly applied to it. This does not actually add a LIMIT plan node to the generated subqueries --- that would be useless overhead --- but it does cause the planner to prefer fast- start plans when the limit is small. After an idea from Phil Endecott.
-
由 Tom Lane 提交于
than tlist_member calls. Building a large join tlist is still O(N^2), but with a much smaller constant factor than before.
-
由 Bruce Momjian 提交于
if you have previously issued a \cd command. Greg Sabino Mullane
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
#log_line_prefix = '' # %u = user name # %d = database name # %r = remote host and port # %h = remote host # %p = PID # %t = timestamp # %m = timestamp with milliseconds # %i = command tag # %c = session id # %l = session line number # %s = session start timestamp # %x = transaction id # %q = stop here in non-session processes # %% = '%' # e.g. '<%u%%%d> '
-
由 Bruce Momjian 提交于
millisecond timestamps (%m) and remote host (%h). The milliseconds are useful for QPS measurements. Ed L.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
'conflicting datestyle specifications' for input that's actually only redundant, such as SET DATESTYLE = MDY, MDY. Per recent gripe.
-
由 Tom Lane 提交于
this in turn causes CREATE TABLE AS in plpgsql to set ROW_COUNT. This is how it behaved before 7.4; I had unintentionally changed the behavior in a bit of sloppy micro-optimization.
-