Re: [GENERAL] invalid UTF-8 byte sequence detected

2006-03-15 Thread Wes
On 3/16/06 12:41 AM, "Michael Glaesemann" <[EMAIL PROTECTED]> wrote: > I hope you didn't take my comments as a suggestion: I think you > *should* preprocess your data and use UTF8 as the default encoding > (or another encoding that includes all of the characters you hope to > use) for your databas

Re: [GENERAL] PostgreSQL on Windows not starting

2006-03-15 Thread Harald Armin Massa
Chris,i dove through all sorts of pain with windows security and PostgreSQL services while postgresql on win32 was in beta. Even deployed some big application to > 30 computers installing win32 PostgreSQL in beta. So, some areas where I had things to learn:  1.) group policies. On win32 computers w

Re: [GENERAL] invalid UTF-8 byte sequence detected

2006-03-15 Thread Michael Glaesemann
On Mar 16, 2006, at 15:39 , Wes wrote: That might be worth a shot. I don't really understand the ramifications, though, especially given Tom's warning. I guess as long as I don't care about things like sort order for those fields, it may not matter much. I hope you didn't take my commen

Re: [GENERAL] invalid UTF-8 byte sequence detected

2006-03-15 Thread Wes
On 3/16/06 12:13 AM, "Michael Glaesemann" <[EMAIL PROTECTED]> wrote: > SQL_ASCII is *not* ASCII. See the "What's a good default encoding?" > thread on this same list from today. > > http://archives.postgresql.org/pgsql-general/2006-03/msg00685.php > > I don't believe it will discard anything on

Re: [GENERAL] Indexes on array columns

2006-03-15 Thread Oleg Bartunov
contrib/intarray might help you Oleg On Wed, 15 Mar 2006, [EMAIL PROTECTED] wrote: On Wed, Mar 15, 2006 at 09:36:04AM -0700, Brendan Duddridge wrote: Hi, Is it possible to put an index on an array column? Apparently yes (I just did it as a test). However, consider the following from the ma

Re: [GENERAL] What's a good default encoding?

2006-03-15 Thread Harald Armin Massa
Good default encoding:does somebody NOT agree that UTF8 is quite a recommendation, at least for all the people without Korean, Japanese and Chinese Chars? I know, that's at maximum 2/3 of our potential user base, but better then nothing. Maybe we could even "suggest" UTF8 in the "getting started" (

Re: [GENERAL] Indexes on array columns

2006-03-15 Thread karly
On Wed, Mar 15, 2006 at 09:36:04AM -0700, Brendan Duddridge wrote: > Hi, > > Is it possible to put an index on an array column? Apparently yes (I just did it as a test). However, consider the following from the manual. Tip: Arrays are not sets; searching for specific array elements may b

Re: [GENERAL] invalid UTF-8 byte sequence detected

2006-03-15 Thread Michael Glaesemann
On Mar 16, 2006, at 14:42 , mike wrote: If you don't care to store those characters then maybe you should change the database character set to use SQL_ASCII instead of UTF-8. I believe ASCII will quietly discard those characters when converting from UTF-8. SQL_ASCII is *not* ASCII. See

Re: [GENERAL] invalid UTF-8 byte sequence detected

2006-03-15 Thread Wes
On 3/15/06 11:42 PM, "mike" <[EMAIL PROTECTED]> wrote: > If you don't care to store those characters then maybe you should change > the database character set to use SQL_ASCII instead of UTF-8. I believe > ASCII will quietly discard those characters when converting from UTF-8. I thought about th

Re: [GENERAL] invalid UTF-8 byte sequence detected

2006-03-15 Thread mike
If you don't care to store those characters then maybe you should change the database character set to use SQL_ASCII instead of UTF-8. I believe ASCII will quietly discard those characters when converting from UTF-8. Mike On Wed, 2006-03-15 at 23:20 -0600, Wes wrote: > Based on a couple of othe

[GENERAL] invalid UTF-8 byte sequence detected

2006-03-15 Thread Wes
Based on a couple of other posts, I think I'm out of luck, but I'm hoping something might have changed recently. I'm loading a very high volume of data with COPY using libpq - about 100+ million rows per day. The problem is that the COPY sometimes aborts with invalid UTF-8 byte sequence detecte

Re: [GENERAL] hi problem with installing postgresql8.1

