Re: [BUGS] attislocal value changed with the dump

2005-12-03 Thread Bruce Momjian
Is there a TODO here? --- Tom Lane wrote: > elein <[EMAIL PROTECTED]> writes: > > This is the repro with the sql file below. > > I looked into this, and the answer is you're doing it to yourself; > you shouldn't be explicit

Re: [BUGS] BUG #2092: No answer to bug reports 1975 and 2055

2005-12-03 Thread Dirk Pirschel
Hi Tom, * Tom Lane wrote on Sat, 03 Dec 2005 at 14:34 -0500: > Well, *something* in your link is trying to pull in OpenSSL. > > What exactly is in /client/lib ... could it be that there is an existing > SSL-dependent installation of libpq in there? In theory the link should > find the libpq in

Re: [BUGS] BUG #2092: No answer to bug reports 1975 and 2055

2005-12-03 Thread Dirk Pirschel
Hi Tom, * Tom Lane wrote on Sat, 03 Dec 2005 at 15:02 -0500: > looking at your command again, the -L/client/lib is in there twice: > [...] > Assuming there is a libpq in /client/lib, I bet this patch will help. $ cd postgresql-8.1.0 $ patch -i ~/patch src/Makefile.shlib $ ./configure --prefix=$

Re: [BUGS] BUG #2092: No answer to bug reports 1975 and 2055

2005-12-03 Thread Dirk Pirschel
Hi Tom, * Tom Lane wrote on Sat, 03 Dec 2005 at 13:11 -0500: > * Dirk Pirschel writes: > > > No answer to bug reports 1975 and 2055 yet. Are you going to fix these > > issues, or is AIX currently unsupportet? > > You seem to have a problem with missing SSL in the link, but I don't > see why that

Re: [BUGS] date overflows

2005-12-03 Thread Michael Fuhr
On Sat, Dec 03, 2005 at 07:53:23PM -0500, Kris Jurka wrote: > I'm seeing some date input overflows here. Yep, I noticed this a few days ago while looking at another problem. I probably should have started a new thread. http://archives.postgresql.org/pgsql-hackers/2005-11/msg01563.php -- Michael

[BUGS] date overflows

2005-12-03 Thread Kris Jurka
I'm seeing some date input overflows here. I tested on CVS HEAD without --enable-integer-datetimes and 7.4.9 and 8.0.4 with --enable-integer-datetimes, so it appears to have been around for a while: jurka=# select '23456-01-01'::date; date --- 5290466-07-05 (1 row) j

Re: [BUGS] BUG #2089: Documentation bug: Triggers in plpythonu

