Re: [GENERAL] warm standby server stops doingcheckpointsafterawhile

2007-06-01 Thread Frank Wittig
Teodor Sigaev schrieb: Hope, attached patch fix that. Pls, test it. It still happens. The log is full of incomplete split dumps: 2007-06-01 23:00:00.001 CEST:% LOG: GIN incomplete splits=8 2007-06-01 23:00:00.001 CEST:% CONTEXT: xlog redo checkpoint: redo D0/28020F48; undo 0/0; tli 1; xid

[GENERAL] warm standby server stops doing checkpoints after a while

2007-05-31 Thread Frank Wittig
cause this behavior of the slave server? Could upgrading to 8.2.4 help? - I didn't find something related in the release notes. Could this be a bug? Greetings, Frank Wittig signature.asc Description: OpenPGP digital signature

Re: [GENERAL] warm standby server stops doing checkpoints after a while

2007-05-31 Thread Frank Wittig
as soon as I can get me a maintenance window for this. Greetings, Frank Wittig signature.asc Description: OpenPGP digital signature

Re: [GENERAL] Anyone know a good opensource CRM that actually installs with Posgtres?

2007-05-07 Thread Frank Finner
You mention Compier not running on PG. Did you look ad ADempiere (http://www.adempiere.com/)? Its a fork of Compiere which claims to run especially with PG (though I did not yet have the time to test it). Regards, Frank. On 4 May 2007 20:07:17 -0700 syaskin [EMAIL PROTECTED] thought long

[GENERAL] rpm containing pgdump

2007-03-01 Thread Frank Church
Which of the postgresql rpms contains pgdump. I have downloaded postgresql-server and postgresql-libs and pgdump is not included. Which rpm contains it? /frank ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] open source - content management system - that uses PostGreSQL

2007-02-20 Thread Frank Miles
One nice CMS package -- it doesn't force you to use Postgresql, but that is (IIRC) the default -- and python: http://www.djangoproject.com/ HTH-- -frank ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] How to force disconnections from a Perl script?

2007-02-19 Thread Frank Finner
these processes (just kill, not with -9). If there are no demons lurking behind them reestablishing the connections, this is a quite reliable way to get rid of connections in a graceful way. Regards, Frank. On Mon, 19 Feb 2007 11:10:55 -0500 Kynn Jones [EMAIL PROTECTED] thought long, then sat down

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Frank Finner
postgres, and to initialize the whole thing. If Cpanel cannot do this for you, don't blame PostgreSQL for the problems of Cpanel! Regards, Frank. On Wed, 24 Jan 2007 01:31:23 +0800 Erick Papadakis [EMAIL PROTECTED] thought long, then sat down and wrote: Correct. Also you will find nearly

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Frank Finner
How about using updatedb before using whereis or locate? Regards, Frank. On Wed, 24 Jan 2007 01:18:20 +0800 Erick Papadakis [EMAIL PROTECTED] thought long, then sat down and wrote: Where is pg_hba.conf? I tried find and whereis commands, but could not find it. Thanks for any pointers

Re: [GENERAL] Get SQL dump from readonly FS

2007-01-18 Thread Frank Wittig
. Greetings, Frank Hannes Dorbath [EMAIL PROTECTED] [18.01.2007 09:29]: Background is that I like to create a SQL dump from file system snapshot. I guess the answer is a plain No. ;) pgpUTy0ZX3RMm.pgp Description: PGP signature

Re: [GENERAL] slow speeds after 2 million rows inserted

2006-12-29 Thread Frank Finner
not occur. Maybe some buffer chokes if the transaction ist too big. In your case I'd recommend to commit after every one or two million rows (if possible). Regards, Frank. On Fri, 29 Dec 2006 12:39:03 -0500 James Neff [EMAIL PROTECTED] thought long, then sat down and wrote: Greetings, Ive

Re: [GENERAL] slow speeds after 2 million rows inserted

2006-12-29 Thread Frank Finner
In Java, assuming you have a Connection c, you simply say c.commit(); after doing some action on the database. After every commit, the transaction will be executed and closed and a new one opened, which runs until the next commit. Regards, Frank. On Fri, 29 Dec 2006 13:23:37 -0500 James Neff

Re: [GENERAL] postgresql /var fill

