Re: [GENERAL] Client SQL Tool

2011-11-14 Thread Jerry Levan
On Nov 14, 2011, at 5:33 PM, pgsql-general-ow...@postgresql.org wrote: > Date: Mon, 14 Nov 2011 16:01:16 +0100 > From: > To: > Subject: Client SQL Tool > Message-ID: <2D9339CD594D4A68B51E9D0B3AF134F4@neuromancer> > > Hi all, > > Iâ•˙ve started a new codeplex project that could be interesting

Re: [GENERAL] Upgrade 8.4 with contrib to 9.1

2011-11-14 Thread Tarlika Elisabeth Schmitz
On Mon, 14 Nov 2011 14:20:39 -0700 Scott Marlowe wrote: >On Mon, Nov 14, 2011 at 11:12 AM, Tarlika Elisabeth Schmitz > wrote: >> I am running 8.4 with various contrib modules (hstore-new, pg_trgm, >> fuzzystrmatch). >> >> If I wanted to upgrade to 9.1, can I / would I have to uninstall the >> con

Re: [GENERAL] Client SQL Tool

2011-11-14 Thread Brandon Phelps
On 11/14/2011 05:42 PM, John R Pierce wrote: On 11/14/11 2:32 PM, Josh Kupershmidt wrote: How does this client compare to pgAdmin (as a graphical client) or psql (as a client in general)? its a MS Windows only program using the .NET framework, and it just executes manually entered SQL commands

Re: [GENERAL] Client SQL Tool

2011-11-14 Thread John R Pierce
On 11/14/11 2:32 PM, Josh Kupershmidt wrote: How does this client compare to pgAdmin (as a graphical client) or psql (as a client in general)? its a MS Windows only program using the .NET framework, and it just executes manually entered SQL commands, displaying the results in a ADO grid objec

Re: [GENERAL] Client SQL Tool

2011-11-14 Thread Josh Kupershmidt
On Mon, Nov 14, 2011 at 10:01 AM, wrote: > Hi all, > > I’ve started a new codeplex project that could be interesting for you. It’s > a simple SQL client for postgreSQL databases. > You can found it here : http://postgresqlclient.codeplex.com/ > > I’ve started with this project, because i want to

Re: [GENERAL] Upgrade 8.4 with contrib to 9.1

2011-11-14 Thread John R Pierce
On 11/14/11 10:12 AM, Tarlika Elisabeth Schmitz wrote: Hello, I am running 8.4 with various contrib modules (hstore-new, pg_trgm, fuzzystrmatch). If I wanted to upgrade to 9.1, can I / would I have to uninstall the contrib modules? Are there any incompatibilities between the contrib and corresp

Re: [GENERAL] Upgrade 8.4 with contrib to 9.1

2011-11-14 Thread Scott Marlowe
On Mon, Nov 14, 2011 at 11:12 AM, Tarlika Elisabeth Schmitz wrote: > Hello, > I am running 8.4 with various contrib modules (hstore-new, pg_trgm, > fuzzystrmatch). > > If I wanted to upgrade to 9.1, can I / would I have to uninstall the > contrib modules? > > Are there any incompatibilities betwee

[GENERAL] syntax highlighting in emacs after \e in psql

2011-11-14 Thread MikeW
Hi All, I'm sure somebody has already solved this problem on Unix. When I open *.sql files in my emacs it highlights the SQL and Postgres syntax correctly. But does anybody know how to make it behave like that also after invoking \e command in psql (so that I don't need to say: M-x sql-mode each

Re: [GENERAL] encoding and LC_COLLATE

2011-11-14 Thread Mark Watson
De : pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] De la part de Adrian Klaver >Envoyé : 14 novembre 2011 13:03 >... > >Second is the data coming in actually UTF8 or some other encoding? >...  Hi Andy, I have to agree with Adrian in that the data may be coming in

[GENERAL] Upgrade 8.4 with contrib to 9.1

2011-11-14 Thread Tarlika Elisabeth Schmitz
Hello, I am running 8.4 with various contrib modules (hstore-new, pg_trgm, fuzzystrmatch). If I wanted to upgrade to 9.1, can I / would I have to uninstall the contrib modules? Are there any incompatibilities between the contrib and corresponding 9.1 functions? -- Best Regards, Tarlika Elisabet

Re: [GENERAL] encoding and LC_COLLATE

