- 18 Jul, 2002 6 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tatsuo Ishii authored
changed since CREATE CONVERSION supported.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tatsuo Ishii authored
conversion procs and conversions are added in initdb. Currently supported conversions are: UTF-8(UNICODE) <--> SQL_ASCII, ISO-8859-1 to 16, EUC_JP, EUC_KR, EUC_CN, EUC_TW, SJIS, BIG5, GBK, GB18030, UHC, JOHAB, TCVN EUC_JP <--> SJIS EUC_TW <--> BIG5 MULE_INTERNAL <--> EUC_JP, SJIS, EUC_TW, BIG5 Note that initial contents of pg_conversion system catalog are created in the initdb process. So doing initdb required is ideal, it's possible to add them to your databases by hand, however. To accomplish this: psql -f your_postgresql_install_path/share/conversion_create.sql your_database So I did not bump up the version in cataversion.h. TODO: Add more conversion procs Add [CASCADE|RESTRICT] to DROP CONVERSION Add tuples to pg_depend Add regression tests Write docs Add SQL99 CONVERT command? -- Tatsuo Ishii
-
- 17 Jul, 2002 2 commits
-
-
Bruce Momjian authored
> * -Report failure to find readline or zlib at end of configure run
-
Bruce Momjian authored
AC_SEARCH_LIBS(getopt_long, [getopt])
-
- 16 Jul, 2002 16 commits
-
-
Tom Lane authored
functionality. Of note: dropping a table that has a SERIAL column defined now drops the associated sequence automatically.
-
Barry Lind authored
fixed bug in support for timestamp without time zone reported by Yuva Chandolu (ychandolu@ebates.com)
-
Bruce Momjian authored
check.
-
Bruce Momjian authored
-
Tom Lane authored
objects created during initdb (except for the system views, which I think do not need to be pinned).
-
Bruce Momjian authored
> > David Clark (dclarknospam@opsi.co.za) reports a bug with a severity > > Table 3-7 SQL Literal escaped octets shows the input escape > > representation for a single quote as '\\'' , but the third paragraph > > below table 3-8 SQL Output Escaped Octets says that the single quote > > must be input as '\'' > > Nice catch. '\'' is correct as shown in the example in Table 3-7. > > > > > Also in the same paragraph mentioned above it says input for the > > single quote must be '\'' (or '\\134') shouldn't this be (or '\\047') > > Also a bug. Should be '\\047', as you pointed out. > Here's a patch to fix the binary string doc errors. Joe Conway
-
Tatsuo Ishii authored
-
Tatsuo Ishii authored
-
Tatsuo Ishii authored
-
Tom Lane authored
to build dependencies for rules, constraint expressions, and default expressions. Repair some problems in the original design of recursiveDeletion() exposed by more complex dependency sets. Fix regression tests that were deleting things in illegal sequences.
-
Bruce Momjian authored
-
Bruce Momjian authored
one place. Everything may be moved to src/utils eventually. Add DLLINIT variable to simplify makfiles.
-
Bruce Momjian authored
-
Bruce Momjian authored
Lockhart. initdb not forced.
-
Bruce Momjian authored
UNIQUE and DISTINCT predicates are both listed as implemented -- AFAIK, neither is. I also included another trivial patch which adds the default location of the DSSSL stylesheets on my system (Debian unstable, docbook-dsssl 1.76) to the list of paths that configure looks for. Neil Conway
-
Bruce Momjian authored
-
- 15 Jul, 2002 10 commits
-
-
Bruce Momjian authored
< * Use our own getopt() for FreeBSD/OpenBSD to allow --xxx flags (Bruce)
-
Bruce Momjian authored
-
Bruce Momjian authored
warnings, and we now look for getopt_long in libgetopt.a.
-
Bruce Momjian authored
-
Bruce Momjian authored
configure.in.
-
Tom Lane authored
so that dependencies in default expressions (on operators, functions, etc) can be expressed properly.
-
Bruce Momjian authored
-
Hiroshi Inoue authored
-
Bruce Momjian authored
this thing.
-
Bruce Momjian authored
-
- 14 Jul, 2002 3 commits
- 13 Jul, 2002 3 commits
-
-
Tom Lane authored
varno of index's relation is not 1. This embarrassing oversight pointed out by Dmitry Tkach 12-Jul-02.
-
Bruce Momjian authored
> o -Add ALTER TABLE DROP non-CHECK CONSTRAINT > * -Allow psql \d to show foreign keys > * -Auto-destroy sequence on DROP of table with SERIAL; perhaps a separate > * -Prevent column dropping if column is used by foreign key > * -Automatically drop constraints/functions when object is dropped > * -Make foreign key constraints clearer in dump file > * -Make foreign keys easier to identify
-
Bruce Momjian authored
o -Add SET or BEGIN timeout parameter to cancel query > * -Add pg_depend table for dependency recording; use sysrelid, oid,
-