2006-10-06 Thread Frank Finner
Maybe you switched full statement logging on in postgresql.conf? This can result in a considerable amount of logfile data in /var/log/somewhere, often /var/log/postgresql/ (although 15 GB is really quite a lot). Regards, Frank. On Fri, 6 Oct 2006 19:10:12 +0530 km [EMAIL PROTECTED] thought

[GENERAL] uConnect Voip

2006-09-07 Thread Frank Church
Does this device allow connection to other phones besides Skype, like Xten Xlite? http://www.voipvoice.com/UConnect-2.html. Compatibility with standard voip is not mentioned on their website? ---(end of broadcast)--- TIP 1: if posting/reading

Re: [GENERAL] uConnect Voip

2006-09-07 Thread Frank Church
Sorry, I realized that. On 9/7/06, Jan de Visser [EMAIL PROTECTED] wrote: On Thursday 07 September 2006 11:38, Frank Church wrote: Does this device allow connection to other phones besides Skype, like Xten Xlite? http://www.voipvoice.com/UConnect-2.html. Compatibility with standard voip

Re: [GENERAL] Syntax for converting double to a timestamp

2006-09-05 Thread Frank Church
On 9/5/06, codeWarrior [EMAIL PROTECTED] wrote: It's generally considered bad form to use reserved words as column names I am aware of that - in this case the column names are chosen to reflect exactly the names of the attributes of the event being recorded. Frank Church [EMAIL

Re: [GENERAL] Syntax for converting double to a timestamp

2006-09-04 Thread Frank Church
On 9/4/06, Alban Hertroys [EMAIL PROTECTED] wrote: Michael Glaesemann wrote: Note that epoch does not mean 1900-01-01 00:00:00. select *, timestamp 'EPOCH' + timestamp * interval '1 second' as tstamp from ccmanager_log where id 15400 select *, timestamp '1900-01-01 00:00:00' + timestamp

[GENERAL] Syntax for converting double to a timestamp

2006-09-03 Thread Frank Church
I am trying to create a view based on this query 'select *, timestamp::timestamp from ccmanager_log' This is the error I get to below, how do I use the time zone syntax error: cannot cast tupe double precision to timestamp without time zone What is the right syntax? The column to be

Re: [GENERAL] Syntax for converting double to a timestamp

2006-09-03 Thread Frank Church
On 9/4/06, Peter Eisentraut [EMAIL PROTECTED] wrote: Frank Church wrote: error: cannot cast tupe double precision to timestamp without time zone What is the right syntax? It's not clear what the meaning of a double precision as a timestamp would be. How about you make that explicit

Re: [GENERAL] Syntax for converting double to a timestamp

2006-09-03 Thread Frank Church
Peter's suggestion did not work. On 9/4/06, Michael Glaesemann [EMAIL PROTECTED] wrote: Please reply to the list so that others may contribute to and learn from the discussion. I am now getting familiar with google mail On Sep 4, 2006, at 8:34 , Frank Church wrote: ERROR: function

Re: [GENERAL] Shared Objects (Dynamic loading)

2006-08-24 Thread Frank Finner
language to use while dealing with email parsing. We have the perl code ready to parse the email. Just wondering what would be the best method to deal with database (postgresql) calls from the perl code. Use DBD::Pg, available at CPAN. -- Frank Finner Invenius - Lösungen mit Linux

Re: [GENERAL] XPath and XML support

2006-08-24 Thread Frank Cohen
Thanks Nikolay: Seeing as xml2 hasn't been ported to Windows yet makes me wonder if this is going to be the best way to use XML in PostgreSQL in the long-term? Is there anything else on the boards? - Frank On Aug 24, 2006, at 4:17 AM, Nikolay Samokhvalov wrote: On 8/24/06, Jeff Davis

[GENERAL] XPath and XML support

2006-08-23 Thread Frank Cohen
. -Frank --- Frank Cohen, Raining Data, http://www.RainingData.com, phone: 408 236 7604 http://www.xquerynow.com for free XML, XQuery and native XML database tips, techniques and solutions. ---(end of broadcast)--- TIP 4: Have you searched our

Re: [GENERAL] Strange error message

2006-08-02 Thread Frank Finner
Disk full or otherwise problems with the disk? I remember I saw somthing similiar some months ago and the reason was (AFAIR) something like a full partition or a partition set to readonly, or a broken mountpoint because of hardware errors. With Linux, not MSW. Regards, Frank On Wed, 02 Aug

Re: [GENERAL] PostgreSQL and OpenVZ

