Re: [GENERAL] Regex with patterns in table field

On 4/14/06, pgdb <[EMAIL PROTECTED]> wrote: > > > Hi Andreas, > > strange but I don't see html from my original email received from the > mailing list, hope this reply is ok:) > > If I'm not wrong, the example you've provided is trying to return matching > rows from multiple patterns and texts as i

Re: [GENERAL] Regex with patterns in table field

Hi Andreas,   strange but I don't see html from my original email received from the mailing list, hope this reply is ok:)   If I'm not wrong, the example you've provided is trying to return matching rows from multiple patterns and texts as inputs in the regex search.   The text in regular _expres

Re: [GENERAL] Off-Topic: DBMS Market Research

Renato Cramer wrote: Can someone where I can found DBMS Market Researches? What institutes publish reliable researchs? Gartner, IDC? Note it's hard for any company to provide reliable research that spans both open-source and non-open-source products. For example, one company I'm familiar with

Re: [GENERAL] Where is client/server compatibility documented?

On Thu, 2006-04-13 at 15:06, Wes wrote: > Where can I find documentation on what client library version interoperate > with which server versions? I've been unable to find anything in the manual > or archives. The only thing I've found is some information in the archives > on certain psql version

[GENERAL] Where is client/server compatibility documented?

Where can I find documentation on what client library version interoperate with which server versions? I've been unable to find anything in the manual or archives. The only thing I've found is some information in the archives on certain psql versions. Is there a compatibility matrix somewhere fo

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

