[BUGS] BUG #1095: make can't find plperl

2004-03-10 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1095 Logged by: Costin Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Slackware Linux 9.1 Description:make can't find plperl Details: I am trying to configure PostgreSQL 7.4.

Re: [BUGS] not necessarily a bug...

2004-03-10 Thread Richard Huxton
On Tuesday 09 March 2004 22:17, Theodore Petrosky wrote: > recently I was playing around with psql and tried to > log onto a postgresql server so I tried... > > psql -h 10.0.1.233 dbname > is this correct behaviour? I was expecting to be > challenged. Host-based access is controlled via the pg_hb

Re: [BUGS] not necessarily a bug...

2004-03-10 Thread Alex J. Avriette
On Tue, Mar 09, 2004 at 02:17:23PM -0800, Theodore Petrosky wrote: > and to my suprise, i was in and able to issue > commands. what is 'bothering' me is that I was not > asked for a password. in defence of the system, I was > on a mac os x box logged in as 'postgres' so my > current name was postg

Re: [BUGS] BUG #1095: make can't find plperl

2004-03-10 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > I am trying to configure PostgreSQL 7.4.2 with Perl 5.8.3 or 5.9.0. I > compiled both versions of Perl, with shared libraries and with no shared > libraries. Then I 'configure'd postgres with '--with-perl' with no error. > Every time I run

[BUGS] Glitch: cannot use Arrays with Raise Notice

2004-03-10 Thread Josh Berkus
Bug: Cannot Use Arrays with Raise Notice in PL/pgSQL. Version Tested: 7.4.1 Severity: Annoyance Description: Attempting to pass an array element to Raise Notice in PL/pgSQL will produce a parse error: CREATE OR REPLACE FUNCTION if_exec_to_text ( TEXT, TEXT[], TEXT[] ) RETURNS text AS

[BUGS] BUG #1096: pg_restore cannot restore large objects with other oid columns

2004-03-10 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1096 Logged by: Janko Richter Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux Description:pg_restore cannot restore large objects with other oid columns Details: I'm usi

[BUGS] BUG #1097: Make failure

2004-03-10 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1097 Logged by: Stewart McKenna Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Debian 'woody3' on Ultra Sparc Description:Make failure Details: Trying to 'make' the postgreSQL

Re: [BUGS] BUG #1097: Make failure

2004-03-10 Thread Bruce Momjian
I have never seen that before. Looks like there is a mix of 64-bit and 32-bit object files. Not sure on the cause. --- PostgreSQL Bugs List wrote: > > The following bug has been logged online: > > Bug reference: 109

Re: [BUGS] BUG #1097: Make failure

2004-03-10 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > /usr/bin/ld -r -o SUBSYS.o heaptuple.o indextuple.o indexvalid.o printtup.o > scankey.o tupdesc.o > /usr/bin/ld: Relocatable linking with relocations from format elf64-sparc > (heaptuple.o) to format elf32-sparc (SUBSYS.o) is not supp > orted

Re: [BUGS] BUG #1096: pg_restore cannot restore large objects with other oid columns

2004-03-10 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > When I restore the dumped database, pg_restore tries to restore the > functions of tsearch2 as a large object. It does what? I don't think you're describing this accurately. Please show the actual problem and not your interpretation of it.

Re: [BUGS] BUG #1097: Make failure

2004-03-10 Thread Peter Eisentraut
PostgreSQL Bugs List wrote: > /usr/bin/ld -r -o SUBSYS.o heaptuple.o indextuple.o indexvalid.o > printtup.o scankey.o tupdesc.o > /usr/bin/ld: Relocatable linking with relocations from format > elf64-sparc (heaptuple.o) to format elf32-sparc (SUBSYS.o) is not > supported You need to run $ sparc32