d again successfully and without
further ado.
This bug is likely to be very sensitive to timing and I didn't bother
trying to recreate it.
Local and remote systems are Ubuntu 10.04 running the distro version of
PG 8.4.4.
-Reece
--
Reece Hart, Ph.D.
Chief Scientist, Genome Co
etely right, of course, and I appreciate your perseverance
in setting me straight. I don't recall making the postgresql.conf change
but I surely was the one who did so.
Thanks for your time.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
our evidence, it seems that the
postgresql.conf comment for max_fsm_pages needs revising to indicate
that the m_f_p default is determined at initdb-time.
Thank you,
Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
re the values shown by vacuum hints and
pg_settings.
So, it still seems to me that the postgresql.conf default (1638400)
should be written in page units (20000) to be consistent with the other
uses. Or, am I misthinking?
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
--
The following bug has been logged online:
Bug reference: 3801
Logged by: Reece Hart
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.5
Operating system: Linux (SLES 10)
Description:max_fsm_pages postgresql.conf default != guc.c default
Details:
The guc.c
ws can depend on views. So, consider your view1 as version1, then
create view2 which depends on view1 and merely recasts the type1 column
as character(3). New code can use view2 and old code can be migrated to
view2 as needed.
-Reece
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
version
--
PostgreSQL 8.2.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.0.2
20050901 (prerelease) (SUSE Linux)
csb=# create function testpl() returns void as 'begin return;
csb'# end;'language 'plpgsql'
r message
This is not a bug. Quoting always makes identifiers case-sensitive, per
the SQL standard.
Read section 4.1.1:
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
---(end of broadcast)
/kb/Content/SQLTipNull.htm
-Reece
--
Reece Hart, Ph.D. [EMAIL PROTECTED], http://www.gene.com/
Genentech, Inc.650-225-6133 (voice), -5389 (fax)
Bioinformatics and Protein Engineering
1 DNA Way, MS-93 http://harts.net/reece/
Sout
On Thu, 2004-01-22 at 09:40, Reece Hart wrote:
4) Ensure that your environment doesn't have C_INCLUDE_PATH, LIBRARY_PATH, or LD_LIBRARY_PATH set (try 'env|grep path').
Ooops... that's 'env|grep PATH' (in capitals)
--
Reece Hart, http://w
ort). comm this file with a similar list from your machine. Perhaps something will stand out.
Good luck,
Reece
--
Reece Hart, http://www.in-machina.com/~reece/, GPG:0x25EC91A0
4Suite-0.11.1-13.i386.rpm
CBD-Common-2.1.5-1.i386.rpm
CBD-DataArchitect-2.1.5-1.i386.rpm
CBD-ODBCBrowser-2.1.
#x27;alter table set default ...'. Thus, the function's OID is greater than the OID of the tables which use them. This is probably not typical. While dumping in OID order (which pg_dump apparently does) will usually mean that dependencies are dumped first, 'alter table...set default&#x
#x27;alter table set default ...'. Thus, the function's OID is greater than the OID of the tables which use them. This is probably not typical. While dumping in OID order (which pg_dump apparently does) will usually mean that dependencies are dumped first, 'alter table...set defau
gs/2003-05/msg00086.php), but I
don't understand the issue or his response. I tried to wrap the create
and drop in EXECUTE '...', but that didn't work.
Does anyone have a suggestion for how I might resolve this? I'd
appreciate a short description of the issue as well.
14 matches
Mail list logo