Maybe add to it the insert/update data in tables based on an XML (a'la MS updategram) Balázs ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] corrupted item pointer:???

"hubert depesz lubaczewski" <[EMAIL PROTECTED]> writes: > On 4/13/06, Tom Lane <[EMAIL PROTECTED]> wrote: >> AFAICS, the only non-index-related occurrence of that error message >> is in PageRepairFragmentation, which is invoked by VACUUM. I'd say >> it indicates a real problem and you shouldn't ig

Re: [GENERAL] corrupted item pointer:???

On 4/13/06, Tom Lane <[EMAIL PROTECTED]> wrote: "hubert depesz lubaczewski" <[EMAIL PROTECTED]> writes:> On 4/13/06, Richard Huxton wrote:>> Hmm - I believe that means a data/index block was corrupted. > indices were recreated (reindex table), so i think this is data related> pro

Re: [GENERAL] corrupted item pointer:???

On 4/13/06, Richard Huxton wrote: All looks fine. Can you isolate the row(s) in question that seem to bethe problem? Then we can have a look at the system columns.http://www.postgresql.org/docs/8.1/static/ddl-system-columns.html i ran the test to find it. as soon as i will get it

Re: [GENERAL] the integer type

Tony Just a thought. I have spent the last couple of weeks googling for admin tools for Postgres - and never came across yours! Zahir > > > > > PG Lightning Admin was created with input from several MS SQL server > DBAs who just absolutely detested pgAdmin III. > We where converting a large

Re: [GENERAL] the integer type

Zahir Lalani wrote: This is exactly how I felt - It made me wonder whether I should go back to MS SQL - the whole UI experience is much better. But now that I have seen lightning - hopefully it will get easier. Also, I was trying to connect this to ColdFusion/Dreamweaver. Since the field was def

Re: [GENERAL] the integer type

This is exactly how I felt - It made me wonder whether I should go back to MS SQL - the whole UI experience is much better. But now that I have seen lightning - hopefully it will get easier. Also, I was trying to connect this to ColdFusion/Dreamweaver. Since the field was defined as int4, Coldfusi

Re: [GENERAL] the integer type

Dave Page wrote: Which allows you to use any custom datatype or domain that you like. double precision == float8 (http://www.postgresql.org/docs/8.1/interactive/datatype.html) which works just fine. Regards, Dave. Actually if you try and type in integer in the combobox, it accepts the

Re: [GENERAL] the integer type

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto > Sent: 13 April 2006 16:19 > To: chris smith > Cc: Zahir Lalani; pgsql-general@postgresql.org > Subject: Re: [GENERAL] the integer type > > It's not a error, pgAdmin III simply does no

Re: [GENERAL] browser shows garbage instead of UTF-8 characters

On Thursday 13 April 2006 13:12, Sadm sadm wrote: >Hello! >I have a PostgreSQL database with UTF-8 encoding. It stores russian > characters. When I fetch a record from this database and output it to > the web browser as html page, it looks like a garbage instead of > normal russian characters. I'm

Re: [GENERAL] the integer type

chris smith wrote: What error do you get? I'm sure pgAdmin will show something. Try it from console: psql.exe dbname create table t1(a int); (Always CC the list, someone else might be able to help you if I don't know the answer). It's not a error, pgAdmin III simply does not display the wo

Re: [GENERAL] export from views

On Apr 13, 2006, at 23:58 , Tomas Lanczos wrote: Is there any convenient and simple method/tool to export data from views to file, something like COPY TO (file) from a table? In psql, take a look at \o (and \? while you're at it). Hope this helps. Michael Glaesemann grzm myrealbox com

[GENERAL] export from views

Hello everybody, I am quite a newbie in the database business, so sorry for stupid questions. Is there any convenient and simple method/tool to export data from views to file, something like COPY TO (file) from a table? I am using WinXP and Postgresql 8.1. Many thanks in advance Tomas ---

Re: [GENERAL] posting request

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 chris smith wrote: >We don't bite :) > > much. :-D - -- Peter L. Berghold [EMAIL PROTECTED] "Those who fail to learn from history are con

Re: [GENERAL] corrupted item pointer:???

"hubert depesz lubaczewski" <[EMAIL PROTECTED]> writes: > On 4/13/06, Richard Huxton wrote: >> Hmm - I believe that means a data/index block was corrupted. > indices were recreated (reindex table), so i think this is data related > problem. AFAICS, the only non-index-related occurrence of that e

Re: [GENERAL] table as hashtable

Anton Andreev wrote: Hi, Can I use a Postgre table as hashtable\\? It's PostgreSQL or Postgres, BTW when I do select where column='test', I want this to be done by hashtable, not linear, not by b-tree. I do not need to sort, sum or else I just want to get the value as fast as possible. T

Re: [GENERAL] corrupted item pointer:???

hubert depesz lubaczewski wrote: On 4/13/06, Richard Huxton wrote: Hmm - I believe that means a data/index block was corrupted. indices were recreated (reindex table), so i think this is data related problem. Have you seen any crashes, or hardware-related errors in your logs? nope. uptime i

Re: [GENERAL] the integer type

On 4/14/06, Zahir Lalani <[EMAIL PROTECTED]> wrote: > Hi Chris > > I am using pgAdmin III. > > Created a table, then started adding fields. This is where the problem > hits - the drop down does not give you an INTEGER option, so you cannot > shoose it. > Also I tried creating a script in the query

Re: [GENERAL] Select first ten of each category?

On Wed, 12 Apr 2006, Benjamin Smith wrote: > I'm stumped on this one... > > I have a table defined thusly: > > create table items ( > id serial, > category integer not null references category(id), > name varchar not null, > price real, > unique(category, name)); I think this should work

Re: [GENERAL] [HACKERS] RH9 postgresql 8.0.7 rpm

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Devrim GUNDUZ wrote: > Hi, > > On Wed, 2006-04-12 at 13:07 +0200, Gaetano Mendola wrote: >> I was able to create it with: >> >> --nodeps --define 'buildrhel3 1' --define 'build9 1' > > I'll be hppy if you send the RPMs directly to me; so that I can

[GENERAL] table as hashtable

Hi, Can I use a Postgre table as hashtable\\? when I do select where column='test', I want this to be done by hashtable, not linear, not by b-tree. I do not need to sort, sum or else I just want to get the value as fast as possible. 10x to anyone answering me Cheers, Anton ---

Re: [GENERAL] how to prevent generating same clipids

This problem has been solved, by the use of sequences. If you can't use them as a default, you can use them instead of MAX(clipid) You would use NEXTVAL(clipid_seq) assuming you had first done CREATE SEQUENCE clipid_seq; SELECT SETVAL('clipid_seq', (select MAX(clipid) from whatevertable)); T

Re: [GENERAL] the integer type

> I have only recently started to use Postgresql and have a problem. I am > using v8.1 on windows. > I cannot seem to get the DB to accept either INT or INTEGER as a type > when using the admin tool. Only INT2 or INT4 work. > I even downloaded Navicat trial and this has the same issue. Is there a >

Re: [GENERAL] browser shows garbage instead of UTF-8 characters

Sadm,what is the encoding setting of your database driver?What happens if you put out the retrieved Data to a console or a debug window?Have you analyzed the garbage, what is it? Escaped Characters? Hungarian? Arabian? Chinese?? How do you "fetch a record", how do you output it to "THE" "Web browse

Re: [GENERAL] posting request

On 4/13/06, Anton Andreev <[EMAIL PROTECTED]> wrote: > > I want to post some questions. Go ahead and post them :) We don't bite :) -- Postgresql & php tutorials http://www.designmagick.com/ ---(end of broadcast)--- TIP 1: if posting/reading throu

Re: [GENERAL] Is a high tab_reloid worrying?

Thanks for the reassurance. You're right the db has been around for a while. Doea anyone know if OIDs for data and system (DDL) objects from the same number generator? John Christopher Browne wrote: In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (John Sidney-Woollet

[GENERAL]

Hello! I have a PostgreSQL database with UTF-8 encoding and Resin application server. When I fetch a record from database using jdbc connection and output it to the web browser as html page, it looks like a garbage instead of normal russian characters. html is set. Please help me to find a mis

Re: [GENERAL] case insensitive match in unicode

This perl function doesn't work for me. I keep getting a Cannot decode string with wide characters at /usr/lib/perl5/5.8.7/i386-linux/Encode.pm line 166 error Do you have any suggestion? Thanks Balázs ---(end of broadcast)--- TIP 1: if posting/read

[GENERAL] posting request

I want to post some questions. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] browser shows garbage instead of UTF-8 characters

