Re: [GENERAL] Allow only certain query on replication slave

On Tue, Oct 24, 2017 at 8:12 AM, basti <mailingl...@unix-solution.de> wrote: > > > Is there a way to allow only the above query and deny all other? > Probably easiest to just configure your HBA to restrict all connections/uses except the one that does your xlog query checks. D

Re: [GENERAL] Finally upgrading to 9.6!

On Wed, Oct 18, 2017 at 4:17 PM, Vik Fearing <vik.fear...@2ndquadrant.com> wrote: > On 10/18/2017 08:17 PM, Don Seiler wrote: > > > I disagree with this. It isn't my company's business to test the > > Postgres software in development, as much as it would be ne

Re: [GENERAL] Finally upgrading to 9.6!

d I quickly put that down. Oracle DBAs have a similar rule of thumb with anything less than .2 (Oracle starts at .1). Don. -- Don Seiler www.seiler.us

Re: [GENERAL] Fwd: 2 process postgres -D for one instance

/data -i -p 5450 -h > bd-sillage.info. > > It appears that the second one is a process forked off from the first > one. That looks normal to me. > > > Because of the reference to 17769 in the second entry? > > -- Don Seiler www.seiler.us

Re: [GENERAL] Charlotte Postgres User Group

Definitely putting this on my calendar. I have not been aware of other PostgreSQL users here - would love to meet some other users. Don On Wed, Feb 17, 2016 at 10:39 AM, Boyan Botev <bbo...@gmail.com> wrote: > If you live near or around Charlotte, please join us for the inaugural

Re: [GENERAL] Multi-Table Insert/Update Strategy - Use Functions/Procedures?

On Wed, Jan 27, 2016 at 6:24 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Jan 27, 2016 at 4:03 PM, Don Parris <parri...@gmail.com> wrote: > > > ​Parameter passing and variables are client-side considerations. You > haven't told us how

Re: [GENERAL] Multi-Table Insert/Update Strategy - Use Functions/Procedures?

On Wed, Jan 27, 2016 at 4:25 PM, Joshua Berkus wrote: > > > > Am I on the right track, or is there some better way to set this up? My > > understanding is that views really aren't meant for insert/update > > operations, and I have seen on the web that using views to

[GENERAL] Multi-Table Insert/Update Strategy - Use Functions/Procedures?

ng views to insert/update is a bit tricky - and still requires a procedure with a rule on the view. Thanks, Don -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ <https://www.xing.com/profile/Don_Parris> <http://w

[GENERAL] Schemas, Roles & Search Path

Hi all, I just want to check my understanding of schemas, search paths and roles in implementing my database design. Scenario: A database with various "modules" (groups of tables & views, etc.), some of which are shared in common across a given organization, but others are specific to a given

Re: [GENERAL] Schemas, Roles & Search Path

ode. > On Sat, Jan 9, 2016 at 10:22 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> Don Parris <parri...@gmail.com> writes: >> > I *think* I want to set the search path on the group roles so that the >> > Facilities team can see the COMMON and FACILITIES schemas: &g

Re: [GENERAL] Schemas, Roles & Search Path

On Sat, Jan 9, 2016 at 10:22 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Don Parris <parri...@gmail.com> writes: > > I *think* I want to set the search path on the group roles so that the > > Facilities team can see the COMMON and FACILITIES schemas: > > ALTER

[GENERAL] Windows Installation User account - Correct database for us

as an alternative. I was hoping the members of this group may have some comments or suggestions as to the direction we should look at. Thank you and appreciate any comments/suggestions Don

[GENERAL] Windows Installation User account - Correct database for us

as an alternative. I was hoping the members of this group may have some comments or suggestions as to the direction we should look at. Thank you and appreciate any comments/suggestions Don

Re: [GENERAL] Locale Issue

On Thu, Aug 22, 2013 at 3:23 AM, Stuart Bishop stu...@stuartbishop.netwrote: On Wed, Aug 21, 2013 at 4:55 PM, Don Parris parri...@gmail.com wrote: I did run pg_dropcluster, pg_createcluster (setting locale to C.UTF8) - and that seemed to work, except that I could not thereafter make remote

Re: [GENERAL] Locale Issue

