[BUGS] BUG #3439: pg_standby and path name with space
The following bug has been logged online: Bug reference: 3439 Logged by: ISHIDA Akio Email address: [EMAIL PROTECTED] PostgreSQL version: CVS HEAD Operating system: Windows XP Description:pg_standby and path name with space Details: pg_standby failed if path name containing spaces. C:\Documents and Settings\ishida\pgsql>pg_standby -d "C:\Documents and Settings\ ishida\pgsql\archive_dir" 0001 data\pg_xlog Trigger file: Waiting for WAL file: C:\Documents and Settings\ishida\pgsql\archive_dir\0001 WAL file path : 0001 Restoring to... : data\pg_xlog Sleep interval : 5 seconds Max wait interval : 0 forever Command for restore : copy C:\Documents and Settings\ishida\pgsql\archive_dir\0001 data\pg_xlog Num archived files kept : all files running restore :The system cannot find the file specified. The system cannot find the file specified. The system cannot find the file specified. not restored: --- pg_standby.c26 Jun 2007 22:05:02 - 1.6 +++ pg_standby.c12 Jul 2007 19:03:19 - @@ -69,7 +69,7 @@ int nextWALFileType; #define SET_RESTORE_COMMAND(cmd, arg1, arg2) \ - snprintf(restoreCommand, MAXPGPATH, cmd " %s %s", arg1, arg2) + snprintf(restoreCommand, MAXPGPATH, cmd " \"%s\" \"%s\"", arg1, arg2) struct stat stat_buf; ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[BUGS] BUG #1766: contrib/ modules can't install with --without-docdir
The following bug has been logged online: Bug reference: 1766 Logged by: ISHIDA Akio Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux Description:contrib/ modules can't install with --without-docdir Details: $ ./configure --without-docdir .. $ cd contrib/pgstattuple/ $ make install mkdir -p -- /contrib mkdir: cannot create directory `/contrib': Permission denied make: *** [installdirs] Error 1 --- src/makefiles/pgxs.mk.org 2004-10-11 01:13:03.0 +0900 +++ src/makefiles/pgxs.mk 2005-07-14 09:54:24.0 +0900 @@ -100,10 +100,12 @@ done endif # MODULES ifdef DOCS +ifdef docdir @for file in $(addprefix $(srcdir)/, $(DOCS)); do \ echo "$(INSTALL_DATA) $$file $(DESTDIR)$(docdir)/contrib"; \ $(INSTALL_DATA) $$file $(DESTDIR)$(docdir)/contrib; \ done +endif # docdir endif # DOCS ifdef PROGRAM $(INSTALL_PROGRAM) $(PROGRAM)$(X) $(DESTDIR)$(bindir) @@ -133,8 +135,10 @@ $(mkinstalldirs) $(DESTDIR)$(pkglibdir) endif ifdef DOCS +ifdef docdir $(mkinstalldirs) $(DESTDIR)$(docdir)/contrib -endif +endif # docdir +endif # DOCS ifneq (,$(PROGRAM)$(SCRIPTS)$(SCRIPTS_built)) $(mkinstalldirs) $(DESTDIR)$(bindir) endif ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[BUGS] contrib/adddepend failed 8.1.2
Hi.
I was trying to upgrade PostgreSQL from 7.2.8 to 8.1.2.
Dump and restore work well. But adddepend was failed.
To fix it, this regexp
$seq =~ s|^nextval\(["']+([^'"\)]+)["']+.*\)$|$1|g;
need to change
$seq =~ s|^nextval\(\(["']+([^'"\)]+)["']+.*\)$|$1|g;
or
$seq =~ s|^nextval\(\(?["']+([^'"\)]+)["']+.*\)$|$1|g;
[EMAIL PROTECTED] adddepend]$ ./adddepend -Y -d ishida
Upgrade the Unique Constraint style via:
DROP INDEX t_i_key RESTRICT;
ALTER TABLE t ADD CONSTRAINT t_i_key UNIQUE (i);
NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "t_i_key"
for table "t"
Do you wish to upgrade Sequence 'nextval(('"t_i_seq"'::text)::regclass)'
to SERIAL?
Found on column t.i
DBD::Pg::st execute failed: ERROR: syntax error at or near ""t_i_seq""
at character 790 at ./adddepend line 539.
logfile
ERROR: syntax error at or near ""t_i_seq"" at character 790
STATEMENT:
INSERT INTO pg_catalog.pg_depend
( classid
, objid
, objsubid
, refclassid
, refobjid
, refobjsubid
, deptype
) VALUES ( (SELECT c.oid--
classid
FROM pg_class as c
JOIN pg_namespace as n
ON (n.oid =
c.relnamespace)
WHERE n.nspname = 'pg_catalog'
AND c.relname = 'pg_class')
, (SELECT c.oid-- objid
FROM pg_class as c
JOIN pg_namespace as n
ON (n.oid =
c.relnamespace)
WHERE n.nspname = 'public'
AND c.relname =
'nextval(('"t_i_seq"'::text)::regclass)')
, 0--
objsubid
, (SELECT c.oid--
refclassid
FROM pg_class as c
JOIN pg_namespace as n
ON (n.oid =
c.relnamespace)
WHERE n.nspname = 'pg_catalog'
AND c.relname = 'pg_class')
, (SELECT c.oid--
refobjid
FROM pg_class as c
JOIN pg_namespace as n
ON (n.oid =
c.relnamespace)
WHERE n.nspname = 'public'
AND c.relname = 't')
, (SELECT a.attnum --
refobjsubid
FROM pg_class as c
JOIN pg_namespace as n
ON (n.oid =
c.relnamespace)
JOIN pg_attribute as a
ON (a.attrelid = c.oid)
WHERE n.nspname = 'public'
AND c.relname = 't'
AND a.attname = 'i')
, 'i' --
deptype
);
--
ISHIDA Akio <[EMAIL PROTECTED] / [EMAIL PROTECTED]>
*** ./contrib/adddepend/adddepend.orig 2003-11-30 07:39:16.0 +0900
--- ./contrib/adddepend/adddepend 2006-01-18 00:46:32.0 +0900
***
*** 469,475
my $seq = $row->{'adsrc'};
# Extract the sequence name from the default
! $seq =~ s|^nextval\(["']+([^'"\)]+)["']+.*\)$|$1|g;
[BUGS] BUG #2214: release.sgml - Migration to version 8.1
The following bug has been logged online:
Bug reference: 2214
Logged by: ISHIDA Akio
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.2
Operating system: Linux
Description:release.sgml - Migration to version 8.1
Details:
./doc/src/sgml/release.sgml
*** ./doc/src/sgml/release.sgml.orig2006-01-06 12:00:06.0 +0900
--- ./doc/src/sgml/release.sgml 2006-01-26 20:44:50.0 +0900
***
*** 632,638
' SET DEFAULT ' ||
regexp_replace(d.adsrc,
$$val\(\(('[^']*')::text\)::regclass$$,
!$$val\(\1$$,
'g') ||
';'
FROMpg_namespace n, pg_class c, pg_attribute a, pg_attrdef d
--- 632,638
' SET DEFAULT ' ||
regexp_replace(d.adsrc,
$$val\(\(('[^']*')::text\)::regclass$$,
!$$val(\1$$,
'g') ||
';'
FROMpg_namespace n, pg_class c, pg_attribute a, pg_attrdef d
---(end of broadcast)---
TIP 6: explain analyze is your friend
