Re: [GENERAL] Development of cross-platform GUI for Open Source DBs

2006/11/25, Ritesh Nadhani <[EMAIL PROTECTED]>: Hello all Let me introduce myself first. I am the ex-lead developer of SQLyog (one of the most popular GUI for MySQL which is Windows only and runs on Linux through WINE, more info at http://www.webyog.com). === New Project: wxWidgets based cro

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

2006/11/23, Arnaud Lesauvage <[EMAIL PROTECTED]>: Arnaud Lesauvage a écrit : > Brandon Aiken a écrit : >> It also might be a big/little endian problem, although I always thought that was platform specific, not locale specific. >> >> Try the UCS-2-INTERNAL and UCS-4-INTERNAL codepages in iconv, w

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

2006/11/22, Brandon Aiken <[EMAIL PROTECTED]>: Gee, didn't Unicode just so simplify this codepage mess? Remember when it was just ASCII, EBCDIC, ANSI, and localized codepages? Unicode is a heaven sent, compared to 3 or 4 codepages representing any given (obviously non-English) language, and

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

2006/11/22, Arnaud Lesauvage <[EMAIL PROTECTED]>: Tomi NA a écrit : > 2006/11/21, Arnaud Lesauvage <[EMAIL PROTECTED]>: >> Hi list ! >> >> I already posted this as "COPY FROM encoding error", but I have >> been doing some more tests since then. &

Re: [GENERAL] MSSQL to PostgreSQL : Encoding problem

2006/11/21, Arnaud Lesauvage <[EMAIL PROTECTED]>: Hi list ! I already posted this as "COPY FROM encoding error", but I have been doing some more tests since then. I'm trying to export data from MS SQL Server to PostgreSQL. The tables are quite big (>20M rows), so a CSV export and a "COPY FROM3

Re: [GENERAL] Issue when inserting Slovak characters in database via PHP code

2006/11/4, Alain Roger <[EMAIL PROTECTED]>: Hi, Sorry to cross post this mail but i'm not able to know from where comes my issue. I have a postgreSQL database in UNICODE (UTF-8 in v8.1.4 and UNICODE in v8.0.1). Via my web application i type a sentence in Slovak language and it is stored into DB

Re: [GENERAL] postgres import

2006/11/2, Albe Laurenz <[EMAIL PROTECTED]>: psql -h host -p port -d database -U user >> >>> It's a good enough solution in most cases, but when the rowcount >>> starts to skyrocket, it simply doesn't seem to cut it (at least I >>> couldn't make it to). >> >> INSERT statements? You dumped wi

Re: [GENERAL] postgres import

2006/11/1, Alban Hertroys <[EMAIL PROTECTED]>: Tomi NA wrote: > 2006/10/31, Albe Laurenz <[EMAIL PROTECTED]>: >> You feed it to the command line interface psql. >> >> Example: >> psql -h host -p port -d database -U user > It's a good enough solutio

Re: [GENERAL] postgres import

2006/10/31, Albe Laurenz <[EMAIL PROTECTED]>: > I have a little problem. I have an .sql file ( db dump ) > and i want to import it to postgres on linux. > > Does anyone know how i can do it? You feed it to the command line interface psql. Example: psql -h host -p port -d database -U user It

Re: [GENERAL] UTF-8

2006/10/13, Martijn van Oosterhout : While sorting for multiple languages simultaneously is an issue, that's not the problem here. Linux/GLibc *does* support correct sorting for all language/charset combinations, and that's what he's using. Just for the hell of it I setup lv_LV.utf8 on my laptop

Re: [GENERAL] UTF-8

2006/10/13, Martijn van Oosterhout : On Thu, Oct 12, 2006 at 11:09:53PM +0200, Tomi NA wrote: > 2006/10/12, Martijn van Oosterhout : > >On Tue, Oct 10, 2006 at 11:49:06AM +0300, Martins Mihailovs wrote: > >> There are some misunderstood. Im using Linux 2.6.16.4, postgresql 8.1.

Re: [GENERAL] UTF-8

2006/10/12, Martijn van Oosterhout : On Tue, Oct 10, 2006 at 11:49:06AM +0300, Martins Mihailovs wrote: > There are some misunderstood. Im using Linux 2.6.16.4, postgresql 8.1.4, > (there are one of locale: lv_LV.utf8, for Latvian language). But if I > want do "lower", then with standard latin

[GENERAL] performace review

I was just reading http://www.opencrx.org/faq.htm where RDBMS engines are one of the questions and see pgsql bashed sentence after sentence. Can anyone offer any insight as to weather it's fact or FUD? t.n.a. ---(end of broadcast)--- TIP 2: Don't '

Re: [GENERAL] vista

On 9/19/06, Roman Neuhauser <[EMAIL PROTECTED]> wrote: # [EMAIL PROTECTED] / 2006-09-19 21:26:16 +1000: > if you want to be taken seriously by anyone who uses Windows (hands up > anyone who knows a Windows user) 1. what do those two things have in common? 2. what makes you think that "an

Re: [GENERAL] One of our own begins a new life

On 9/15/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote: Hello, Yeah, this is a cross post and it is slightly off topic but IMHO this is important. Tomorrow one of our own, Devrim Gunduz is becoming a man. He is sucking it up, and committing to the cvs repo of project marriage. May the patches r

Re: [GENERAL] [pgsql-advocacy] Thought provoking piece on

On 9/1/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote: Martijn van Oosterhout wrote: > Do we want to keep relying on the system libraries for collation, or > do we want to use a cross-platform library like ICU or do we want to > create our own collation library? ICU seems fine. +1 t.n.a. ---

Re: [GENERAL] [ANNOUNCE] == PostgreSQL Weekly News - September 10 2006 ==

On 9/11/06, Tatsuo Ishii <[EMAIL PROTECTED]> wrote: > == PostgreSQL Product News == > > pgpool-II-1.0.0 is out, now supporting more than two servers and with > the new pgpoolAdmin tool written in PHP. > http://pgfoundry.org/projects/pgpool/ You dropped the most important feature in pgpool-II: pa

Re: [GENERAL] find a free database design software

On 9/9/06, aBBISh <[EMAIL PROTECTED]> wrote: hello everyone: i want find a free software for design postgresql database model please commend one ~ thanks If you mean free as in beer, azzuri is what I use from time to time: http://www.azzurri.jp/en/software/clay/download.jsp If you mean free

Re: [GENERAL] Confused about locales

On 8/19/06, John Gunther <[EMAIL PROTECTED]> wrote: I've been reading about locales, encodings, sort orders, the to_ascii function and, embarrasingly, I'm more confused than enlightened.: What I want is very simple: 1) I want the database to correctly accept, store, and display alphabetic charac

Re: [GENERAL] Data warehouse & OLAP

On 8/9/06, Stefano B. <[EMAIL PROTECTED]> wrote: hi, I'm working in the implementation of a datawarehouse on Postgres. For analisys of aggregated data I'd like to use some OLAP tools like for example, Mondrian, OR use the meterialized view (if better). My questions: is there any documentation

Re: [GENERAL] I need a function

On 8/8/06, Feri@ <[EMAIL PROTECTED]> wrote: Hello to wholes, I am new therein and I am going by of mysql to postgres,somebody serious so kind to explain me as I can obtain in an array the names of the draws of a given base of data in PostGres. am programming in PHP, sorry for my English, i sp

Re: [GENERAL] different sort order in windows and linux version

On 7/2/06, Agent M <[EMAIL PROTECTED]> wrote: Certain Japanese characters cannot make a reliable round-trip through Unicode. ICU uses UTF-16 as its store, so the Japanese folks won't be happy with an ICU-only solution. However, it would still be of great Could you explain what you mean and wha

Re: [GENERAL] different sort order in windows and linux version

On 7/1/06, Martijn van Oosterhout wrote: On Fri, Jun 30, 2006 at 07:29:12PM +0200, Tomi NA wrote: > If I sound harsh, please excuse me, but I feel like I'm the only one > who thinks these encoding problems (collation, upper/lowercase, > multiple languages in a single databas

Re: [GENERAL] different sort order in windows and linux version

On 6/30/06, Martijn van Oosterhout wrote: On Fri, Jun 30, 2006 at 11:56:19AM +0200, Dragan Matic wrote: > I have two postgres servers, one on linux (fedora core 5), one on > windows, both are version 8.1.4. > > Both databases are initialized with locale Croatian and win1250 encoding. > > running

Re: [GENERAL] performance tips please

On 6/21/06, Hugo <[EMAIL PROTECTED]> wrote: Hi, I am testing my application and DB (postgres 8.1.4 ) on a : DELL-Power Edge 1800 with 2 Xeon 3.2ghz, 2 Gb RAM and 2 SCSI 149 Gb each. trouble is that the same application and DB(postgres 8.0.4) runs on a: DELL pentium 3 with 526MB of RAM a

Re: [GENERAL] COLLATE

On 6/7/06, Martijn van Oosterhout wrote: Kind of all three, feeding off eachother. There's just not enough interest from any front to really get it moving. It's a fairly invasive change and without significant support and interest from somewhere, chances of completion let alone acceptance are p

Re: [GENERAL] Best open source tool for database design / ERDs?

On 6/2/06, Rich Shepard <[EMAIL PROTECTED]> wrote: On Fri, 2 Jun 2006, Michael Dean wrote: > a caveat: I don't believe, from my reading of the license, that this is an > open source software product. May not be. I don't recall. Neither is Java. But, if you're using it for your own purposes,

[GENERAL] review SQL command history?

Is there a way to see SQL command history (specifically, a number of INSERTS in a batch command) that happened a couple of weeks ago? I need to see if a database was initialized with the correct data... TIA, t.n.a. ---(end of broadcast)--- TIP 9: I

Re: [GENERAL] Best open source tool for database design / ERDs?

On 5/29/06, Bjørn T Johansen <[EMAIL PROTECTED]> wrote: Druid works ok http://druid.sourceforge.net/index.html Are there a couple of screenshots available on the net, a flash demo perhaps? t.n.a. ---(end of broadcast)--- TIP 1: if posting/r

Re: [GENERAL] Best open source tool for database design / ERDs?

I use the azzuri eclipse plugin. It's rudimentary, but get's the job done for smaller (a couple of dozens of tables) models. It has a commercial version which might be even better. t.n.a. On 28 May 2006 05:19:04 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: What open source tool do people

Re: [GENERAL] ALTER SEQUENCE ... RESTART WITH [variable] problem

On 5/20/06, Martijn van Oosterhout wrote: Seems you can't use a variable there. Your choices are to build a string and use EXECUTE, or just do: SELECT setval('sequence',value); The EXECUTE string solution did the job. Thank you very much, Martijn. t.n.a. ---(end of

[GENERAL] ALTER SEQUENCE ... RESTART WITH [variable] problem

I need to generate a couple of dozen statements reseting my sequences so that they're next values are greater than the biggest existing ids. The problem is, I can't even form a statement to update one sequence. This is what I tried: CREATE OR REPLACE FUNCTION init_sequences() RETURNS void AS $BOD

Re: [GENERAL] Is PostgreSQL an easy choice for a large CMS?

On 4/30/06, Tony Lausin <[EMAIL PROTECTED]> wrote: Hello all, I'm working on a CMS which requires an open source database capable of handling hundreds of thousands of users simultaneously, with a high rate of database writes, and without buckling. We're talking somewhere between nerve.com/catch2

Re: [GENERAL] setting the environment locale - linux, windows

On 4/21/06, Martijn van Oosterhout wrote: > On Fri, Apr 21, 2006 at 03:34:27PM +0200, Tomi NA wrote: > > On 4/21/06, Martijn van Oosterhout wrote: > > > You need to look at your LC_COLLATE settings. LC_COLLATE and LC_CTYPE > > > are fixed at initdb and constant acro

Re: [GENERAL] setting the environment locale - linux, windows

On 4/21/06, Martijn van Oosterhout wrote: > On Fri, Apr 21, 2006 at 12:49:31AM +0200, Tomi NA wrote: > > This is probably somewhat offtopic, but it does relate to postgresql so... > > Problem summary: I have a UTF-8 encoded database running on linux on > > which upper

[GENERAL] setting the environment locale - linux, windows

This is probably somewhat offtopic, but it does relate to postgresql so... Problem summary: I have a UTF-8 encoded database running on linux on which upper() and lower() string functions ignore locale specific characters. To make things a bit more interesting, the development machines (including th

[GENERAL] full text search: the concept of a "word"

I'm considering using tsearch2 in the project I'm working on right now...however, I'm not sure if tsearch2 can handle my very specific requirements - I therefore hope someone can tell me if the following is possible and how I should go about it... My textfields are trigger-generated using informat

Re: [GENERAL] ilike and utf-8

On 4/14/06, Martijn van Oosterhout wrote: On Fri, Apr 14, 2006 at 03:16:01PM +0200, Raphael Bauduin wrote:> Hi,>> Does the ilike operator work fine with cyrillic text put in a UTF-8> encoded database?> I've had remarks of a user (of http://myowndb.com, a web database)> with tex

Re: [GENERAL] database design questions

On 4/3/06, Ottavio Campana <[EMAIL PROTECTED]> wrote:  3) faq 4.11.1 says>CREATE TABLE person (>id   SERIAL,>name TEXT>);>>is automatically translated into this:>>CREATE SEQUENCE person_id_seq; >CREATE TABLE person (>id   INT4 NOT NULL DEFAULT nextval('person

Fwd: [GENERAL] how to create script of database in postgres..sql(winxp)

-- Forwarded message --From: deepak pal <[EMAIL PROTECTED]>Date: Apr 3, 2006 2:05 PM Subject: Re: [GENERAL] how to create script of database in postgres..sql(winxp)To: Tomi NA <[EMAIL PROTECTED]>it do not recognize that \i and pg_dump i use \i pg_dump mydbname>new

Re: [GENERAL] Implementation Suggestions

On 3/29/06, Ian Harding <[EMAIL PROTECTED]> wrote: Seriously, it's not too bad if you don't mind it's plentifulshortcomings.  I was getting carpal tunnel syndrome from typing pages so I switched to RoR for a hobby app.  Itworks fine, but you have to do it "The Rails Way" and expect no help from the

Re: [GENERAL] PostgreSQL's XML support comparison against other RDBMSes

On 3/29/06, Martijn van Oosterhout wrote: On Wed, Mar 29, 2006 at 02:57:44PM +0400, Ivan Zolotukhin wrote:> So let's make such analysis here within PostgreSQL community! There> were a lot of talks about XML support in Postgres, but they did not> lead to any steady work in this d

Re: [GENERAL] Disability the trigger

On 3/13/06, Claudio Tognolo <[EMAIL PROTECTED]> wrote: I can disable the Trigger?I'd like to know how this could be done, as well. What I really need is a hold-off-all-triggers-untill-I-tell-you-to command, but hey, making a trigger just not fire and vice versa would also be nice. :) Tomislav

Re: [GENERAL] picking the correct locale when doing initdb

On 3/16/06, Harald Armin Massa <[EMAIL PROTECTED]> wrote: on bugs Magnus wrote:> It's a matter of picking the correct locale when you initdb your database.and he is PERFECTLY right. Getting the locale wrong while doing intidb can really screw up ones day. But: because of initdb being at the very

[GENERAL] programatic database dump

I'd like to dump a postgresql database from my (java) app and copy the dump file to the client machine.This backup strategy prooved invalueable in the past (given enough room on the harddrives, which I have) and I'd like to implement it now with postgresql. Is there something like a system stored p

Re: [GENERAL] database/schema level triggers?

Thanks for the info, everyone.Tomislav

[GENERAL] database/schema level triggers?

Does anything like that exist in postgresql?It'd rid me of a whole lot of work if it did...and I'd still have plenty more to keep me busy. :)TIA,Tomislav

Re: [GENERAL] collation & UTF-8

On 2/24/06, Martijn van Oosterhout <kleptog@svana.org> wrote: On Fri, Feb 24, 2006 at 06:23:07PM +0100, Tomi NA wrote:> I'm using PosgreSQL 8.1.2 on linux and want to load UTF-8 encoded varchars.> While I can store and get at stored text correctly, the ORDER BY places all >

[GENERAL] collation & UTF-8

I'm using PosgreSQL 8.1.2 on linux and want to load UTF-8 encoded varchars.While I can store and get at stored text correctly, the ORDER BY places all accented characters (Croatian, in this case - probably marked hr_HR) after non-accented characters. This is no showstopper, but it does affect the g