2005-12-03 Thread Alvaro Herrera
Jozef Behran wrote: > A trigger in plpythonu cannot use the `args' list to obtain the arguments > and does not return the row to be written into the database. Instead the > arguments are placed into a global dictionary called "TD". The row is in > TD["new"] as a dictionary keyed by the names of th

Re: [BUGS] BUG #2088: logfiles only readable by instance owner

2005-12-03 Thread Bruno Wolff III
On Fri, Dec 02, 2005 at 23:30:21 +0100, Dick Snippe <[EMAIL PROTECTED]> wrote: > > Using a log rotation program is possible (apache rotatelogs comes to mind), > but that would require starting postgresql with something like > postmaster | rotatelogs > and just hope that rotetelogs doesn't

Re: [BUGS] BUG #2092: No answer to bug reports 1975 and 2055

2005-12-03 Thread Tom Lane
I wrote: > What exactly is in /client/lib ... could it be that there is an existing > SSL-dependent installation of libpq in there? In theory the link should > find the libpq in ../../../../src/interfaces/libpq not the one in > /client/lib, but we've seen bizarre linker search behavior before ...

Re: [BUGS] BUG #2092: No answer to bug reports 1975 and 2055

2005-12-03 Thread Tom Lane
Dirk Pirschel <[EMAIL PROTECTED]> writes: >> for example, what configure arguments did you use? > Nothing relevant. > ./configure --prefix=$HOME/software --with-includes=/client/include > --with-libs=/client/lib > [...] > checking whether to build with OpenSSL support... no Well, *something* in

Re: [BUGS] BUG #2085: pg_dump incompletely dumps ACLs

2005-12-03 Thread Tom Lane
David J N Begley <[EMAIL PROTECTED]> writes: > I have verified that _no_ GRANT/REVOKE commands are dumped for the database, > and only some GRANT/REVOKE commands are dumped for "language" objects (see > below); The latter is not really a bug. Languages don't currently have owners (ie there is no

Re: [BUGS] BUG #2092: No answer to bug reports 1975 and 2055

2005-12-03 Thread Tom Lane
"" <[EMAIL PROTECTED]> writes: > No answer to bug reports 1975 and 2055 yet. Are you going to fix these > issues, or is AIX currently unsupportet? You seem to have a problem with missing SSL in the link, but I don't see why that should be; ecpg certainly tries to link to ssl. You'll need to dig i

Re: [BUGS] BUG #2091: ecpglib.h needs to be updated....

2005-12-03 Thread Tom Lane
"Chuck Wegrzyn" <[EMAIL PROTECTED]> writes: > There are a number of places in function prototypes of ECPGdo, ECPGprepare > and ECPGdeallocate where 'char *' should be changed to 'const char *'. This was already addressed: http://archives.postgresql.org/pgsql-committers/2005-12/msg8.php Do you

Re: [BUGS] BUG #2056: to_char no long takes time as input?

2005-12-03 Thread Bruce Momjian
Patch applied to HEAD and 8.1.X. --- Tom Lane wrote: > Bruce Momjian writes: > > I see your issue with HH/HH24, but I wanted this to work: > > > test=> select to_char('14 hours'::interval, 'HH'); > > to_char > >

Re: [BUGS] BUG #2091: ecpglib.h needs to be updated....

2005-12-03 Thread Bruce Momjian
This will be fixed when we release 8.1.1, which is planned for next week. Before then, you can grab from CVS using the 8.1 tag. --- Chuck Wegrzyn wrote: > > The following bug has been logged online: > > Bug reference:

Re: [BUGS] BUG #2088: logfiles only readable by instance owner

2005-12-03 Thread Dick Snippe
On Fri, Dec 02, 2005 at 12:59:17PM -0500, Bruce Momjian wrote: > Dick Snippe wrote: > > On Fri, Dec 02, 2005 at 12:30:17AM -0500, Tom Lane wrote: > > > > > "Dick Snippe" <[EMAIL PROTECTED]> writes: > > > > setting umask 077 makes sense for the data files, but not per se for the > > > > logfile. >

[BUGS] BUG #2092: No answer to bug reports 1975 and 2055

2005-12-03 Thread
The following bug has been logged online: Bug reference: 2092 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: ... Operating system: ... Description:No answer to bug reports 1975 and 2055 Details: No answer to bug reports 1975 and 2055 yet. Are you g

[BUGS] BUG #2091: ecpglib.h needs to be updated....

2005-12-03 Thread Chuck Wegrzyn
The following bug has been logged online: Bug reference: 2091 Logged by: Chuck Wegrzyn Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Linux Description:ecpglib.h needs to be updated Details: There are a number of places in function

Re: [BUGS] BUG #2088: logfiles only readable by instance owner

2005-12-03 Thread Dick Snippe
On Fri, Dec 02, 2005 at 02:11:06PM -0600, Jim C. Nasby wrote: > On Fri, Dec 02, 2005 at 12:59:17PM -0500, Bruce Momjian wrote: > > Dick Snippe wrote: > > > On Fri, Dec 02, 2005 at 12:30:17AM -0500, Tom Lane wrote: > > > > > > > "Dick Snippe" <[EMAIL PROTECTED]> writes: > > > > > setting umask 077