Re: [BUGS] Bug in CREATE FUNCTION with character type

2010-04-15 Thread Pavel Golub
Hello, Tom. You wrote: TL> Pavel Golub writes: >> Example: >> CREATE OR REPLACE FUNCTION test_char_function() >> RETURNS TABLE(id int, salesourcecode character) AS >> $BODY$ >> VALUES (1, 'one'), (2, 'two'), (3, 'three'); >> $BODY$ >> LANGUAGE 'sql' >> pqfmod function from libpq library fo

[BUGS] BUG #5422: problems installing postgresql-8.4 deleted folder / .s.PGSQL.lock not initinot initiate the connecti

2010-04-15 Thread Alex Soto Paez
The following bug has been logged online: Bug reference: 5422 Logged by: Alex Soto Paez Email address: alejandro.soto...@gmail.com PostgreSQL version: 8.4 Operating system: linux Description:problems installing postgresql-8.4 deleted folder / .s.PGSQL.lock not initino

[BUGS] BUG #5423: problems installing postgresql-8.4 deleted folder / .s.PGSQL.lock not initiate the connecti

2010-04-15 Thread Alex Soto Paez
The following bug has been logged online: Bug reference: 5423 Logged by: Alex Soto Paez Email address: alejandro.soto...@gmail.com PostgreSQL version: 8.4 Operating system: linux 9.10 Description:problems installing postgresql-8.4 deleted folder / .s.PGSQL.lock not in

Re: [BUGS] BUG #5416: int4inc() is wrong

2010-04-15 Thread John Regehr
Hi Tom, > If you can show me rewrites of all the basic arithmetic operations that > detect overflow in full compliance with the C standard, and are > readable, portable, and efficient, I'm all ears. These are the best ones that I know of: https://www.securecoding.cert.org/confluence/display/secc

Re: [BUGS] build error: strlcat/strlcpy used from heimdal libroken.so

2010-04-15 Thread Martin von Gagern
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dear Bruce, On 15.04.2010 03:59, Bruce Momjian wrote: > I haven't seen anyone reply to this report, Probably because Craig Ringer forwarded it to the -hackers list with cc to me personally, but not to these lists. For that thread see http://thread.gm

Re: [BUGS] BUG #5423: problems installing postgresql-8.4 deleted folder / .s.PGSQL.lock not initiate the connecti

2010-04-15 Thread Scott Mead
On Wed, Apr 14, 2010 at 8:15 PM, Alex Soto Paez wrote: > > The following bug has been logged online: > > Bug reference: 5423 > Logged by: Alex Soto Paez > Email address: alejandro.soto...@gmail.com > PostgreSQL version: 8.4 > Operating system: linux 9.10 > Description:

Re: [BUGS] BUG #5418: psql exits after using tab-completion with error message

2010-04-15 Thread Tom Lane
Ben Madin writes: > I also reported it to Apple, but without this information, so I hope they get > the sense that it might be important enough to look at, especially if there > is already a fix known. Mine is problem ID 7866382, if you'd like to add a note to yours pointing out the duplication

Re: [BUGS] Bug in CREATE FUNCTION with character type (CONFIRMED BUG)

2010-04-15 Thread Tom Lane
Pavel Stehule writes: > I think, so RETURNS TABLE can be modified for returning typmode > without significant problems - this function is called in table > context and I don't see any problematic use case. RETURNS TABLE is just a shorthand for some OUT parameters. I don't believe it's either eas

Re: [BUGS] Reset ACL to default for pg 8.0

2010-04-15 Thread Juan C. Aragon
Thanks Bruce for replying. The ACL is display in the PgAdmin tool for Windows on the properties for a table or function. ACL is the Privileges. By default, when you create a new function or table, the ACL is null. However, if you add some privileges, and then remove all, the ACL is not longer null

Re: [BUGS] Bug in CREATE FUNCTION with character type (CONFIRMED BUG)

2010-04-15 Thread Pavel Stehule
2010/4/15 Tom Lane : > Pavel Stehule writes: >> I think, so RETURNS TABLE can be modified for returning typmode >> without significant problems - this function is called in table >> context and I don't see any problematic use case. > > RETURNS TABLE is just a shorthand for some OUT parameters.  I

[BUGS] BUG #5424: Not able to Install

2010-04-15 Thread Aditya Vats
The following bug has been logged online: Bug reference: 5424 Logged by: Aditya Vats Email address: aditya.v...@cerner.com PostgreSQL version: 8.4.2-1 Operating system: Windows Vista Description:Not able to Install Details: While installing I am getting an error say

