Re: 8.3.0 backend segfaults

From: "Alex Hunsaker" <badalex(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 8.3.0 backend segfaults
Date: 2008-03-12 20:00:57
Message-ID: 34d269d40803121300o3c8347dfm3dae9555b262d529@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

err that should be (forgot the username, password placeholders)

> my $db = DBI->connect('dbi:Pg:dbname=test;', '', '', {'pg_server_prepare'=>1, 'pg_prepare_now'=>1}) || die "could not connect: $!";
> $db->do('create table junk (junk text, junk_id int);');
> $db->do('create sequence junk_seq;');
> $db->do("create or replace function junk_func(int) returns integer as
> 'select junk_id from junk where junk_id = \$1;' language 'sql' stable
> strict;");
>
> my $sth = $db->prepare('select * from junk where junk = ? and junk_id
> = junk_func(1) limit 1;');
>
> $db->do('vacuum junk;');
> $db->begin_work();
>
> $db->do('select nextval(\'junk_seq\');');
>
> $sth->execute('test') || die "failed: $!";
> $sth->fetchall_arrayref();
>
> $db->disconnect();
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alex Hunsaker 2008-03-12 20:09:42 Re: 8.3.0 backend segfaults
Previous Message Alex Hunsaker 2008-03-12 19:59:42 Re: 8.3.0 backend segfaults