| Commit message (Collapse) | Author | Age |
|
|
|
|
|
| |
Define conversions to and from text for date, time, and timetz.
Have millisecond and microsecond return full # of seconds in those units.
Previously, only returned full fractional part in those units.
|
|
|
|
|
| |
"best choice" type category when resolving UNKNOWN function and operator
arguments. Thanks to Tom Lane for finding test case.
|
|
|
|
|
|
|
| |
functions, per recent discussions on pghackers. For now, I have called
the verbose-display formatting function text(), but will reconsider if
enough people object.
initdb forced.
|
|
|
|
|
| |
order to continue to access the tuple more than now.
This would resolve a segmentation fault error.
|
| |
|
|
|
|
|
|
|
|
| |
message about recursive use of a syscache. Also remove most of the
specialized indexscan routines in indexing.c --- it turns out that
catcache.c is perfectly able to perform the indexscan for itself,
in fact has already looked up all the information needed to do so!
This should be faster as well as needing far less boilerplate code.
|
| |
|
|
|
|
|
| |
and improperly prevented the main result rel from being closed if it
wasn't one of the Append's own result rels. Per report from Hiroshi.
|
| |
|
|
|
|
| |
to resolve the unknown constants as type TEXT.
|
|
|
|
| |
Thanks to Kevin O'Gorman for finding these...
|
| |
|
|
|
|
|
|
|
|
|
| |
(WAL logging for this is not done yet, however.) Clean up a number of really
crufty things that are no longer needed now that DROP behaves nicely. Make
temp table mapper do the right things when drop or rename affecting a temp
table is rolled back. Also, remove "relation modified while in use" error
check, in favor of locking tables at first reference and holding that lock
throughout the statement.
|
| |
|
| |
|
|
|
|
| |
user interface.
|
| |
|
|
|
|
|
|
|
| |
Same code exactly as for function resolution.
An obvious example is for
select '1' = '01';
which used to throw an error and which now resolves to two text strings.
|
|
|
|
| |
Andreas
|
|
|
|
| |
mea culpa...
|
|
|
|
|
| |
to work everywhere. Also, on FreeBSD you need to set the optreset variable
to 1 before parsing the command line a second time with getopt().
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Previously, all fields were unsigned, with only a trailing "ago" to
indicate negative intervals. Now, ISO format does not use "ago", and
and the traditional PostgreSQL format has the first numeric field unsigned
with "ago" supporting that field. So "1 month - 2 days ago" is two days
less than a month in the past.
Fix interval arithmetic across daylight savings time boundaries.
Previously, most math across boundaries introduced a one hour offset.
Allow some date/time functions to return NULL if called with NULL args.
Implement functions for AT TIME ZONE support.
Support "SAT" as an Australian time zone if USE_AUSTRALIAN_RULES
is defined.
|
|
|
|
| |
AT is now a keyword but is not a reserved word.
|
|
|
|
|
|
|
| |
any available string type. Previously, all candidate choices must have
fallen within the same "type category" for PostgreSQL to be willing to
choose any of them.
Need to apply the same fixup to operator type resolution.
|
|
|
|
|
| |
Auto removing of offline log files and creating new file
at checkpoint time.
|
|
|
|
|
| |
got confused by 'dummy' targetlist built for the UNION's toplevel query.
Fix by making dummy targetlist a little less cheesy.
|
|
|
|
|
|
| |
the grammar did not allow redundant parentheses around sub-selects.
Distinguish LIMIT ALL from LIMIT 0; make the latter behave as one would
expect.
|
| |
|
|
|
|
|
|
|
| |
definitions using inherited columns in the
create table statement.
Stephan Szabo
|
|
|
|
| |
it to an absolute path.
|
| |
|
|
|
|
|
| |
from an ACL list if it had no permissions remaining, which confused
aclcheck terribly. Also clean up code a little.
|
| |
|
|
|
|
| |
thinkos in inv_seek().
|
|
|
|
| |
'self' characters.
|
|
|
|
| |
owner of unix socket.
|
|
|
|
| |
(Thanks to Tatsuo Ishii for finding bug)
|
|
|
|
| |
pointing to bug).
|
|
|
|
|
|
|
| |
Bruce Hartzler <bruceh@mail.utexas.edu>. It contains shared library
support, regression test map, and the usual template files. The dynamic
loader is missing, the spin lock code apparently doesn't assemble due to
syntax problems, and semaphores are to be hoped for from Apple.
|
|
|
|
|
| |
leading 'b', as it appears to be more convenient this way for the input
and node functions.
|
|
|
|
|
|
|
|
|
|
| |
position() and substring() functions, so that it works transparently for
bit types as well. Alias the text functions appropriately.
Add position() for bit types.
Add new constant node T_BitString that represents literals of the form
B'1001 and pass those to zpbit type.
|
| |
|
|
|
|
|
|
| |
Supported encodings are: EUC_JP, EUC_CN, EUC_KR, EUC_TW, Shift JIS,
Big5, ISO8859-[1-5].
TODO: testings! and documentations...
|
| |
|
| |
|
|
|
|
| |
operators.
|
|
|
|
|
|
|
|
| |
equivalent.
In linux.h there were some #undef HAVE_INT_TIMEZONE, which are useless
because HAVE_TM_ZONE overrides it anyway, and messing with configure
results isn't cool.
|
|
|
|
| |
test.
|
|
|
|
|
|
| |
a) mismatching backend program, by checking --version output
b) mismatching bki files, by putting a version-identifying comment atop
those files.
|
| |
|