[BUGS] BUG #2123: join between stored procedures

The following bug has been logged online: Bug reference: 2123 Logged by: Konstantin S. Zhinko [tIT] Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: CentOS 3.5 Description:join between stored procedures Details: Hi all! I have a very big

[BUGS] BUG #2131: SQL Query Bug ?

The following bug has been logged online: Bug reference: 2131 Logged by: kenichi nakanishi Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.x Japanese Operating system: Windows 2000 Professional Japanese Description:SQL Query Bug ? Details: I found something

Re: [BUGS] BUG #2102: Backend reports wrong number of affected rows for a

Thanks for your response.   Let me see if I understand this correctly.  If the original query is an update and the instead rule replaces it with an update, then I should get a return status that is not zeros.  And if the original query was an update and the instead rule replaced it with something

[BUGS] BUG #2129: dblink problem

The following bug has been logged online: Bug reference: 2129 Logged by: Akio Iwaasa Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.10 Operating system: Redhat EL ES 3.0 Description:dblink problem Details: I'm very sorry for my poor English. "postgres" pr

[BUGS] BUG #2133: can't reinstall postgresql

The following bug has been logged online: Bug reference: 2133 Logged by: Guerra Antonio Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.1 Operating system: windows xp professional edition Description:can't reinstall postgresql Details: I installed postegres

[BUGS] BUG #2127: Regular Expression Limits Do Not Work

The following bug has been logged online: Bug reference: 2127 Logged by: Kyril Alyoshin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows XP Description:Regular Expression Limits Do Not Work Details: I am writing a regex to verify

Re: [BUGS] BUG #2118: could not connect to server

Tom Lane, I have read the email you mailed me. And I have SELinux enabled in permissive mode and the testlibpq program can run. I am very happy. In the future, I will use the PostgreSQL and give up the MySQL and other databases. I think the PostgreSQL is better than the others. Thank you ve

[BUGS] BUG #2126: Index usage for function value

The following bug has been logged online: Bug reference: 2126 Logged by: Grzegorz Tańczyk Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Slackware Description:Index usage for function value Details: SELECT * FROM table WHERE id = myfunct

[BUGS] BUG #2128: unable to install win32 version of pgsql 8.1.1

The following bug has been logged online: Bug reference: 2128 Logged by: venkat Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.1 Operating system: windows Xp service pack2 Description:unable to install win32 version of pgsql 8.1.1 Details: unable to instal

[BUGS] BUG #2124: Error "relation with OID ... does not exist" when using temporary table in function.

The following bug has been logged online: Bug reference: 2124 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.1-1 Operating system: Windows Description:Error "relation with OID ... does not exist" when using temporary table in function. Details:

[BUGS] BUG #2125: SELECT problem with strings containing \

The following bug has been logged online: Bug reference: 2125 Logged by: Tony Email address: [EMAIL PROTECTED] PostgreSQL version: 80100 Operating system: XP SP2 Description:SELECT problem with strings containing \ Details: Hi, Please refer to the DDL and data belo

[BUGS] BUG #2122: Inconsistent FK Error Messages

The following bug has been logged online: Bug reference: 2122 Logged by: David Wheeler Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Mac OS X 10.4.3 Description:Inconsistent FK Error Messages Details: I noticed that when I update or in

Re: [BUGS] BUG #2118: could not connect to server [From zhuge xiao <[EMAIL PROTECTED]>]

Tom Lane, I have read the email you mailed me yesterday. And I have SELinux enabled in permissive mode and the testlibpq program can run. I am very happy. In the future, I will use the PostgreSQL and give up the MySQL and other databases. I think the PostgreSQL is better than the others. Thank

Re: [BUGS] BUG #2123: join between stored procedures

"Konstantin S. Zhinko [tIT]" <[EMAIL PROTECTED]> writes: > SELECT b.* > FROM get_obj_list a > LEFT JOIN get_obj(a.id) b ON 1=1 > Error: relation "a" does not exists. This is not a bug. You cannot make use of values from one inside the definition of another . So the reference "a.id" is taken to

Re: [BUGS] BUG #2102: Backend reports wrong number of affected rows for a

[EMAIL PROTECTED] writes: > In my case we have an unconditional instead rule. The original query was an > update and the instead rule replaced it with an update of another table; an > update was replaced with an update. Then I should expect to see the status > of the last query that was insert

Re: [BUGS] BUG #2127: Regular Expression Limits Do Not Work

"Kyril Alyoshin" <[EMAIL PROTECTED]> writes: > IF (NEW.postal_code_name !~ '\\d{5}') > The bug description is: > If postal_code_name is > 5 digits, the expression would still evaluate to > false, and the error will not be raised. > Please correct this. Please learn how to use regular expression

Re: [BUGS] BUG #2126: Index usage for function value

"Grzegorz TaÅczyk" <[EMAIL PROTECTED]> writes: > SELECT * FROM table WHERE id = myfunction('x', 10); > There is an index created on id column, but query planner doesn't use it. Have you declared myfunction as IMMUTABLE or STABLE? If it's volatile then optimizing to an indexscan is incorrect and t

Re: [BUGS] BUG #2125: SELECT problem with strings containing \

"Tony" <[EMAIL PROTECTED]> writes: > When running a query such as: > select folder from public.folders > where lower(folder) like '%c:\\1%' > no rows are returned This is not a bug --- you've forgotten that backslash is an escape character in LIKE patterns. You can either double it again:

Re: [BUGS] BUG #2124: Error "relation with OID ... does not exist" when

See our FAQ about temporary tables: 4.19) Why do I get "relation with OID # does not exist" errors when accessing temporary tables in PL/PgSQL functions? --- [EMAIL PROTECTED] wrote: > > The follow

Re: [BUGS] BUG #2131: SQL Query Bug ?

On Mon, Dec 26, 2005 at 03:47:36PM +, kenichi nakanishi wrote: > I found something strange result when using a following sql sentence, > "select xxx || ' / ' || || ' / ' || as aaa from TABLE", > sometime I could get empty results. > When using same scentence on linux platform, I could

Re: [BUGS] BUG #2128: unable to install win32 version of pgsql 8.1.1

venkat wrote: > > The following bug has been logged online: > > Bug reference: 2128 > Logged by: venkat > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.1 > Operating system: windows Xp service pack2 > Description:unable to install win32 version of pgsql 8

Re: [BUGS] BUG #2129: dblink problem

We have significantly improved dblink since 7.4. Would you try 8.1 and see if you can reproduce the problem? --- Akio Iwaasa wrote: > > The following bug has been logged online: > > Bug reference: 2129 > Logged by: