NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitaa4c702

committed

Update /contrib for "autocommit TO 'on'".

Create objects in public schema.Make spacing/capitalization consistent.Remove transaction block use for object creation.Remove unneeded function GRANTs.

1 parentfb9bc34 commitaa4c702Copy full SHA for aa4c702

File tree

91 files changed

+3607

-2720

lines changed

contrib
- adddepend
  - adddepend
- array
  - array_iterator.sql.in
- btree_gist
  - btree_gist.sql.in
  - expected
    - btree_gist.out
  - sql
    - btree_gist.sql
- chkpass
  - chkpass.sql.in
- cube
  - cube.sql.in
  - expected
    - cube.out
  - sql
    - cube.sql
- dbase
  - dbf2pg.c
- dblink
  - dblink.sql.in
  - expected
    - dblink.out
  - sql
    - dblink.sql
- dbmirror
  - AddTrigger.sql
  - DBMirror.pl
  - MirrorSetup.sql
  - clean_pending.pl
- earthdistance
  - earthdistance.sql.in
  - expected
    - earthdistance.out
  - sql
    - earthdistance.sql
- findoidjoins
  - findoidjoins.c
- fulltextindex
  - fti.pl
  - fti.sql.in
  - uninstall.sql
- fuzzystrmatch
  - fuzzystrmatch.sql.in
- intagg
  - int_aggregate.sql.in
- intarray
  - _int.sql.in
  - expected
    - _int.out
  - sql
    - _int.sql
- isbn_issn
  - isbn_issn.sql.in
- lo
  - lo.sql.in
  - lo_drop.sql
  - lo_test.sql
- ltree
  - expected
    - ltree.out
  - ltree.sql.in
  - ltreetest.sql
  - sql
    - ltree.sql
- miscutil
  - misc_utils.sql.in
- noupdate
  - noup.sql.in
- oid2name
  - oid2name.c
- pg_dumplo
  - main.c
- pgbench
  - pgbench.c
- pgcrypto
  - expected
  - pgcrypto.sql.in
  - sql
- pgstattuple
  - pgstattuple.sql.in
- reindexdb
  - reindexdb
- rtree_gist
  - bench
    - bench.pl
    - create_test.pl
  - expected
    - rtree_gist.out
  - rtree_gist.sql.in
  - sql
    - rtree_gist.sql
- seg
  - expected
    - seg.out
  - seg.sql.in
  - sql
    - seg.sql
- spi
  - autoinc.sql.in
  - insert_username.sql.in
  - moddatetime.sql.in
  - refint.sql.in
  - timetravel.sql.in
- string
  - string_io.sql.in
- tablefunc
  - expected
    - tablefunc.out
  - sql
    - tablefunc.sql
  - tablefunc.sql.in
- tsearch
  - expected
    - tsearch.out
  - sql
    - tsearch.sql
  - tsearch.sql.in
- userlock
  - user_locks.sql.in
- vacuumlo
  - vacuumlo.c
- xml
  - pgxml_dom.source
src/bin/scripts
- Makefile

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

91 files changed

+3607

-2720

lines changed

`‎contrib/adddepend/adddepend`

Lines changed: 15 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`#!/usr/bin/perl`
`2`		`-# $Id: adddepend,v 1.1 2002/09/1820:38:59 momjian Exp $`
	`2`	`+# $Id: adddepend,v 1.2 2002/10/1818:41:19 momjian Exp $`
`3`	`3`
`4`	`4`	`# Project exists to assist PostgreSQL users with their structural upgrade`
`5`	`5`	`# from 7.2 (or prior) to 7.3 (possibly later). Must be run against a 7.3`
`@@ -125,6 +125,20 @@ my $dbh = DBI->connect($dsn, $dbuser, $dbpass);`
`125`	`125`	`# We want to control commits`
`126`	`126`	`$dbh->{'AutoCommit'} = 0;`
`127`	`127`
	`128`	`+# turn on autocommit`
	`129`	`+my$sql =qq{`
	`130`	`+ SET search_path = public;`
	`131`	`+};`
	`132`	`+my$sth =$dbh->prepare($sql);`
	`133`	`+$sth->execute();`
	`134`	`+`
	`135`	`+# turn on autocommit`
	`136`	`+my$sql2 =qq{`
	`137`	`+ SET autocommit TO 'on';`
	`138`	`+};`
	`139`	`+my$sth2 =$dbh->prepare($sql2);`
	`140`	`+$sth2->execute();`
	`141`	`+`
`128`	`142`	`END {`
`129`	`143`	`$dbh->disconnect()if$dbh;`
`130`	`144`	`}`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitaa4c702

File tree

91 files changed

Some content is hidden

91 files changed

`‎contrib/adddepend/adddepend`

0 commit comments