Re: Speaking of upgrades... (was Re: [GENERAL] Predicted ...)

2007-01-26 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/27/07 00:19, Martijn van Oosterhout wrote: > On Fri, Jan 26, 2007 at 10:16:39PM -0600, Ron Johnson wrote: >> What are your plans for reducing the number of resources needed to >> upgrade databases? > > As noted, the table structure changes only

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-01-26 Thread Tom Lane
Shane Ambler <[EMAIL PROTECTED]> writes: > Bill Moran wrote: >> Does the PostgreSQL project have any similar policy about EoLs? > There is no set time frame planned that I know of. No, there's no agreed-on policy. So far there's really only been one release that we've actively decided to decommi

Re: Speaking of upgrades... (was Re: [GENERAL] Predicted ...)

2007-01-26 Thread Martijn van Oosterhout
On Fri, Jan 26, 2007 at 10:16:39PM -0600, Ron Johnson wrote: > What are your plans for reducing the number of resources needed to > upgrade databases? As noted, the table structure changes only slightly between versions, if at all. What does change significantly is the catalog. Even now there have

Re: Speaking of upgrades... (was Re: [GENERAL] Predicted ...)

2007-01-26 Thread Joshua D. Drake
1. Cleanly shutdown pg. 2. Install v8.2. 3. Start pg. 4. psql -c 'REINDEX DATABASE' some_db >>> The changes are usually very subtle, like changes in the storage format >>> for certain data types, or bit changes in the row headers --- it isn't >>> something really of interest ex

Re: Speaking of upgrades... (was Re: [GENERAL] Predicted ...)

2007-01-26 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/26/07 21:48, Bruce Momjian wrote: > Ron Johnson wrote: >>> Yes: >>> >>> http://www.postgresql.org/docs/8.2/static/migration.html >> I was thinking of something like the release notes, but a bit more >> targeted. (I know. diff the source.) >

Re: Speaking of upgrades... (was Re: [GENERAL] Predicted ...)

2007-01-26 Thread Bruce Momjian
Ron Johnson wrote: > > Yes: > > > > http://www.postgresql.org/docs/8.2/static/migration.html > > I was thinking of something like the release notes, but a bit more > targeted. (I know. diff the source.) > > http://www.postgresql.org/docs/8.2/interactive/release-8-2.html > > For example, I

Re: Speaking of upgrades... (was Re: [GENERAL] Predicted ...)

2007-01-26 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/26/07 20:12, Bruce Momjian wrote: > Ron Johnson wrote: >>> There is no set time frame planned that I know of. >>> >>> It is more a matter of users that keep the old versions alive. Some with >>> large datasets on busy servers that can't allocate

Re: Speaking of upgrades... (was Re: [GENERAL] Predicted ...)

2007-01-26 Thread Bruce Momjian
Ron Johnson wrote: > > There is no set time frame planned that I know of. > > > > It is more a matter of users that keep the old versions alive. Some with > > large datasets on busy servers that can't allocate enough downtime to > > upgrade tend to be keeping the older versions running. > > How m

Re: [GENERAL] Speaking of upgrades...

2007-01-26 Thread Douglas McNaught
Ron Johnson <[EMAIL PROTECTED]> writes: > How much does the on-disk structure of *existing* tables and indexes > change between x.y versions? > > Between, for example, 8.0 and 8.2? Enough to require a dump/reload in order to upgrade. :) Within major versions (8.2.0, 8.2.1, etc) the files are co

Re: [GENERAL] Ayuda sobre Indices

2007-01-26 Thread Jaime Casanova
Si quieres escribir en español, por favor, escribe a [EMAIL PROTECTED] esta es una lista en ingles. Tu respuesta abajo... On 1/25/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Buen Dia. Por favor si saben como, me gustaria saber como puedo eliminar un indice PERO SOLO si este existe. Como va

Re: [GENERAL] Loop plpgsql recordset

