Re: [BUGS] BUG #3116: attribute has wrong type

2007-03-06 Thread Tom Lane
I wrote: > "Greg Sabino Mullane" <[EMAIL PROTECTED]> writes: >> CREATE OR REPLACE FUNCTION gregtest(int) RETURNS varchar >> LANGUAGE sql AS $$ SELECT 'abc'::text; $$; > Hm, I'd argue that that should be rejected. SQL functions currently > demand exact match between the declared return type and th

Re: [BUGS] BUG #3116: attribute has wrong type

2007-03-06 Thread Tom Lane
"Greg Sabino Mullane" <[EMAIL PROTECTED]> writes: > CREATE OR REPLACE FUNCTION gregtest(int) RETURNS varchar > LANGUAGE sql AS $$ SELECT 'abc'::text; $$; Hm, I'd argue that that should be rejected. SQL functions currently demand exact match between the declared return type and their final SELECT

[BUGS] BUG #3116: attribute has wrong type

2007-03-06 Thread Greg Sabino Mullane
The following bug has been logged online: Bug reference: 3116 Logged by: Greg Sabino Mullane Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.8 Operating system: Linux Description:attribute has wrong type Details: Reproduced on 8.2.3, 8.1.8, and CVS HEAD: C

Re: [BUGS] BUG #3115: backend died abnormally HELP!!

2007-03-06 Thread Heikki Linnakangas
Bryan O'Neill wrote: PostgreSQL version: 7.2.3 That's a very old and unsupported version. You should upgrade, regardless of this problem. Operating system: Redhat 8.0 Description:backend died abnormally HELP!! Details: On 3/4/07, I received the following message from the subje

Re: [BUGS] BUG #3113: pg_restore --use-list=FILENAME

2007-03-06 Thread Tom Lane
"Jarrod Chesney" <[EMAIL PROTECTED]> writes: > The "-L, --use-list=FILENAME use specified table of contents for ordering" > flag does nothing in pg_restore in linux. Fairly hard to believe. Please provide a reproducible example... regards, tom lane -

Re: [BUGS] BUG #3110: Online Backup introduces Duplicate OIDs

2007-03-06 Thread Tom Lane
"Randy Isbell" <[EMAIL PROTECTED]> writes: > When restoring the output of an online backup, many tables now have > duplicate OID values / primary keys, viz: > ... > sn=# reindex table at_dns; > ERROR: could not create unique index I'm confused. You're claiming that the reload succeeds, but after

Re: [BUGS] BUG #3106: A problem with escaping table name pattern for DatabaseMetaData.getColumns()

2007-03-06 Thread Kris Jurka
On Sun, 4 Mar 2007, Valery Meshkov wrote: The following bug has been logged online: Bug reference: 3106 PostgreSQL version: 8.2.3 Description:A problem with escaping table name pattern for DatabaseMetaData.getColumns() Details: I am seeing a problem in the JDBC driver postgresql

[BUGS] Problem with insert

2007-03-06 Thread Steven Lambert
Hello,We have a Postgresql 8.1.8 and a problem, probably no bug.But we must go in production tomorrow and we don't know where to look to solve this. Therefore I hope somebody can help us.The problem is when we insert with a function, we get the message SQLSTATE = 25P02Error while executing the quer

[BUGS] BUG #3115: backend died abnormally HELP!!

2007-03-06 Thread Bryan O'Neill
The following bug has been logged online: Bug reference: 3115 Logged by: Bryan O'Neill Email address: [EMAIL PROTECTED] PostgreSQL version: 7.2.3 Operating system: Redhat 8.0 Description:backend died abnormally HELP!! Details: On 3/4/07, I received the following me

[BUGS] BUG #3106: A problem with escaping table name pattern for DatabaseMetaData.getColumns()

2007-03-06 Thread Valery Meshkov
The following bug has been logged online: Bug reference: 3106 Logged by: Valery Meshkov Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows Description:A problem with escaping table name pattern for DatabaseMetaData.getColumns() Detail

[BUGS] BUG #3113: pg_restore --use-list=FILENAME

2007-03-06 Thread Jarrod Chesney
The following bug has been logged online: Bug reference: 3113 Logged by: Jarrod Chesney Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Linux 2.6.17.10 Ubuntu (Edgy Edge) Description:pg_restore --use-list=FILENAME Details: In pg_restore.

[BUGS] BUG #3111: PostgreSQL Driver is compatible with Win2003 Server 64 bits?

2007-03-06 Thread Bruno
The following bug has been logged online: Bug reference: 3111 Logged by: Bruno Email address: [EMAIL PROTECTED] PostgreSQL version: v8.2.3 Operating system: Win2003 Server 64bits Description:PostgreSQL Driver is compatible with Win2003 Server 64 bits? Details: Hello

[BUGS] BUG #3110: Online Backup introduces Duplicate OIDs

2007-03-06 Thread Randy Isbell
The following bug has been logged online: Bug reference: 3110 Logged by: Randy Isbell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: FreeBSD 6.1 i386 Description:Online Backup introduces Duplicate OIDs Details: This issue is observed in

Re: [BUGS] BUG #3098: make check failed 33 times

2007-03-06 Thread Heikki Linnakangas
Theodore Petrosky wrote: I tried to upload to the list but I think the file got lost...I am attaching it here. A-ha, this is the problem: ! psql: FATAL: sorry, too many clients already I'm guessing this is the same issue as here: http://archives.postgresql.org/pgsql-hackers/2006-08/msg01821.