neh...@gmail.com writes:
> [ test_bug_type is composite ]
> $$DECLARE
> test_bug_var test_bug_type;
> BEGIN
> SELECT test_field INTO test_bug_var FROM test_bug_table LIMIT 1;
> --ERROR: invalid input syntax for type numeric: "(15.50,USD)"
> --CONTEXT: PL/pgSQL function "inline_code_bl
On Tue, Mar 20, 2012 at 2:48 PM, Tom Lane wrote:
>> I think Tom's correct about what the right behavior would be if
>> composite types supported defaults, but they don't, never have, and
>> maybe never will. I had a previous argument about this with Tom, and
>> lost, though I am not sure that any
On Mon, Mar 19, 2012 at 14:40, Alvaro Herrera
wrote:
>
> Excerpts from Alex Hunsaker's message of mié mar 07 01:08:25 -0300 2012:
>> The attached fixes it for me, It would be great if you could confirm that.
>
> Thanks -- applied to 9.1 and master.
Thanks!
--
Sent via pgsql-bugs mailing list (
neeraj.punm...@securetogether.com writes:
> First database session:
> ---
> Lock table Test;
> Second database session
> ---
> Select y from Test where x=1 for update nowait;
> select query waits until first session releases table lock.
This isn't a b
wrote:
> Create Table Test (x integer,y integer);
>
> Insert Into Test Values(1,100);
> Insert Into Test Values(2,200);
>
> First database session:
> ---
> start transaction;
> Lock table Test;
>
> Second database session
> ---
> start transaction;
The following bug has been logged on the website:
Bug reference: 6548
Logged by: Neeraj Punmiya
Email address: neeraj.punm...@securetogether.com
PostgreSQL version: 9.1.3
Operating system: CentOS 6.2 , Windows 7
Description:
Steps to simulate problem
=