Re: [BUGS] BUG #5422: problems installing postgresql-8.4 deleted folder / .s.PGSQL.lock not initinot initiate the connecti

2010-04-15 Thread Alvaro Herrera
Alex Soto Paez escribió: > > The following bug has been logged online: > > Bug reference: 5422 > Logged by: Alex Soto Paez > Email address: alejandro.soto...@gmail.com > PostgreSQL version: 8.4 > Operating system: linux > Description:problems installing postgresql-8.4

Re: [BUGS] BUG #5418: psql exits after using tab-completion with error message

2010-04-15 Thread Ben Madin
Thanks Tom, I also reported it to Apple, but without this information, so I hope they get the sense that it might be important enough to look at, especially if there is already a fix known. I also contacted William Kyngesbury, and he was sympathetic (but had never had the problem himself, but

[BUGS] Dump and Restore in postgresql-8.3.6-1PGDG

2010-04-15 Thread suresh adapa
I am on Linux using postgresql-8.3.6-1PGDG Taking Dump using = export PGPASSWORD=suresha && pg_dump -b -c -C --format=c -h localhost -p 5432 -U suresha -f /tmp/dump/db/suresha.sql suresha Trying to Restore the same like === [r...@cu018 scripts]# pg

Re: [BUGS] Dump and Restore in postgresql-8.3.6-1PGDG

2010-04-15 Thread Scott Mead
On Thu, Apr 15, 2010 at 12:47 PM, Scott Mead wrote: > On Thu, Apr 15, 2010 at 10:33 AM, suresh adapa wrote: > >> >> >> I am on Linux using postgresql-8.3.6-1PGDG >> >> >> >> Taking Dump using >> >> = >> >> export PGPASSWORD=suresha && pg_dump -b -c -C --format=c -h localhost -p >>

Re: [BUGS] Dump and Restore in postgresql-8.3.6-1PGDG

2010-04-15 Thread Scott Mead
On Thu, Apr 15, 2010 at 10:33 AM, suresh adapa wrote: > > > I am on Linux using postgresql-8.3.6-1PGDG > > > > Taking Dump using > > = > > export PGPASSWORD=suresha && pg_dump -b -c -C --format=c -h localhost -p > 5432 -U suresha -f /tmp/dump/db/suresha.sql suresha > > > > Trying

Re: [BUGS] BUG #5423: problems installing postgresql-8.4 deleted folder / .s.PGSQL.lock not initiate the connecti

2010-04-15 Thread Scott Mead
On Thu, Apr 15, 2010 at 6:35 PM, Geoffrey Pitman wrote: Offlist reply posted back to list. How did you perform your install? (I think you're running Ubuntu 9.10). > > Did you use the repositories, or did you build it from source? > > If you used the Ubuntu repositories, have you checked the Commu

Re: [BUGS] BUG #5424: Not able to Install

2010-04-15 Thread Craig Ringer
On 15/04/2010 10:14 PM, Aditya Vats wrote: The following bug has been logged online: Bug reference: 5424 Logged by: Aditya Vats Email address: aditya.v...@cerner.com PostgreSQL version: 8.4.2-1 Operating system: Windows Vista Description:Not able to Install Details:

Re: [BUGS] Reset ACL to default for pg 8.0

2010-04-15 Thread Bruce Momjian
Juan C. Aragon wrote: > Thanks Bruce for replying. > > The ACL is display in the PgAdmin tool for Windows on the properties for a > table or function. ACL is the Privileges. By default, when you create a new > function or table, the ACL is null. However, if you add some privileges, and > then remo

Re: [BUGS] BUG #5423: problems installing postgresql-8.4 deleted folder / .s.PGSQL.lock not initiate the connecti

2010-04-15 Thread Scott Mead
On Thu, Apr 15, 2010 at 6:35 PM, Geoffrey Pitman wrote: Off-list reply posted to list How did you perform your install? (I think you're running Ubuntu 9.10). > > Did you use the repositories, or did you build it from source? > > If you used the Ubuntu repositories, have you checked the Commun

Re: [BUGS] Reset ACL to default for pg 8.0

2010-04-15 Thread Tom Lane
Bruce Momjian writes: > Community, do we want to make a permission reset cause the column to > become null? That's not a permission reset. >> I just need to know if the brackets are normal when all the privileges are >> remove. Or how to reset the privileges (ACL) to default (null). > They are