Re: [GENERAL] Converting an ASCII database to an UTF-8 database

I have this exact problem. I have dumped and reloaded other databases and set the client encoding to convert them to UTF-8 but I have one database with values that still cause it to fail, even if I specify that the client encoding is SQL_ASCII. How do I fix that? On Feb 17, 2006, at 4:08

Re: [GENERAL] primary index permits duplicates

H Hale <[EMAIL PROTECTED]> writes: > Let's assume for a moment the dsuuid lib is correct, how then is it > possible to get non-unique values for a primary index? Well, you're assuming a fact not in evidence as far as I'm concerned. But feel free to send in a reproducible test case, and we'll

Re: [GENERAL] primary index permits duplicates

dsuuid is my library The library uses standard uuid comparison functions provided with linux. To clarify, the compare returns the same value the uuid compare functions.   From man page...   Returns an integer less than, equal to, or greater than zero if uu1 is found, respectively, to be lexigr

[GENERAL] Updating a sequential range of unique values?

How can I update a range of constrained values in order, without having to resubmit a query for every single possiblity? I'm trying to create a customer-specific sequence number, so that, for each customer, the number starts at one, and continues, 1, 2, 3, 4, 5... etc. with no values skipped.

Re: [GENERAL] EnterpriseDB

Benjamin Arai wrote: Is the PL support in EnterpriseDB worth the money? Are there any specific benefits that I should specifically be aware of? It depends.. do you want plSQL/Oracle compatibility? If so... then probably. If not... then the base PostgreSQL pl support is more then enough conside

Re: [GENERAL] A question about Vacuum analyze

Quoth [EMAIL PROTECTED] (Emi Lu): >> no. the suggestion was that a VACUUM is not needed, but that an >> ANALYZE might be. > > Thank you gnari for your answer. But I am a bit confused about not > running vacuum but only "analyze". Can I seperate these two > operations? I guess "vacuum analyze" do bo

Re: [GENERAL] How do I use the backend APIs

A long time ago, in a galaxy far, far away, "Chad" <[EMAIL PROTECTED]> wrote: > In a word: The kind of problems people use Berkeley DB for. > People use BDB for more fine grained cursor access to BTrees. Stuff you > CANNOT do with SQL. There is a market for this. See their website. I'd > like some

Re: [GENERAL] EnterpriseDB

[EMAIL PROTECTED] ("Benjamin Arai") wrote: > Is the PL support in EnterpriseDB worth the money?  Are there any > specific benefits that I should specifically be aware of? I dunno; this is a PostgreSQL list, and many (most?) of us have never used EnterpriseDB. The people that can answer your *seco

Re: [GENERAL] Performance Tuning

The world rejoiced as [EMAIL PROTECTED] ("Darryl W. DeLao Jr.") wrote: > Running ver 7.3.10 in RHEL 3.0 ES.  If I change shared buffers, dont i have > to change max connections as well?  If you have enough connections, then that seems unnecessary. The *opposite* would be true; if you change max

Re: [GENERAL] Converting an ASCII database to an UTF-8 database

On fös, 2006-02-17 at 22:38 +0100, Peter Eisentraut wrote: > [EMAIL PROTECTED] wrote: > > How do I convert a database in the ASCII format into one of the UTF-8 > > format? > > ASCII is a subset of UTF-8, so you don't need to do anything. Just > change the encoding entry in the pg_database table.

Re: [GENERAL] How do I use the backend APIs

On Fri, Feb 17, 2006 at 01:06:16AM -0800, Chad wrote: > In a word: The kind of problems people use Berkeley DB for. > > People use BDB for more fine grained cursor access to BTrees. Stuff you > CANNOT do with SQL. There is a market for this. See their website. I'd > like something similar from Pos

Re: [GENERAL] Converting an ASCII database to an UTF-8 database

[EMAIL PROTECTED] wrote: > How do I convert a database in the ASCII format into one of the UTF-8 > format? ASCII is a subset of UTF-8, so you don't need to do anything. Just change the encoding entry in the pg_database table. Of course, using pg_dump would be the official way to convert a data

Re: [GENERAL] return setof and Temp tables

On Friday 17 February 2006 00:13, Justin B. Kay wrote: > I have looked around and found that you can use return setof in a > function to return a result set, but can you use a temp table as the > setof target? I build a temp table using various select statements and > then try to return the result