On Thu, Aug 22, 2013 at 11:29 AM, Don Parris parri...@gmail.com wrote: On Thu, Aug 22, 2013 at 3:23 AM, Stuart Bishop stu...@stuartbishop.netwrote: On Wed, Aug 21, 2013 at 4:55 PM, Don Parris parri...@gmail.com wrote: SNIP you install the PostgreSQL packages, it runs pg_createcluster

Re: [GENERAL] Locale Issue

On Thu, Aug 22, 2013 at 5:12 PM, Vincent Veyron vv.li...@wanadoo.fr wrote: Le jeudi 22 août 2013 à 11:29 -0400, Don Parris a écrit : Still, how could I have made UTF-8 the default encoding at install time? I did several recent installations of Postgresql on Debian Wheezy with UTF8

[GENERAL] Locale Issue

connections (despite resetting the hba and postgres.conf files as they should be). Thanks! Don -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ https://www.xing.com/profile/Don_Parrishttp://www.linkedin.com/in/dcparris GPG Key ID

Re: [GENERAL] Locale Issue

On Wed, Aug 21, 2013 at 10:08 AM, Tom Lane t...@sss.pgh.pa.us wrote: Don Parris parri...@gmail.com writes: SNIP initdb will absorb locale/encoding from its environment, unless told otherwise through a --locale switch. So the usual expectation would be that it'd work like you want

Re: [GENERAL] (SOLVED)How To Install Extension Via Script File?

and use the ltree data type. Two related points remain a bit confusing, but I will read up more and re-post if I cannot figure them out. Thanks all! Don -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ https://www.xing.com

Re: [GENERAL] How To Install Extension Via Script File?

On Thu, Aug 8, 2013 at 8:42 PM, Tom Lane t...@sss.pgh.pa.us wrote: Don Parris parri...@gmail.com writes: When I try a simple psql -U postgres -W - just to initiate the psql session, I get: psql: FATAL: Peer authentication failed for user postgres It's like my regular user cannot

Re: [GENERAL] How To Install Extension Via Script File?

On Fri, Aug 9, 2013 at 11:49 AM, Quentin Hartman qhart...@direwolfdigital.com wrote: A bit of an aside, but you also might want to change that CREATE EXTENSION ltree; to CREATE EXTENSION IF NOT EXISTS ltree; That way your script won't error out if the extension is already enabled. Thanks

[GENERAL] How To Install Extension Via Script File?

a permission denied error. I did create a password for my postgres user (hence the -W option). And this is on a local box. How can I run my script? Thanks! Don -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ https

Re: [GENERAL] How To Install Extension Via Script File?

On Thu, Aug 8, 2013 at 5:44 PM, Thomas Kellerer spam_ea...@gmx.net wrote: Don Parris wrote on 08.08.2013 23:13: And to be able to run it from the Bash prompt (as securely as possible). I thought I could add the commands and run the create script by doing: sudo -u postgres psql -U user -W

Re: [GENERAL] How To Install Extension Via Script File?

On Thu, Aug 8, 2013 at 5:45 PM, Rob Sargent robjsarg...@gmail.com wrote: On 08/08/2013 03:13 PM, Don Parris wrote: Hi all, I have a database that uses the ltree extension. I typically create a new database like so (as a normal user), using my script file: CREATE DATABASE mydb

Re: [GENERAL] How To Install Extension Via Script File?

On Thu, Aug 8, 2013 at 6:30 PM, John R Pierce pie...@hogranch.com wrote: On 8/8/2013 2:13 PM, Don Parris wrote: I thought I could add the commands and run the create script by doing: sudo -u postgres psql -U user -W -d mydb --file=/home/user/dev/mydb_** create.sql I thought that, running

[GENERAL] Connecting Multiple LibreOffice Base Users to a Remote Postgres Database

to showcase a small project using LibreOffice Base as a front-end to PostgreSQL. http://dcparris.net/2013/07/22/ill-call-it-ldinero/ In any case, I hope these will be of some use to others here. Please enjoy and let me know if you need any clarification of any of my points. Regards, Don -- D.C. Parris

[GENERAL] LibreOffice Base and PostgreSQL Transactions

, Don -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ https://www.xing.com/profile/Don_Parrishttp://www.linkedin.com/in/dcparris GPG Key ID: F5E179BE

