| Commit message (Collapse) | Author | Age |
... | |
| |
|
| |
|
|
|
|
|
| |
* Remove wal_files postgresql.conf option because WAL files are
now recycled
|
|
|
|
| |
Improve wording of pre-7.3 syntax mention.
|
| |
|
|
|
|
|
| |
that the functionality is available to anyone via ReturnSetInfo, rather
than hard-wiring it to PL/pgSQL.
|
|
|
|
| |
translation.
|
|
|
|
| |
Manfred Koizar
|
|
|
|
|
|
|
| |
to the table function, thus preventing memory leakage accumulation across
calls. This means that SRFs need to be careful to distinguish permanent
and local storage; adjust code and documentation accordingly. Patch by
Joe Conway, very minor tweaks by Tom Lane.
|
| |
|
|
|
|
|
| |
INSERT, UPDATE, or DELETE shouldn't change FOUND. IMHO anyway.
Also, try to make documentation a little clearer.
|
|
|
|
| |
This breaks support for 6.2 or older client libraries.
|
|
|
|
|
| |
types, SRFs. Not happy with memory management yet, but I'll commit these
other changes.
|
|
|
|
|
|
| |
Note can probably be removed after a couple of releases.
Rod Taylor
|
| |
|
|
|
|
| |
a more logical ordering.
|
|
|
|
|
|
| |
formatting (\timing) works correctly. Change "Total time" to "Time"
since there is nothing that "total" refers to. Remove non-multibyte
code.
|
|
|
|
| |
except that it's more robust, reconnects less often, and is NLS'ed.
|
|
|
|
| |
from Tom Lane.
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
bit on the indexes.
I also attach clusterdb and clusterdb.sgml; both of them are blatant
rips of vacuumdb and vacuumdb.sgml, but get the job done. Please review
them, as I'm probably making a lot of mistakes with SGML and I can't
compile it here.
vacuumdb itself is not very comfortable to use when the databases have
passwords, because it has to connect once for each table (I can probably
make it connect only once for each database; should I?). Because of
this I added a mention of PGPASSWORDFILE in the documentation, but I
don't know if that is the correct place for that.
Alvaro Herrera
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
| |
value '-2' is used to indicate a variable-width type whose width is
computed as strlen(datum)+1. Everything that looks at typlen is updated
except for array support, which Joe Conway is working on; at the moment
it wouldn't work to try to create an array of cstring.
|
|
|
|
|
| |
the declarations of some index access method support functions. Support
SQL functions returning VOID.
|
|
|
|
|
|
| |
instance in which the docs mention that 'NAMEDATALEN == 32".
Neil Conway
|
|
|
|
|
|
|
| |
settings of NAMEDATALEN. I looked through the docs for other
references to NAMEDATALEN, but this is the only one I could find.
Neil Conway
|
| |
|
| |
|
| |
|
|
|
|
| |
docs and find the other obsolete statements that no doubt lurk.
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
|
| |
>>" It's also possible to select no escape character by writing ESCAPE ''.
>>In this case there is no way to turn off the special meaning of
>>underscore and percent signs in the pattern."
Joe Conway
|
|
|
|
|
|
| |
> > is a patch to add some cross-referencing.
Oliver Elphick
|
| |
|
|
|
|
|
|
| |
with OPAQUE, as per recent pghackers discussion. I still want to do some
more work on the 'cstring' pseudo-type, but I'm going to commit the bulk
of the changes now before the tree starts shifting under me ...
|
| |
|
| |
|
|
|
|
| |
Use off_t and size_t in pg_dump to handle file offset arithmetic correctly.
|
|
|
|
|
|
|
|
|
|
|
|
| |
FOUND is set whenever a SELECT INTO returns > 0 rows, *or* when an
INSERT, UPDATE, or DELETE affects > 0 rows. We implemented the first
part of this behavior, but not the second.
I also improved the documentation on the various situations in which
FOUND can be set (excluding inside FOR loops, which I still need to
think about), and added some regression tests for this behavior.
Neil Conway
|
|
|
|
| |
Christopher Kings-Lynne
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
> Quick system function to pull out the current database.
>
> I've used this a number of times to allow stored procedures to find out
> where they are. Especially useful for those that do logging or hit a
> remote server.
>
> It's called current_database() to match with current_user().
It's also a necessity for an informational schema. The catalog
(database) name is required in a number of places.
Rod Taylor
|
| |
|
|
|
|
|
| |
cause SERIAL column declaration not to imply UNIQUE, so that this can be
done without creating an extra index.
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
The -n and -N options were removed. Quoting is now smart enough to
supply quotes if and only if necessary.
Numerical types are now printed without quotes, except in cases of
special values such as NaN.
Boolean values printed as true and false.
Most string literals now do not escape whitespace characters (newlines,
etc.) for portability.
SET SESSION AUTHORIZATION argument is a string literal, to follow SQL.
Made commands output by pg_dump use consistent spacing and indentation.
|