- Apr 01, 2002
-
-
Tom Lane authored
-
Tom Lane authored
path. The default behavior if no per-user schemas are created is that all users share a 'public' namespace, thus providing behavior backwards compatible with 7.2 and earlier releases. Probably the semantics and default setting will need to be fine-tuned, but this is a start.
-
Bruce Momjian authored
> * Remove unreferenced table files and temp tables during database vacuum > * Allow psql \d to show temporary table structure
-
- Mar 31, 2002
-
-
Bruce Momjian authored
> * -Remove unreferenced table files and temp tables during database vacuum > * -Allow psql \d to show temporary table structure
-
- Mar 29, 2002
-
-
Tom Lane authored
in different namespaces. Also, cleanup work on relation namespace support: drop, alter, rename commands work for tables in non-default namespaces.
-
- Mar 27, 2002
-
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
- Mar 26, 2002
-
-
Tom Lane authored
in schemas other than the system namespace; however, there's no search path yet, and not all operations work yet on tables outside the system namespace.
-
- Mar 25, 2002
-
-
Bruce Momjian authored
Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/PgSQL (Tom)
-
Bruce Momjian authored
Allow CREATE TABLE AS ... SELECT in PL/PgSQL (Tom)
-
Bruce Momjian authored
< * Automatically make a view temporary if it uses a temporary table > * Require view using temporary tables to be temporary views
-
Bruce Momjian authored
> o Fix problems with complex temporary table creation/destruction > without using PL/PgSQL EXECUTE
-
- Mar 24, 2002
-
-
Bruce Momjian authored
> * Automatically make a view temporary if it uses a temporary table
-
Tom Lane authored
-
Tom Lane authored
-
Tom Lane authored
Also, fix debug logging of parse/plan trees so that the messages actually go through elog(), not directly to stdout.
-
- Mar 22, 2002
-
-
Tom Lane authored
there and CREATE SCHEMA will make entries in it...
-
Peter Eisentraut authored
-
- Mar 21, 2002
-
-
Tom Lane authored
the parsetree representation. As yet we don't *do* anything with schema names, just drop 'em on the floor; but you can enter schema-compatible command syntax, and there's even a primitive CREATE SCHEMA command. No doc updates yet, except to note that you can now extract a field from a function-returning-row's result with (foo(...)).fieldname.
-
- Mar 20, 2002
-
-
Tom Lane authored
-
- Mar 19, 2002
-
-
Tom Lane authored
-
Bruce Momjian authored
> > to perform sql command: > > update pg_amop set amopreqcheck = true where amopclaid = > > (select oid from pg_opclass where opcname = 'gist_txtidx_ops'); > > Oleg, sorry, I don't understand where this should appear. In the README > file, and if so, where? Is this something only for people upgrading > from 7.2? Sorry Bruce, I was unclear. I have attached patch to Readme.tsearch Also, It'd be worth to mention in Changes to point users of tsearch about importang upgrade notices. Oleg Bartunov
-
Bruce Momjian authored
> * -Add domain capability [domain] (Rod Taylor)
-
Bruce Momjian authored
-
Bruce Momjian authored
Rod Taylor.
-
Bruce Momjian authored
Ensure that sequence counters do not go backwards after a crash
-
Bruce Momjian authored
-
- Mar 18, 2002
-
-
Bruce Momjian authored
-
- Mar 17, 2002
-
-
Tom Lane authored
-
- Mar 15, 2002
-
-
Bruce Momjian authored
-
Bruce Momjian authored
! DIFFERENCE (− or ∖): builds the set difference of two tables. Let <classname>R</classname> and <classname>S</classname> again be two tables with the same arity. <classname>R</classname> - <classname>S</classname> --- 488,494 ---- <listitem> <para> ! EXCEPT (− or ∖): builds the set difference of
-
- Mar 11, 2002
-
-
Bruce Momjian authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
- Mar 10, 2002
-
-
Bruce Momjian authored
< * Remove brackets as multi-statement rule grouping, must use parens (Bruce) > * -Remove brackets as multi-statement rule grouping, must use parens (Bruce) 458d457 < * Remove USING clause from pg_get_indexdef() if index is btree (Bruce)
-
Bruce Momjian authored
-
- Mar 09, 2002
-
-
Bruce Momjian authored
file that SIGHUP or "pg_ctl reload" are required for changes to take affect on a running server.
-
- Mar 08, 2002
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
* Change FIXED_CHAR_SEL to 0.20 from 0.04 to give better selectivity (Bruce)
-