Hello! I have a PostgreSQL database with UTF-8 encoding. It stores russian characters. When I fetch a record from this database and output it to the web browser as html page, it looks like a garbage instead of normal russian characters. I'm using html with . Please help me to find a mistake. T

[GENERAL] the integer type

Hello All I have only recently started to use Postgresql and have a problem. I am using v8.1 on windows. I cannot seem to get the DB to accept either INT or INTEGER as a type when using the admin tool. Only INT2 or INT4 work. I even downloaded Navicat trial and this has the same issue. Is there a

Re: [GENERAL] Regex with patterns in table field

am 13.04.2006, um 12:47:38 + mailte pgdb folgendes: > > > > > Hi, >   > like to know how, if possible, for patterns > as attribute in a table to be used in a regex search with a > fixed string. The query should therefore return the rows that > have matching patterns with the single text.

Re: [GENERAL] How to compile PostGreSQL on Windows 64 bits ?

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > DANTE ALEXANDRA > Sent: 13 April 2006 14:02 > To: pgsql-general@postgresql.org > Cc: DANTE ALEXANDRA > Subject: [GENERAL] How to compile PostGreSQL on Windows 64 bits ? > > Hello List, > > After

[GENERAL] How to compile PostGreSQL on Windows 64 bits ?

Hello List, After having compiled and installed PostGreSQL on IA64, Red Hat Enterprise Linux 4 AS, I had to do the same thing on Windows 64 bits... I have read that PostGreSQL wasn't test on Windows 64 bits, is it still correct ? My problem is to find how obtain an Unix/Linux environnement co

[GENERAL] Regex with patterns in table field

Hi,   like to know how, if possible, for patterns as attribute in a table to be used in a regex search with a fixed string. The query should therefore return the rows that have matching patterns with the single text.   Regards pgdb Free POP3 Email from www.gawab

Re: [GENERAL] Is a high tab_reloid worrying?

In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (John Sidney-Woollett) transmitted: > I just added a new table to a slony relication set. The new table > seems to have a really high tab_reloid value of 94,198,669 I presume the database instance has been around for a while?