2006-03-15 Thread Luckys
Firstly, the existence of the Path would be there from previous installation, of which PG thinks data is already present. Secondly you should have logged in as another user and not administrator, e.g postgres which can be even a part of domain.   Luckys   Data directory error:  The specified data

Re: [GENERAL] \copy combine with SELECT

2006-03-15 Thread Qingqing Zhou
""jia ding"" <[EMAIL PROTECTED]> wrote > I tried: > select id, name into table2 from table1; > \copy table2 to filename.txt > in order to export 2 columns from table1 to a file. > > But, I am thinking, if there is a command can combine these two > command together? Notice that COPY command c

Re: [GENERAL] Problems with Postgres and TCP/IP Protocol

2006-03-15 Thread Chris
Paulo wrote: I installed recently the last version of Postgres, but I can't get to connect using any tcp/ip port. I tried many. Few time ago I used the NLite program and I remove the Secondary Logon service and the program always asks by this service. So, I installed no service. I tried no fir

Re: [GENERAL] PostgreSQL on Windows not starting

2006-03-15 Thread Oisin Glynn
Chris Travers wrote: I have a customer who is having issues starting PostgreSQL 8.1 on Windows. It worked for a while and now doesn't appear to be running. I thought it was probably a stale pidfile, but had him search and could not find it. Is the pid information still in a pidfile or is it

Re: [GENERAL] Reprise of Oracle decode functionality...now with nifty

