You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@empire-db.apache.org by Frank Lupo <fr...@email.it> on 2009/03/26 17:49:28 UTC
Postgresql BLOB
In Postgrql "BLOB" type not exist but is possible to create a "bytea"
column.
in DBDatabaseDriverPostgreSQL.java
case BLOB:
sql.append("BLOB");
if (c.getSize() > 0)
sql.append(" (" + String.valueOf((long) c.getSize())
+ ") ");
break;
change in
case BLOB:
sql.append("bytea");
break;
http://www.postgresql.org/docs/8.3/static/datatype.html
http://jdbc.postgresql.org/documentation/80/binary-data.html
Best Regards
--
Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f
Sponsor:
Con Poker Club anche a Marzo il montepremi è garantito: ogni lunedì, giovedì e domenica vinci fino a 25.000!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8801&d=26-3
Re: Postgresql BLOB
Posted by Francis De Brabandere <fr...@gmail.com>.
and fixed
On Fri, Mar 27, 2009 at 10:05 AM, Francis De Brabandere
<fr...@gmail.com> wrote:
> I created an issue
>
> https://issues.apache.org/jira/browse/EMPIREDB-37
>
>
> On Thu, Mar 26, 2009 at 5:52 PM, Francis De Brabandere
> <fr...@gmail.com> wrote:
>> And even better would be that you create a jira issue...
>>
>> https://issues.apache.org/jira/browse/EMPIREDB
>>
>> On Thu, Mar 26, 2009 at 5:51 PM, Francis De Brabandere
>> <fr...@gmail.com> wrote:
>>> Thanks for reporting!
>>>
>>> I'll take care of this this evening.
>>>
>>> On Thu, Mar 26, 2009 at 5:49 PM, Frank Lupo <fr...@email.it> wrote:
>>>> In Postgrql "BLOB" type not exist but is possible to create a "bytea"
>>>> column.
>>>>
>>>> in DBDatabaseDriverPostgreSQL.java
>>>> case BLOB:
>>>> sql.append("BLOB");
>>>> if (c.getSize() > 0)
>>>> sql.append(" (" + String.valueOf((long) c.getSize()) + ")
>>>> ");
>>>> break;
>>>>
>>>> change in
>>>> case BLOB:
>>>> sql.append("bytea");
>>>> break;
>>>>
>>>>
>>>> http://www.postgresql.org/docs/8.3/static/datatype.html
>>>> http://jdbc.postgresql.org/documentation/80/binary-data.html
>>>>
>>>> Best Regards
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP
>>>> autenticato? GRATIS solo con Email.it http://www.email.it/f
>>>>
>>>> Sponsor:
>>>> Con Poker Club anche a Marzo il montepremi è garantito: ogni lunedì, giovedì
>>>> e domenica vinci fino a 25.000 !
>>>> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8801&d=26-3
>>>>
>>>
>>>
>>>
>>> --
>>> http://www.somatik.be
>>> Microsoft gives you windows, Linux gives you the whole house.
>>>
>>
>>
>>
>> --
>> http://www.somatik.be
>> Microsoft gives you windows, Linux gives you the whole house.
>>
>
>
>
> --
> http://www.somatik.be
> Microsoft gives you windows, Linux gives you the whole house.
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.
Re: Postgresql BLOB
Posted by Francis De Brabandere <fr...@gmail.com>.
I created an issue
https://issues.apache.org/jira/browse/EMPIREDB-37
On Thu, Mar 26, 2009 at 5:52 PM, Francis De Brabandere
<fr...@gmail.com> wrote:
> And even better would be that you create a jira issue...
>
> https://issues.apache.org/jira/browse/EMPIREDB
>
> On Thu, Mar 26, 2009 at 5:51 PM, Francis De Brabandere
> <fr...@gmail.com> wrote:
>> Thanks for reporting!
>>
>> I'll take care of this this evening.
>>
>> On Thu, Mar 26, 2009 at 5:49 PM, Frank Lupo <fr...@email.it> wrote:
>>> In Postgrql "BLOB" type not exist but is possible to create a "bytea"
>>> column.
>>>
>>> in DBDatabaseDriverPostgreSQL.java
>>> case BLOB:
>>> sql.append("BLOB");
>>> if (c.getSize() > 0)
>>> sql.append(" (" + String.valueOf((long) c.getSize()) + ")
>>> ");
>>> break;
>>>
>>> change in
>>> case BLOB:
>>> sql.append("bytea");
>>> break;
>>>
>>>
>>> http://www.postgresql.org/docs/8.3/static/datatype.html
>>> http://jdbc.postgresql.org/documentation/80/binary-data.html
>>>
>>> Best Regards
>>>
>>>
>>>
>>>
>>> --
>>> Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP
>>> autenticato? GRATIS solo con Email.it http://www.email.it/f
>>>
>>> Sponsor:
>>> Con Poker Club anche a Marzo il montepremi è garantito: ogni lunedì, giovedì
>>> e domenica vinci fino a 25.000 !
>>> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8801&d=26-3
>>>
>>
>>
>>
>> --
>> http://www.somatik.be
>> Microsoft gives you windows, Linux gives you the whole house.
>>
>
>
>
> --
> http://www.somatik.be
> Microsoft gives you windows, Linux gives you the whole house.
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.
Re: Postgresql BLOB
Posted by Francis De Brabandere <fr...@gmail.com>.
And even better would be that you create a jira issue...
https://issues.apache.org/jira/browse/EMPIREDB
On Thu, Mar 26, 2009 at 5:51 PM, Francis De Brabandere
<fr...@gmail.com> wrote:
> Thanks for reporting!
>
> I'll take care of this this evening.
>
> On Thu, Mar 26, 2009 at 5:49 PM, Frank Lupo <fr...@email.it> wrote:
>> In Postgrql "BLOB" type not exist but is possible to create a "bytea"
>> column.
>>
>> in DBDatabaseDriverPostgreSQL.java
>> case BLOB:
>> sql.append("BLOB");
>> if (c.getSize() > 0)
>> sql.append(" (" + String.valueOf((long) c.getSize()) + ")
>> ");
>> break;
>>
>> change in
>> case BLOB:
>> sql.append("bytea");
>> break;
>>
>>
>> http://www.postgresql.org/docs/8.3/static/datatype.html
>> http://jdbc.postgresql.org/documentation/80/binary-data.html
>>
>> Best Regards
>>
>>
>>
>>
>> --
>> Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP
>> autenticato? GRATIS solo con Email.it http://www.email.it/f
>>
>> Sponsor:
>> Con Poker Club anche a Marzo il montepremi è garantito: ogni lunedì, giovedì
>> e domenica vinci fino a 25.000 !
>> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8801&d=26-3
>>
>
>
>
> --
> http://www.somatik.be
> Microsoft gives you windows, Linux gives you the whole house.
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.
Re: Postgresql BLOB
Posted by Francis De Brabandere <fr...@gmail.com>.
Thanks for reporting!
I'll take care of this this evening.
On Thu, Mar 26, 2009 at 5:49 PM, Frank Lupo <fr...@email.it> wrote:
> In Postgrql "BLOB" type not exist but is possible to create a "bytea"
> column.
>
> in DBDatabaseDriverPostgreSQL.java
> case BLOB:
> sql.append("BLOB");
> if (c.getSize() > 0)
> sql.append(" (" + String.valueOf((long) c.getSize()) + ")
> ");
> break;
>
> change in
> case BLOB:
> sql.append("bytea");
> break;
>
>
> http://www.postgresql.org/docs/8.3/static/datatype.html
> http://jdbc.postgresql.org/documentation/80/binary-data.html
>
> Best Regards
>
>
>
>
> --
> Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP
> autenticato? GRATIS solo con Email.it http://www.email.it/f
>
> Sponsor:
> Con Poker Club anche a Marzo il montepremi è garantito: ogni lunedì, giovedì
> e domenica vinci fino a 25.000 !
> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8801&d=26-3
>
--
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.