| Commit message (Collapse) | Author | Age |
|
|
|
|
| |
Re-add warning if the locale prevents LIKE-optimization. Done within
initdb now.
|
|
|
|
|
|
|
|
| |
to reset session userid to the originally-authenticated name. Also,
relax SET SESSION AUTHORIZATION to allow specifying one's own username
even if one is not superuser, so as to avoid unnecessary error messages
when loading a pg_dump file that uses this command. Per discussion from
several months ago.
|
|
|
|
|
| |
where the tuple's xmin or xmax is older than the snapshot xmin. There
is no need to check it against snapshot xmax in that case.
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
| |
As proof of concept, provide an alternate implementation based on POSIX
semaphores. Also push the SysV shared-memory implementation into a
separate file so that it can be replaced conveniently.
|
| |
|
|
|
|
|
| |
only if they would not be found without qualification given the current
search path, as per idea from Peter Eisentraut.
|
| |
|
|
|
|
| |
from Liam Stewart. Minor code cleanups also.
|
| |
|
|
|
|
|
|
|
|
| |
handled as special productions. This is needed to keep us honest about
user-schema type names that happen to coincide with system type names.
Per pghackers discussion 24-Apr. To avoid bloating the keyword list
too much, I removed the translations for datetime, timespan, and lztext,
all of which were slated for destruction several versions back anyway.
|
| |
|
|
|
|
|
|
| |
in gram.y can make use of the keywords.c string table, instead of having
their own copies of the keyword strings. This saves a few kilobytes and
more importantly eliminates an opportunity for cut-and-paste errors.
|
|
|
|
|
|
| |
in the search path. (We might want to make these available as SQL
functions too, but I haven't done that yet.) Fix format_type to be
schema-aware.
|
|
|
|
| |
binary case) already has. Needed for upcoming ruleutils change.
|
|
|
|
|
|
|
|
|
|
|
|
| |
in parse error messages, not just the part scanned by the last flex rule.
For example,
select "foo" "bar";
used to draw
ERROR: parser: parse error at or near """
which was rather unhelpful. Now it gives
ERROR: parser: parse error at or near ""bar""
Also, error messages concerning bitstring literals and suchlike will
quote the source text at you, not the processed internal form of the literal.
|
|
|
|
| |
see changes made by the transaction itself.
|
|
|
|
|
| |
I concluded that RENAME should require CREATE privilege on the namespace
as well as ownership of the table.
|
|
|
|
| |
don't scribble on tuple returned by table scan.
|
| |
|
| |
|
| |
|
|
|
|
| |
was incorrectly used for both qsort and bsearch.
|
|
|
|
|
|
|
|
| |
lists to join RTEs, attach a list of Vars and COALESCE expressions that will
replace the join's alias variables during planning. This simplifies
flatten_join_alias_vars while still making it easy to fix up varno references
when transforming the query tree. Add regression test cases for interactions
of subqueries with outer joins.
|
|
|
|
| |
in quoting rules and recognition of implicit type coercions.
|
| |
|
|
|
|
|
|
|
|
|
| |
pg_database, pg_shadow, pg_group, all of which now have potentially-long
fields. Along the way, get rid of SharedSystemRelationNames list: shared
rels are now identified in their include/pg_catalog/*.h files by a
BKI_SHARED_RELATION macro, while indexes and toast rels inherit sharedness
automatically from their parent table. Fix some bugs with failure to detoast
pg_group.grolist during ALTER GROUP.
|
|
|
|
| |
pg_hba.conf changes.
|
|
|
|
|
|
|
| |
messages more uniform and internationalizable: the global array
aclcheck_error_strings[] is gone in favor of a subroutine
aclcheck_error(). Partial implementation of namespace-related
permission checks --- not all done yet.
|
|
|
|
|
|
|
| |
divide backend/commands by object type, let's try to pay at least
minimal attention to respecting that structure, eh? Also reorder the
contents of tablecmds.c; it seems odd to me to put ALTER commands before
creation/deletion commands.
|
|
|
|
|
| |
Update has_table_privilege functions to cope with schema-qualified
names in the same way as nextval() and others.
|
|
|
|
|
|
|
| |
per pghackers discussion. Add some more typsanity tests, and clean
up some problems exposed thereby (broken or missing array types for
some built-in types). Also, clean up loose ends from unknownin/out
patch.
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
mysteriously disappearing.
ie. \d+ will only ever show the comment for the current database --
which is appropriate since it can only pull comments from the current
database.
Won't break pgadmin functionality as it enforces this behaviour already.
I didn't find any regression tests for COMMENT.
Rod Taylor
|
|
|
|
|
|
|
|
| |
left a stub for a future "ALTER RULE RENAME" but did not write that one
yet. Bruce, if you want to add my name for for that I'll take it and do
it later.
Joe Conway
|
|
|
|
|
|
| |
Appears I forgot to update the docs earlier.
Rod Taylor
|
|
|
|
|
|
|
|
|
|
| |
BAD: INSERT INTO tab (col1, col2) VALUES ('val1');
GOOD: INSERT INTO tab (col1, col2) VALUES ('val1', 'val2');
Regress tests against DEFAULT and normal values as they're managed
slightly different.
Rod Taylor
|
|
|
|
|
|
|
|
|
|
| |
looking for places that assume UNKNOWN == TEXT. One of those was the
"SET" type in pg_type.h, which was using textin/textout. This one I took
care of in this patch. The other suspicious place was in
string_to_dataum (which is defined in both selfuncs.c and indxpath.c). I
wasn't too sure about those, so I left them be.
Joe Conway
|
|
|
|
| |
Ulrich Neumann
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Attached is a pacth against 7.2 which adds locale awareness to the
character classes of the regular expression engine.
...
> > I still think the xdigit class could be handled the same way the digit
> > class is (by enumeration rather than using the isxdigit function). That
> > saves you a cicle, and I don't think there's any loss.
>
> In fact, I will email you when I apply the original patch.
I miss that case :-(. Here is the pached patch.
...
Here is a patch which addresses Tatsuo's concerns (it does return an
static struct instead of constructing it).
|
|
|
|
|
| |
UINT64CONST, since unsigned was what it wanted anyway. Centralize macro
definitions into c.h.
|
| |
|
|
|
|
| |
ALTER COLUMN SET STORAGE should be allowed.
|
|
|
|
|
| |
Change elog(ERROR) messages to say that a variable takes one parameter,
rather than saying that it does not take multiple parameters.
|
|
|
|
|
| |
The last version caught this with an assert because I wasn't sure whether
we should elog(ERROR) or just loop through the parameters.
|