2006-06-30 Thread Frank Finner
. Because the OpenVZ server starts with the same IP like the main database server, there is no need to change anything else while switching from main server to backup server. Regards, Frank. On Fri, 30 Jun 2006 18:37:27 +0400 Ivan Zolotukhin [EMAIL PROTECTED] thought long, then sat down and wrote

Re: [GENERAL] casting... adding integer to timestamp

2006-06-25 Thread Frank Finner
... Regards, -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651 pgpFDCN81x4Xm.pgp Description: PGP

Re: [GENERAL] 8.1.4: Installation ends up in endless recheck loops

2006-06-05 Thread Frank Finner
On Sun, 04 Jun 2006 15:14:37 -0400 Tom Lane [EMAIL PROTECTED] thought long, then sat down and wrote: Frank Finner [EMAIL PROTECTED] writes: I run ./configure --with-perl --with-pam --with-openssl then gmake and end up in endless loops of cd . ./config.status --recheck so configure

[GENERAL] 8.1.4: Installation ends up in endless recheck loops

2006-06-04 Thread Frank Finner
and CentOS) on other computers I got no problems at all. Any ideas? -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A

Re: [GENERAL] How to do a CREATE DATABASE and then connect to it?

2006-06-03 Thread Frank Finner
. That__s equivalent to what \c does. It would sometimes really be nice, btw, if inter-database queries were possible. -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http://www.invenius.de Key

Re: [GENERAL] Interface

2006-05-10 Thread Frank L. Parks
Bob, Can you at least show what your insert statement looks like please? Also, are you using ODBC or VitaVoom's direct driver for DBExpress? Frank Bob Pawley wrote: The folks on the Delphi forum haven't been responsive to this question. Perhaps the ones that visit the forum don't know

Re: [GENERAL] pl/perl error

2006-04-10 Thread Frank
On Sun, Apr 09, 2006 at 06:22:40PM -0400, Tom Lane wrote: Frank [EMAIL PROTECTED] writes: I have a perl script running as a daemon. It's using DBD::Pg (1.43) to connect to my Postgres server (8.0.7) running on the same box and talking over a socket. When I start the server, it runs fine

[GENERAL] pl/perl error

2006-04-09 Thread Frank
. Does anyone else have any debugging suggestions or know what might be causing this problem? Thanks, Frank ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

[GENERAL] Looking for good PostgreSQL hosters

2006-04-05 Thread Frank Church
servers myself / Frank ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] SQL ASCII encoding

2006-04-05 Thread Frank Church
My databases are created in SQL ASCII by default. Is there some disadvantage to this? As a British user, which is the preferred character set and what advantage do I have to gain by using it?database ---(end of broadcast)--- TIP 2: Don't 'kill

Re: REPOST: [GENERAL] How to determine the table a query or a views columns come from?

2006-03-07 Thread Frank Church
Quoting Tom Lane [EMAIL PROTECTED]: Quoting Tom Lane [EMAIL PROTECTED]: Can this info be obtained by querying the system tables, especially in the case of views? I am using 'scripting' languages and using C will be quite awkward. Frank Church [EMAIL PROTECTED] writes: Is there way

Re: [GENERAL] How to determine the table a query or a views columns come from?

2006-03-06 Thread Frank Church
Quoting Tom Lane [EMAIL PROTECTED]: Can this info be obtained by querying the system tables, especially in the case of views? I am using 'scripting' languages and using C will be quite awkward. I have got to find if libpq's output is exposed in PHP or Ruby. Frank Church [EMAIL PROTECTED

[GENERAL] How to determine the table a query or a views columns come from?

2006-03-03 Thread Frank Church
Is there way to determine the table a query or a view's columns come from? I am looking for something like that in postgresql. If it doesn't exist is there some generalized SQL that can parse the query or view's definition and retrieve the list. something like column name | actual column name

[GENERAL] What is the syntax for setting a default date in PostgreSQL?

2006-02-20 Thread Frank Church
This issue always stumps me. I need to set the default date for a column in postgres. A value for today, today + x days, now (timestamp), now + x amount of days. I never seem to be able to locate it in the documentation or online. Can anyone post it here once and for all for posterity? I will

[GENERAL]

2006-02-14 Thread Frank Church
I get this error when I try to delete a column in a table in PG 7.4 ERROR: multiple INTERNAL dependencies for table What could the cause be and how do I get rid of it? ---(end of broadcast)--- TIP 5: don't forget to increase your free space map

[GENERAL] using schema-qualified names in INSERTs

