Re: [BUGS] BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

2008-02-01 Thread Adam Hardy
I think my message below didn't get through, according to error notifications from [EMAIL PROTECTED] Hopefully this will be successful. See copy below. Kris Jurka on 23/01/08 08:51, wrote: On Tue, 22 Jan 2008, Adam Hardy wrote: The following bug has been logged online: Bug reference:

Re: [BUGS] BUG #3894: JDBC DatabaseMetaData.getTables is inconsistently case-sensitive with schema name

2008-02-01 Thread Kris Jurka
On Fri, 1 Feb 2008, Adam Hardy wrote: it seems to me from what you just said that PostgreSQL server and JDBC driver require the schema name to be lower case deliberately, and that any given name that is not all lower case is converted to lower case by the server or the driver. Am I correct?

Re: [BUGS] BUG #3921: CREATE TABLE / INCLUDING INDEXES fails with permission denied

2008-02-01 Thread Tom Lane
Andrew Gilligan [EMAIL PROTECTED] writes: test= CREATE TABLE t2 (LIKE t1 INCLUDING INDEXES); ERROR: permission denied for tablespace pg_default How annoying :-(. We could work around this particular manifestation with a patch to make generateClonedIndexStmt() not set index-tableSpace if

Re: [BUGS] BUG #3921: CREATE TABLE / INCLUDING INDEXES fails with permission denied

2008-02-01 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: 1. DefineIndex() treats an omitted tablespace clause differently from explicitly specifying the tablespace that is the database's default: if you explicitly specify the space then you must have permissions on it, otherwise you don't need any. (This is the

[BUGS] BUG #3922: Problems migrating databases.

2008-02-01 Thread Maximiliano
The following bug has been logged online: Bug reference: 3922 Logged by: Maximiliano Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: Debian 8.2 Description:Problems migrating databases. Details: I being working with RedHat 7.3 and