Re: [GENERAL] sqlite speed comparison

On 2/14/06, Neil Conway <[EMAIL PROTECTED]> wrote: > On Tue, 2006-02-14 at 13:53 -0500, Kevin Murphy wrote: > > A Windows PostgreSQL guru who cares (;-)) might help this guy with his > > benchmark of mysql, firebird, sqlite, and postgresql: > > > > http://www.sqlite.org/cvstrac/wiki?p=SpeedComparis

Re: [GENERAL] Converting an ASCII database to an UTF-8 database

On fös, 2006-02-17 at 05:21 -0800, [EMAIL PROTECTED] wrote: > Hi All, > > I have a database in PostgreSQL which is ASCII. > Due to some internationalization issues, I need to convert the database > to the UTF-8 format. > > So my question is: > How do I convert a database in the ASCII format into

Re: [GENERAL] primary index permits duplicates

H Hale <[EMAIL PROTECTED]> writes: > dsuuid is a custom data type for uuids with an external library with > comparsion functions. Unless you can reproduce this with a standard datatype, you should probably file this report with the developer(s) of dsuuid. It sounds like an incorrect comparison

[GENERAL] primary index permits duplicates

Hello, I am using Postgres 8.0.3 on Fedora Core 4. I may have found a bug in Postgres. I have a table as follows:   Table ".master"   Column  |  Type  | Modifiers --++---  objectid | dsuuid | not null  classid  | dsuuid | not null Indexes:     "master

Re: [GENERAL] How do I use the backend APIs

"Chad" <[EMAIL PROTECTED]> writes: > This is exactly what I am looking for. I'm wondering how easy it is to > sit on top of this backend. You can't, and you'll get exactly zero community support for trying. We don't believe in embedded databases --- or at least, we don't believe in trying to use P

Re: [GENERAL] Performance Tuning

On Fri, 2006-02-17 at 14:01, Darryl W. DeLao Jr. wrote: > Running ver 7.3.10 in RHEL 3.0 ES. If I change shared buffers, dont i > have to change max connections as well? You should update to a newer version of PostgreSQL if performance is important to you. 7.3 was ok, but 8.1 is light years ah

Re: [GENERAL] Performance Tuning

Running ver 7.3.10 in RHEL 3.0 ES.  If I change shared buffers, dont i have to change max connections as well?  On 2/17/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Darryl W. DeLao Jr." <[EMAIL PROTECTED]> writes: > I have max_connections set to 512, with shared buffers set to 1024.  If I> set this an

Re: [GENERAL] connecting to pgsql