2006-02-13 Thread Frank Church
Does PostgreSQL support INSERT syntax of this kind - insert into table (table.col1, table.col2, table.col3) values('one', 'two', 'three')? Trying it out generates an error. It works when the 'table' bit is removed from the column names. F Church ---(end of

[GENERAL] Gotcha's in copying data between servers via file copy

2006-02-01 Thread Frank Church
I want to copy the data from one server to another. One is running Postgresql 7.4.6 and the other 7.4.7. Are they any gotchas I should lookout for when making the copy? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will

[GENERAL] I need some info on repairing database corruption

2006-01-30 Thread frank church
One of my database tables appears to corrupted see this post - Re: [GENERAL] REPOST:Memory Allocation error using pg_dump on 7.4. On checking the archives it appears I have to use a pg_filedump program to fix it, which doesn't appear to be in my distribution. Where can I find it and install it?

[GENERAL] REPOST:Memory Allocation error using pg_dump on 7.4

2006-01-27 Thread frank church
I repeatedly get this error whenever I try to backup a database The command used is: pg_dump -Fc -O -U username tablename tablename.20060122 pg_dump: ERROR: invalid memory alloc request size 4294967290 pg_dump: SQL command to dump the contents of table cc_ratecard failed: PQendcopy() failed.

[GENERAL] Working out diskspace taken by database and tables 7.4

2006-01-22 Thread frank church
I am trying to work out how much space is taken up by a given database in the file system. I have googled the archives and found the stuff there looks dated. Is there some script or query that can work it all out? My current version is 7.4. Knowing abut 8.x.x will be fine too?

[GENERAL] Memory Allocation error using pg_dump on 7.4

2006-01-22 Thread frank church
I repeatedly get this error whenever I try to backup a database The command used is: pg_dump -Fc -O -U username tablename tablename.20060122 pg_dump: ERROR: invalid memory alloc request size 4294967290 pg_dump: SQL command to dump the contents of table cc_ratecard failed: PQendcopy() failed.

[GENERAL] Does pg_dump have result codes to indicate success or failure

2006-01-22 Thread frank church
I want to use pg_dump in a php program. Does pg_dump have specific error codes? Does use the normal shell result codes to indicate success or failure ? This message was sent using IMP, the Internet Messaging Program.

[GENERAL] Is there a way to list running queries

2006-01-21 Thread frank church
Is there a way to list running queries in PostgreSQL, especially those that appear to have gone away or don't seem to be running at all? This message was sent using IMP, the Internet Messaging Program.

[GENERAL] What is the maximum length of an IN(a,b,c....d) list in PostgreSQL

2006-01-19 Thread frank church
What is the maximum length of an IN(a,b,cd) list in PostgreSQL? I am using 7.4. This message was sent using IMP, the Internet Messaging Program. ---(end of broadcast)--- TIP

Re: [GENERAL] PostgreSQL Top 10 Wishlist

2006-01-18 Thread Frank van Vugt
L.S. Sorry 'bout that last post in dutch, it was meant to go to a private address. -- Best, Frank. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] PostgreSQL Top 10 Wishlist

2006-01-18 Thread Frank van Vugt
might work, but I wouldn't bet on it. Me neither, since I haven't tried that in a while too (the OP was already aware of this). Anyway, it's just a good thing people are paying attention around here ;) -- Best, Frank. ---(end of broadcast

Re: [GENERAL] Image in postgresql 7.3

2006-01-18 Thread Frank Finner
of pictures, you might want to use an other method. Another (small) disadvantage is that one has to encode/decode the binary files before storing/after retreiving. Regards, Frank. On Wed, 18 Jan 2006 05:13:22 -0800 (PST) Peerri (sent by Nabble.com) [EMAIL PROTECTED] thought long, then sat down

[GENERAL] Is there a way to list runaway queries and kill them?

2006-01-17 Thread frank church
Is there a way to list runaway or long runninng queries and kill them? Frank This message was sent using IMP, the Internet Messaging Program. ---(end of broadcast)--- TIP 3: Have

[GENERAL] Loading large amounts of data in a SQL command

2006-01-05 Thread frank church
which allows the same performance as transactions, without causing the whole process to fail, like a delayed updates or write mechanism of some sort? Frank This message was sent using IMP, the Internet Messaging Program

[GENERAL] just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?

2005-12-28 Thread Frank van Vugt
where it occured - setting log_error_verbosity to 'verbose' doesn't log the query itself either Is there a way to get the failed query into the log, or should it have been there in the first place? -- Best, Frank. ---(end of broadcast

Re: [GENERAL] Final stored procedure question, for now anyway

2005-12-28 Thread Frank L. Parks
Do you refresh you database after you add the function? It will not show up until after you refresh. Ted Byers wrote: Well, I just ran another test and the result indicates the cause of the problem lies elsewhere. I replaced the original function name with add_entity and the end result is

Re: [GENERAL] PL/pgSQL : notion of deferred execution

2005-12-12 Thread Frank van Vugt
the TG_WHEN var I could imagine there was, but If there is not and it's also not something expected to be 'nice to have', so be it, no problem ;) Too bad TriggerEvent doesn't seem to make this info available, either ;) -- Best, Frank. ---(end of broadcast

Re: [GENERAL] PL/pgSQL : notion of deferred execution

2005-12-12 Thread Frank van Vugt
always the simple stuff ;) Had been overlooking TG_ARGV[] here, that should prove to be a nice compromise, thanks for the hint! -- Best, Frank. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

