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();
>
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 |