2007-01-26 Thread George Weaver
On Thursday, January 25 Furesz Peter wrote: >How can I loop a PL/PgSQL recorset variable? The example: >DECLARE >v_tmp_regi RECORD; >v_tmp RECORD; >BEGIN > SELECT * INTO v_tmp_regi FROM sulyozas_futamido sf WHERE >sf.termekfajta_id= > a_termekfajta_id AND sf.mar

Speaking of upgrades... (was Re: [GENERAL] Predicted ...)

2007-01-26 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/26/07 17:28, Shane Ambler wrote: > Bill Moran wrote: >> I spend some time googling this and searching the Postgresql.org site, >> but >> I'm either not good enough with the search strings, or it's not to be >> found. >> >> I'm trying to plan upgr

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

2007-01-26 Thread Shane Ambler
Bill Moran wrote: I spend some time googling this and searching the Postgresql.org site, but I'm either not good enough with the search strings, or it's not to be found. I'm trying to plan upgrades so that we don't upgrade needlessly, but also don't get caught using stuff that nobody's supportin

Re: [GENERAL] [Fwd: [PORTS] M$ SQL server DTS package equivalent

2007-01-26 Thread Paul Lambert
Thanks all for your tips and pointers. Looking at copy I think it may do just what I need. The tables I load the data into have the same columns in the same order as those in the CSV file. Loading data in this manner is going to be a rare occurance - just when we install a new customer site an

Re: [GENERAL] PostgreSQL data loss

2007-01-26 Thread Joshua D. Drake
Scott Marlowe wrote: > On Fri, 2007-01-26 at 15:06, Bill Moran wrote: >> In response to BluDes <[EMAIL PROTECTED]>: > >>> Any suggestion? > >> In any event, refuse to ever do any business with him again. In my >> experience, these kinds of customers aren't worth the pennies they pay >> you. Als

Re: [GENERAL] PostgreSQL data loss

2007-01-26 Thread Scott Marlowe
On Fri, 2007-01-26 at 15:06, Bill Moran wrote: > In response to BluDes <[EMAIL PROTECTED]>: > > > > Any suggestion? > > In any event, refuse to ever do any business with him again. In my > experience, these kinds of customers aren't worth the pennies they pay > you. Also, refuse to give in.

Re: [GENERAL] Record not returned until index is rebuilt

2007-01-26 Thread Tom Lane
"Nik" <[EMAIL PROTECTED]> writes: > I have the following table definition in postgres 8.0: PG 8.0.what, exactly? > Why is it that the record is visible when bulk selected, but not when > selected as a part of the WHERE clause, and why is it that the index > rebuild and vacuum fixes the problem?

Re: [GENERAL] Sample C++ code using libpqxx/Postgresql sought

2007-01-26 Thread Reid Thompson
On Fri, 2007-01-26 at 12:16 -0800, [EMAIL PROTECTED] wrote: > I am looking for some sample code using the libpqxx (C++) API for > Postgresql. I have found some tutorials > > (http://thaiopensource.org/devprojects/libpqxx/doc/2.6.8/html/Tutorial/ > http://www.cs.wisc.edu/~ajkunen/libpqxx-2.4.2/Tut

Re: [GENERAL] PostgreSQL data loss

2007-01-26 Thread Bill Moran
In response to BluDes <[EMAIL PROTECTED]>: > Hi everyone, > I have a problem with one of my costomers. > I made a program that uses a PostgreSQL (win32) database to save its data. > My customer claims that he lost lots of data reguarding his own clients > and that those data had surely been sav

Re: [GENERAL] Can you specify the pg_xlog location from a config file?

2007-01-26 Thread Bill Bartlett
The Windows Server 2003 Resource Kit and WinXP Resource Kit (both free to download) both also provide the LINKD utility -- we use LINKD to create junctions on most of our Windows servers (to mimic the equivalent hard links we use on our Linux servers). - Bill > -Original Message- > From:

Re: [GENERAL] Installation on Web Server

2007-01-26 Thread Richard Hayward
Thanks for the advise folks. I've just installed postgresql in its entirety, but won't run it. Regards, Richard ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joini

[GENERAL] PostgreSQL data loss

2007-01-26 Thread BluDes
Hi everyone, I have a problem with one of my costomers. I made a program that uses a PostgreSQL (win32) database to save its data. My customer claims that he lost lots of data reguarding his own clients and that those data had surely been saved on the database. My first guess is that he is the o

[GENERAL] Sample C++ code using libpqxx/Postgresql sought

2007-01-26 Thread usenet
I am looking for some sample code using the libpqxx (C++) API for Postgresql. I have found some tutorials (http://thaiopensource.org/devprojects/libpqxx/doc/2.6.8/html/Tutorial/ http://www.cs.wisc.edu/~ajkunen/libpqxx-2.4.2/Tutorial/) and some references (http://thaiopensource.org/devprojects/l

[GENERAL] Record not returned until index is rebuilt

2007-01-26 Thread Nik
I have the following table definition in postgres 8.0: CREATE TABLE "userInfo" ( "userID" character varying(32) NOT NULL, "password" character varying(32) NOT NULL, salt character varying(16) NOT NULL, CONSTRAINT "userInfo_PK" PRIMARY KEY ("userID") ) ; Administrators are able to add new

[GENERAL] Installation on Web Server

2007-01-26 Thread Richard Hayward
I'm wanting to install PHP on a Apache/Linux server with support for PostgreSQL. It seems that I need to install PostgreSQL on the machine first, before the PHP installation will work. The way I've done this previously is simply to install PostgreSQL. However, the database server is in fact anoth

[GENERAL] Ayuda sobre Indices

2007-01-26 Thread julio . caicedo
Buen Dia. Por favor si saben como, me gustaria saber como puedo eliminar un indice PERO SOLO si este existe. Como valido si existe o no el indice para luego eliminarlo ?? Gracias. --- Please, i need drop index but ONLY and ONLY this exist index. Thanks. ---(en

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Jeremy Haile
Using standard build (none of the things you mentioned) on 8.2.1 currently. I really appreciate it! On Fri, 26 Jan 2007 21:24:09 +0100, "Magnus Hagander" <[EMAIL PROTECTED]> said: > Jeremy Haile wrote: > >> Applied to HEAD and 8.2 --- assuming the Windows buildfarm machines go > >> green, we sho

[GENERAL] Default fillfactor question (index types other than btree)

2007-01-26 Thread Tony Caduto
Does anyone know what the default fillfactor is for index types other than btree? I found in the docs that the default for btree is 90, but can't seem to find what it is for the other index types. Thanks in advance, Tony ---(end of broadcast)-

Re: [GENERAL] DBI support for pg native arrays?

2007-01-26 Thread Martijn van Oosterhout
On Fri, Jan 26, 2007 at 12:00:42PM +0100, Louis-David Mitterrand wrote: > Hello, > > For a "select array(...) as col1, col2, col3 from table" I'd like the DBI > driver to output col1 as a perl array instead of a scalar > "{res1,res2,etc.}" representation of it. > > Is that somehow possible? I l

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
Jeremy Haile wrote: >> Applied to HEAD and 8.2 --- assuming the Windows buildfarm machines go >> green, we should probably consider back-porting this to 8.1 and 8.0. > > Not trying to be a nuisance, but I'd really like to try this out in my > environment and see if my problems disappear. Is there

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Jeremy Haile
> Applied to HEAD and 8.2 --- assuming the Windows buildfarm machines go > green, we should probably consider back-porting this to 8.1 and 8.0. Not trying to be a nuisance, but I'd really like to try this out in my environment and see if my problems disappear. Is there anyone out there who could

[GENERAL] Postgresql Backup

2007-01-26 Thread bala
Hello frends! i am using postgresql database. I am using crond for daily backup. Following is the crontab entry, 29 17 * * 1-6 postgres /path/to/script.sh 'script.sh' contains PGUSER=postgres pg_dumpall > /path/to/backup_date.sql Running the script using crond creates the 0 byte files.

Re: [GENERAL] too many trigger records found for relation "item" -

2007-01-26 Thread Martijn van Oosterhout
On Fri, Jan 26, 2007 at 02:33:05PM +0100, Furesz Peter wrote: > I have the same problem yesterday. I got this error when I try to disable > the trigger in pg_catalog: > > UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid = > 'foobar'::pg_catalog.regclass'; Well duh. The error is precisely

[GENERAL] Loop plpgsql recordset

2007-01-26 Thread Furesz Peter
Hello, How can I loop a PL/PgSQL recorset variable? The example: DECLARE v_tmp_regi RECORD; v_tmp RECORD; BEGIN SELECT * INTO v_tmp_regi FROM sulyozas_futamido sf WHERE sf.termekfajta_id= a_termekfajta_id AND sf.marka_id=a_marka_id; DELETE FROM sulyoz

Re: [GENERAL] Postgresql Backup

2007-01-26 Thread Alan Hodgson
On Wednesday 24 January 2007 20:57, "bala" <[EMAIL PROTECTED]> wrote: > 'script.sh' contains > > PGUSER=postgres pg_dumpall > /path/to/backup_date.sql > > Running the script using crond creates the 0 byte files. > > But , If i run the script in console , it creates the file with > content. > >

[GENERAL] relationship in a table

2007-01-26 Thread Kai Schlamp
Hello! What is the best way to find out the relationship of two columns in a table? I want to know if it is 1:1, 1:N, or M:N. Is there an easy way to do this with a SQL statement? Best regards, Kai ---(end of broadcast)--- TIP 1: if posting/readin

[GENERAL] column limit

2007-01-26 Thread Isaac Ben
Hi, I'm trying to create a table with 20,000 columns of type int2, but I keep getting the error message that the limit is 1600. According to this message http://archives.postgresql.org/pgsql-admin/2001-01/msg00199.php it can be increased, but only up to about 6400. Can anyone tell me how to get

Re: [GENERAL] Problem with result ordering

2007-01-26 Thread Filip Rembiałkowski
2007/1/25, Thorsten Körner <[EMAIL PROTECTED]>: Hi, when I fire the following query: select m_id, m_u_id, m_title, m_rating from tablename where m_id in (26250, 11042, 16279, 42197, 672089); I will get the same results in the same order, as in in the next query: select m_id, m_u_id, m_title, m_

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > Attached patch seems to solve the problem on my machine at least. Uses > pgwin32_waitforsinglesocket() instead of pgwin32_select(). Changes > pgwin32_waitforsinglesocket() to accept the timeout as a parameter (this > is why it touches files outside of t

Re: [GENERAL] column limit

2007-01-26 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/26/07 13:37, Isaac Ben wrote: > On 1/26/07, Bruno Wolff III <[EMAIL PROTECTED]> wrote: >> On Thu, Jan 25, 2007 at 10:47:50 -0700, Isaac Ben >> <[EMAIL PROTECTED]> wrote: [snip] > > I plan on accessing the data with postgres via python and R. The

Re: [GENERAL] column limit

2007-01-26 Thread Isaac Ben
On 1/26/07, Bruno Wolff III <[EMAIL PROTECTED]> wrote: On Thu, Jan 25, 2007 at 10:47:50 -0700, Isaac Ben <[EMAIL PROTECTED]> wrote: > > The data is gene expression data with 20,000 dimensions. Part of the > project I'm working on is to discover what dimensions are truly > independent. But to

Re: [GENERAL] column limit

2007-01-26 Thread Bruno Wolff III
On Thu, Jan 25, 2007 at 10:47:50 -0700, Isaac Ben <[EMAIL PROTECTED]> wrote: > > The data is gene expression data with 20,000 dimensions. Part of the > project I'm working on is to discover what dimensions are truly > independent. But to start with I need to have > all of the data available in

Re: [GENERAL] Can you specify the pg_xlog location from a config

2007-01-26 Thread Adam Rich
You can also "mount" a partition as a directory under an existing drive letter, using the "disk management" utility built-in to windows. It's not as granular as the junction method, but there's a built-in gui for it, and its more widely known and used. -Original Message- From: "Jere

Re: [GENERAL] Installation on Web Server

2007-01-26 Thread Joshua D. Drake
Alan Hodgson wrote: >>> Is there some (easy !) way to install just the minimum parts of >>> PostgreSQL I need on the web server? > > In a sane distribution, you would just do something like "yum install > php php-pgsql", and that would pull in whatever bits of PostgreSQL are > required (shared l

Re: [GENERAL] Problem with result ordering

2007-01-26 Thread Ted Byers
Hi Ted, Hi Thorsten, Am Donnerstag, 25. Januar 2007 19:53 schrieb Ted Byers: The question I'd ask before offering a solution is, "Does the order of the id data matter, or is it a question of having all the results for a given id together before proceeding to the next id?" The answer to th

Re: [GENERAL] Can you specify the pg_xlog location from a config file?

2007-01-26 Thread Jeremy Haile
This utility is useful for creating junctions in Windows: http://www.microsoft.com/technet/sysinternals/FileAndDisk/Junction.mspx I am using this to "symlink" my pg_xlog directory to another disk and it works great. Jeremy Haile On Fri, 26 Jan 2007 18:27:04 +, "Roman Neuhauser" <[EMAIL PROT

Re: [GENERAL] Installation on Web Server

2007-01-26 Thread Alan Hodgson
> > Is there some (easy !) way to install just the minimum parts of > > PostgreSQL I need on the web server? In a sane distribution, you would just do something like "yum install php php-pgsql", and that would pull in whatever bits of PostgreSQL are required (shared libraries). -- "It's not a

Re: [GENERAL] Rollback using WAL files?

2007-01-26 Thread Karen Hill
On Jan 26, 9:45 am, [EMAIL PROTECTED] (Tom Lane) wrote: > Florian Weimer <[EMAIL PROTECTED]> writes: > > In theory, this should be possible (especially if you haven't switched > > off full page writes).Not really --- the WAL records are not designed to > > carry full > information about the prece

[GENERAL] Predicted lifespan of different PostgreSQL branches

2007-01-26 Thread Bill Moran
I spend some time googling this and searching the Postgresql.org site, but I'm either not good enough with the search strings, or it's not to be found. I'm trying to plan upgrades so that we don't upgrade needlessly, but also don't get caught using stuff that nobody's supporting any more. The Fre

Re: [GENERAL] Problem with result ordering

2007-01-26 Thread Thorsten Körner
Hi Ted, Am Donnerstag, 25. Januar 2007 19:53 schrieb Ted Byers: > The question I'd ask before offering a solution is, "Does the order of the > id data matter, or is it a question of having all the results for a given > id together before proceeding to the next id?" The answer to this will > deter

Re: [GENERAL] Rollback using WAL files?

2007-01-26 Thread Tom Lane
Florian Weimer <[EMAIL PROTECTED]> writes: > In theory, this should be possible (especially if you haven't switched > off full page writes). Not really --- the WAL records are not designed to carry full information about the preceding state of the page, so you can't use them to undo. (Example: a

Re: [GENERAL] Can you specify the pg_xlog location from a config file?

2007-01-26 Thread Tom Lane
"Karen Hill" <[EMAIL PROTECTED]> writes: > Windows doesn't support symlinks. Yes it does, at least in reasonably modern versions. They're called "junctions" or something like that. regards, tom lane ---(end of broadcast)---

Re: [GENERAL] Can you specify the pg_xlog location from a config

2007-01-26 Thread Dave Page
Karen Hill wrote: > Windows doesn't support symlinks. Is it possible instead for there to > be a config file that lets one set where the pg_xlog directory will sit? > You can use a junction point for this instead of a symlink. Google for utilities to create them. Regards, Dave.

Re: [GENERAL] Installation on Web Server

2007-01-26 Thread codeWarrior
In theory -- yes. In practicality -- no -- And yes... yopu are corerct -- postgreSQL needs to be installed PHP. YOu will find this to be the case with ANY dependencies in PHP, including things like jpeg supprt, curl, etc. So this is NOT a postgreSQL problem, not really anyway. This is realy a

Re: [GENERAL] Can you specify the pg_xlog location from a config file?

2007-01-26 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2007-01-26 09:21:27 -0800: > Windows doesn't support symlinks. Is it possible instead for there to > be a config file that lets one set where the pg_xlog directory will sit? Windows has junction points. -- How many Vietnam vets does it take to screw in a light bulb? You do

[GENERAL] Can you specify the pg_xlog location from a config file?

2007-01-26 Thread Karen Hill
Windows doesn't support symlinks. Is it possible instead for there to be a config file that lets one set where the pg_xlog directory will sit? ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Postgresql 8.1: plperl code works with LATIN1, fails with UTF8

2007-01-26 Thread Philippe Lang
Hi, I've got plperl code that works just fine when the database is encoded using LATIN1, but fails as soon as I switch to UTF8. I've been testing PG 8.1.4 under Linux, and PG 8.1.6 under FreeBSD, both behave exactly the save. I'm sorry I'm not able to strip down the code, and show you a small

Re: [GENERAL] Rollback using WAL files?

2007-01-26 Thread Florian Weimer
* M. A. Oude Kotte: > I'm running a production/development database using PostgreSQL 8.1 on a > Debian server. Due to some bad code in one of our applications who use > this database, some of the data was modified incorrectly the last few > days. The idea is that I would like to restore the entire

Re: [GENERAL] too many trigger records found for relation "item" -

2007-01-26 Thread Tom Lane
Csaba Nagy <[EMAIL PROTECTED]> writes: > And BTW, I have seen something similar while creating temporary tables > which should not conflict even with the same table name I think... I've heard reports of that, but never been able to duplicate it ... regards, tom lane -

Re: [GENERAL] triggers vs b-tree

2007-01-26 Thread Tomas Vondra
> Hello I have a design question: > > I have a table representing Families, and a table representing Persons. > The table Family have a row family_id as primary key. > The table Person have a row person_id as primary key and contain also a > row family_id. > As you can understand, the row family_

Re: [GENERAL] [Fwd: [PORTS] M$ SQL server DTS package equivalent in

2007-01-26 Thread Jeremy Haile
I've also used Pentaho Data Integration (previously known as Kettle) quite extensively, and can recommend it. It supports many different databases and has fairly good documentation (although thin in some areas). It has a GUI drag-and-drop tool that can be used to configure transformations and is

Re: [GENERAL] [Fwd: [PORTS] M$ SQL server DTS package equivalent in Postgres]

2007-01-26 Thread Tomi N/A
Besides being easy to schedule and very flexible, manipulating data with queries is extremely powerful and fairly easy to maintain assuming you know a little SQL -- thanks to postgresql's huge array of built in string manipulation functions. Your skills learned here will pay off using the databas

Re: [GENERAL] "no unpinned buffers available" ? why? (hstore and plperl involved)

2007-01-26 Thread Tom Lane
Dave Cramer <[EMAIL PROTECTED]> writes: > I've also got a customer getting this error message. > the OS is OSX 10.3 they are using plpgsql, and shared buffers is set > very low > shared_buffers = 16 Well, the answer to that is "if it hurts, don't do that". You couldn't expect to process more

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Jeremy Haile
> We have had lots of reports of issues with the stats collector on > Windows. Some were definitly fixed by the patch by O&T, but I don't > think all. Here were a couple of other reports I found: http://archives.postgresql.org/pgsql-hackers/2006-09/msg00415.php http://archives.postgresql.org/pgsql

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Fri, Jan 26, 2007 at 09:55:39AM -0500, Tom Lane wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: > > Apparantly there is a bug lurking somewhere in pgwin32_select(). Because > > if I put a #undef select right before the select in pgstat.c, the > > regression tests pass. > > I guess the bug

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > Apparantly there is a bug lurking somewhere in pgwin32_select(). Because > if I put a #undef select right before the select in pgstat.c, the > regression tests pass. > I guess the bug is shown because with row level stats we simply have > more data to

Re: [GENERAL] Rollback using WAL files?

2007-01-26 Thread Merlin Moncure
On 1/26/07, M.A. Oude Kotte <[EMAIL PROTECTED]> wrote: Now I've found the WAL files in the pg_xlog directory, and started browsing around for documentation on what I can do with those. But all I can find is that you can use them to restore your database after a crash or a custom backup. But I wou

Re: [GENERAL] [Fwd: [PORTS] M$ SQL server DTS package equivalent in Postgres]

2007-01-26 Thread Merlin Moncure
On 1/26/07, Tomi N/A <[EMAIL PROTECTED]> wrote: 2007/1/23, Paul Lambert <[EMAIL PROTECTED]>: > Is there an equivalent in Postgres to the DTS Packages available in M$ > SQL server. what you're looking for exists in a number of variations. You can use a good text editor with the postgres' COPY c

[GENERAL] large document multiple regex

2007-01-26 Thread Merlin Moncure
Hello, I am receiving a large (300k+_ document from an external agent and need to reduce a few interesting bits of data out of the document on an insert trigger into separate fields. regex seems one way to handle this but is there any way to avoid rescanning the document for each regex. One sol

Re: [GENERAL] "no unpinned buffers available" ? why? (hstore and plperl involved)

2007-01-26 Thread Dave Cramer
Tom, I've also got a customer getting this error message. the OS is OSX 10.3 they are using plpgsql, and shared buffers is set very low shared_buffers = 16 Dave On 3-Jan-07, at 10:19 AM, Tom Lane wrote: "hubert depesz lubaczewski" <[EMAIL PROTECTED]> writes: and - after some time of

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Alvaro Herrera
Jeremy Haile wrote: > Magnus - thanks for your investigation and work! Any chance I could get > a patched exe for win32 and test on my servers? In the meantime, could you please confirm that turning row_level_stats off makes the regression test pass? And whatever tests you were doing? (Note tha

Re: [GENERAL] too many trigger records found for relation "item" -

2007-01-26 Thread Furesz Peter
I have the same problem yesterday. I got this error when I try to disable the trigger in pg_catalog: UPDATE pg_catalog.pg_class SET reltriggers = 0 WHERE oid = 'foobar'::pg_catalog.regclass'; But if I disabling the trigger using this syntax: "ALTER TABLE tablename DISABLE TRIGGER triggername"

Re: [GENERAL] trigger question

2007-01-26 Thread Furesz Peter
Hello, maybe I have found a better solution. In PostgreSQL 8.2 this current solution is not working properly, because I got "too many triggers on table tablename" error. This is the first thing. The second problem that if something go wrong between the disable and re-enable the trigger, the trigge

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Jeremy Haile
> > > >Apparantly there is a bug lurking somewhere in pgwin32_select(). Because > > > >if I put a #undef select right before the select in pgstat.c, the > > > >regression tests pass. > > > > > > May be, problem is related to fixed bug in pgwin32_waitforsinglesocket() ? > > > WaitForMultipleObject

Re: [GENERAL] [Fwd: [PORTS] M$ SQL server DTS package equivalent in Postgres]

2007-01-26 Thread Tomi N/A
2007/1/23, Paul Lambert <[EMAIL PROTECTED]>: G'day, Is there an equivalent in Postgres to the DTS Packages available in M$ SQL server. I use these in SQL server to pre-load data from CSV files prior to enabling replication from my primary application. Any pointers on where best to go for this

[GENERAL] Rollback using WAL files?

2007-01-26 Thread M.A. Oude Kotte
Hi all! First of all I'm new to this list, please be gentle :-) Next I'd like to mention that I've already searched the documentation and the archives, but couldn't find the answer to my question. I'm running a production/development database using PostgreSQL 8.1 on a Debian server. Due to some b

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Fri, Jan 26, 2007 at 12:26:58PM +0100, Magnus Hagander wrote: > On Fri, Jan 26, 2007 at 01:11:00PM +0300, Teodor Sigaev wrote: > > >Apparantly there is a bug lurking somewhere in pgwin32_select(). Because > > >if I put a #undef select right before the select in pgstat.c, the > > >regression test

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Fri, Jan 26, 2007 at 01:11:00PM +0300, Teodor Sigaev wrote: > >Apparantly there is a bug lurking somewhere in pgwin32_select(). Because > >if I put a #undef select right before the select in pgstat.c, the > >regression tests pass. > > May be, problem is related to fixed bug in pgwin32_waitfors

[GENERAL] DBI support for pg native arrays?

2007-01-26 Thread Louis-David Mitterrand
Hello, For a "select array(...) as col1, col2, col3 from table" I'd like the DBI driver to output col1 as a perl array instead of a scalar "{res1,res2,etc.}" representation of it. Is that somehow possible? I looked at the docs without finding anything. Thanks, ---(end

Re: [GENERAL] triggers vs b-tree

2007-01-26 Thread Joris Dobbelsteen
I believe you should design it in a slightly different way: >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >gustavo halperin >Sent: donderdag 25 januari 2007 21:34 >To: pgsql-general@postgresql.org >Subject: [GENERAL] triggers vs b-tree > >Hello I ha

Re: [GENERAL] Duplicate key violation

2007-01-26 Thread Joris Dobbelsteen
>-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Brian Wipf >Sent: donderdag 25 januari 2007 22:42 >To: pgsql-general@postgresql.org >Subject: [GENERAL] Duplicate key violation > >I got a duplicate key violation when the following query was performed: >

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Teodor Sigaev
Apparantly there is a bug lurking somewhere in pgwin32_select(). Because if I put a #undef select right before the select in pgstat.c, the regression tests pass. May be, problem is related to fixed bug in pgwin32_waitforsinglesocket() ? WaitForMultipleObjectsEx might sleep indefinitely while wa

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Thu, Jan 25, 2007 at 04:29:58PM -0500, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Jeremy Haile wrote: > >> If anyone else is experiencing similar problems, please post your > >> situation. > > > All the Windows buildfarm machines are, apparently. > > Can't anyone with a d

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Thu, Jan 25, 2007 at 04:29:58PM -0500, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Jeremy Haile wrote: > >> If anyone else is experiencing similar problems, please post your > >> situation. > > > All the Windows buildfarm machines are, apparently. > > Can't anyone with a d

Re: [GENERAL] Stats collector frozen?

2007-01-26 Thread Magnus Hagander
On Thu, Jan 25, 2007 at 04:29:58PM -0500, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > Jeremy Haile wrote: > >> If anyone else is experiencing similar problems, please post your > >> situation. > > > All the Windows buildfarm machines are, apparently. > > Can't anyone with a d

Re: [GENERAL] too many trigger records found for relation "item" -

2007-01-26 Thread Csaba Nagy
> [snip] I believe this is fixed as of 8.2 --- can you duplicate it > there? (No, backpatching the fix is not practical.) No, I was not able to duplicate it on 8.2, so I think it's fixed (given that on 8.1 the errors are triggered almost 100% of the runs). > How sure are you about that uninterlo