[GENERAL] PL/pgSQL : notion of deferred execution

2005-12-11 Thread Frank van Vugt
an item for the todo list? Ratio: when deferred triggers on table A are used to calculate field values of table B (which then obviously need an update), one might want to prevent direct updates on these fields of table B -- Best, Frank. ---(end of broadcast

[GENERAL] how to use SAVEPOINT in stored function

2005-12-05 Thread Frank . Motzkat
savepoint_test(1, CAST('test-1' AS VARCHAR), CAST('id_1' AS VARCHAR)); regards, frank

[GENERAL] how to use SAVEPOINT in stored function

2005-12-05 Thread Frank . Motzkat
THEN ROLLBACK TO my_savepoint; END; END $$ LANGUAGE plpgsql; -- call test function select * from savepoint_test(1, CAST('test-1' AS VARCHAR), CAST('id_1' AS VARCHAR)); regards, frank ---(end of broadcast)--- TIP 3: Have you checked our

[GENERAL] How to change database owner in 7.4

2005-11-30 Thread frank church
Hi guys, What is the command change database owner in PostgreSQL 7.4? I think the 'ALTER DATABASE foo OWNER TO blob;' is not implemented in 7.4 R Church This message was sent using IMP, the Internet Messaging Program.

[GENERAL] How to check options PostgreSQL was started with

2005-11-30 Thread frank church
How do you check the options a PosgreSQL service was started with? Frank This message was sent using IMP, the Internet Messaging Program. ---(end of broadcast)--- TIP 3: Have you

[GENERAL] declare function with IN and OUT parameter as well as refcursor

2005-11-24 Thread Frank Motzkat/IC3S AG
! Cheers, frank

[GENERAL] long transactions, SAVEPOINTS, performance and memory consumption

2005-09-06 Thread Frank Kardel
and possibly improve performance by reducing adminitrative overhead. Regards and thanks in advance, Frank Kardel Ansgar Seiter ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] newbie - postgresql or mysql

2005-09-01 Thread Frank
mysqldump --extended-insert=FALSE Thanks for the help, this is allowing me to import the data now. Regards, Frank At 09:37 AM 9/1/2005, Michael Fuhr wrote: [Please copy the mailing list on replies so others can contribute to and learn from the discussion. Also, please don't top-post

[GENERAL] newbie - postgresql or mysql

2005-08-31 Thread Frank
Hello, I would like to try postgresql and was wondering what benefits it has over MySql. I am using navicat to manage my MySQL databases. Thanks for the help. Frank ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] newbie - postgresql or mysql

2005-08-31 Thread Frank
', 2, '2004-10-12 10:50:04'), (15, 'Software - Server', 2, '2004-10-12 10:50:04'), (16, 'Hardware - Wyse Terminal', 2, '2004-10-12 10:50:05'); Regards, Frank ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] newbie - postgresql or mysql

2005-08-31 Thread Frank
-12 10:50:05'); Regards, Frank ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] stack depth limit exceeded

2005-08-29 Thread Frank L. Parks
I think that you forgot the table name. CREATE TRIGGER updateContact AFTER INSERT OR UPDATE ON contacts FOR EACH ROW EXECUTE PROCEDURE contacts.addContactField(); Frank Jamie Deppeler wrote: What i am trying to do is update the field contact with field values in firstname and lastname