Did you make the required changes to pg_hba.conf?? Maybe you forgot to do those -Chandra Sekhar Surapaneni -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of mmaclennan Sent: Thursday, February 16, 2006 11:38 PM To: pgsql-general@postgresql.org Subject: [GE

Re: [GENERAL] Performance Tuning

"Darryl W. DeLao Jr." <[EMAIL PROTECTED]> writes: > I have max_connections set to 512, with shared buffers set to 1024. If I > set this any higher, postgres will not start. But, it seems that this > setting is not enough. Though the server runs fine, certain queries for > reports are taking anyw

[GENERAL] EnterpriseDB

Is the PL support in EnterpriseDB worth the money?  Are there any specific benefits that I should specifically be aware of?   Benjamin Arai [EMAIL PROTECTED] http://www.benjaminarai.com  

[GENERAL] Converting an ASCII database to an UTF-8 database

Hi All, I have a database in PostgreSQL which is ASCII. Due to some internationalization issues, I need to convert the database to the UTF-8 format. So my question is: How do I convert a database in the ASCII format into one of the UTF-8 format? Thanks in advance - Kishore

Re: [GENERAL] How do I use the backend APIs

In a word: The kind of problems people use Berkeley DB for. People use BDB for more fine grained cursor access to BTrees. Stuff you CANNOT do with SQL. There is a market for this. See their website. I'd like something similar from Postgres so that the data would be stored in a full fledged RDBMS b

Re: [GENERAL] Ident authentication failed without su to user

Yes. It turns out the problem was that my pg_hba.conf file was replaced by another file during a yum install of the new postgresql but in a different path. When I used "locate pg_hba.conf" it returned the path of the old file which didn't have the 'ident sameuser' rule.

Re: [GENERAL] Btrieve to SQL

If you need to extract your data you can take a look at BtSearch at www.nssdd.com. It allows you to export your data to dbase or ascii formats which you can then import into about anything else. Gil ---(end of broadcast)--- TIP 5: don't forget to

Re: [GENERAL] How do I use the backend APIs

Thanks Martijn, This is exactly what I am looking for. I'm wondering how easy it is to sit on top of this backend. Does anybody have any stand alone sample code? Is it a library that can be linked or do you need to produce a modified version of the postgres server? Can it be used in shared library

[GENERAL] connecting to pgsql

I have installed postgresql with postgis on a server at my home and I have loaded some data into it but I can not access this data from another computer. I have downloaded the ODBC driver from the postgresql web site and have installed it on another computer but when I try to establish a connection

Re: [GENERAL] Basic problems using plpythonu - bug?

Thanks a bunch - that cleaned everything up! Curt - Original Message - From: "Michael Fuhr" <[EMAIL PROTECTED]> To: "Curt Schwaderer" <[EMAIL PROTECTED]> Cc: Sent: Friday, February 17, 2006 11:57 AM Subject: Re: [GENERAL] Basic problems using plpythonu - bug? On Fri, Feb 17, 2006 a

[GENERAL] Performance Tuning

I wanted to check on my settings in my postgresql.conf file for a Dual Xeon 2.4 GHZ server with 6 GB of Ram.   I have max_connections set to 512, with shared buffers set to 1024.  If I set this any higher, postgres will not start.  But, it seems that this setting is not enough.  Though the server r

Re: [GENERAL] TSearch2 / German compound words / UTF-8

Norwegian (Nynorsk and Bokmaal) ispell dictionaries are available from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ I didn't test them. Oleg On Fri, 17 Feb 2006, Teodor Sigaev wrote: Very strange... ~% file tsearch/dict/ispell_no/norwegian.dict tsearch/dict/ispell_no/n

Re: [GENERAL] A question about Vacuum analyze

On fös, 2006-02-17 at 12:06 -0500, Emi Lu wrote: > In another way, whenever we "delete/truncate and then insert" data into > a table, it is better to "vacuum anaylze"? > > ... > >> > >>So, your suggestion is that after the population of table A, the query > >>planner should be abl

Re: [GENERAL] Basic problems using plpythonu - bug?

On Fri, Feb 17, 2006 at 11:38:21AM -0600, Curt Schwaderer wrote: > ERROR: plppython: function "send_ctl_msg" failed > DETAIL: exceptions.KeyError: 'cfgCmd' You're getting bit by case folding of identifiers. You created the column as: > cfgCmdVARCHAR(16), -- ENS configuration contr

Re: [GENERAL] TSearch2 / German compound words / UTF-8

BTW, if you take norwegian dictionary from http://folk.uio.no/runekl/dictionary.html then try to build it from OpenOffice sources (http://lingucomponent.openoffice.org/spell_dic.html, tsearch2/my2ispell). I found mails in my archive which says that norwegian people prefer OpenOffice's one. --

Re: [GENERAL] TSearch2 / German compound words / UTF-8

Very strange... ~% file tsearch/dict/ispell_no/norwegian.dict tsearch/dict/ispell_no/norwegian.dict: ISO-8859 C program text ~% file tsearch/dict/ispell_no/norwegian.aff tsearch/dict/ispell_no/norwegian.aff: ISO-8859 English text Can you place that files anywhere wher I can download it

[GENERAL] Basic problems using plpythonu - bug?

I'm trying to do something pretty basic per the documentation using plpython triggers. When I change the "cfgCmd" field in the SysConfig table below, the trigger works fine and if I have a null function that does nothing but write to the pipe, that all works fine. The trouble is when the fun

Re: [GENERAL] A question about Vacuum analyze

On Fri, 2006-02-17 at 11:06, Emi Lu wrote: > In another way, whenever we "delete/truncate and then insert" data into > a table, it is better to "vacuum anaylze"? > > > > > >>>You shouldn't need a VACUUM if you haven't yet done any updates or > >>>deletes sinc

Re: [GENERAL] A question about Vacuum analyze

In another way, whenever we "delete/truncate and then insert" data into a table, it is better to "vacuum anaylze"? You shouldn't need a VACUUM if you haven't yet done any updates or deletes since the TRUNCATE. An ANALYZE seems like a good idea, though. (You could get away without

Re: [GENERAL] Btrieve to SQL

Adam Alkins wrote: Hey, Been looking around to do this for a while, haven't gotten concrete information. I'm interested in taking data from Peachtree Accounting 2003 (Which is stored Btrieve DAT files) and importing them into a Postgres SQL database. I have looked around on the net about this, b

Re: [GENERAL] Fixing up a corrupted toast table

On Feb 17, 2006, at 6:29 AM, Tom Lane wrote: Steve Atkins <[EMAIL PROTECTED]> writes: pg_dump: ERROR: missing chunk number 0 for toast value 25923965 I'd like to make the current problem go away, though, perhaps by deleting the relevant row in the element table. I'm not quite sure how to

[GENERAL] Btrieve to SQL

Hey, Been looking around to do this for a while, haven't gotten concrete information. I'm interested in taking data from Peachtree Accounting 2003 (Which is stored Btrieve DAT files) and importing them into a Postgres SQL database. I have looked around on the net about this, but haven't gotten any

Re: [GENERAL] Implicit conversion from string to timestamp

David Goodenough <[EMAIL PROTECTED]> writes: > I have some generic code to which I pass a series of values to be inserted > into a PostgreSQL table which includes a field which is defined as a timestamp > and which I wish to populate with a string of the form > "-MM-dd hh:mm:ss.SSS". Under p

Re: [GENERAL] TSearch2 / German compound words / UTF-8

Hello, Thanks for your efforts, I still don't get it to work. I now tried the norwegian example. My encoding is ISO-8859 (I never used UTF-8, because I thought it would be slower, the thread name is a bit misleading). So I am using an ISO-8859-9 database: ~/cvs/ssd% psql -l Name

Re: [GENERAL] Take advantage of PREPARE (Pool of Conections)

> It's called pgpool. I've installed it in my computer, that's o.k. Now, how do I to know if it's working with Postgresql? Thanks :o) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-n

Re: [GENERAL] Fixing up a corrupted toast table

Steve Atkins <[EMAIL PROTECTED]> writes: > pg_dump: ERROR: missing chunk number 0 for toast value 25923965 > I'd like to make the current problem go away, though, perhaps by > deleting the relevant row in the element table. I'm not quite sure how > to go about that, though. Could anyone point me

Re: [GENERAL] Problem with postgres installation

On Friday, February 17, 2006 12:50 AM, Richard Huxton wrote: > Jim McMaster wrote: >> I am trying to use the Windows installer for postgtes-8.0.3, for >> Windows XP SP 2. I had installed and de-installed it previously. >> The install fails, because the postgres user is

Re: [GENERAL] Take advantage of PREPARE (Pool of Conections)

On Fri, Feb 17, 2006 at 10:47:16AM +, Marcos wrote: > > Hi, > > I will have an aplication on the web that will have many connections > because it will be looking for data. > This means, if each visitor of the website opens and closes the > connection, PREPARE is useless. > > I need the

[GENERAL] Take advantage of PREPARE (Pool of Conections)

Hi, I will have an aplication on the web that will have many connections because it will be looking for data. I'm doing the main functions that will be used in PL/PGSQL, they use the PREPARE resource, but in order to use it, I need the connection to be permanent because the PLAN generated by P

Re: [GENERAL] return setof and Temp tables

2006/2/17, Justin B. Kay <[EMAIL PROTECTED]>: I have looked around and found that you can use return setof in a function to return a result set, but can you use a temp table as the setof target?   Yes, you can ( PostgreSQL 8.0.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5

[GENERAL] Implicit conversion from string to timestamp

I have some generic code to which I pass a series of values to be inserted into a PostgreSQL table which includes a field which is defined as a timestamp and which I wish to populate with a string of the form "-MM-dd hh:mm:ss.SSS". Under pg 8 and before this worked fine but now with 8.1 I se

Re: [GENERAL] How do I use the backend APIs

On Thu, Feb 16, 2006 at 07:41:09AM -0800, Chad wrote: > Hi, > > In Postgres, is there a C language API which would give me access to > BTrees like Berkeley DB does? eg to seek to a particular key/value pair > and iterate forward from there? If not whats the nearest thing to this > in Postgres? We

Re: [GENERAL] Problem with postgres installation

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jim McMaster > Sent: 17 February 2006 02:32 > To: pgsql-general@postgresql.org > Subject: [GENERAL] Problem with postgres installation > > I am trying to use the Windows installer for postgtes-8.0.3