[BUGS] BUG #7791: create database with owner, owner does not get usage on schema

The following bug has been logged on the website: Bug reference: 7791 Logged by: Brice Breeden Email address: zardozwild...@hotmail.com PostgreSQL version: 9.1.7 Operating system: windows x64 Description: This database creation script was executed via the postgres sup

[BUGS] BUG #7790: null filters in CTEs don't work

The following bug has been logged on the website: Bug reference: 7790 Logged by: Luisa Francisco Email address: luisa.j.franci...@gmail.com PostgreSQL version: 9.2.2 Operating system: 32-bit Windows 7 SP1 Description: Expected output should have no nulls in it, but it

[BUGS] BUG #7794: pg_dump: errors when using pipes/streams

The following bug has been logged on the website: Bug reference: 7794 Logged by: Stefan Reiser Email address: s.rei...@tu-bs.de PostgreSQL version: 9.1.7 Operating system: Windows 7 Pro 64-Bit Description: I intend to stream the output of pg_dump into a zip file (alon

[BUGS] BUG #7792: pg_dump does not treat -c flag correctly when using tar format

The following bug has been logged on the website: Bug reference: 7792 Logged by: Eli Mesika Email address: emes...@redhat.com PostgreSQL version: 9.1.7 Operating system: Fedora 16 Description: steps to reproduce (aasuming database name is : test) 1) pg_dump -F t -U p

[BUGS] BUG #7793: tsearch_data thesaurus size limit

The following bug has been logged on the website: Bug reference: 7793 Logged by: David Boutin Email address: dav...@gmail.com PostgreSQL version: 9.1.7 Operating system: Ubuntu 12.04 LTS 64bits Description: Hi all, I like working with thesaurus files with specific te

Re: [BUGS] BUG #7791: create database with owner, owner does not get usage on schema

zardozwild...@hotmail.com writes: > This database creation script was executed via the postgres superuser. > Executes create database and the "with owner" clause. > Create database assigns ownership to a role (myta_admin_role). This is not a > login role. > After database creation, script creates a

Re: [BUGS] BUG #7794: pg_dump: errors when using pipes/streams

s.rei...@tu-bs.de writes: > pg_dump shows one or more warnings when used with non-seekable streams: > "pg_dump: [custom archiver] WARNING: ftell mismatch with expected position > -- ftell used" > Examples (on Windows 7 Pro 64 Bit, PG 9.1.7 and 9.1.6, 64 Bit) > 1) pg_dump --format=custom --schema-

Re: [BUGS] BUG #7792: pg_dump does not treat -c flag correctly when using tar format

emes...@redhat.com writes: > 1) pg_dump -F t -U postgres -f test.tar test > 2) tar xvf test.tar to any directory > 3) vi restore.sql > * restore.sql includes DROP statements for each object even tough -c flag > was not given I believe this is intentional - at least, pg_backup_tar.c goes out of it

Re: [BUGS] BUG #7793: tsearch_data thesaurus size limit

dav...@gmail.com writes: > [ thesaurus dictionary fails for more than 64K entries ] I see a whole bunch of uses of "uint16" in src/backend/tsearch/dict_thesaurus.c. It's not immediately clear which of these would need to be widened to support more entries, or what the storage cost of doing that w

Re: [BUGS] BUG #7790: null filters in CTEs don't work

luisa.j.franci...@gmail.com writes: > Expected output should have no nulls in it, but it does: It's not apparent to me why you think the first query shouldn't produce any rows with null parent_id? AFAICS, the recursive query will "crawl up the tree" producing a row for every parent level above th

Re: [BUGS] BUG #7781: pgagent incorrect installation

The ini file clearly says that the pgAgent has been installed in /Library/pgAgent. Can you please share install-pgagent.log from your system temp (/tmp)? On Sat, Jan 5, 2013 at 7:56 PM, Aleksander Shniperson < alex.shniper...@gmail.com> wrote: > Sorry for late answer > > Here is ini-file: > [Post