Re: [GENERAL] Upgrading 8.0.2 to 8.0.3 on Windows XP

2005-08-15 Thread Frank Rittinger
service is removed) and installed the new version, using the old data directory. However, I would still do a dump before :-) Hope this helps,Frank Giovanni M. wrote: Hello, Wondering if somebody can help me out with upgrading a PostgreSQL 8.0.2 installation on Windows XP SP2. I

Re: [GENERAL] Case sensitivity

2005-08-10 Thread Frank Millman
Frank Millman wrote: Hi all Is there an LC_COLLATE setting, or any other method, which allows all data in a database to be treated in a case-insensitive manner? Thanks for all the replies, guys, I really appreciate it. Here is what I have decided to do. If anyone sees any problems

Re: [GENERAL] Case sensitivity

2005-08-10 Thread Frank Millman
Frank Millman wrote: 1. Will SELECT WHERE LOWER(colname) = 'a001' use the index, or must I create a separate index on LOWER(colname)? Sorry. RTFM. The docs clearly state that this is necessary. Frank ---(end of broadcast)--- TIP 6: explain

Re: [GENERAL] Case sensitivity

2005-08-09 Thread Frank Millman
Frank Millman wrote: Hi all Is there an LC_COLLATE setting, or any other method, which allows all data in a database to be treated in a case-insensitive manner? I was hoping to stimulate some discussion on this topic, but it seems I will have to kick-start it myself and see if anyone

[GENERAL] Case sensitivity

2005-08-06 Thread Frank Millman
a value of 'a' to be rejected if there is already a value of 'A'. Workaround - create a unique index on LOWER(col_name). 2. I would like WHERE col_name = 'x' and WHERE col_name LIKE 'x%' to find 'X' and 'X1'. Workaround - WHERE LOWER(col_name) = 'x' and WHERE col_name ILIKE 'x%'. TIA Frank

Re: [GENERAL] What causes lock??

2005-08-05 Thread Frank Miles
another test to the regression set... My apologies to Federico (psycopg), which was blameless, and my continued thanks to the Postgresql community (particularly Michael and Tom) for their help! -frank ---(end of broadcast)--- TIP 1

Re: [GENERAL] What causes lock??

2005-08-04 Thread Frank Miles
On Thu, 4 Aug 2005, Michael Fuhr wrote: On Thu, Aug 04, 2005 at 03:03:47PM -0700, Frank Miles wrote: I have a python-based application which provides a user interface to a Postgresql database. The latest version of the application suddenly lost the inability to insert new data in some

Re: [GENERAL] transaction timeout

2005-07-26 Thread Frank L. Parks
TIP 2: Don't 'kill -9' the postmaster Dr NoName wrote: The common view on this kind of thing is that if your client is broken, you need to fix it. The problem is, we can't fix the users, nor can we fix other software that our client has to interact with. There will always be

Re: [GENERAL] Windows version of PostgreSQL 8?

2005-07-13 Thread Frank Rittinger
or should I look elsewehere after a good sql srv for Windows? Regards. BTJ Regards Frank -- Frank Rittinger TERRAPLAN Geographische Informationssysteme Gewerbestr. 33 79227 Schallstadt Germany Tel.: 07664-505315 Fax.: 07664-505321 http://www.terraplan.com ---(end

Re: [GENERAL] PITR problems

2005-07-05 Thread Frank Finner
database. You may now start the interface to the master again. Recovery might take some minutes due to data masses of WALs. For example, I have about 160M of WALs per hour. Regards, Frank. On Tue, 5 Jul 2005 15:24:35 +0200 Per Lauvås [EMAIL PROTECTED] thought long, then sat down and wrote

Re: [GENERAL] PL/pgSQL function to validate UPC and EAN barcodes

2005-06-25 Thread Frank van Vugt
) THEN RETURN (10 - chksm); ELSE RETURN chksm; END IF; END;'; -- Best, Frank. ---(end of broadcast)--- TIP 5: Have you checked our extensive

[GENERAL] problem calling psql from another program

2005-06-24 Thread Frank Rittinger
the .NET program it behaves strange: it never finishes but the server doesn't do anything. When I kill the program with CTRL-C than it seams as if the script gets executed. (BTW this works fine under WinXP Pro!) Any suggestions are welcomed. Regards Frank Rittinger

Re: [GENERAL] Need input on postgres used for phpBB