Re: [GENERAL] LibreOffice Base and PostgreSQL Transactions

On Thu, Jul 18, 2013 at 5:01 PM, Joshua D. Drake j...@commandprompt.comwrote: On 07/18/2013 01:44 PM, Don Parris wrote: Maybe I really need something like macros and BASIC or Python to make such a thing work? If anyone knows a good tutorial on this subject, I can certainly read - just

[GENERAL] PostgreSQL Presentation at SELF 2013

on the SouthEast LinuxFest. http://dcparris.net/2013/06/11/southeast-linuxfest-what-you-missed/ Anyway, here's hoping you'll enjoy this and find it useful as the few attendees who sat in did. I hope it helps in some small way. Regards, Don -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security

Re: [GENERAL] Tutorial On Connecting LibreOffice to PostgreSQL Available

You're welcome! Heaven knows, I ask plenty of questions - it's good to be able to offer an answer now and again. :-) Don On Mon, Jul 9, 2012 at 6:04 PM, Willy-Bas Loos willy...@gmail.com wrote: thx for sharing! On Fri, Jul 6, 2012 at 9:13 PM, Don Parris parri...@gmail.com wrote: Hi all

[GENERAL] Tutorial On Connecting LibreOffice to PostgreSQL Available

Hi all, I believe this may be pertinent here. Last year I wrote a tutorial on connecting LibreOffice to the powerful PostgreSQL database server. Now there is an updated driver that allows read-write access. So I've updated my tutorial, complete with screenshots this time. The actual connection

Re: [GENERAL] out of memory - no sort

on the client machine. Both machines are 64bit. Thanks Don On 8/30/2011 10:25 AM, Pavel Stehule wrote: Hello if table is large, then client can raise this exception too try to set FETCH_COUNT to 1000 http://www.postgresql.org/docs/8.4/interactive/app-psql.html Regards Pavel Stehule 2011

Re: [GENERAL] out of memory - no sort

factor ? On 8/31/2011 8:57 AM, Scott Ribe wrote: On Aug 31, 2011, at 9:51 AM, Don wrote: Both machines are 64bit. Are all your server client builds 64-bit? 32M rows, unless the rows are 50 bytes each, you'll never be able to manipulate

[GENERAL] out of memory - no sort

I am trying a simple access of a table and get an out of memory error. How do I avoid this issue. It seems I have some configuration set wrong. Our system has 24GB of memory and is dedicated to the postgres database.

[GENERAL] What happen to the VARATT_SIZEP macro in version 8.3?

Hello all, I have C code which defines some user defined postgres functions. This code has been used with Postgres version 7.4 and it uses the VARATT_SIZEP macro. I updated to Postgres version 8.3 and attempted to compile my C code and noticed that the VARATT_SIZEP macro (which my code

[GENERAL]

good day webmaster. i want to ask some help from you. my problem is this. i have already installed postgres on a certain computer. i have already created tables and put necessary data in it. one day, my operating system bugged down (i am using windows xp). how could i possible retireve

[GENERAL] Beginner's Questions

, myself, unless I have to be. My development boxes are a 1.1 GHz Athlon with 512 RAM with XP and a dual-processor G4 with MacOS 10.4.) Are there ballpark requirements for what such a database will need to run? Thanks! Don ---(end of broadcast

Re: [GENERAL] Beginner's Questions

, many more questions as I continue the development process. Cheers! Don ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] Cannot digest subscribe

this is a nice community! Thanks, Don Begin forwarded message: From: [EMAIL PROTECTED] Date: March 4, 2007 9:28:30 AM EST To: Don Lavelle [EMAIL PROTECTED] Subject: Majordomo results Reply-To: [EMAIL PROTECTED] subscribe-digest pgsql-general The subscribe command did not succeed

[GENERAL] ERROR: type i does not exist

In the postgres log I am getting the following: ERROR: type i does not exist What is the cause of this error and/or how do I track it down? I am running postgres ver 8.1.4 under redhat 4 Thanks for any help Don begin:vcard fn:Don Laurine - DOH n:Laurine;Don org:Northwest River Forecast

Re: [GENERAL] [NOVICE] Question About Aggregate Functions

On 9/13/06, Brandon Aiken [EMAIL PROTECTED] wrote: Ah, I did not know what was in your fields, so I did not assume they were Boolean values. It looked to me like you were trying to use IS TRUE to substitute for the lack of a GROUP BY, so I didn't know what to do.That was in the

