Re: [BUGS] The column index is out of range in PostgreSQL + resolve

On Mon, 31 Jul 2006, Murali Doss wrote: SQL Query is running perfect from PG Admin but it gives error "The column index is out of range " when running through java application.Please advise me how to solve this issue. This error message has nothing to do with the query execution, but rather

Re: [BUGS] BUG #2559: why jdbc-driver AbstractJdbc2ResultSetMetaData.

On Tue, 1 Aug 2006, flash.xu wrote: Bug reference: 2559 PostgreSQL version: 8.1.4 Description:why jdbc-driver AbstractJdbc2ResultSetMetaData. getTableName(int column) return "" Details: I'm using jdbc3 8.1 to build my java project.But when I use ResultSetMetaData class to get ta

Re: [BUGS] referential integrity violation - key referenced from

On Fri, 4 Aug 2006, Luiz Henrique wrote: > Hi, could you tell me how postgresql look for a referenced key? It looks in > table index? Maybe only the index is corrupted? It basically runs a query like: SELECT * FROM parenttable WHERE keycol1 = ? [AND keycol2 = ? ...] FOR SHARE It should act lik

Re: [BUGS] Restoring 7.4 "pg_dumpall -o" output in 8.1 fails

[EMAIL PROTECTED] (Andreas Gustafsson) writes: > I recently attempted to upgrade a PostgreSQL 7.4 installation to 8.1 by > following the instructions at > , > having used "pg_dumpall -o" to dump the data in 7.4. When I tried to

Re: [BUGS] referential integrity violation - key referenced from

Hi, could you tell me how postgresql look for a referenced key? It looks in table index? Maybe only the index is corrupted?Thanks!On 8/2/06, Stephan Szabo <[EMAIL PROTECTED]> wrote: On Wed, 2 Aug 2006, Luiz Henrique wrote:> Hi,>> I'm running Postgresql 7.3 in Debian Woody OS.>> After some time wor

[BUGS] Restoring 7.4 "pg_dumpall -o" output in 8.1 fails

I recently attempted to upgrade a PostgreSQL 7.4 installation to 8.1 by following the instructions at , having used "pg_dumpall -o" to dump the data in 7.4. When I tried to restore the data in 8.1, psql reported a large number

[BUGS] BUG #2562: In rules: recalculation of input expression on each access

The following bug has been logged online: Bug reference: 2562 Logged by: IvankoB Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Linux ( Debia 3.1) Description:In rules: recalculation of input expression on each access Details: For a tes

[BUGS] BUG #2563: In rules: recalculation of input expression on each access

The following bug has been logged online: Bug reference: 2563 Logged by: ivankob Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Linux Description:In rules: recalculation of input expression on each access Details: For a testcase like :

Re: [BUGS] Patch to allow C extension modules to initialize/finish

On Thu, Aug 03, 2006, [EMAIL PROTECTED] wrote: > On Wed, Aug 02, 2006 at 09:04:11PM +0200, Ralf S. Engelschall wrote: > > PostgreSQL provides a way to load C extension modules with its internal > > FMGR. Unfortunately there is no portable way for an extension module to > > initialize (directly aft

[BUGS] Fwd: Strange behaviour of RULE (selecting last inserted ID of 'sequenced' column)

I still think that this is quite strange behaviour. When I write '...SELECT NEW.id...' I don't expect that another calling of column's default expr will take place. I just want to have access to "id" column of just-created row. Any thoughts? -- Forwarded message -- From: Nikolay