Re: [BUGS] BUG #3876: Problems migrating databases

2008-01-15 Thread Guillaume Smet
On Jan 15, 2008 5:52 PM, Ruben Camargo Gomez <[EMAIL PROTECTED]> wrote: > I had this error from my log file: > ERRORROR: missing FROM-clause entry for table "tbldishot" > CONTEXT: SQL statement "update tblalohot set alohot_con = > coalesce(alohot_con,0)+8 where tbldishot.dishot_cod = tblalohot.d

[BUGS] Information

2008-01-15 Thread Esquivel, Maria Jose (Merrill Lynch Service Desk)
Hello I installed progres 8.2 on my windows xp computer and created a database. I am able to see the data base when I connect to PG Admin III but I'm not able to get its location on my HD. Can you please tell me how to proceed since I need to copy it to a server? Thanks in advanced, Mariajos

Re: [BUGS] BUG #3877: Doc Clarification: archive_command and restore_command replacements

2008-01-15 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: >> That sounds reasonable. > Yep, I'll scan the docs and submit a patch, unless Tom has already. I have not --- go for it. regards, tom lane ---(end of broadcast)--- TIP 6: explain an

Re: [BUGS] BUG #3877: Doc Clarification: archive_command and restore_command replacements

2008-01-15 Thread Simon Riggs
On Tue, 2008-01-15 at 14:50 -0500, Tom Lane wrote: > "Kevin Hunt" <[EMAIL PROTECTED]> writes: > > The description of %p is misleading since it is replaced with not just the > > path, but also filename. > > Hm? "Path name" includes the file name in all usages I know about. Agreed. > > An example

Re: [BUGS] BUG #3877: Doc Clarification: archive_command and restore_command replacements

2008-01-15 Thread Tom Lane
"Kevin Hunt" <[EMAIL PROTECTED]> writes: > The description of %p is misleading since it is replaced with not just the > path, but also filename. Hm? "Path name" includes the file name in all usages I know about. > An example showing how the sample commands would be expanded would also > help: T

[BUGS] BUG #3877: Doc Clarification: archive_command and restore_command replacements

2008-01-15 Thread Kevin Hunt
The following bug has been logged online: Bug reference: 3877 Logged by: Kevin Hunt Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: n/a Description:Doc Clarification: archive_command and restore_command replacements Details: When describ

Re: [BUGS] BUG #3876: Problems migrating databases

2008-01-15 Thread J6M
Hi, Dis you take a look at the Postgres release notes and at the section of postgresql.conf on compatibility with previous releases ? (see below) #--- # VERSION/PLATFORM COMPATIBILITY #-

[BUGS] BUG #3876: Problems migrating databases

2008-01-15 Thread Ruben Camargo Gomez
The following bug has been logged online: Bug reference: 3876 Logged by: Ruben Camargo Gomez Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Linux Red Hat Enterprice 5 Description:Problems migrating databases Details: Hi, frist of all than

[BUGS] BUG #3875: Building GIN index on full table could be slower than filling table with existing index.

2008-01-15 Thread Sokolov Yura
The following bug has been logged online: Bug reference: 3875 Logged by: Sokolov Yura Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC1 8.2.x Operating system: Debian 4.0 Description:Building GIN index on full table could be slower than filling table with ex

Re: [BUGS] BUG #3860: xpath crashes backend when is querying xmlagg result

2008-01-15 Thread Sokolov Yura
Tom Lane wrote: "Sokolov Yura" <[EMAIL PROTECTED]> writes: xpath() crashes backend when is querying particular xmlagg results. Please see whether this patch fixes it: http://archives.postgresql.org/pgsql-committers/2008-01/msg00190.php The specific examples you give seem to be fixed,