Hi,
I done in JDBC driver barrier preventing of execution of query until
the cancel will not return, but future queries after cancellation are
occasionally terminated.
The query cancel sends following 16, 123456789, pid, key, flush, after
this it tries to read EOF, I got and ignore exception
On 2011-01-20, Robert Paresi wrote:
> Hello,
>
> We have 700 user install base using Sybase SQL Anywhere 9.02
>
> We are looking at migrating these installations over to PostGres
> 1. Very Very Short Answer Please - why should we?
postgres is the best database in the universe. :)
> 2. Does an
Hi All,
I want to fire a query such that if the particular column does not exist
then query should return some default value.
For that I have tried following experiment.
CREATE TABLE tbl (
c1 integer,
c2 integer,
c3 integer
);
INSERT INTO tbl VALUES (1, 2, 3);
INSERT I
On Jan 24, 2011, at 3:25 PM, Jerry LeVan wrote:
> I assume that if I were to jump to Pg 9.x.x that phpPgAdmim would die, yes?
I have not tried it, but my guess is it will work. I don't recall seeing that
there were any major protocol changes for version 9, so I suspect whatever
libpq version i
2011/1/23 Attila Nagy :
> Hello,
>
> I'm looking for a database backend for a dictionary coder project. It would
> have three major tasks:
> - take a text corpus, get their words and substitute each word by a 64 bit
> integer (the word:integer is always constant) and store the result
> (encoding)
Hi,
I need to put some images on Base64 in a PostgreSQL database. Wich
type should I use and what is the difference between using bytea or
text to store Base64?
Best Regards,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.p
In response to Andre Lopes :
>
> I need to put some images on Base64 in a PostgreSQL database. Wich
> type should I use and what is the difference between using bytea or
> text to store Base64?
bytea is overkill if you know for sure that the data will always be
base64. Aside from that, I don't k
On 1/25/2011 4:27 PM, Andre Lopes wrote:
Hi,
I need to put some images on Base64 in a PostgreSQL database. Wich
type should I use and what is the difference between using bytea or
text to store Base64?
Best Regards,
If they are encoded in base64, use text. Use bytea if you dont want to
enc
2011/1/26 Andy Colson
> On 1/25/2011 4:27 PM, Andre Lopes wrote:
>
>> Hi,
>>
>> I need to put some images on Base64 in a PostgreSQL database. Wich
>> type should I use and what is the difference between using bytea or
>> text to store Base64?
>>
>> Best Regards,
>>
>>
> If they are encoded in bas
On 25 January 2011 22:27, Andre Lopes wrote:
> Hi,
>
> I need to put some images on Base64 in a PostgreSQL database. Wich
> type should I use and what is the difference between using bytea or
> text to store Base64?
I really don't think you want to do that. Base64 is used to make
binary data 7-bi
In response to Peter Geoghegan :
> On 25 January 2011 22:27, Andre Lopes wrote:
> > Hi,
> >
> > I need to put some images on Base64 in a PostgreSQL database. Wich
> > type should I use and what is the difference between using bytea or
> > text to store Base64?
>
> I really don't think you want t
2011/1/26 Peter Geoghegan
> On 25 January 2011 22:27, Andre Lopes wrote:
> > Hi,
> >
> > I need to put some images on Base64 in a PostgreSQL database. Wich
> > type should I use and what is the difference between using bytea or
> > text to store Base64?
>
> I really don't think you want to do th
Thanks for all the reply's.
I will be using PHP for now to insert data.
So I shouldn't use base64 to store images or any other kind of files.
I'm new to storing files in the database. This will be my first
experience.
I will research about PQescapeByteaConn.
Thanks for the help.
Best Regards,
2011/1/26 Andre Lopes
> Thanks for all the reply's.
>
> I will be using PHP for now to insert data.
>
> So I shouldn't use base64 to store images or any other kind of files.
> I'm new to storing files in the database. This will be my first
> experience.
>
You may want to use large objects to stor
Thanks for the reply.
I will mainly store files with 100kb to 250kb not bigger than this.
PQescapeByteaConn is not available in a default installation of
PostgreSQL? My hosting account hava a standard installation of
PostgreSQL. There are other options for escaping binary files?
Best Regards,
2011/1/26 Andre Lopes
> Thanks for the reply.
>
> I will mainly store files with 100kb to 250kb not bigger than this.
>
> PQescapeByteaConn is not available in a default installation of
> PostgreSQL? My hosting account hava a standard installation of
> PostgreSQL. There are other options for esca
Using these instructions http://wiki.flexive.org/confluence/display/FX/Postgres+9.x+installation+in+Ubuntu?focusedCommentId=4915206#comment-4915206
I am trying to install current pgadmin3 1.12 on an ubuntu lucid client. Using the instructions above I have an Ubuntu 10.4 Postgresql 9 server up and
I hear there are several, But I can't understand why someone would want to
perform non-graphical tasks using a GUI.
Because it is easier.
I've managed to do everything I need - as well as write a full query
editor/report writer for PostGreSQL.
It is being beta tested now, and I plan on relea
hi
was testing an idea with pg 8.2.19
generally, I had master and slave, wal archiving set in both of them,
but when slave was slave, it didn't archive any wal segments. which is
fine.
*but*
when I finished slave recovery, it went online, but it didn't start
automatically the archiving process.
i
2011/1/25 Jasen Betts
> On 2011-01-20, Robert Paresi wrote:
> > Hello,
> >
> > We have 700 user install base using Sybase SQL Anywhere 9.02
> >
> > We are looking at migrating these installations over to PostGres
>
> > 1. Very Very Short Answer Please - why should we?
>
> postgres is the best d
I recommend dbWrench as a diagramming tool for Postgres.
I can also recommend SchemaSpy (http://schemaspy.sourceforge.net/), a superb
command line-based schema browser and ERD generator.
-- Gary Chambers
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
Google being useless tonight - now that's new :-)
What I'm trying to do is the following and I'm certain there is a simple
solution which eludes me:
I have a query like this:
SELECT a,b,c, (select problem from other_table where id=a) as problem FROM
mytable WHERE a=1
So far so good. Actually
22 matches
Mail list logo
