Обсуждение: Version of driver for 7.3 postgresql

I've just upgraded our database from 7.2.3 to 7.3.2.  When running the older
7.2.3, I was actually using a 7.3 JDBC driver because there were some
problems with large objects as it relates to performance and I had patched
my copy and I'm pretty sure my patches were then incorporated into the
mainline.

Will the JDBC driver that comes with 7.3.2 be the "latest greatest" for use
with 7.3.2, or should I be looking at downloading the latest 7.3 build 109
from jdbc.postgresql.org?

Thanks,
David

---------------------------------------------
David A. E. Wall
Chief Software Architect
Yozons, Inc.
Tel 425.822.4465    david.wall@yozons.com
Fax 425.827.9415    www.yozons.com

Signed & Secured - Secure document delivery and electronic signatures

David,

The version on the website (build 109) has bug fixes post 7.3.2.  So it
is the "latest greatest" version available for 7.3.

--Barry

David Wall wrote:
> I've just upgraded our database from 7.2.3 to 7.3.2.  When running the older
> 7.2.3, I was actually using a 7.3 JDBC driver because there were some
> problems with large objects as it relates to performance and I had patched
> my copy and I'm pretty sure my patches were then incorporated into the
> mainline.
>
> Will the JDBC driver that comes with 7.3.2 be the "latest greatest" for use
> with 7.3.2, or should I be looking at downloading the latest 7.3 build 109
> from jdbc.postgresql.org?
>
> Thanks,
> David
>
> ---------------------------------------------
> David A. E. Wall
> Chief Software Architect
> Yozons, Inc.
> Tel 425.822.4465    david.wall@yozons.com
> Fax 425.827.9415    www.yozons.com
>
> Signed & Secured - Secure document delivery and electronic signatures
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

What is the correct syntax to create a table with an array of bytes?

I tried
CREATE TABLE tablename (bytearrayname TINYINT[] );

but that doesn't work.

Also, what is the correct getXXX method to access stored array from a
row in a ResultSet?

Thanks

Charlie

I think the datatype bytea is what you are looking for.  And getBytes()
is the method you are looking for.

--Barry

Charlie Kelly wrote:
> What is the correct syntax to create a table with an array of bytes?
>
> I tried
> CREATE TABLE tablename (bytearrayname TINYINT[] );
>
> but that doesn't work.
>
> Also, what is the correct getXXX method to access stored array from a
> row in a ResultSet?
>
> Thanks
>
> Charlie
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>