summaryrefslogtreecommitdiff
path: root/src/pl
Commit message (Collapse)AuthorAgeFilesLines
* Revise Tcl/Tk configuration. Make missing Tcl after --with-tcl an error,Peter Eisentraut2000-09-251-2/+2
| | | | | | | add --without-tk option to disable Tk. We don't need the AC_PATH_XTRA test because tkConfig.sh already contains all the information about how to compile and link with X. Also make sure that libpq is up to date for libpgtcl. Remove executable bits from pgaccess.sh, but add it to pgaccess.
* disable plperl again.Bruce Momjian2000-09-251-4/+4
|
* Support for DESTDIR make variable. This is used as in `make installPeter Eisentraut2000-09-173-13/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | DESTDIR=/else/where' and prepends the value of DESTDIR to the full installation paths (e.g., /else/where/usr/local/pgsql/bin). This allows users to install the package into a location different from the one that was configured and hard-coded into various scripts, e.g., for creating binary packages. DESTDIR is in many cases preferrable over `make install prefix=/else/where' because a) `prefix' affects the path that is hard-coded into the files, which can lead to a `make install prefix=xxx' (as done by the regression test driver) corrupting the files in the source tree with wrong paths. b) it doesn't work at all if a directory was overridden to not depend on `prefix', e.g., --sysconfdir=/etc. (Updating the regression test driver to use DESTDIR is a separate undertaking.) See also autoconf@gnu.org, From: Akim Demaille <akim@epita.fr>, Date: 08 Sep 2000 12:48:59 +0200, Message-ID: <mv4em2vb1lw.fsf@nostromo.lrde.epita.fr>, Subject: Re: HTML format documentation.
* Allow PL/pgSQL accept non ascii identifiersTatsuo Ishii2000-09-151-3/+3
|
* Clean up compiler warning.Tom Lane2000-09-121-3/+2
|
* This patch, when applied in src/pl will unbreak plperl inBruce Momjian2000-09-122-12/+11
| | | | | | | | | | | | | | 7.0.2 release. Sorry, if that's fixed ages ago - I don't track development versions of PostgreSQL. Patch is just a little bit tested (some valid functions created and successfully run as well as some erroneous ones created and emitted proper error messages when used). My platform is FreeBSD 5.0-CURRENT (with perl 5.6.0 provided in the base system). Alex Kapranoff
* GET DIAGNOSTICS statement to PL/pgSQL to access SPI_processedJan Wieck2000-09-055-9/+236
| | | | | | and SPI_return values. Patch from Philip Warner. Jan
* Fix relative path references so that make knowns which dependencies referPeter Eisentraut2000-08-314-8/+8
| | | | | to one another. Sort out builddir vs srcdir variable namings. Remove some now obsoleted make variables.
* Added EXECUTE command to PL/pgSQL for execution ofJan Wieck2000-08-316-9/+368
| | | | | | dynamic SQL and utility statements. Jan
* New configure test for flex, which recognizes only flex but does so in allPeter Eisentraut2000-08-281-5/+8
| | | | | | incarnations (I hope). When an acceptable flex version is not found, print instructive error messages from both configure and the makefiles, so that users can continue building anyway.
* SQL-language functions are now callable in ordinary fmgr contexts ...Tom Lane2000-08-241-6/+6
| | | | | | for example, an SQL function can be used in a functional index. (I make no promises about speed, but it'll work ;-).) Clean up and simplify handling of functions returning sets.
* Fix plpgsql lexer to accept Windows-style and Mac-style newlines asTom Lane2000-08-221-27/+44
| | | | newlines.
* Clean up handling of variable-free qual clauses. System now does theTom Lane2000-08-131-21/+6
| | | | | | | | | | right thing with variable-free clauses that contain noncachable functions, such as 'WHERE random() < 0.5' --- these are evaluated once per potential output tuple. Expressions that contain only Params are now candidates to be indexscan quals --- for example, 'var = ($1 + 1)' can now be indexed. Cope with RelabelType nodes atop potential indexscan variables --- this oversight prevents 7.0.* from recognizing some potentially indexscanable situations.
* More functions updated to new fmgr style --- money, name, tid datatypes.Tom Lane2000-08-032-15/+25
| | | | | We're reaching the mopup stage here (good thing too, this is getting tedious).
* Add distprep target to take some of the job of the release_prep script.Peter Eisentraut2000-07-193-6/+9
| | | | | | | | | | | | | The latter updated accordingly. Also add `dist' and `distcheck' targets to play with, but caveat packager. Updated backend/bootstrap and backend/parser makefile to make them marginally builddir aware and fix the usual set of things. Add rule to automatically remake config.h dependent on config.h.in and config.status. (Adopted from Autoconf manual and about every other package.) On a good day we should now have a complete and accurate set of dependencies throughout everything.
* Added untrusted PL/TclU (pltclu) language. Executes all proceduresJan Wieck2000-07-191-118/+251
| | | | | | | | | | in a non-safe interpreter, so with full OS access! Language is restricted to be used by DB superusers. Added "argisnull n" and "return_null" commands to gain full control over NULL values from new FMGR capabilities. Jan
* Fixed an ordering problem in test queries andJan Wieck2000-07-182-7/+7
| | | | | | formatting differences due to new psql. Jan
* Update pltcl regress test's expected output for 7.0 psql output format.Tom Lane2000-07-181-137/+133
| | | | | | | NOTE: this implementation of tcl_avg() fails with 'divide by zero' for zero input rows. It ought to return NULL, but pltcl does not currently provide a way to do that, so I'm leaving the problem unsolved for now.
* Revise aggregate functions per earlier discussions in pghackers.Tom Lane2000-07-171-12/+17
| | | | | | | | | | | There's now only one transition value and transition function. NULL handling in aggregates is a lot cleaner. Also, use Numeric accumulators instead of integer accumulators for sum/avg on integer datatypes --- this avoids overflow at the cost of being a little slower. Implement VARIANCE() and STDDEV() aggregates in the standard backend. Also, enable new LIKE selectivity estimators by default. Unrelated change, but as long as I had to force initdb anyway...
* update pltcl test to have at least some chance of running ... stillTom Lane2000-07-172-11/+2
| | | | seems to be busted though ...
* pltcl seems to be broken on HPUX with recent Tcl versions, becauseTom Lane2000-07-171-1/+7
| | | | link needs to specify -lc but doesn't. Quick hack to make it better.
* First stage of reclaiming memory in executor by resetting short-termTom Lane2000-07-121-12/+20
| | | | | | memory contexts. Currently, only leaks in expressions executed as quals or projections are handled. Clean up some old dead cruft in executor while at it --- unused fields in state nodes, that sort of thing.
* Update textin() and textout() to new fmgr style. This is just phaseTom Lane2000-07-054-22/+28
| | | | | one of updating the whole text datatype, but there are so dang many calls of these two routines that it seems worth a separate commit.
* A little bit of clean-up/bug fix in Tcl build. Handle gracefully casesPeter Eisentraut2000-07-013-28/+14
| | | | where someone wants to build these but hasn't configured for Tcl.
* Fixes for Solaris/cc suggested by <pgsql-hackers@thewrittenword.com>Peter Eisentraut2000-06-301-2/+2
| | | | | | | | Don't use DISABLE_COMPLEX_MACRO on Solaris. Don't define the replacement function in the header file. Use -KPIC, not -K PIC. Use CC to link C++ libraries, not ld/ar. Eliminate file not found warnings in tcl build code.
* Makefile cleanup for interface tree. Now essentially with all thePeter Eisentraut2000-06-282-6/+9
| | | | | | | | | | | | | | | | | | | | | standard targets and behaviour. Replaced Makefile.in's with Makefile's and declared the respective variables in Makefile.global. maintainer-clean target now available at top level, although it does not work in the backend tree yet. Cleanup pass over Makefile.shlib, renamed some targets and variables. The shared library symlink tests are now done by make, not the shell. ecpg: Remove one warning in sloppy flex output. PL/Perl and Perl interface: the MakeMaker documentation is confusing, the realclean target *does* "delete derived files", but it also uninstalls them. Don't use that. The submake targets in the various bin directories that update libpq should `make all', not `make libpq.a'. That is a) unportable, and b) doesn't build the shared library.
* Makefile cleanup for bin and pl subtrees. They should now supportPeter Eisentraut2000-06-278-237/+151
| | | | | all the standard semantics. Also get rid of Makefile.in's on the way and instead declare all variables in Makefile.global.
* Cleaned up PL/pgSQL build. Fixed a couple of copyandpaste'os in thePeter Eisentraut2000-06-206-67/+120
| | | | | interfaces and interfaces/odbc make files. Adjusted regression test driver to start building and installing in the top level directory.
* Remove fmgrstamp-h business -- not needed and confusingPeter Eisentraut2000-06-172-5/+5
| | | | | Add options to configure to automatically build for Kerberos support; no more editing of make files.
* Big warnings cleanup for Solaris/GCC. Down to about 40 now, butPeter Eisentraut2000-06-141-2/+2
| | | | | | | | | | | we'll get there one day. Use `cat' to create aclocal.m4, not `aclocal'. Some people don't have automake installed. Only run the autoconf rule in the top-level GNUmakefile if the invoker specified `make configure', don't run it automatically because of CVS timestamp skew.
* >> What happened to the patch I sent regarding the bug in the TCLBruce Momjian2000-06-121-2/+2
| | | | | | | | >> Makefile where the make bombs if "." is not in the builder's path? >> The last I checked, it wasn't applied and the fix is very easy >> (explicitly use "./" to call the script). SL Baur
* Moved the intricacies of the perl interface build into its own makefilePeter Eisentraut2000-06-104-45/+91
| | | | | | | | | | | | | | | | | | that now functions as a wrapper around the MakeMaker stuff. It might even behave sensically when we have separate build dirs. Same for plperl, which of course still doesn't work very well. Made sure that plperl respects the choice of --libdir. Added --with-python to automatically build and install the Python interface. Works similarly to the Perl5 stuff. Moved the burden of the distclean targets lower down into the source tree. Eventually, each make file should have its own. Added automatic remaking of makefiles and configure. Currently only for the top-level because of a bug(?) in Autoconf. Use GNU `missing' to work around missing autoconf and aclocal. Start factoring out macros into their own config/*.m4 files to increase readability and organization.
* Gen_fmgrtab.sh is strange: it is a platform dependent way (because it usesPeter Eisentraut2000-06-071-2/+2
| | | | | | | | | | | | | | | | | | | | | CPP) to create platform independent files. Unfortunately, that means that every config.status (or configure) run invariably causes a relink of the postmaster and also that we can't put these files in the distribution (usefully). So we make it a little smarter: when the output files already exist and it notices that it would recreate them in identical form, it doesn't touch them. In order to avoid re-running the make rule all the time we update a timestamp file instead. Update release_prep accordingly. Also make Gen_fmgrtab.sh use the awk that is detected at configure time, not necessarily named `awk' and have it check for exit statuses a little better. In other news... Remove USE_LOCALE from the templates, it was set to `no' everywhere anyway. Also remove YACC and YFLAGS from the templates, configure is smart enough to find bison or yacc itself. Use AC_PROG_YACC for that instead of the hand-crafted code. Do not set YFLAGS to `-d'. The make rules that need this flag should explicitly invoke it. YFLAGS should be a user variable. Update the makefiles to that effect.
* Moved configure script from src/ to the top level directory. MovedPeter Eisentraut2000-06-061-2/+2
| | | | | configuration helper things into config/ dir. Adjusted some relative paths in makefiles.
* Latest round of fmgr updates. All functions with bool,char, or int2Tom Lane2000-06-053-6/+8
| | | | | | | inputs have been converted to newstyle. This should go a long way towards fixing our portability problems with platforms where char and short parameters are passed differently from int-width parameters. Still more to do for the Alpha port however.
* Third round of fmgr updates: eliminate calls using fmgr() andTom Lane2000-05-303-75/+60
| | | | | fmgr_faddr() in favor of new-style calls. Lots of cleanup of sloppy casts to use XXXGetDatum and DatumGetXXX ...
* Cleanup of <> and ""Bruce Momjian2000-05-292-6/+6
|
* Generated header files parse.h and fmgroids.h are now copied intoTom Lane2000-05-293-6/+4
| | | | | the src/include tree, so that -I backend is no longer necessary anywhere. Also, clean up some bit rot in contrib tree.
* Second round of fmgr changes: triggers are now invoked in new style,Tom Lane2000-05-293-37/+15
| | | | CurrentTriggerData is history.
* First round of changes for new fmgr interface. fmgr itself and theTom Lane2000-05-285-216/+186
| | | | | | | key call sites are changed, but most called functions are still oldstyle. An exception is that the PL managers are updated (so, for example, NULL handling now behaves as expected in plperl and plpgsql functions). NOTE initdb is forced due to added column in pg_proc.
* Transmit -I switches selected by configure (particularly those fromTom Lane2000-05-232-4/+4
| | | | | | --with-includes) to makefiles for pltcl and plperl, so that these switches will be used even though we do not want other top-level CFLAGS. Ain't it fun trying to support multiple-compiler platforms?
* Cast parameters to ckfree to (char *) to suppress compiler warnings.Tom Lane2000-05-231-9/+9
|
* Irix fixes from Murad NayalBruce Momjian2000-05-221-2/+2
|
* Oops, plpgsql didn't have the datetime->timestamp and timespan->intervalBruce Momjian2000-05-111-10/+14
| | | | | | | mappings. In fact, it had them backward because it was using the 6.5.* code. Copied them from parser/gram.y, so it is fixed now. Looks like our first 7.0.1 fix. Oops, seems Tom has beat me to it as I was typing this.
* plpgsql RAISE statement was careless about the possibility of a NULLTom Lane2000-04-281-1/+3
| | | | | field value being displayed; produced coredump instead of the expected <NULL> display.
* pltcl didn't work well at all when Tcl had been built with a differentTom Lane2000-04-211-11/+14
| | | | | | | compiler than the one selected to build Postgres with. It was trying to feed Postgres-compiler switches to Tcl's compiler. (Seen this before with the perl5 interface...) Fix to use only CFLAGS taken from Tcl's configure information, plus -I which is pretty universal.
* Security fix for plperl.Bruce Momjian2000-04-182-23/+21
|
* Add code to test for non-shared libperl and fail gracefully.Tom Lane2000-04-171-4/+48
| | | | Not a big step forward, but it's something...
* Show failing OID in 'cache lookup failed' messages;Tom Lane2000-04-162-21/+29
| | | | print OIDs as %u not %d.
* Show failing OID in 'cache lookup failed' messages.Tom Lane2000-04-161-2/+2
|