2005-05-10 Thread Frank Finner
database became extremely slow, vacuum itself needed several hours instead of several minutes, after doing some weeks of heavy inserting. Vaccum obviously does not release all unused memory in 7.3.x. -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606

Re: [GENERAL] Debugging deadlocks

2005-04-01 Thread frank
update the reference table (if you keep it), you mustn't forget to also update the check constraints in more than one place. Rgds, Frank ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Debugging deadlocks

2005-03-30 Thread frank
, since his queries are only *reading* the referenced tables?? Regards, Frank ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] PL/Perl trusted throws error on example function

2005-03-03 Thread Frank Finner
works fine now. Thanks for your help, it opened my eyes. Regards, Frank On Thu, 03 Mar 2005 12:14:53 -0500 Tom Lane [EMAIL PROTECTED] thought long, then sat down and wrote: Frank Finner [EMAIL PROTECTED] writes: error from Perl function: trusted Perl functions disabled - please upgrade

[GENERAL] PL/Perl trusted throws error on example function

2005-03-02 Thread Frank Finner
untrusted, the example above works correctly. What is so bad with this function that I only can run it untrusted? Regards, Frank -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608Web: http

Re: [GENERAL] invalid multibyte character for locale

2005-03-01 Thread Frank van Vugt
. seems to be broken. PostgreSQL should not use wide-character method if LC_CTYPE is C. [TL] Yeah, we came to that same conclusion a few days ago in another thread. I am planning to install the fix cut Great, no rush, it's an easily avoided issue ;) -- Best, Frank

[GENERAL] invalid multibyte character for locale

2005-02-28 Thread Frank van Vugt
that. Obviously, the error doesn't occur on the first machine due to the hack needed for the buggy glibc. I'd appreciate a pointer as to what is causing this. It 'shouldn't' be the hack nor the dump/restore cycle, but...? TIA. -- Best, Frank. ---(end

Re: [GENERAL] Export a column in a view without announcing it?

2005-01-31 Thread Frank D. Engel, Jr.
that it actually updates the underlying table. I did it for the first time yesterday and found the concept quite interesting. Sim Frank D. Engel, Jr. [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm fairly certain there is currently no way to do

Re: [GENERAL] Moving from Sybase to Postgres - Stored Procedures

2005-01-28 Thread Frank D. Engel, Jr.
of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16

Re: [GENERAL] Extended unit

2005-01-27 Thread Frank D. Engel, Jr.
computation toolkit with equations and units somewhere ? - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only

Re: [GENERAL] pg_dump shell script with ~/.pgpass

2005-01-27 Thread Frank Miles
admin. [how to accomplish this in WinXX I have no idea] HTH, -frank ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [BUGS] [GENERAL] My postmaster just crashed !

2005-01-27 Thread Frank D. Engel, Jr.
Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible

Re: [GENERAL] text field constraint advice

2005-01-26 Thread Frank D. Engel, Jr.
if it is too long? - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth

Re: [GENERAL] Extended unit

2005-01-26 Thread Frank D. Engel, Jr.
. - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life. $ -BEGIN PGP

[GENERAL] Export a column in a view without announcing it?

2005-01-26 Thread Frank D. Engel, Jr.
automatically? Thank you! - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever

Re: [GENERAL] Splitting queries across servers

2005-01-26 Thread Frank D. Engel, Jr.
if your joining column's datatypes do not match - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only

Re: [GENERAL] What is the format of 'binary' data in the postgresql client/server protocol version 3

2005-01-25 Thread Frank D. Engel, Jr.
- --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life. $ -BEGIN PGP

[GENERAL] ODBC Driver Issue (possibly OT - wrong list?)

2005-01-25 Thread Frank D. Engel, Jr.
=168, reverse=0, errornumber=0, errormsg='(NULL)' buffer_in=18440320, buffer_out=1824 buffer_filled_in=576, buffer_filled_out=0, buffer_read_in=576 conn=18429304, PGAPI_Disconnect - --- Frank D. Engel, Jr. [EMAIL

Re: [GENERAL] Data entry - forms design or other APIs etc. - what is there?

2005-01-24 Thread Frank D. Engel, Jr.
commands go to [EMAIL PROTECTED] - --- Frank D. Engel, Jr. [EMAIL PROTECTED] $ ln -s /usr/share/kjvbible /usr/manual $ true | cat /usr/manual | grep John 3:16 John 3:16 For God so loved the world, that he gave his only begotten Son

<    1   2   3   4   5   >