Re: [BUGS] BUG #2898: dynamic load support

2007-01-16 Thread Tom Lane
"Pankaj" <[EMAIL PROTECTED]> writes: > creating conversionsFATAL: dynamic load not supported > STATEMENT: CREATE OR REPLACE FUNCTION... > Please let us know the cause of the above error. The encoding conversion code is all in dynamically-loaded libraries. (There are some other thi

Re: [BUGS] BUG #2848: information_schema.key_column_usage does not work

2007-01-16 Thread Laurence Rowe
I see the same problem with 8.2 on linux. Laurence Tony Marston wrote: The following bug has been logged online: Bug reference: 2848 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:information

[BUGS] BUG #2895: Private Use Unicode character crashes server when using ILIKE

2007-01-16 Thread James Russell
The following bug has been logged online: Bug reference: 2895 Logged by: James Russell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Linux (Fedora Core 5) Description:Private Use Unicode character crashes server when using ILIKE Details:

[BUGS] BUG #2899: psql-odbc logging does not work for ordinary users

2007-01-16 Thread Peter Hardman
The following bug has been logged online: Bug reference: 2899 Logged by: Peter Hardman Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows XP Pro Description:psql-odbc logging does not work for ordinary users Details: Checking MyLog on

[BUGS] BUG #2896: Dynamic loading

2007-01-16 Thread Pankaj Srinivasan
The following bug has been logged online: Bug reference: 2896 Logged by: Pankaj Srinivasan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.0 Operating system: LynxOS Description:Dynamic loading Details: I have been able to install PostgresSQL 8.2.0 on LynxO

[BUGS] BUG #2901: missing alter table online help in psql

2007-01-16 Thread Jens-Wolfhard Schicke
The following bug has been logged online: Bug reference: 2901 Logged by: Jens-Wolfhard Schicke Email address: [EMAIL PROTECTED] PostgreSQL version: PostgreSQL 8.2 Operating system: Linux Description:missing alter table online help in psql Details: \h alter table is

Re: [BUGS] BUG #2901: missing alter table online help in psql

2007-01-16 Thread Tom Lane
"Jens-Wolfhard Schicke" <[EMAIL PROTECTED]> writes: > \h alter table > is missing the syntax for the command > alter table the_table alter column the_column type varchar(175); Maybe you're using an old psql? My 8.2 psql shows regression=> \h alter table Command: ALTER TABLE Description: chan

Re: [BUGS] BUG #2848: information_schema.key_column_usage does not work

2007-01-16 Thread Tom Lane
Laurence Rowe <[EMAIL PROTECTED]> writes: >> I have the following query: >> >> SELECT key_column_usage.*,constraint_type >> FROM information_schema.key_column_usage >> LEFT JOIN information_schema.table_constraints USING >> (table_schema,table_name,constraint_name) >> WHERE table_schema='whatev

Re: [BUGS] BUG #2898: dynamic load support

2007-01-16 Thread Bruce Momjian
Pankaj wrote: > > The following bug has been logged online: > > Bug reference: 2898 > Logged by: Pankaj > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.0 > Operating system: LynxOS > Description:dynamic load support > Details: > > I have installed Postg

Re: [BUGS] BUG #2895: Private Use Unicode character crashes server when using ILIKE

2007-01-16 Thread Michael Fuhr
On Tue, Jan 16, 2007 at 06:16:22AM +, James Russell wrote: > Description: Private Use Unicode character crashes server when using ILIKE The archives show that ILIKE is known to be broken with multibyte characters in 8.1 and earlier, although I don't recall seeing reports of a crash resulting.