On Thu, 05 May 2011 16:47:09 -0600,
Rob Sargent wrote:
[...]
> Doesn't appear to. I use sql-mode alot/daily. The multiple prompts
> never bothers me, though the output not starting at the left kind of
> does.
Then you might like this:
http://www.emacswiki.org/emacs/SqlMode#toc3
bottom secti
Tom Lane wrote on 07.05.2011 18:48:
Thomas Kellerer writes:
My database is initialized as follows:
postgres=# select version();
version
PostgreSQL 9.1beta1, compiled by Visual C++ build 1500, 32
Thomas Kellerer writes:
> My database is initialized as follows:
> postgres=# select version();
> version
>
> PostgreSQL 9.1beta1, compiled by Visual C++ build 1500, 32-bit
> (1 row)
I gather this is
Guillaume Lelarge wrote on 07.05.2011 14:02:
create table foo (bar text collate "fr_FR") --> collation "fr_FR" for
encoding "UTF8" does not exist
create table foo (bar text collate "fr_FR.1252") --> collation "fr_FR"
for encoding "UTF8" does not exist
create table foo (bar text collate "fr_
On 05/07/2011 01:19 PM, Thomas Kellerer wrote:
> Hi,
>
> I'm playing around with 9.1beta1 and would like to create a table where
> one column has a non-default collation.
>
> But whatever I try, I can't find the correct name that I have to use.
>
> My database is initialized as follows:
>
> pos
Hi,
I'm playing around with 9.1beta1 and would like to create a table where one
column has a non-default collation.
But whatever I try, I can't find the correct name that I have to use.
My database is initialized as follows:
postgres=# select version();
version
---
On Wed, 4 May 2011 23:48:04 +0100
Tarlika Elisabeth Schmitz wrote:
>I have got a database that needs to be populated, first with historical
>data, then on a daily basis.[...]
>Once imported, data will neither be modified nor deleted.
>
>Data come in denormalized CSV formats. [...]
>I created inte
Thank your for your reply, Sergey.
(By the way, I noticed you are not cc'ing/replying to the list.)
On Fri, 6 May 2011 01:45:19 +0300
sergey kapustin wrote:
>INSERT ... RETURNING will not work in rules i think. You cannot nest
>INSERTs and its not possible to use variables.
And rules are not ac