[GENERAL] Query cancellation in JDBC

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

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

On 2011-01-20, Robert Paresi firstn...@lastname.net 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.

[GENERAL] Queyring for columns which are exist in table.

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

Re: [GENERAL] iPad and Pg revisited...

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

Re: [GENERAL] Postgresql as a dictionary coder backend?

2011/1/23 Attila Nagy b...@fsn.hu:  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

[GENERAL] Store base64 in database. Use bytea or text?

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:

Re: [GENERAL] Store base64 in database. Use bytea or text?

In response to Andre Lopes lopes80an...@gmail.com: 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

Re: [GENERAL] Store base64 in database. Use bytea or text?

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

Re: [GENERAL] Store base64 in database. Use bytea or text?

2011/1/26 Andy Colson a...@squeakycode.net 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

Re: [GENERAL] Store base64 in database. Use bytea or text?

On 25 January 2011 22:27, Andre Lopes lopes80an...@gmail.com 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

Re: [GENERAL] Store base64 in database. Use bytea or text?

In response to Peter Geoghegan peter.geoghega...@gmail.com: On 25 January 2011 22:27, Andre Lopes lopes80an...@gmail.com 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

Re: [GENERAL] Store base64 in database. Use bytea or text?

2011/1/26 Peter Geoghegan peter.geoghega...@gmail.com On 25 January 2011 22:27, Andre Lopes lopes80an...@gmail.com 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

Re: [GENERAL] Store base64 in database. Use bytea or text?

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,

Re: [GENERAL] Store base64 in database. Use bytea or text?

2011/1/26 Andre Lopes lopes80an...@gmail.com 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

Re: [GENERAL] Store base64 in database. Use bytea or text?

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,

Re: [GENERAL] Store base64 in database. Use bytea or text?

2011/1/26 Andre Lopes lopes80an...@gmail.com 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

[GENERAL] Install Pgadmin3 1.12 on ubuntu 10.4 lucid client without postgresql server install

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

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

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

[GENERAL] archive_command not enabled after finshing recovery?

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.

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

2011/1/25 Jasen Betts ja...@xnet.co.nz On 2011-01-20, Robert Paresi firstn...@lastname.net 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?

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

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

[GENERAL] Subselect AS and Where clause

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.