Re: [GENERAL] unattened dump

Martijn van Oosterhout scrisse in data 04/13/06 10:47: On Thu, Apr 13, 2006 at 10:35:55AM +0200, Paolo Sala wrote: Hi all I am a newbe in postgres and I'm trying to obtain an unattended dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I havn't found a way to pass a pas

Re: [GENERAL] corrupted item pointer:???

On 4/13/06, Richard Huxton wrote: Hmm - I believe that means a data/index block was corrupted.indices were recreated (reindex table), so i think this is data related problem.  Have you seen any crashes, or hardware-related errors in your logs?nope. uptime is over 40 days.the mach

Re: [GENERAL] corrupted item pointer:???

hubert depesz lubaczewski wrote: hi. basic information: machine: desktop computer, with sata hard drive, no bad blocks. 2g ram.AMD Sempron(tm) Processor 2600+ system: linux debian testing, using 2.6.11 kernel. postgresql: 8.1.3 compiled by hand using: ... version() -> PostgreSQL 8.1.3 on i68

Re: [GENERAL] [Slony1-general] Is a high tab_reloid worrying?

My tables are defined "WITHOUT OID" - does that make a difference? John Hannu Krosing wrote: Ühel kenal päeval, N, 2006-04-13 kell 10:06, kirjutas John Sidney-Woollett: I just added a new table to a slony relication set. The new table seems to have a really high tab_reloid value of 94,198,669

[GENERAL] corrupted item pointer:???

hi.basic information:machine: desktop computer, with sata hard drive, no bad blocks. 2g ram.AMD Sempron(tm) Processor 2600+system: linux debian testing, using 2.6.11 kernel.postgresql: 8.1.3 compiled by hand using: ./configure \    --prefix=/home/pgdba/work \    --without-debug \    --d

Re: [GENERAL] [Slony1-general] Is a high tab_reloid worrying?

Ühel kenal päeval, N, 2006-04-13 kell 10:06, kirjutas John Sidney-Woollett: > I just added a new table to a slony relication set. The new table seems > to have a really high tab_reloid value of 94,198,669 ... > Is this something I should be worried about? Can I find out where all > the intermedia

[GENERAL] Is a high tab_reloid worrying?

I just added a new table to a slony relication set. The new table seems to have a really high tab_reloid value of 94,198,669 I'm using Slon 1.1.5 with pg 7.4.6 and 7.4.11 on unix On the master I see (wcprogallery is the new table added to set 4) tab_id|tab_reloid|tab_relname |tab_nspname|tab_

Re: [GENERAL] unattened dump

On Thu, Apr 13, 2006 at 10:35:55AM +0200, Paolo Sala wrote: > Hi all I am a newbe in postgres and I'm trying to obtain an unattended > dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I > havn't found a way to pass a password in a unattended way. So I have to > guess the on

Re: [GENERAL] how can I create the DML for an existing database - within an application

  From: Harald Armin Massa [mailto:[EMAIL PROTECTED] Sent: 13 April 2006 09:37To: Dave PageSubject: Re: [GENERAL] how can I create the DML for an existing database - within an application Dave, >> AFAIK, pgadmin opens a pipe to pg_dump.Yes, when creating an actua

[GENERAL] unattened dump

Hi all I am a newbe in postgres and I'm trying to obtain an unattended dump to pgsql. I mean, I've tryed to use pg_dump using the -U flag but I havn't found a way to pass a password in a unattended way. So I have to guess the only solution is to configure pg_hba.conf to use ident as authenticat

Re: [GENERAL] how can I create the DML for an existing database - within an application

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Magnus Hagander > Sent: 13 April 2006 08:40 > To: Harald Armin Massa; pgsql-general > Subject: Re: [GENERAL] how can I create the DML for an > existing database - within an application > > > I w

Re: [GENERAL] how can I create the DML for an existing database - within an application

> I want to get the output from > > pg_dump --struct-only --table=whatever > > inside a programm. Of course I could call pg_dump in a > seperate process and capture the output and all; but ... > > as PGAdmin is doing it someway, I strongly suspect there is a > kind of call to recreate the DML