Re: [GENERAL] pl/R problem

Michael Fuhr wrote: On Tue, Aug 22, 2006 at 04:24:46PM -0500, Don Isgitt wrote: gds2=# create function sd(_float8) returns float as '' language 'plr'; CREATE FUNCTION gds2=# select round(sd('{1.23,1.31,1.42,1.27}'::_float8)::numeric,8); server closed the connection unexpectedly

Re: [GENERAL] pl/R problem

Adam Witney wrote: Don Isgitt wrote: Michael Fuhr wrote: On Tue, Aug 22, 2006 at 04:24:46PM -0500, Don Isgitt wrote: gds2=# create function sd(_float8) returns float as '' language 'plr'; CREATE FUNCTION gds2=# select round(sd('{1.23,1.31,1.42,1.27}'::_float8)::numeric,8

Re: [GENERAL] pl/R problem

Michael Fuhr wrote: On Wed, Aug 23, 2006 at 08:38:01AM -0500, Don Isgitt wrote: Thanks for the reply and the research. The relevant file is [EMAIL PROTECTED] R-2.3.0]$ ls -l $R_HOME/etc/Renviron -rw-rw-r--1 djisgitt djisgitt 1151 Jun 1 11:42 /home/djisgitt/R-2.3.0/etc/Renviron

Re: [GENERAL] pl/R problem

Alvaro Herrera wrote: Don Isgitt wrote: Michael Fuhr wrote: On Wed, Aug 23, 2006 at 08:38:01AM -0500, Don Isgitt wrote: Thanks for the reply and the research. The relevant file is [EMAIL PROTECTED] R-2.3.0]$ ls -l $R_HOME/etc/Renviron -rw-rw-r--1 djisgitt djisgitt

[GENERAL] pl/R problem

So, the question: what am I missing that enables it to find the Renviron Thank you. Don ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] ALTER SEQUENCE

Tom Lane wrote: Don Y [EMAIL PROTECTED] writes: Jim C. Nasby wrote: This is a very minor reason why you should be running the most recent 8.0.x release and not 8.0.3. A much bigger reason is that there are data-loss bugs that have been fixed. The folks watching the Postgres releases haven't

Re: [GENERAL] ALTER SEQUENCE

Jim C. Nasby wrote: On Wed, May 17, 2006 at 03:00:48PM -0700, Don Y wrote: I see the documentation mention added August 1, 2005 byt Tom Lane. Date tag on the bottom of my man pages is 2005-01-17 -- so that explains *that*! : This is a very minor reason why you should be running the most

Re: [GENERAL] Contributing code

Tom Lane wrote: Tim Allen [EMAIL PROTECTED] writes: Don Y wrote: So, I'll deploy them and get feedback on which features I may need to add (some of the data types are probably a bit too exotic for most users). I figure I can always contribute them just before a release... Just before

Re: [GENERAL] Contributing code

Martijn van Oosterhout wrote: On Tue, May 16, 2006 at 08:12:05PM -0700, Don Y wrote: Hi, Is it possible to have one of my user defined data types reviewed/critiqued to see if there are things that I am not doing properly? Or, other things that I should be including? Or, should I just

[GENERAL] ALTER SEQUENCE

Hi, It doesn't appear that there is a way to rename a sequence (ideally with a cascade action). Nor does there appear to be a way to change the owner of a sequence. Obviously, I can DROP and recreate... *but*, how prudent (foolish?) would it be just to change the entries in the system tables,

Re: [GENERAL] ALTER SEQUENCE

Bruce Momjian wrote: Don Y wrote: Hi, It doesn't appear that there is a way to rename a sequence (ideally with a cascade action). Uh, the ALTER SEQUENCE manual page says: Uh, the 8.0.3 man page for ALTER SEQUENCE makes no mention of this. Nor does \h ALTER SEQUENCE in psql yield any

Re: [GENERAL] ALTER SEQUENCE

Bruce Momjian wrote: Don Y wrote: Bruce Momjian wrote: Don Y wrote: Hi, It doesn't appear that there is a way to rename a sequence (ideally with a cascade action). Uh, the ALTER SEQUENCE manual page says: Uh, the 8.0.3 man page for ALTER SEQUENCE makes no mention of this. Nor does \h