2006-03-15 Thread Mike Adams
Ack! Should at least pull the current version from the database: This version also correctly checks the "default" return value for a possible return of a wanted NULL value. (The part just ahead of "return $final_else;". /***/ C

[GENERAL] Reprise of Oracle decode functionality...now with nifty plperlu (and two cupholders)

2006-03-15 Thread Mike Adams
I've been lurking on the pgsql-* lists for about a month now and have decided to quit being a "wall flower". Looking through the achives, I've noticed a fair number of threads about Oracle compatibility functions: predominantly for decode(). I've even seen and (quickly) looked at one implemen

Re: [GENERAL] What's a good default encoding?

2006-03-15 Thread Tom Lane
"Junaili Lie" <[EMAIL PROTECTED]> writes: > I am wondering if somebody here can tell me the difference between > UTF-8 and SQL-ASCII, whether there are any benefits of converting > SQL-ASCII to UTF-8? SQL_ASCII isn't really an encoding; it's more like a declaration of ignorance. If the encoding i

Re: [GENERAL] apparent loss of sys tables!! - help

2006-03-15 Thread Noel Faux
Chris wrote: Noel Faux wrote: On the client machine: $ psql --version psql (PostgreSQL) 8.1.3 At the host: monashprotein=> select version(); version -

Re: [GENERAL] apparent loss of sys tables!! - help

2006-03-15 Thread Chris
Noel Faux wrote: On the client machine: $ psql --version psql (PostgreSQL) 8.1.3 At the host: monashprotein=> select version(); version - PostgreSQL 7.4.8

Re: [GENERAL] apparent loss of sys tables!! - help

2006-03-15 Thread Noel Faux
On the client machine: $ psql --version psql (PostgreSQL) 8.1.3 At the host: monashprotein=> select version(); version -  PostgreSQL 7.4.8 on ia64-unknow

Re: [GENERAL] Remote Sync

2006-03-15 Thread Daniel Blaisdell
This sounds like a good idea. I only see one potential problem. Say someone in the central office notices an error in a remote table, they misentered a charge to be billed out. Using a replication system such as Slony the table local to the worker in the central office will be readonly. How would

Re: [GENERAL] apparent loss of sys tables!! - help

2006-03-15 Thread Noel Faux
Klint Gore wrote: On Thu, 16 Mar 2006 12:33:26 +1100, Noel Faux <[EMAIL PROTECTED]> wrote: Has anyone had this problem? while in psql: monashprotein=> \d alignment ERROR: column c2.reltablespace does not exist monashprotein=> \d region ERROR: column c2.reltablespace does not ex

Re: [GENERAL] apparent loss of sys tables!! - help

2006-03-15 Thread Klint Gore
On Thu, 16 Mar 2006 12:33:26 +1100, Noel Faux <[EMAIL PROTECTED]> wrote: > Has anyone had this problem? > > while in psql: > > monashprotein=> \d alignment > ERROR: column c2.reltablespace does not exist > monashprotein=> \d region > ERROR: column c2.reltablespace does not exist > monashprotein

[GENERAL] apparent loss of sys tables!! - help

2006-03-15 Thread Noel Faux
Hi all, Has anyone had this problem? while in psql: monashprotein=> \d alignment ERROR: column c2.reltablespace does not exist monashprotein=> \d region ERROR: column c2.reltablespace does not exist monashprotein=> monashprotein=> \d ERROR: relation "pg_catalog.pg_roles" does not exist Any

Re: [GENERAL] What's a good default encoding?

2006-03-15 Thread Junaili Lie
I am wondering if somebody here can tell me the difference between UTF-8 and SQL-ASCII, whether there are any benefits of converting SQL-ASCII to UTF-8? If so, under what circumstances do we want to convert to UTF-8? Thanks, On 3/15/06, Michael Schmidt <[EMAIL PROTECTED]> wrote: Perhaps oth

Re: [GENERAL] question about postgresql time intervals

2006-03-15 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > On Mar 15, 2006, at 23:39 , Linda wrote: >> According to the SQL standard, shouldn't this work? >> >> select '506:47:04'::interval day to second ; > No one has implemented this in PostgreSQL yet. It depends on what you define as "work". 8.1 says

Re: [GENERAL] Remote Sync

2006-03-15 Thread Simon Riggs
On Wed, 2006-03-15 at 17:12 -0500, Daniel Blaisdell wrote: > I am currently in a situation where I have a distributed application > between a few remote nodes all connecting to a central database. I > have been searching for a database replication or synchronization > system that will allow a disco

Re: [GENERAL] tsearch is slow

2006-03-15 Thread Scott Marlowe
On Wed, 2006-03-15 at 18:09, Abbath wrote: > Hello Scott, > > Wednesday, March 15, 2006, 8:49:00 PM, you wrote: > >> > >> I can't guess what the user want to search. > > > But that query will likely load up all the index info into memory. > > Misunderstanding: I experienced that if I run a sear

Re: [GENERAL] question about postgresql time intervals

2006-03-15 Thread Michael Glaesemann
On Mar 15, 2006, at 23:39 , Linda wrote: According to the SQL standard, shouldn't this work? select '506:47:04'::interval day to second ; No one has implemented this in PostgreSQL yet. Is there a portable way to do this without using justify_hours()? Not currently that I know of. Michae

Re: [GENERAL] tsearch is slow

2006-03-15 Thread Abbath
Hello Scott, Wednesday, March 15, 2006, 8:49:00 PM, you wrote: > On Wed, 2006-03-15 at 13:36, Abbath wrote: >> Hello Richard, >> >> Wednesday, March 15, 2006, 3:35:26 PM, you wrote: >> > If you want to force the data to be cached, just put a cron-job in to >> > run a query for "abc" or whatever

Re: [GENERAL] URGENT!!! SELECT statement please help

2006-03-15 Thread Guy Rouillier
Why have you asked the same question 3 times in five minutes? Additional responses below. [EMAIL PROTECTED] wrote: > hi all, > > i have a web based java application with a postgres db. > > now i am trying to generate a temp table which contains all hour > records for a selected date range. eg. i

Re: [GENERAL] Concurrencia

2006-03-15 Thread Jaime Casanova
redirecting to [EMAIL PROTECTED] On 3/13/06, Editores S.A. <[EMAIL PROTECTED]> wrote: > > > Tengo una consulta acerca de manejo de concurrencia en postgres con PHP > > En un acceso de 50 usuarios simultaneamente como agilizar el bolqueo de > tablas accesadas > y como puedo garantizar un refresc

Re: [GENERAL] \copy combine with SELECT

2006-03-15 Thread Chris
jia ding wrote: Hi all, I tried: select id, name into table2 from table1; \copy table2 to filename.txt in order to export 2 columns from table1 to a file. But, I am thinking, if there is a command can combine these two command together? Maybe, something like: \copy select id,name from ta

Re: [GENERAL] catch SELECT statement return

2006-03-15 Thread Chris
[EMAIL PROTECTED] wrote: hi all, i am working on this postgresql statement. it picks up all non-null values only. is there a way to pickup all hour values (if any hour value not existing, still find them and assign their value to be 0). coz my table does not contain all hour values, only ones whi

Re: [GENERAL] Case Sensitive problem

2006-03-15 Thread Chris
Erik Ferencz wrote: Hi, I have got problems with case sensitive sort. My Postgre DB is Case sensitive but I need case insensitive. Could anyone help me,please. I don't know where or how to set this option. What output do you get and what do you expect to get? It sounds like a locale issue, I'm

Re: [GENERAL] Case Sensitive problem

2006-03-15 Thread Douglas McNaught
"Erik Ferencz" <[EMAIL PROTECTED]> writes: > Hi, > I have got problems with case sensitive sort. > My Postgre DB is Case sensitive but I need case insensitive. > Could anyone help me,please. > I don't know where or how to set this option. It's not an option you can set. Just do "ORDER BY upper(m

Re: [GENERAL] URGENT!!! SELECT statement please help

2006-03-15 Thread Ben
Have you considered using a stored proceedure? It seems like it might easily give you the logic you're after. http://www.postgresql.org/docs/8.1/static/xplang.html On Sun, 12 Mar 2006, [EMAIL PROTECTED] wrote: hi all, i have a web based java application with a postgres db. now i am trying t

Re: [GENERAL] Remote Sync

2006-03-15 Thread Douglas McNaught
"Daniel Blaisdell" <[EMAIL PROTECTED]> writes: > I am currently in a situation where I have a distributed application > between a few remote nodes all connecting to a central database. I > have been searching for a database replication or synchronization > system that will allow a disconnected nod

Re: [GENERAL] What's a good default encoding?

2006-03-15 Thread Michael Schmidt
Perhaps others can comment on encoding versus type of data.  I would add that the manner in which data are accessed may also be a consideration.  Specifically, UTF-8 is a good choice if one is going to use JDBC.   Michael Schmidt

Re: [GENERAL] Can the PostgreSQL store the Multimedia files

2006-03-15 Thread Devrim GUNDUZ
Hi, On Fri, 2006-03-10 at 08:47 -0800, [EMAIL PROTECTED] wrote: > - Can the PostgreSQL store the Multimedia files ( Images ,video > ,audio)??and exactly how?? Yes. The keyword is "large object". > pleaze I want the answer very fast Was that fast enough? -- The PostgreSQL Company - Comman

[GENERAL] Project survey: Commercial Companies and the Open Source Community

2006-03-15 Thread imypraz
Hi, I am a student studying Business IT Systems (MSc) at the University of Strathclyde in Scotland. For my masters dissertation I am investigating the relationship between commercial companies and the open source community. The project examines the issues, motivations and critical success factor

[GENERAL] Create a new table

2006-03-15 Thread sconeek
hi all, i am trying to create a postgres table from within my java code. now the scenario is that the user selects a date range and clicks submit from my HTML form. now i want to create a table, which contains records for each hour within that date range as a timestamp and another column for value

[GENERAL] URGENT!!! SELECT statement please help

2006-03-15 Thread sconeek
hi all, i have a web based java application with a postgres db. now i am trying to generate a temp table which contains all hour records for a selected date range. eg. if the user selects 2006-03-14 as from and 2006-03-14 as to, the system should insert 24 hour records with their individual time

[GENERAL] Concurrencia

2006-03-15 Thread Editores S.A.
  Tengo una consulta acerca de manejo de concurrencia  en postgres con PHP   En un acceso de  50  usuarios simultaneamente como agilizar el bolqueo de tablas accesadas y como puedo garantizar un refresco de pantalla en PHP, que la informacion desplegada  este actualizada.  evitar un desbord

Re: [GENERAL] Create a new table

2006-03-15 Thread sconeek
i just had this thought. i should take both dates, subtract them and multiply the figure by 24. then i should insert that many rows with their individual timestamps into the table in a sequential order. eg 2005-12-12 12:00:00 2005-12-13 01:00:00 and so on. can somebody please guide me in this

[GENERAL] Disability the trigger

2006-03-15 Thread Claudio Tognolo
I can disable the Trigger?-- Claudio Tognolo[EMAIL PROTECTED]

[GENERAL] \copy combine with SELECT

2006-03-15 Thread jia ding
Hi all,I tried: select id, name  into table2   from table1; \copy table2 to filename.txt in order to export 2 columns from table1 to a file.But, I am thinking, if there is a command can combine these two command together? Maybe, something like: \copy select id,name  from table  to filename.txt ?Nin

[GENERAL] Hour records within a date range

2006-03-15 Thread sconeek
hi all, i am trying to take a datefrom and dateto from a user and insert all hour records within that date range within the db. eg, if the user selects 2006-03-14 as datefrom and 2006-03-14 as dateto, the system would insert 24 rows within the table with their corresponding timestamps (eg 2006-03-1

[GENERAL] catch SELECT statement return

2006-03-15 Thread sconeek
hi all, i am working on this postgresql statement. it picks up all non-null values only. is there a way to pickup all hour values (if any hour value not existing, still find them and assign their value to be 0). coz my table does not contain all hour values, only ones which have a non-zero value.

[GENERAL] PostgreSQL on Windows not starting

2006-03-15 Thread Chris Travers
I have a customer who is having issues starting PostgreSQL 8.1 on Windows. It worked for a while and now doesn't appear to be running. I thought it was probably a stale pidfile, but had him search and could not find it. Is the pid information still in a pidfile or is it in the registry somew

Re: [GENERAL] full text indexing

2006-03-15 Thread Ian Harding
On 3/15/06, chris smith <[EMAIL PROTECTED]> wrote: > Hi all, > > Just wondering which full text module is better & what the differences > are between tsearch and fti ? Having only used tsearch/tsearch2 all I can say that it works as advertised and I am extremely happy with it. - Ian

[GENERAL] Case Sensitive problem

2006-03-15 Thread Erik Ferencz
Hi, I have got problems with case sensitive sort. My Postgre DB is Case sensitive but I need case insensitive. Could anyone help me,please. I don't know where or how to set this option.   Thanks.   Erik ferencz

[GENERAL] hi problem with installing postgresql8.1

2006-03-15 Thread VenuGopal Papasani
Hi all,    I am new to pgsql family.I had a problem with installing postgres8.1 i was getting the following error at the 4th step of installation the error is as follows:Data directory error:  The specified data directory is not empty    If you have an existing database with teh same major version

[GENERAL] Problems with Postgres and TCP/IP Protocol

2006-03-15 Thread Paulo
I installed recently the last version of Postgres, but I can't get to connect using any tcp/ip port. I tried many. Few time ago I used the NLite program and I remove the Secondary Logon service and the program always asks by this service. So, I installed no service. I tried no firewalls too and

[GENERAL] ERROR: FULL JOIN is only supported with merge-joinable join conditions

2006-03-15 Thread Harco de Hilster
Hi all, I am porting my application from Ingres to Postgres, and I have the following problem. I am not sure if this is a known limitation of Postgresql or a bug. My code works under Ingres but fails in Postgres with the following error: ERROR: FULL JOIN is only supported with merge-joinabl

[GENERAL] Can the PostgreSQL store the Multimedia files

2006-03-15 Thread senyorita . abeer
hallo, I am working with a group on a Gradute project and we use the PostgreSQL database for build an information system for a school. we have a small question: - Can the PostgreSQL store the Multimedia files ( Images ,video ,audio)??and exactly how?? - IF not , can we make some change in the s

Re: [GENERAL] PostgreSQL Free Visual Manager

2006-03-15 Thread Tony Caduto
I'm looking for a free or open source PostgreSQL visual manager (Linux or Windows). My aim is to quickly create and manage databases. The ability to export DB schema to file will be really useful for me. It's not free, but you can get PG Lightning Admin right now for 5 dollars and 1 dollar

Re: [GENERAL] PostgreSQL Free Visual Manager

2006-03-15 Thread Ycrux
Thanks guys, I'll give it a try cheers /youn Moises Alberto Lindo Gutarra a écrit : http://www.pgadmin.org/ 2006/3/15, Ycrux <[EMAIL PROTECTED]>: Hi Folks! I'm looking for a free or open source PostgreSQL visual manager (Linux or Windows). My aim is to quickly create and manage databases

[GENERAL] Remote Sync

2006-03-15 Thread Daniel Blaisdell
I am currently in a situation where I have a distributed application between a few remote nodes all connecting to a central database. I have been searching for a database replication or synchronization system that will allow a disconnected node to operate independently of the central database. The

Re: [GENERAL] PostgreSQL Free Visual Manager

2006-03-15 Thread Moises Alberto Lindo Gutarra
http://www.pgadmin.org/ 2006/3/15, Ycrux <[EMAIL PROTECTED]>: > Hi Folks! > > I'm looking for a free or open source PostgreSQL visual manager (Linux > or Windows). > > My aim is to quickly create and manage databases. The ability to export > DB schema to > file will be really useful for me. > > Th

[GENERAL] PostgreSQL Free Visual Manager

2006-03-15 Thread Ycrux
Hi Folks! I'm looking for a free or open source PostgreSQL visual manager (Linux or Windows). My aim is to quickly create and manage databases. The ability to export DB schema to file will be really useful for me. Thanks in advance /youn ---(end of broadcast)-

Re: [GENERAL] tsearch is slow

2006-03-15 Thread Scott Marlowe
On Wed, 2006-03-15 at 13:36, Abbath wrote: > Hello Richard, > > Wednesday, March 15, 2006, 3:35:26 PM, you wrote: > > If you want to force the data to be cached, just put a cron-job in to > > run a query for "abc" or whatever once a minute. > > I can't guess what the user want to search. But tha

Re: [GENERAL] tsearch is slow

2006-03-15 Thread Abbath
Hello Richard, Wednesday, March 15, 2006, 3:35:26 PM, you wrote: > Abbath wrote: >> is slow for the first time (7-15 sec), but then using the same keyword >> next time it is fast (10-100 ms). The reason is, as I read, first time >> it is not cached at all, but next time the index pages are >> cac

RES: [GENERAL] Creating a function that acept any data type

2006-03-15 Thread Alejandro Michelin Salomon \( Adinet \)
Thanks Michael and Tom. Y try put anyelement and the function works perfectly. Alejandro Michelin Salomon Porto Alegre Brasil -Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Em nome de Michael Fuhr Enviada em: sexta-feira, 10 de março de 2006 17:43 Para: Alejandro Mi

Re: [GENERAL] PostgreSQL Knowledge Base

2006-03-15 Thread Martijn van Oosterhout
On Wed, Mar 15, 2006 at 07:25:16PM +0100, Stephen Slezak wrote: > In the interim period while a central PostgreSQL community knowledge > base is being put together, Pervasive Software is opening up access > to our PostgreSQL Knowledge Base ( > http://www.pervasivepostgres.com/instantkb13/). Any int

Re: [GENERAL] Dumping rows into an array?

2006-03-15 Thread karly
On Wed, Mar 15, 2006 at 09:52:48AM -0500, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > I've been unable to come up with the counterpart to select the > > keywords and populate an array that I can return.. > > I think you want something along the lines of > > kwlist := array(select keyw

[GENERAL] PostgreSQL Knowledge Base

2006-03-15 Thread Stephen Slezak
In the interim period while a central PostgreSQL community knowledge base is being put together, Pervasive Software is opening up access to our PostgreSQL Knowledge Base ( http://www.pervasivepostgres.com/instantkb13/). Any interested person can submit a KB article on our web site ( http://www.

[GENERAL] psqlODBC Unicode 8.01.02.00 Driver "Overflows" On MS-Access Dates

2006-03-15 Thread Randy Yates
Hi Folks, I'm trying to export a table from my MS-Access database to my postgresql database. I downloaded and installed the 8.01.02.00 driver on my Win2k system, created the datasource. Then when I try to export my table to the datasource, I get a single-world message "overflow" and the export abo

Re: [GENERAL] encoding aliases

2006-03-15 Thread Martijn van Oosterhout
On Wed, Mar 15, 2006 at 11:33:25AM -0500, Vivek Khera wrote: > We're developing a DB that will be storing email messages. The clear > winner for the DB encoding is UTF8. However, I will need to set the > proper client encoding based on the encoding as defined in the email > message. Give

[GENERAL] Indexes on array columns

2006-03-15 Thread Brendan Duddridge
Hi,Is it possible to put an index on an array column?Thanks, Brendan Duddridge | CTO | 403-277-5591 x24 |  [EMAIL PROTECTED] ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB  T2G 0V9 http://www.clickspace.c

Re: [GENERAL] [pgsql-advocacy] Wisconsin Circuit Court Access (WCCA) on

2006-03-15 Thread Darcy Buskermolen
On Tuesday 14 March 2006 16:00, Kevin Grittner wrote: > >>> On Tue, Mar 14, 2006 at 2:08 am, in message > > <[EMAIL PROTECTED]>, Simon Riggs > > <[EMAIL PROTECTED]> wrote: > > On Mon, 2006- 03- 13 at 13:27 - 0600, Kevin Grittner wrote: > >> Even more important is the fast response we have had when

[GENERAL] encoding aliases

2006-03-15 Thread Vivek Khera
We're developing a DB that will be storing email messages. The clear winner for the DB encoding is UTF8. However, I will need to set the proper client encoding based on the encoding as defined in the email message. Looking at the docs (http://www.postgresql.org/docs/8.1/static/ multibyte

Re: [GENERAL] Five reasons why you should never use PostgreSQL -- ever

2006-03-15 Thread Thomas Hallgren
TJ O'Donnell wrote: Slashdot had this today. http://searchopensource.techtarget.com/originalContent/0,289142,sid39_gci1172668,00.html Interesting. JDBC is now a 'language'. Regards, Thomas Hallgren ---(end of broadcast)--- TIP 2: Don't 'kil

[GENERAL] Five reasons why you should never use PostgreSQL -- ever

2006-03-15 Thread TJ O'Donnell
Slashdot had this today. http://searchopensource.techtarget.com/originalContent/0,289142,sid39_gci1172668,00.html TJ O'Donnell www.gnova.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose

Re: [GENERAL] Inserting in psql - invalid byte sequence for encoding "UNICODE": 0xe9

2006-03-15 Thread Tom Lane
CSN <[EMAIL PROTECTED]> writes: > I created a new database with encoding UTF8, connected > using psql, and ensured the client encoding is also > UTF8 (Unicode). But when I try to insert characters > like 'é', I get this error: > ERROR: invalid byte sequence for encoding "UNICODE": > 0xe9 Whateve

Re: [GENERAL] Dumping rows into an array?

2006-03-15 Thread Tom Lane
[EMAIL PROTECTED] writes: > I've been unable to come up with the counterpart to select the > keywords and populate an array that I can return.. I think you want something along the lines of kwlist := array(select keyword from keywords where ...); regards, tom la

Re: [GENERAL] tsearch is slow

2006-03-15 Thread Richard Huxton
Abbath wrote: is slow for the first time (7-15 sec), but then using the same keyword next time it is fast (10-100 ms). The reason is, as I read, first time it is not cached at all, but next time the index pages are cached so it is fast. I think in a real word application, in this form, it is use

Re: [GENERAL] question about postgresql time intervals

2006-03-15 Thread Linda
According to the SQL standard, shouldn't this work? select '506:47:04'::interval day to second ; Is there a portable way to do this without using justify_hours()? - Thanks On Tuesday 14 March 2006 6:58 pm, Michael Glaesemann wrote: > You will get better, faster answers by sending questions to a

Re: [GENERAL] Wisconsin Circuit Court Access (WCCA) on

2006-03-15 Thread Stephen Frost
* Bruno Wolff III ([EMAIL PROTECTED]) wrote: > On Tue, Mar 14, 2006 at 23:27:24 -0500, > Stephen Frost <[EMAIL PROTECTED]> wrote: > > About which vendors they use and what contracts they have and you might > > be able to figure out which vendors have such a clause. I don't know > > that such a r

[GENERAL] tsearch is slow

2006-03-15 Thread Abbath
Hi, Recently I have tried TSearch2 (also on Linux and win with an Athlon64 3000+ machine). I have a table and I loaded some text files into it, so I have a row number, and a text column and there is a ts_vec column for tsvector. I created the gist index for ts_vec. The table has ~ 1 million record

Re: [GENERAL] Turn OFF Stats of Postgresql

2006-03-15 Thread Marcos
Hi Ycrux Thank very much for your help. Marcos Em Ter, 2006-03-14 às 21:28 +0100, Ycrux escreveu: > Ho Marcos! > You can also try to adpat this parameters to your config: > > TUNING: > * First, see: > http://www.lyris.com/lm_help/6.0/tuning_postgresql.html > > * Adjust this p

Re: [GENERAL] full text indexing

2006-03-15 Thread Oleg Bartunov
On Wed, 15 Mar 2006, chris smith wrote: Hi all, Just wondering which full text module is better & what the differences are between tsearch and fti ? if you need online indexing and linguistic support (dictionaries, stop words, ranking) tsearch2 is fine. If your data are static and you need

Re: [GENERAL] out of memory using Postgres with

2006-03-15 Thread Simon Riggs
On Tue, 2006-03-14 at 22:06 -0800, maarten roosendaal wrote: > We are currently having a problem that our Postgres DB > is throwing an SQL error which states that it's 'out > of memory'. > > What we have is a DB with 1 table that has 3.9 million > records. We need to find certain records that ar

Re: [GENERAL] full text indexing

2006-03-15 Thread Richard Huxton
chris smith wrote: Hi all, Just wondering which full text module is better & what the differences are between tsearch and fti ? The table in question has roughly 80,000 rows. I've been very happy with tsearch2. Note that if you're running an old version of PostgreSQL (7.4?) there are some ma

[GENERAL] full text indexing

2006-03-15 Thread chris smith
Hi all, Just wondering which full text module is better & what the differences are between tsearch and fti ? The table in question has roughly 80,000 rows. Thanks! -- Postgresql & php tutorials http://www.designmagick.com/ ---(end of broadcast)---

Re: [GENERAL] Inserting é in psql - inv

2006-03-15 Thread Richard Huxton
CSN wrote: I created a new database with encoding UTF8, connected using psql, and ensured the client encoding is also UTF8 (Unicode). But when I try to insert characters like 'é', I get this error: ERROR: invalid byte sequence for encoding "UNICODE": 0xe9 Something isn't UTF-8, possibly your

Re: [GENERAL] out of memory using Postgres with Spring/Hibernate/Java

2006-03-15 Thread Richard Huxton
maarten roosendaal wrote: Hi, We are currently having a problem that our Postgres DB is throwing an SQL error which states that it's 'out of memory'. What we have is a DB with 1 table that has 3.9 million records. We need to find certain records that are to be processed by a Java App so we do

Re: [GENERAL] pgsql and streams

2006-03-15 Thread Richard Huxton
Christopher Condit wrote: Thanks for your response, Josh. Actually I'm looking for the most general way to do this, since my remote database might not be psql. In fact, I will probably be streaming through a java process. So I'd like to go from the java process directly into the psql db. Is i

Re: [GENERAL] Inserting é

2006-03-15 Thread Martijn van Oosterhout
On Wed, Mar 15, 2006 at 01:33:56AM -0800, CSN wrote: > I created a new database with encoding UTF8, connected > using psql, and ensured the client encoding is also > UTF8 (Unicode). But when I try to insert characters > like 'é', I get this error: > > ERROR: invalid byte sequence for encoding "UN

[GENERAL] Inserting � in psql - invalid byte sequence for encoding "UNICODE": 0xe9

2006-03-15 Thread CSN
I created a new database with encoding UTF8, connected using psql, and ensured the client encoding is also UTF8 (Unicode). But when I try to insert characters like 'é', I get this error: ERROR: invalid byte sequence for encoding "UNICODE": 0xe9 Isn't this possible with psql? Hopefully it's not

Re: [GENERAL] out of memory

2006-03-15 Thread Antonis Antoniou
surabhi.ahuja wrote: hi i use postgres 8.0.0 i have a test program in c++, which tries to insert rows into the tables of my database. is there any way that i can check that there are no memory leaks etc happening. i ran valgrind on my test program that is not showing any mem leak, but are th

Re: [GENERAL] out of memory

2006-03-15 Thread surabhi.ahuja
Title: Re: [GENERAL] out of memory using Postgres with Spring/Hibernate/Java hi i use postgres 8.0.0 i have a test program in c++, which tries to insert rows into the tables of my database.   is there any way that i can check that there are no memory leaks etc happening.   i ran valgrind o

Re: [GENERAL] Error in Postgresql after a Machine Crash

2006-03-15 Thread Qingqing Zhou
""Paulo Henrique Oliveira"" <[EMAIL PROTECTED]> wrote > I was using postgres 7.2.1 in a Debian Woody server (in prodution). > The machine crashed and when I restart it the following error occurs a lot > in log. > 2006-03-14 14:35:23 [11858] ERROR: XLogFlush: request 102/7407C864 is not > satisfi