[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 Postgr

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

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->tableSpa

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?

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

2008-02-01 Thread Andrew Gilligan
The following bug has been logged online: Bug reference: 3921 Logged by: Andrew Gilligan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: FreeBSD 4.11 Description:CREATE TABLE / INCLUDING INDEXES fails with permission denied Details: Hi a

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:

[BUGS] BUG #3920: sequence not generated for postgres using toplink jpa

2008-02-01 Thread Arun
The following bug has been logged online: Bug reference: 3920 Logged by: Arun Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Win XP Description:sequence not generated for postgres using toplink jpa Details: sequence not generated for post

[BUGS] BUG #3919: Service Privileges Bug

2008-02-01 Thread Sergey
The following bug has been logged online: Bug reference: 3919 Logged by: Sergey Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC2 Operating system: Windows 2003 SP2 Description:Service Privileges Bug Details: Postgre can't run under restricted user's accou