2011-11-14 Thread Adrian Klaver
On Mon, Nov 14, 2011 at 8:25 AM, LPlateAndy wrote: > Hi Adrian, > > ** ** > > You’re right, i’m trying to get the copy command to put a load of data > into a table. It’s now working fine except for any instances with an e acute > > > ** ** > > I tried putting “ SET CLIENT_ENCODING TO ‘UT

Re: [GENERAL] encoding and LC_COLLATE

2011-11-14 Thread LPlateAndy
Hi Adrian, You're right, i'm trying to get the copy command to put a load of data into a table. It's now working fine except for any instances with an e acute I tried putting " SET CLIENT_ENCODING TO 'UTF-8'; " but still got the error. I guess that just because i'm verifying what's incoming

Re: [GENERAL] encoding and LC_COLLATE

2011-11-14 Thread Adrian Klaver
On Monday, November 14, 2011 3:03:32 am LPlateAndy wrote: > Hi, > > I set up my postgres 9.0 install 6 months ago and generally everything is > fine but a recent data load with an e acute character failed which an > unsupported message which surprised me as we're using UTF-8. > > However, i can

[GENERAL] Client SQL Tool

2011-11-14 Thread bjoern
Hi all, I’ve started a new codeplex project that could be interesting for you. It’s a simple SQL client for postgreSQL databases. You can found it here : http://postgresqlclient.codeplex.com/ I’ve started with this project, because i want to improve my WPF skills and create something useful for

Re: [GENERAL] issue with delimiter in field during COPY

2011-11-14 Thread Adrian Klaver
On Monday, November 14, 2011 6:27:10 am LPlateAndy wrote: > Thanks Adrian, > > > > Apologies, i'd assumed specifying "CSV" would work just for actual CSV > files with comma separation. No problem. CSV has become a generic term describing separated value files of all types. > > > > Thanks

Re: [GENERAL] issue with delimiter in field during COPY

2011-11-14 Thread LPlateAndy
Thanks Adrian, Apologies, i'd assumed specifying "CSV" would work just for actual CSV files with comma separation. Thanks again Andy From: Adrian Klaver-3 [via PostgreSQL] [mailto:ml-node+s1045698n4990887...@n5.nabble.com] Sent: 14 November 2011 14:24 To: LPlateAndy Subject: Re: is

Re: [GENERAL] issue with delimiter in field during COPY

2011-11-14 Thread Adrian Klaver
On Monday, November 14, 2011 5:39:41 am LPlateAndy wrote: > Hi, > > Using COPY to bring data into a table. It uses "|" which i allow for with a > command such as: > > COPY mydata FROM E'C:\\mydata\\mydata.txt' USING DELIMITERS '|' > > This works fine except for a url field which randomly include

Re: [GENERAL] issue with delimiter in field during COPY

2011-11-14 Thread LPlateAndy
Hi, My apologies for the previous post, i reread the documentation and realised that a "CSV" load can actually use a file with delimiters other than a comma. As such, i have answered my own question. Thanks Andy -- View this message in context: http://postgresql.1045698.n5.nabble.com/issue-wi

[GENERAL] issue with delimiter in field during COPY

2011-11-14 Thread LPlateAndy
Hi, Using COPY to bring data into a table. It uses "|" which i allow for with a command such as: COPY mydata FROM E'C:\\mydata\\mydata.txt' USING DELIMITERS '|' This works fine except for a url field which randomly includes a pipeline "|" character. Despite the url being in quotation (" ") marks

Re: [GENERAL] encoding and LC_COLLATE

2011-11-14 Thread LPlateAndy
Hi, In response to my own question i have now read the following: http://stackoverflow.com/questions/6579621/lc-collate-and-lc-ctype-suport-for-utf-8-in-postgresql It seems to show that apart from a complete reinstall i should just use a Locale of C (as i'm on Windows and POSIX wont work). This

[GENERAL] encoding and LC_COLLATE

2011-11-14 Thread LPlateAndy
Hi, I set up my postgres 9.0 install 6 months ago and generally everything is fine but a recent data load with an e acute character failed which an unsupported message which surprised me as we're using UTF-8. However, i can now see that the listing for the database set up show a restriction unde

Re: [GENERAL] = any((select )) needs cast, why?

2011-11-14 Thread Frank van Vugt
Hi Tom, > ANY(SELECT ...) normally means searching down the rows ah, yeah, but I was focussing here more on the ANY() from documentation paragraph 9.21.3 (postgresql v9.1.1): expression operator ANY (array expression) > where the select is expected to return a single column matching th