[Redirect] Simple CREATE TABLE in DBI::Pg?

Поиск
Список
Период
Сортировка
От Ken McGlothlen
Тема [Redirect] Simple CREATE TABLE in DBI::Pg?
Дата
Msg-id 199806171934.MAA06041@ralf.serv.net
обсуждение исходный текст
Список pgsql-interfaces
[I posted this to [GENERAL] on Sunday; scrappy@hub.org quite rightly pointed
out that it should go here.  Voila.]

Here's the program, in Perl; I've pared it down to the bare minimum:

    #!/usr/local/bin/perl

    use DBI;

    sub tbl_easy_init {
        local( $dbh ) = shift;
        local( $sth ) = $dbh->prepare( "create table tbl_easy (id int4)" );
        $sth->execute();
    }

    $dbh = DBI->connect( "dbi:Pg:dbname=booga", "", "",
                 { "PrintError" => 0, "AutoCommit" => 0 } );

    $rv = &tbl_easy_init( $dbh );

This program fails.  I've tried it with all global variables, tried a number of
different CREATE TABLE statements, and so on, and $rv always winds up being
equal to -1.  Yet, typing in the CREATE TABLE statement in psql works.

If the table is already created in psql, I can use all manner of select
statements in the above program skeleton, and it'll work.

So.  What am I doing wrong?

                            ---Ken

В списке pgsql-interfaces по дате отправления:

Предыдущее
От: "Jose' Soares Da Silva"
Дата:
Сообщение: Re: [INTERFACES] NEW ODBC DRIVER v.0245
Следующее
От: William Kearns MHLP-CSC
Дата:
Сообщение: ...