The following bug has been logged online:
Bug reference: 4095
Logged by: Pavel Zaitsev
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Windows 2003 Server SP1
Description:Out of memory when restore db
Details:
I made the backup of databa
> In ECPG when I have "$select a into :a from table where b = :b;" this query
> raises an error if the value a is NULL.
> If I have added the indicator value "$select a int :a, :a_ind from table
> where b = :b;" this also raises the same error. I cannot read rows including
> null values without r
"Pavel Zaitsev" <[EMAIL PROTECTED]> writes:
> I made the backup of database named avtopzipbuh:
> pg_dump -f%DRIVETO%\Backup\%DIRNAME%\%FILENAME% -Upostgres avtozipbuh
> then, I tried to restore it:
> psql -davtozipbuh -Upostgres -fF:\Backup\avtozipbuh
> -oF:\Backup\logrestore.txt
> but I had an er
Dave Page wrote:
On Tue, Mar 18, 2008 at 12:47 AM, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
Mike Leahy wrote:
> Is this actually a bug, or is there a specific reason that the pgxs
> files omitted in the windows installer? I noticed the 8.3.1 installer
> has been posted (as the updates had a
Hello,
By documentation advice in:
http://www.postgresql.org/docs/8.3/interactive/role-attributes.html
Tip: It is good practice to create a role that has the CREATEDB
and CREATEROLE privileges, but is not a superuser, and then use this
role for all routine management of databases and roles. T
Gabriel Ramirez <[EMAIL PROTECTED]> writes:
> Tip: It is good practice to create a role that has the CREATEDB
> and CREATEROLE privileges, but is not a superuser, and then use this
> role for all routine management of databases and roles. This approach
> avoids the dangers of operating as a supe
Joe Conway wrote:
> Dave Page wrote:
> > On Tue, Mar 18, 2008 at 12:47 AM, Alvaro Herrera
> > <[EMAIL PROTECTED]> wrote:
> >> Mike Leahy wrote:
> >> > Is this actually a bug, or is there a specific reason that the
> >> > pgxs files omitted in the windows installer? I noticed the
> >> > 8.3.1 in
