- Apr 13, 2002
-
-
Tom Lane authored
-
Bruce Momjian authored
the libpgtcl "pg_execute" command. This was mentioned on pgsql-interfaces on Mar 3. I am posting it here in the hope that someone will check to see if it makes sense and is correct SGML-wise. I did run it through jade, but this is my first try at this sort of thing. ljb
-
Bruce Momjian authored
-
- Apr 12, 2002
-
-
Bruce Momjian authored
-
- Apr 11, 2002
-
-
Tom Lane authored
entries, per pghackers discussion. This fixes aggregates to live in namespaces, and also simplifies/speeds up lookup in parse_func.c. Also, add a 'proimplicit' flag to pg_proc that controls whether a type coercion function may be invoked implicitly, or only explicitly. The current settings of these flags are more permissive than I would like, but we will need to debate and refine the behavior; for now, I avoided breaking regression tests as much as I could.
-
Peter Eisentraut authored
and --without-zlib to turn them off.
-
- Apr 10, 2002
-
-
Peter Eisentraut authored
-
- Apr 09, 2002
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
refcursors.
-
Bruce Momjian authored
-
- Apr 08, 2002
-
-
Tom Lane authored
timestamp.
-
- Apr 05, 2002
-
-
Tom Lane authored
volatile), rather than the old cachable/noncachable distinction. This allows indexscan optimizations in many places where we formerly didn't. Also, add a pronamespace column to pg_proc (it doesn't do anything yet, however).
-
- Apr 04, 2002
-
-
Bruce Momjian authored
A new pg_hba.conf column, USER Allow specifiction of lists of users separated by commas Allow group names specified by + Allow include files containing lists of users specified by @ Allow lists of databases, and database files Allow samegroup in database column to match group name matching dbname Removal of secondary password files Remove pg_passwd utility Lots of code cleanup in user.c and hba.c New data/global/pg_pwd format New data/global/pg_group file
-
- Apr 03, 2002
-
-
Peter Eisentraut authored
and/or with GUC variables.
-
- Apr 02, 2002
-
-
Tom Lane authored
depend on this rather than the trigger argument strings to locate the other relation to test. This makes RI triggers function properly in the presence of schemas and temp tables. Along the way, fix bogus lack of locking in RI triggers, handle quoting of names fully correctly, compute required sizes of query buffers with some semblance of accuracy.
-
- 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.
-
- 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)
-
- Mar 24, 2002
- 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
-
Bruce Momjian authored
Rod Taylor.
-
Bruce Momjian authored
Ensure that sequence counters do not go backwards after a crash
-
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
-