• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Postgres 9.0 and bytea?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Postgres 9.0 and bytea?


  • Subject: Re: Postgres 9.0 and bytea?
  • From: Richard Palmer <email@hidden>
  • Date: Wed, 5 Jan 2011 22:41:14 -0600

I was using 9.0 with ERDatabaseAttachments, with pdfs  and png thumbnails.  All the attachments would be stored correctly and then sporadically, they all became corrupted simultaneously. The byte counts looked about right, but the columns were junk.
I reverted to File Attachments, and did not investigate further.

Richard Palmer

On Jan 5, 2011, at 6:09 PM, Anjo Krank wrote:

> Hi,
>
> is anyone here using PG with bytea columns?
>
> I just updated a test db from 8.3 to 9.0 and am getting errors on received data - rs.getBytes(col) returns the bytes (49) for the characters of my PKs, not the bytes.
>
> In the shell, it looks like this in 8.3:
>
> gaia=# select length(pk_id) from age_group limit 1;
> length
> --------
>     24
> (1 row)
>
> gaia=# select pk_id from age_group limit 1;
>                                        pk_id
> --------------------------------------------------------------------------------------
> \000\000\300\250\214\007\000\000\226\036\021\000\000\000\000\3678\363!\221\333m#\003
> (1 row)
>
> for 9.0 it's like:
>
> gaia=# select length(pk_id) from age_group limit 1;
> length
> --------
>     24
> (1 row)
>
> gaia=# select pk_id from age_group limit 1;
>                                        pk_id
> --------------------------------------------------------------------------------------
> \x0000c0a88c070000961e1100000000f738f32191db6d2303
> (1 row)
>
> Updating drivers to 9.0 didn't help so far, my guess is that there is a new setting. Is anyone familiar with PG and 9.0?
>
> Cheers, Anjo
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Postgres 9.0 and bytea?
      • From: Kieran Kelleher <email@hidden>
References: 
 >Postgres 9.0 and bytea? (From: Anjo Krank <email@hidden>)

  • Prev by Date: Re: Postgres 9.0 and bytea?
  • Next by Date: Re: A few newbie maven questions
  • Previous by thread: Re: Postgres 9.0 and bytea?
  • Next by thread: Re: Postgres 9.0 and bytea?
  • Index(es):
    • Date
    • Thread