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 wrote: > If you live near or around Charlotte, please join us for the inaugural > meeting of

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?

I have several tables related to people and their contact information, and want db users to be able to add or update a given person and their respective contact information in one step, and get all the information into the correct tables. I think I am ok with setting the privileges on the tables

[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

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

Hi all, When I install the Kubuntu (13.04) postgresql (9.1) packages, the default template1 encoding turns out to be ASCII, which is not really what I want. My OS locale command reveals everything to be en_US.UTF-8, except for LC_ALL, which is left open. I am guessing that my best bet is to

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?

On Sat, Aug 10, 2013 at 10:05 AM, Tom Lane t...@sss.pgh.pa.us wrote: Chris Travers chris.trav...@gmail.com writes: As for whether UTF-8 is the default, it is in many cases, but I remember struggling with the fact that a few Linux distros still default to SQL-ASCII. Ultimately this is

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?

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 WITH TEMPLATE template0 ENCODING 'UTF8'; And then su to postgres, login and install the ltree extension on mydb. Then I logout of my

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

Hi all, I have been posting on my blog about getting LibreOffice Base and PostgreSQL working together. My latest actually focuses on getting multiple users connecting to a single, remote, stand-alone PostgreSQL server. You can set this up fairly quickly and - in my case, anyway - with no

[GENERAL] LibreOffice Base and PostgreSQL Transactions

Hi all, I have a 4-table DB in PostgreSQL to which I connect using LibreOffice Base. I have a form with 2 subforms in place that allows me to: Select an existing entity (from the ENTITY table) Add a new financial transaction (to the TRANSREC table) Add new line items for each transaction (to the

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

Hi all, I am a member of the Charlotte Linux User Group and did a presentation on PostgreSQL at the SouthEast LinuxFest this past weekend. Our LUG table was right next to the PostgreSQL table this year, and I am guessing some of you will find the presentation of some interest. My discussion

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] [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