[GENERAL] Namespace issues

than a single namespace for functions, this just won't work. What am I failing to see, here? Thanks! --don ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] error handling in cast functions for user defined types

Tom Lane wrote: Don Y [EMAIL PROTECTED] writes: I'm writing a set of casts to/from various user defined types. As is unexpected, there are cases where one data type doesn't neatly map to another (for certain values). In these cases I emit an INVALID_PARAMETER_VALUE or OUT_OF_RANGE error

Re: [GENERAL] Namespace issues

Martijn van Oosterhout wrote: On Tue, May 16, 2006 at 10:29:27AM -0700, Don Y wrote: Given a user defined type foo... I've created several casts to/from foo and built-in types. I had adopted a naming convention of: baz foo_to_baz(foo); foo foo_from_baz(baz); But: snip I don't see how I

[GENERAL] Type checking

) that computes 1/x for any value of x without testing for x==0? grimace Am I being clear enough about the question I am asking? :-/ Thanks! --don ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Contributing code

Hi, Is it possible to have one of my user defined data types reviewed/critiqued to see if there are things that I am not doing properly? Or, other things that I should be including? Or, should I just contribute it and hope for the best? (if so, how do I do that?) Thanks! --don

[GENERAL] error handling in cast functions for user defined types

PG_RETURN_NULL()? I note the cast of int4's to int2's signal similar errors -- *but* returns (int2) value. Is the return value just *ignored* when the error is signaled? Thanks! --don ---(end of broadcast)--- TIP 1: if posting/reading through

Re: [GENERAL] ISSTRICT behavior

Tom Lane wrote: Don Y [EMAIL PROTECTED] writes: Is there any way of mimicking the IS STRICT behavior *without* declaring the function as STRICT? Are you looking for PG_RETURN_NULL()? If not, this seems a bit nonsensical. No. First, if the function is defined to return an INT16

Re: [GENERAL] ISSTRICT behavior

Martijn van Oosterhout wrote: On Wed, May 03, 2006 at 11:02:26PM -0700, Don Y wrote: (sigh) Sorry to be picking nits. I'm just trying to sort out how to protect against folks making careless mistakes in the future (e.g., forgetting STRICT in the function declarations when adding a function

Re: [GENERAL] ISSTRICT behavior

Tom Lane wrote: Don Y [EMAIL PROTECTED] writes: Is there any way to prevent them from *adding* these functions (i.e. build them into template) so they have to use them the way *I* have already defined them? Only if you think you can deny your users superuser privileges on their own databases

Re: [GENERAL] ISSTRICT behavior

Martijn van Oosterhout wrote: On Wed, May 03, 2006 at 11:45:31PM -0700, Don Y wrote: Martijn van Oosterhout wrote: Unfortunatly there is no way to ensure the user declares the function in SQL in the way your code expects. I remember a discussion once about allowing you to declare the essential

Re: [GENERAL] ISSTRICT behavior

Tom Lane wrote: Don Y [EMAIL PROTECTED] writes: First, if the function is defined to return an INT16, then returning a NULL doesn't make any sense -- since the caller doesn't know how to deal with a NULL (it expects an INT16, for example). Really? That would be a caller bug, if it's calling

Re: [GENERAL] ISSTRICT behavior

Martijn van Oosterhout wrote: On Thu, May 04, 2006 at 12:19:12AM -0700, Don Y wrote: I'm not designing for the traditional role that you're used to so I can do whatever makes sense for this product and just *define* that as it's behavior. Since there are no other products that compete

Re: [GENERAL] ISSTRICT behavior

Martijn van Oosterhout wrote: On Thu, May 04, 2006 at 12:29:30AM -0700, Don Y wrote: OTOH, if the function could *abort* it's invocation, then I don't have to worry about return values. It is a closer model to the STRICT behavior -- instead of aborting the function invocation BEFORE (which

Re: [GENERAL] ISSTRICT behavior

Martijn van Oosterhout wrote: On Thu, May 04, 2006 at 12:23:07AM -0700, Don Y wrote: I don't want to hide the function; just ensure that no one *redefines* the SQL interface to it in a manner that is inconsistent with its implementation. If I can make the implementation robust enough

[GENERAL] ISSTRICT behavior

., forgetting STRICT in the function declarations when adding a function to a database, etc) Thanks! --don ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Return value (instead of reference) for user defined type

