BUG #13880: Different procedures in same SQL

From: victor(dot)evangelista(at)caixa(dot)gov(dot)br
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13880: Different procedures in same SQL
Date: 2016-01-21 16:53:10
Message-ID: 20160121165310.2736.59053@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13880
Logged by: Victor Neves
Email address: victor(dot)evangelista(at)caixa(dot)gov(dot)br
PostgreSQL version: 9.1.9
Operating system: RedHat 4.4.7 x64
Description:

I found a different procedures in same SQL, in postgres 9.1.9.

I create a table, but i dont insert any data, after execute

insert into <table> (namecolum1, namecolum2, namecolum3, namecolum4)
select distinct 'value1', 'value2', 'value3', 'value4'
from <table> where not exists (select 1 from <table> sis where
sis.namecolum2='value2' )

Postgres says: "Query returned successfully: 0 rows affected, 1 ms execution
time."

But if I insert any data in the table and execute the SQL again, the insert
works fine!

If I truncate the table and execute de SQL, postgres says "0 rows affected"
again.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-01-22 04:22:48 Re: BUG #13879: include_dir directive not working
Previous Message Dang Minh Huong 2016-01-21 11:05:37 Re: Window2012R2: initdb error: "The current directory is invalid."