Re: [GENERAL] INSERT OR UPDATE?

2005-10-09 Thread andrew
I think is almost the same that in many other languages, and like in many other with the time you can have function's libraries, or more likely class libraries with the usefull stuff. In desktop programming environments you have components, here you have classes that are the same thing using it in

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
I use 7.3 and use RECORD as the input data type of the function by "create function foo(record) returns int4 as '$libdir/bar' language C". But I got this error msg:" ERROR: parser: parse error at or near "record" at character". What is the problem? I look up the 7.3 manual. it seems record is a

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
in Warn_restart code What is the problem here? Did you test it on 7.3? On 1/25/06, Tom Lane <[EMAIL PROTECTED]> wrote: > andrew <[EMAIL PROTECTED]> writes: > > I use 7.3 and use RECORD as the input data type of the function by > > "create function foo(record) re

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
Function complete(person) does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts On 1/25/06, Tom Lane <[EMAIL PROTECTED]> wrote: > andrew <[EMAIL PROTECTED]> writes: > > ERROR: parser:

[GENERAL] filtering after join

2006-01-25 Thread andrew
les generated by the join operation. How can I do that? Thanks! -- andrew ---(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

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
sorry, mistakenly leave out another try: backend> select *, complete(CAST (Person AS record)) from Person QUERY: select *, complete(CAST (Person AS record)) from Person ERROR: Relation reference "person" cannot be used in an expression On 1/25/06, andrew <[EMAIL PROTECTED]>

Re: [GENERAL] user defined function

2006-01-26 Thread andrew
Thanks, Tom. It is done by modifying coerce_type() and can_coerce_type(). The reason I have to keep to verson 7.3 is I am working on a research prototype that is built over pgsql 7.3. I need the extra functions provided by that prototype. On 1/25/06, Tom Lane <[EMAIL PROTECTED]> wrote: &g

[GENERAL] PostgreSQL 8.1 - SSL:Required

2006-10-02 Thread Andrew
Hi,I am using the binary install for postgresql 8.1 Win32 on Windows XP. I know how to intstall SSL if I was installing from source, --with-openssl, but I am installing onto Windows XP for the first time, so my question is: 1. How do I install the SSL module via the install wizard?Blessings Andrew

Re: [GENERAL] Full Text Search - i18n

2008-06-24 Thread Andrew
Re-reading the documentation, and I have the answer. If adding a tsvector column, then for per row selection, I should also add a second column of type regconfig to specify the language that rows contents are in. Cheers, Andy Andrew wrote: Apologies if this question has been previously

[GENERAL] Full Text Search - i18n

2008-06-24 Thread Andrew
Apologies if this question has been previously covered, but I was not able to find something similar in any of the mailing list archives. With full text search, if you need to support a table where the content of individual tuples/rows may be in different languages with the language of the con

[GENERAL] 0xc3 error Text Search Windows French

2008-06-25 Thread Andrew
I have a feeling that an issue I'm running into is related to this: http://archives.postgresql.org/pgsql-bugs/2008-06/msg00113.php On Windows XP running PgAdmin III 1.8.4 against either PostgreSQL 8.3.0 or 8.3.3 DB, when attempting to do a: select * from ts_debug('french', 'catalogue'); gett

Re: [GENERAL] 0xc3 error Text Search Windows French

2008-06-25 Thread Andrew
Sorry one last detail. All of my databases are in utf-8 format. My Windows XP is en_AU and defaults to ISO-8859-1 character sets. My postgresql.conf is set to the default for the client_encoding setting, which should then default to the database utf-8 format. Andrew wrote: One additional

Re: [GENERAL] 0xc3 error Text Search Windows French

2008-06-25 Thread Andrew
s, which I have not touched in anyway and it is also occurring with the portuguese catalogue. Cheers Andy Andrew wrote: I have a feeling that an issue I'm running into is related to this: http://archives.postgresql.org/pgsql-bugs/2008-06/msg00113.php On Windows XP running PgAdmin

[GENERAL] hibernate nativequery and uuid

2008-07-31 Thread Andrew
I'm currently using JPA with Hibernate as my ORM and have been able to convince hibernate to play nicely with the Postgresql UUID. Most of my queries have been in EJBQL using the JPA entity manager's createQuery. However when I try to do a UNION, JPA only returned the results of the first que

Re: [GENERAL] hibernate nativequery and uuid

2008-07-31 Thread Andrew
Yeah, tried that, but get the following: org.hibernate.MappingException: No Dialect mapping for JDBC type: Thanks for the suggestion though. Douglas McNaught wrote: On Thu, Jul 31, 2008 at 5:57 PM, Andrew <[EMAIL PROTECTED]> wrote: The only relevant thing I have been able t

Re: [GENERAL] hibernate nativequery and uuid

2008-07-31 Thread Andrew
iated though. A.M. wrote: On Jul 31, 2008, at 5:57 PM, Andrew wrote: I'm currently using JPA with Hibernate as my ORM and have been able to convince hibernate to play nicely with the Postgresql UUID. Most of my queries have been in EJBQL using the JPA entity manager's createQuery.

Re: [GENERAL] hibernate nativequery and uuid

2008-07-31 Thread Andrew
Oh, I see what you mean. Use EJBQL on a view. That would probably work. Have to get going, so will try that when I get back in several hours. I'll let you know how I go. Andrew wrote: I have given it consideration, but haven't tried it as I have concluded that I would still hav

Re: [GENERAL] hibernate nativequery and uuid

2008-08-01 Thread Andrew
oops, forgot to cc the mailing list again... Andrew wrote: I know none of this relates directly to postgresql and on reflection is probably more appropriate for the hibernate forums. So apologies for having raised the topic here. Also, thanks for the suggestions that I have received on the

Re: [GENERAL] Oracle and Postgresql

2008-09-25 Thread Andrew
For an alternative view of the security argument, which may be a little off topic... One consideration in regard to arguments for additional security, whether column and row level security or the divergent thread on obfuscated stored procedures is whether postgresql currently supports PCI (in

[GENERAL] stateful UDF?

2006-02-14 Thread andrew
Hi Can I implement a stateful UDF in C? i.e. storing the state of the previous run of the function and access them in the succeeding runs. Is it supported? How do I implement it? Thanks. -- andrew ---(end of broadcast)--- TIP 4: Have you searched

Re: [GENERAL] stateful UDF?

2006-02-15 Thread andrew
this function is computed based on this information and the current input tuple. On 2/15/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Tue, Feb 14, 2006 at 11:47:49PM +0100, andrew wrote: > > Can I implement a stateful UDF in C? i.e. storing the state of the > > previous ru

Re: [GENERAL] stateful UDF?

2006-02-15 Thread andrew
100, andrew wrote: > > Within the same query. The function takes a tuple as its input > > parameter. It will be used in the where clause. So I think it will be > > called one time for each read tuple, right? I want to maintain a > > structure to store the information about the tup

[GENERAL] disjunctive queries

2006-08-04 Thread andrew
Hi, What are the techniques used by PostgreSQL to optimize disjunctive queries? Treat every disjunct separately? Or special optimization is performed to save the cost? Could any one give me some general ideas? Thanks! -- andrew ---(end of broadcast

Re: [GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-09 Thread Andrew
Hi Mohammed, See my answers below, and hopefully they won't lead you too far astray. Note though, it has been a long time since I have done this and there are doubtless more knowledgeable people in this forum who will be able to correct anything I say that may be misleading or incorrect. Ch

Re: [GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-10 Thread Andrew
Mohamed wrote: Thank you for you detailed answer. I have learned alot more about this stuff now :) Your welcome :-) As I see it accordingly to the results it's between Hunspell and Aspell. My Aspell version is 0.6 released 2006. The Hunspell was released in 2008. When I run the Postgres c

[GENERAL] pgadmin story...

2010-11-18 Thread andrew
hi all, I've just read that pgadmin team was hired by some company and the project will be closed... It was a post from 2009. I'm just curious what's the story behind that. Did anyone leave? thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your s

Re: [GENERAL] pgadmin story...

2010-11-18 Thread andrew
Chris Browne wrote: andrew writes: hi all, I've just read that pgadmin team was hired by some company and the project will be closed... It was a post from 2009. I'm just curious what's the story behind that. Did anyone leave? thanks. Are you thinking about this annou

[GENERAL] Local Users "su'ing" (REPOST)

2000-08-26 Thread andrew
Hi, Don't think this made it the first time... Thanks, Andrew -- Forwarded message -- Date: Sat, 26 Aug 2000 15:45:55 +1000 (EST) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Local Users "su'ing" Hi, I'm running postgresql 7.0.2 under Free

Re: [GENERAL] table count limitation

2000-08-27 Thread andrew
, motor boats etc as you store different attributes. As postgresql is an OORBMS it should be able to handle it without any nasty squash into the relational model tricks. I've never used an OO database in production mind you...perhaps there is some catch I'm not aware of. Andrew

[GENERAL] Making changes visible to other connections

2000-10-09 Thread andrew
Hi, If I run an UPDATE operation from one connection the changed data is only visible form that connection. How do make the change visible from other connections? Do I have to wrap everything in a transaction? I'm using libpq if that makes a difference. Thanks, Andrew

[GENERAL] Making changes visible to other connections

2000-10-09 Thread andrew
Hi, If I run an UPDATE operation from one connection the changed data is only visible from that connection. How do make the change visible from other connections? Do I have to wrap everything in a transaction? I'm using libpq if that makes a difference. Thanks, Andrew

[GENERAL] pg_dump and circular dependency

2004-02-17 Thread andrew
Table A has a CHECK constraint testing boolean function F. Function F has a SELECT from Table A. In my manual build script, I create the table, then the function, and then at the very end of the script to I do an ALTER TABLE ADD CHECK. pg_dump appears to put the CHECK constraint as a clause in t

Re: [GENERAL] That movie

2003-08-20 Thread andrew
Please see the attached file for details. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-16 Thread Andrew Dunstan
en() calls CreateFile(). cheers andrew ---(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

Re: [GENERAL] More grist for the PostgreSQL vs MySQL mill

2007-01-21 Thread Andrew - Supernews
On 2007-01-21, Ron Johnson <[EMAIL PROTECTED]> wrote: >> And no BDB (at least last I checked is not GPL) > > It's BSD (for obvious reasons), no? No, Sleepycat's licence is _NOT_ BSD. -- Andrew, Supernews http://www.supernews.com - individual

Re: [GENERAL] Installing PostgreSQL under Cpanel

2007-01-23 Thread Andrew Kroeger
;t provide any indication that the interactive pages exist. Andrew P.S. - Has anyone considered adding links in the documentation so that a given static/interactive documentation page would contain a link to the same page in the interactive/static section? Or at least a link from the static

Re: [GENERAL] Compilation Error AIX

2007-02-01 Thread Andrew Sullivan
ent or the employee or agent > responsible for delivering it to the intended recipient, you are hereby > notified that any use, dissemination or copying of this email transmission is > strictly prohibited by the sender. If you have received this transmission in > error, please de

Re: [GENERAL] Compilation Error AIX

2007-02-02 Thread Andrew Sullivan
This is free software; see the source for copying conditions. > There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A > PARTICULAR PURPOSE. Ok, now what are you handing to ./configure? A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological

Re: [GENERAL] DBMS Engines and Performance

2007-02-02 Thread Andrew Sullivan
tioned) all sorts of ugly hairs that relate to MySQL "features" that are really just there to cover up missing pieces of implementation. (Or rather, used-to-be-missing. MySQL has come a long way in the past couple releases, no matter what anyone thinks of their marketing approach of

Re: [GENERAL] DBMS Engines and Performance

2007-02-02 Thread Andrew Sullivan
he above is not universally true, but I have seen or read such sentiments often enough to realise that there are plenty of application developers who don't know anything about their database technology. A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimate month"

Re: [GENERAL] Can a database be restored successfully after new installation.

2007-02-02 Thread Andrew Sullivan
mp? Sure, oughta work fine, assuming you have all the necessary support in your target system. (e.g. if you're using plpgsql, for instance, you need to have performed createlang for it, &c.) A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

2007-02-06 Thread Andrew Sullivan
On Tue, Feb 06, 2007 at 09:43:01AM -0600, Thomas F. O'Connell wrote: > DETAIL: Table has type character varying, but query expects > character varying. In another thread, someone else is reporting this too. I'm wondering whether something went wrong in the 8.2.2 release

Re: [GENERAL] Hardware

2007-02-06 Thread Andrew Sullivan
f the array in the event any disk in the side fails. So I always use 1+0 if I can. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 1: if posting/readi

Re: [GENERAL] replication choices

2007-02-06 Thread Andrew Sullivan
ould _not_ worry about the outbound replication from the centre, assuming that the changes are infrequent. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism.

Re: [GENERAL] replication choices

2007-02-06 Thread Andrew Sullivan
ame cluster. This is really no more load than the single replication user, although it is expensive at the disk level. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun --

[GENERAL] Problems shutting down Postmaster

2007-02-08 Thread Andrew Edson
I need to add a system to our postgres pg_hba.conf file; the main server went down a few days ago, and this system was mistakenly left off the list of allowed systems when the server was brought back up. (Older version of the .conf file; I managed to accidentally delete the more current one whi

Re: [GENERAL] Problems shutting down Postmaster

2007-02-08 Thread Andrew Edson
Okay, for some reason we still had a problem connecting after a pg_ctl reload, but the shutdown went through this time, and everything's working now. Thanks for the assistance. Tom Lane <[EMAIL PROTECTED]> wrote: Andrew Edson writes: > Someone else added the IP address for the o

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

2007-02-18 Thread Andrew Kirkness
MySQL. If I'm using a PostGreSQL database to store data from customers, but also have MySQL database capability, can I still use a Content Management System that uses MySQL and still use PostGreSQL to store data from customers? Thank you for your time. Cheers, Andrew -- Andrew Kirkness [EMAI

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

2007-02-19 Thread Andrew Kelly
On Sun, 2007-02-18 at 09:59 -0500, John DeSoi wrote: > On Feb 16, 2007, at 4:13 PM, Andrew Kirkness wrote: > > > I am currently setting up a website and have PostGreSQL database > > I'm using for the backend. I'm researching an open source Content > > Mana

Re: [GENERAL] Database performance comparison paper.

2007-02-19 Thread Andrew Sullivan
On Sat, Feb 17, 2007 at 12:02:08AM +0100, Leif B. Kristensen wrote: > > There ought to be a proper name for this kind of pseudo-technical Gonzo > journalism. There is, but it's not the sort of word one uses in polite company ;-) A -- Andrew Sullivan | [EMAIL PROTECTED]

[GENERAL] Re: [HACKERS] 5 Weeks till feature freeze or (do you know where your patch is?)

2007-02-23 Thread Andrew Dunstan
Joshua D. Drake wrote: Andrew Dunstan: Something with COPY? Andrew? The only thing I can think of is to remove the support for ancient COPY syntax from psql's \copy, as suggested here: http://archives.postgresql.org/pgsql-hackers/2007-02/msg01078.php That's hardly a featur

Re: [GENERAL] help required regarding queryin postgis database from google maps

2007-02-26 Thread Andrew Hammond
On Feb 25, 9:34 am, [EMAIL PROTECTED] (Andrew Dunstan) wrote: > Phani Kishore wrote: > > > hi ! > > > i think u people could probably help me i how to query the > > pgsql/postgis from google maps api to display the markers on the > > google maps which are stored i

[GENERAL] How does filter order relate to query optimization?

2007-02-27 Thread Andrew Edson
I'm working on a php project that's supposed to draw information from the DB for display, and I've been requested to speed up the display as much as possible. I'm drawing data from four tables, with an additional two that I have to 'bounce' through to match the keys together. Also, I've got fi

Re: [GENERAL] How does filter order relate to query optimization?

2007-02-27 Thread Andrew Edson
Index Cond: ("outer".person_seq = persn.person_seq) Total runtime: 271175.640 ms (22 rows) Anybody ideas what might be causing the problems with the slowdown? The slow database is fed by slony logshipping from the 'normal' one, and both are (at least theoreti

[GENERAL] Curious situation - running program cannot seem to delete records.

2007-02-28 Thread Andrew Edson
I've been given a file to maintain, the purpose of which is to purge the database of records more than two years old. (Database setup is pg 8.1.3) The program (written in perl) enters postgres as the user 'postgres', and is supposed to select foreign-key records from all tables that link t

[GENERAL] PostgreSQL 8.2.3, Jboss 4.0.3 and postgresql-8.2-504.jdbc4

2007-02-28 Thread Andrew Madu
l-8.1-405.jdbc3 and all works fine again! What is the issue here? I am using Java 1.5.0_06 on Window XP SP2 -- Regards Andrew

[GENERAL] Select retrieval slowdown after db drop/reload. Suggestions?

2007-02-28 Thread Andrew Edson
I have a select statement, used in a Perl program, which is supposed to find all records related to those in one table which have a delete_dt field value of four years or older. This is the select statement: SELECT t2.dist_id, t1.clnt_seq, t2.cntrct_seq, t2.cntrct_id, t3.aunit_seq, t1.pe

[GENERAL] PostgreSQL primary (sequence) key issue (Ruby/Rails)

2007-03-01 Thread Andrew Madu
violates not-null constraint FexecMain.c L1795 RExecConstraints: INSERT INTO usertbl Oh my head hurts!! -- Regards Andrew On 01/03/07, Andrew Madu < [EMAIL PROTECTED]> wrote: Hi Dave, my apologies for contacting you off list but i'm having a spot of bother with postgreSQL sequ

[GENERAL] SOLVED: Re: PostgreSQL primary (sequence) key issue (Ruby/Rails)

2007-03-01 Thread Andrew Madu
Hi, this one has been finally put to bed!! -- Regards Andrew On 01/03/07, Andrew Madu <[EMAIL PROTECTED]> wrote: Hi Guys, I'm completely stumped with this one! I've included ActiveRecord::Base.set_sequence_name in my environment.rb, and in my user.rb I've placed the f

[GENERAL] RFC tool to support development / operations work with slony replicated databases

2007-03-05 Thread Andrew Hammond
pment / maintenance. As a result I would like to both solicit the input of the community and share the results. Documentation (which is still somewhat drafty) follows. Thank you for your time, Andrew Hammond Current Approach A common problem in the database world is handling revisions to the dat

Re: [GENERAL] RFC tool to support development / operations work with slony replicated databases

2007-03-06 Thread Andrew Hammond
On Mar 6, 5:44 am, [EMAIL PROTECTED] (Kenneth Downs) wrote: > Andrew Hammond wrote: > > Each release will include a directory that has the same name as the > > full release tag. This directory must contain all the scripts to be > > applied. > > Have you considered usin

[GENERAL] programmatic way to fetch latest release for a given major.minor version

2007-04-09 Thread Andrew Hammond
g the parsing that? Both approaches feel quite awkward to me. Andrew ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] programmatic way to fetch latest release for a given major.minor version

2007-04-09 Thread Andrew Hammond
On 4/9/07, CAJ CAJ <[EMAIL PROTECTED]> wrote: On 9 Apr 2007 14:47:20 -0700, Andrew Hammond <[EMAIL PROTECTED]> wrote: > I'm writing a script that wants to know the latest release for a given > major.minor version. Is there some better way than parsing > http://www.pos

[GENERAL] Select taking excessively long; Request help streamlining.

2007-04-11 Thread Andrew Edson
If this message has already appeared on the list, I apologize. My system tried to temporarily freeze up when I attempted to send this message a few minutes ago, and I do not know if I hit send before it halted or not. I am working with a php program that is designed to enter the database,

[GENERAL] Dumping part (not all) of the data in a database...methods?

2007-04-11 Thread Andrew Edson
I'm needing to do a partial dump on a database. All of the entries in the db can be marked as one of two groups, and I've been asked to create a dump of just the second group. It is possible to do a select statement based dump and just grab the one set of records in the output? ---

Re: [GENERAL] Acces via applets

2007-04-11 Thread Andrew Thompson
o not generally read this group, so if you wish to pursue the matter, I suggest taking it up on the comp.lang.java.help usenet newsgroup. HTH Andrew T. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to

Re: [GENERAL] Acces via applets

2007-04-11 Thread Andrew Thompson
On Apr 11, 3:45 pm, [EMAIL PROTECTED] ("Marc") wrote: .. > The applet has been self signed. .. I did miss that bit on my initial reading, but like I said earlier - best to continue it in a discussion on a Java group. Andrew T. ---(end

Re: [GENERAL] Dumping part (not all) of the data in a database...methods?

2007-04-11 Thread Andrew Edson
I am aware of this, yes, but the data in question is all (both sets) contained on a single table. That's why I was looking for a way to do a 'dump where (select foo where bar = 'criteria')' structure. Merlin Moncure <[EMAIL PROTECTED]> wrote: On 4/11/07, Andre

Re: [GENERAL] hashtext () and collisions

2007-04-11 Thread Andrew - Supernews
y bits_ in your hash value than you think you do. (e.g. using md5(), which is a 128-bit hash) -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [GENERAL] role passwords and md5()

2007-04-12 Thread Andrew Kroeger
g_authid WHERE rolname='my_user' AND rolpassword = 'md5' || md5('my_password' || 'my_user'); Hope this helps. Andrew ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] Download source

2007-04-18 Thread Andrew Toth
sztelettel: / Grüße / Yours sincerely, Andrew Toth [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] ICQ: 311-837-922 homepage: http://tothaa.mydns.hu mirror: http://toan.fw.hu

Re: [GENERAL] Download source

2007-04-19 Thread Andrew Toth
2007. 04. 18, szerda keltezéssel 18.21-kor Alvaro Herrera ezt írta: > Andrew Toth wrote: > > Dear List, > > > > I would like to download the version of source code containing > > catversion.h with the line "#define CATALOG_VERSION_NO 200611051". Thi

Re: [GENERAL] Download source

2007-04-20 Thread Andrew Toth
2007. 04. 19, csütörtök keltezéssel 16.09-kor Alvaro Herrera ezt írta: > Andrew Toth wrote: > > 2007. 04. 18, szerda keltezéssel 18.21-kor Alvaro Herrera ezt írta: > > > > > Andrew Toth wrote: > > > > Dear List, > > > > > > > > I

Re: [GENERAL] selective export for subsequent import (COPY)

2007-04-23 Thread Andrew Kroeger
works with bash, csh, tcsh, and ksh under Linux: In order to emit an actual tab character on the shell command line (and ignore any shell auto-completion features that are normally tied to the tab key), preface the literal tab character with Ctrl-V. Thus, the delimiter speci

Re: [GENERAL] [HACKERS] Kill a Long Running Query

2007-04-25 Thread Andrew Dunstan
d our excellent documentation. It contains the answers to your questions, I believe. cheers andrew ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Processing a work queue

2007-04-28 Thread Andrew - Supernews
On 2007-04-26, Steve Crawford <[EMAIL PROTECTED]> wrote: > Anyone have any ideas on how to handle a work queue? Advisory locks (userlocks in pre-8.2). -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services ---(end of

[GENERAL] Re: [HACKERS] SOS, help me please, one problem towards the postgresql developement on windows

2007-05-01 Thread Andrew Dunstan
ed to be extensible, but you are apparently ignoring the extensibility features. cheers andrew ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Processing a work queue

2007-05-01 Thread Andrew - Supernews
On 2007-04-30, "John D. Burger" <[EMAIL PROTECTED]> wrote: > Andrew - Supernews wrote: > >>> Anyone have any ideas on how to handle a work queue? >> >> Advisory locks (userlocks in pre-8.2). > > Can someone explain why these are a better fit t

[GENERAL] Indexing questions: Index == key? And index vs substring - how successful?

2007-05-03 Thread Andrew Edson
As the title of this message suggests, I've got a couple of questions about indexing that I'm not sure about. I've tried to take a look at the docs, but I can't remember seeing anything on these; it's quite possible, I admit, that I'm simply not remembering all of what I saw, but I would apprec

Re: [GENERAL] Slow query and indexes...

2007-05-07 Thread Andrew Kroeger
for you, you may also be able to eliminate the (data_logger_id, date_time) index if no other queries need it (i.e. you added it in an attempt to speed up this specific case). Hope this helps. Andrew ---(end of broadcast)--- TIP 9: In versions below 8.0

Re: [GENERAL] Dangers of fsync = off

2007-05-08 Thread Andrew Sullivan
roduces problems for replication, which is indeed possible. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton

Re: [GENERAL] Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

2007-05-17 Thread Andrew Sullivan
n B mounts that disk. Anything else is just asking for your weekend to be ruined by a data recovery. A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimate month" is not in truth a good way of saying November. --H.W. Fowler ---(end

Re: [GENERAL] Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

2007-05-17 Thread Andrew Sullivan
lue company has a similar product, that in my experience does _not_ always work as advertised. A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA ---(end of broadcast)

Re: [GENERAL] Data replication through disk replication

2007-05-18 Thread Andrew Sullivan
that there are different kinds of need and therefore different replication technologies.) A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)--- TI

Re: [GENERAL] Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

2007-05-18 Thread Andrew Sullivan
t talk themselves into specifying this on Thursday and deploying on Monday. A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics problem. --Bruce Schneier ---(end of broadcast)--

Re: [GENERAL] Data replication through disk replication

2007-05-18 Thread Andrew Sullivan
ruption in such a case? This is entirely out of PostgreSQL's control, and up to the operating system and cluster/failover implementation you have. Note that there are many ways to do this wrong, including things like using tokens on the filesystem as a lockfile (I swear someone once proposed th

Re: [GENERAL] Data replication through disk replication

2007-05-19 Thread Andrew Sullivan
BM recommends DRBD for DB2. IBM also sells HACMP. I refuse to comment on whether IBM's advice on high availability products is worth taking seriously. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marke

Re: [GENERAL] Data replication through disk replication

2007-05-20 Thread Andrew Sullivan
, though, so I have to assume it doesn't. (It's not the question of what it could do, but what it actually does, that's the important one for implementors.) A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do s

Re: [GENERAL] Problem with pg_dump

2007-05-22 Thread Andrew Sullivan
OID 225893271 not found You're using Slony, right? You can't use pg_dump on a database where _any_ table is Slony-replicated right now. Yes, this is due to the catalogue corruption Slony introduces. There's an alternative in the Slony tools/ directory. A -- Andrew Sulliva

Re: [GENERAL] Integrity on large sites

2007-05-23 Thread Andrew Sullivan
m bugs in application code. If your data is worth storing, it's surely worth storing correctly. A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimate month" is not in truth a good way of saying November. --H.W. Fowler ---(

Re: [GENERAL] Need software infrastructure advice

2007-05-23 Thread Andrew Sullivan
have to talk to all other nodes. (I think the flakey network might bite you here, though.) A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA ---(end of broadcast)-

Re: [GENERAL] why postgresql over other RDBMS

2007-05-24 Thread Andrew Sullivan
nted hack in a connection pool. I'm shuddering at the thought of it, to be honest, so details are left as an exervisse for the reader. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising

Re: [GENERAL] why postgresql over other RDBMS

2007-05-25 Thread Andrew Sullivan
community probably means a lower estimation of the value of the feature. So features that seem sort of boutique are to be regarded at least with scepticism, in order to keep the code useful for everyone. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. Wh

Re: [GENERAL] why postgresql over other RDBMS

2007-05-25 Thread Andrew Sullivan
own immediate interests, like patch review, so that when later they say, "This patch works," there is a stronger probability the community will take seriously their claims that the patch works correctly. Free software never comes without cost, and this is one of them. A -- Andrew

Re: [GENERAL] why postgresql over other RDBMS

2007-05-25 Thread Andrew Sullivan
actually does this sort of trick in order to get exception handling. A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimate month" is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] why postgresql over other RDBMS

2007-05-25 Thread Andrew Sullivan
s also the kind that is likely to have dedicated storage hardware for that database. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris --

Re: [GENERAL] createdb.exe prompting for password on Vista

2007-05-28 Thread Andrew Sullivan
> so why does it ask me for a password? You must have password authentication enabled. You'd have to change it to "trust", I guess. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. Tha

Re: [GENERAL] why postgresql over other RDBMS

2007-05-28 Thread Andrew Sullivan
ome time. And there are a lot of grotty corners to IPv6 for which there are no analogies in IPv4. Uh, scoped addresses, anyone ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics problem. --Bruce Schn

Re: [GENERAL] createdb.exe prompting for password on Vista

2007-05-28 Thread Andrew Sullivan
s, so if there's some Windows-specific tricks, you may need to know that. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- TIP 3:

Re: [GENERAL] createdb.exe prompting for password on Vista

2007-05-28 Thread Andrew Sullivan
t it will work > for now. You could perhaps set up a .pgpass just for you at the beginning as well; but in general, yes, if you have to rely on someone else managing the permissions to the back end, then you also have to be able to cope with the authentication mechanisms. A -- Andrew Sulliv

  1   2   3   4   5   6   7   8   9   10   >