but this type fits in an int4 so value seems more economical). I don't see anything in the documentation that suggests that I can NOT do this... :-/ Below, snippets of the implementation and associated SQL. Thanks for any pointers! --don typedef int4 foo; PG_FUNCTION_INFO_VI(foo_in

Re: [GENERAL] PG_RETURN_?

Richard Huxton wrote: Don Y wrote: Hi, I have a set of functions for a data type that return small integers (i.e. [0..12]). I can, of course, represent it as a char, short or long (CHAR, INT16 or INT32). re there any advantages/drawbacks to chosing one particular PG_RETURN_ type over another

Re: [GENERAL] PG_RETURN_?

Martijn van Oosterhout wrote: On Tue, May 02, 2006 at 08:43:03AM -0700, Don Y wrote: Richard Huxton wrote: Don Y wrote: Hi, I have a set of functions for a data type that return small integers (i.e. [0..12]). I can, of course, represent it as a char, short or long (CHAR, INT16 or INT32). re

Re: [GENERAL] PG_RETURN_?

Martijn van Oosterhout wrote: On Tue, May 02, 2006 at 10:06:19AM -0700, Don Y wrote: The type as declared determines the storage required to store it. That Yes, but for a function returning a value that does not exceed sizeof(Datum), there is no *space* consequence. I would assume most modern

Re: [GENERAL] Return value (instead of reference) for user defined

Tom Lane wrote: Don Y [EMAIL PROTECTED] writes: Nearest I can tell, the problem is related to my attempt to return an int by value If that's what you intend, try cluing in CREATE TYPE (see PASSEDBYVALUE). Thanks! That did the trick! --don ---(end of broadcast

[GENERAL] Calling V1 function from within the server

this issue by creating an internal function that is used by other functions -- and *wrapped* in the PG_FUNCTION_INFO_V1 framework under another name (i.e. that name is never used directly in the rest of the code) --don ---(end of broadcast)--- TIP 9

Re: [GENERAL] Calling V1 function from within the server

Martijn van Oosterhout wrote: On Tue, May 02, 2006 at 11:24:34AM -0700, Don Y wrote: Hi, If I define: Datum barcode_checksum(PG_FUNCTION_ARGS) PG_FUNCTION_INFO_V1(barcode_checksum) snip and now want to *use* that function within some other (related) function, how can I invoke

Re: [GENERAL] Use of ISpell dictionaries with tsearch2 - what is the point?

about the use of English ISpell, then what would be the best sequence, e.g. French ISpell, English ISpell, English stemmer? -Original Message- From: Teodor Sigaev [mailto:[EMAIL PROTECTED] Sent: May 1, 2006 10:31 To: Don Walker Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Use

[GENERAL] PG_RETURN_?

just casts)? Thanks! --don ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] I18N

What is the preferred way of issuing errors of the form: Delimiter expected after character #3 (where 3 obviously varies). ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] Use of ISpell dictionaries with tsearch2 - what is the point?

I'm new to using tsearch2 and am trying to understand why I would want to use an ISpell dictionary before the stemming dictionary. I'd originally hoped that ISpell would suggest corrections for misspelled words as the documents that I will be indexing will contain a lot of spelling mistakes. From

Re: [GENERAL] Use of ISpell dictionaries with tsearch2 - what is the point?

with misspellings in English and/or French? 2.2 Are there any clever linguistic algorithms that can partly solve the same problem? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Walker Sent: April 28, 2006 15:11 To: pgsql-general@postgresql.org Subject

[GENERAL] Please comment on the following OpenFTS/tsearch2 issues!

This topic was originally posted to the OpenFTS-general list on April 24, 2006. There were no replies in about 22 hours so I'm reposting to this more active list. I'm investigating OpenFTS and tsearch2 to see if they provide enough full-text searching features to be used in a new application.

[GENERAL] Hidden field for each column

to implement them but I was hoping for something slicker... :) Thanks! --don ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Upcalls (sort of) from the database

for confirmation. Then, *if* confirmed, do the real INSERT. Is there a more elegant way? Thanks, --don ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Upcalls (sort of) from the database

