From: | Fandarel <fandarel(at)mail(dot)solisys(dot)com> |
---|---|
To: | <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Tables with oid |
Date: | 1998-07-16 18:47:54 |
Message-ID: | 199807161848.OAA25102@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm having some trouble using tables with oids:
I created a table using the following command:
CREATE TABLE registry_blob_t (
registry_key varchar(1024) NOT NULL,
registry_value oid NOT NULL
);
I then tried to insert a value to it using the DBD::Pg interface for perl:
$dbh->do("INSERT INTO registry_blob_t (registry_key, registry_value)
VALUES (user.bob.name.middle, lo_import('/path/file_name') )");
where /path is the path to the file and /file_name is the name of the
file with my data to insert.
I got back this error:
"ERROR: user: Table does not exist."
I tried changing "registry_key" to "thing" to see what happened and I got:
"ERROR: Relation registry_blob_t does not have attribute thing"
so, it can find the table when the sql statement is wrong.
I checked the example for blobs that came with DBD::Pg and used all of
the same code except where the example had an id field of int4 I created
one with varchar(1024). I got the same error so I tried changing the id
field to int4 and it worked.
Can a table with oids deal with varchar(x)'s or can I just not reference
values to keys of type varchar(x)?
At this point, I'll have to do a workaround with an extra table
referencing my varchar(x) key to the int4 key that the table seems to
need.
Thanks,
Matt Vanderpol
From | Date | Subject | |
---|---|---|---|
Next Message | Fandarel | 1998-07-16 18:50:39 | Re: [GENERAL] listing all tables |
Previous Message | Gene Selkov, Jr. | 1998-07-16 18:47:33 | Re: [GENERAL] listing all tables |