Re: [BUGS] BUG #4047: case preserve for columns

2008-03-24 Thread Eugen.Konkov
if standard cause head acheing ignore standard You do so with UPPERCASE, so now you use all lowercased. This is good when you do thing simpler. But why you ignore asking of thousands people about case preserving? create table test ( "Id" integer ); SELECT "Id" as "ID" FROM test This cause BIG h

[BUGS] BUG #4051: ERROR: relation with OID xxxx does not exist

2008-03-24 Thread N Jagan Mohan Rao
The following bug has been logged online: Bug reference: 4051 Logged by: N Jagan Mohan Rao Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Window XP Description:ERROR: relation with OID does not exist Details: Here what i did: I am

Re: [BUGS] BUG #4051: ERROR: relation with OID xxxx does not exist

2008-03-24 Thread Pavan Deolasee
On Mon, Mar 24, 2008 at 5:50 PM, N Jagan Mohan Rao <[EMAIL PROTECTED]> wrote: > > I am using EntityManager, NativeQueries and deleting postgresql tables and > createing them dinamically(the schema is generated by using hybernate-tool). > till this point it is working fine .. and in the same tra

[BUGS] BUG #4052: GCC update -fwrapv and new -Wstrict-overflow

2008-03-24 Thread
The following bug has been logged online: Bug reference: 4052 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Linux Description:GCC update -fwrapv and new -Wstrict-overflow Details: http://www.airs.com/blog/archives/120 -Wst

Re: [BUGS] BUG #4052: GCC update -fwrapv and new -Wstrict-overflow

2008-03-24 Thread Tom Lane
"" <[EMAIL PROTECTED]> writes: > Description:GCC update -fwrapv and new -Wstrict-overflow I am not sure what your point is? regards, tom lane - Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql

[BUGS] BUG #4053: libpq documentation should express clearly, that integers are passed in network octet order

2008-03-24 Thread Aleksej Saushev
The following bug has been logged online: Bug reference: 4053 Logged by: Aleksej Saushev Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: NetBSD, but this does no matter Description:libpq documentation should express clearly, that integers ar

[BUGS] BUG #4054: Text containing ';' upsets db restores

2008-03-24 Thread Martin Gregorie
The following bug has been logged online: Bug reference: 4054 Logged by: Martin Gregorie Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: Linux (Redhat Fedora 8 Description:Text containing ';' upsets db restores Details: I've been dumping

Re: [BUGS] BUG #4054: Text containing ';' upsets db restores

2008-03-24 Thread Tom Lane
"Martin Gregorie" <[EMAIL PROTECTED]> writes: > The errors were captured in the log file, which is safe from being > overwritten. You're welcome to either the whole thing or to edited > highlights from it. That's probably fairly useless, but if you have the dump file it would be interesting to loo

[BUGS] BUG #4055: Using Like in PostgreSQL 8.2.7 and 8.3.1

2008-03-24 Thread Hugo Rafael Lesme Marquez
The following bug has been logged online: Bug reference: 4055 Logged by: Hugo Rafael Lesme Marquez Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.7 and 8.3.1 Operating system: Windows 2003 Server SP2 Description:Using Like in PostgreSQL 8.2.7 and 8.3.1 Detai

Re: [BUGS] BUG #4055: Using Like in PostgreSQL 8.2.7 and 8.3.1

2008-03-24 Thread Alvaro Herrera
Hugo Rafael Lesme Marquez wrote: > ERROR: operator does not exist: bigint ~~ unknown > SQL state: 42883 > Dica: No operator matches the given name and argument type(s). You might > need to add explicit type casts. > Caracter: 47 > > What can I do to resolve? Change the LIKE to = (equal sign). -

Re: [BUGS] BUG #3645: regular expression back references seem broken

2008-03-24 Thread Bruce Momjian
Added to TODO: * Fix regular expression bug when using complex back-references http://archives.postgresql.org/pgsql-bugs/2007-10/msg0.php --- Eric Haszlakiewicz wrote: > > The following bug has been logged online:

Re: [BUGS] BUG #3692: Conflicting create table statements throw unexpected error

2008-03-24 Thread Bruce Momjian
Added to TODO: o Prevent concurrent CREATE TABLE table1 from sometimes returning a cryptic error message http://archives.postgresql.org/pgsql-bugs/2007-10/msg00169.php --- Bill Moran wrote: >

Re: [BUGS] BUG #3855: backend sends corrupted data onEHOSTDOWNerror

2008-03-24 Thread Bruce Momjian
Email removed from patch queue --- Tom indicates this is an operating system bug. Perhaps if we get more bug reports we will have to address it. --- Scot Loach wrote: > Yes that is what I am trying to explain. > So I think

Re: [BUGS] BUG #3883: Autovacuum deadlock with truncate?

2008-03-24 Thread Bruce Momjian
Added to TODO: * Detect deadlocks involving LockBufferForCleanup() http://archives.postgresql.org/pgsql-hackers/2008-01/msg00873.php --- Steven Flatt wrote: > On Jan 18, 2008 10:58 AM, Tom Lane <[EMAIL PROTECTED]> wrote

Re: [BUGS] why provide cross type arithmetic operators

2008-03-24 Thread Bruce Momjian
Added to TODO: * Add more cross-data-type operators http://archives.postgresql.org/pgsql-bugs/2008-01/msg00189.php --- ykhuang wrote: > there are many cross type arithmetic operators, like int2 + int4, int8 + > int4, I

Re: [BUGS] why provide cross type arithmetic operators

2008-03-24 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Added to TODO: > * Add more cross-data-type operators > http://archives.postgresql.org/pgsql-bugs/2008-01/msg00189.php Uh ... that is exactly 180 degrees away from the point of the thread. regards, tom lane -- Sent via pgsql-

[BUGS] BUG #4056: problem creating function with domain argument

2008-03-24 Thread eric melbardis
The following bug has been logged online: Bug reference: 4056 Logged by: eric melbardis Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: windows xp sp 2 Description:problem creating function with domain argument Details: hi when i execute

Re: [BUGS] BUG #4056: problem creating function with domain argument

2008-03-24 Thread Tom Lane
"eric melbardis" <[EMAIL PROTECTED]> writes: > Description:problem creating function with domain argument AFAICT this example works fine in psql. You need to take it up on the pgAdmin mailing list. It looks to me like pgAdmin is mistakenly thinking that a domain has type modifiers.