Bernhard Weisshuhn wrote: Don Y wrote: [snip] For example, the title may match an existing entry -- but the author may be different (e.g., misspelled, or some other author listed on a book having multiple authors, etc.). Ideally, I would like the database to suspend the INSERT, ask

Re: [GENERAL] User defined data type

Martijn van Oosterhout wrote: On Thu, Mar 30, 2006 at 11:51:41AM -0700, Don Y wrote: [snipped questions and answers] Thanks! - Wish list item: errdetail(va_list arg) et al. functions (Yeah, I can write my own... but it would be nice if this was part of the error reporting routines

Re: [GENERAL] User defined data type

Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: On Thu, Mar 30, 2006 at 11:51:41AM -0700, Don Y wrote: - Can *_in() be ever invoked with a NULL argument? Or, can I safely assume that the pointer I am passed is valid? You can't get a NULL there. Yes, the pointer is valid

Re: [GENERAL] User defined data type

Tom Lane wrote: Don Y [EMAIL PROTECTED] writes: Yeah, I was hoping someone would have built a template for new types that trimmed everything down to a single page/file instead of having to snoop the source tree. :-( The various new types in contrib/ are there in part to serve as models

Re: [GENERAL] database design questions

... keep the charge! [sic] : --don ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] User defined data type

) -- mainly due to embedded commentary, etc. Thanks for any pointers. And, apologies if this was the *wrong* list for this post! :-( --don ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index

[GENERAL] 32/64 architectures for backup/WALs

I saw a posting about not being able to backup/WALs on different architectures for 8.0.6. Is this still true for the current release? Don HayesDatabase AdministratorTualatin Hills Parks Recreation DistrictPhone: (503) 614-1219FAX: (503) 629-5398

Re: [GENERAL] Index use in BETWEEN statement...

. Don ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] point(lseg,lseg) does not exist

and the result is the intersection point. Don ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Update sql question

opr_match.oldopr=master.operator; if no match, just update to self. Fine. What am I doing wrong that gives me the 261 null operator fields after the update? Thank you very much for your assistance. Don p.s. The operator is not null where clause is needed for other states that do have null operator values

Re: [GENERAL] Update sql question

Tom Lane wrote: Don Isgitt [EMAIL PROTECTED] writes: gds2=# update master set operator=(select coalesce(newopr,master.operator) from opr_match where state=master.state and oldopr=master.operator limit 1) where state='NM' and operator is not null; I think what you want is gds2

[GENERAL] ECPG - Timestamp to ascii Conversion PG version 7.4

away from INFORMIX. -- Don Laurine NOAA, Northwest River Forecast Center voice: (503) 326-7291 (ext. 323) ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere

[GENERAL] substring and POSIX re's

re's is they are always greedy. So, why do I get only SE instead of NE NE SE? Pilot error, probably, but would someone please enlighten me? Thank you very much. Don p.s. The target string can have from 1 to 6 of the 2 char strings, not just 3 as shown in this example

Re: [GENERAL] substring and POSIX re's

Tom Lane wrote: Don Isgitt [EMAIL PROTECTED] writes: gds2=# select substring('NE NE SE 2310 FSL 330 FEL' from '^([A-Z][A-Z] )+'); substring --- SE (1 row) The pg docs say that this form of substring uses POSIX re's, and my understanding of POSIX re's is they are always greedy

Re: [GENERAL] substring and POSIX re's

Michael Fuhr wrote: On Tue, Apr 19, 2005 at 12:39:52PM -0400, Alvaro Herrera wrote: On Tue, Apr 19, 2005 at 10:03:45AM -0600, Michael Fuhr wrote: On Tue, Apr 19, 2005 at 11:17:46AM -0500, Don Isgitt wrote: Thanks, Tom. Interestingly enough, neither my original query or your

Re: [GENERAL] Recovering db from cracked server

a million; I've got my data back. Don Doumakes Email: doumakes at loganet.net Do not reply to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] how to capture query?

M Hi, M I'm getting some errors in log file saying invalid character at M position M #20... I know that this is most likely that query is wrong. M Is it possible to capture all queries that get send or at least the M invalid queries? M I'm using postgresql 7.4.3 on Red Hat 9 M Thanks, M Mark

  1   2   >