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 the Charlotte PUG o
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 wrote:
>
>
> Parameter passing and variables are client-side considerations. You
> haven't told us how you plan to execute
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 insert/update
> is
> > a bit
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 a
On Sat, Jan 9, 2016 at 10:22 AM, Tom Lane wrote:
> Don Parris 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 ROLE fm_users search_path=common, facilities, accoun
L will naturally assume lowercase for all
> objects
> unless they are quoted. So probably you want schema names to be common,
> facilities, etc.
>
>
Thanks. I was just capitalizing for the e-mail. I never actually use
upper or camel case in my code.
> On Sat, Jan 9, 2016 at
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 dep
On Thu, Aug 22, 2013 at 5:12 PM, Vincent Veyron 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 Wheez
On Thu, Aug 22, 2013 at 11:29 AM, Don Parris wrote:
> On Thu, Aug 22, 2013 at 3:23 AM, Stuart Bishop wrote:
>
>> On Wed, Aug 21, 2013 at 4:55 PM, Don Parris wrote:
>>
>>
> you install the PostgreSQL packages, it runs pg_createcluster for you.
>> If you don&
On Thu, Aug 22, 2013 at 3:23 AM, Stuart Bishop wrote:
> On Wed, Aug 21, 2013 at 4:55 PM, Don Parris 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
>
On Wed, Aug 21, 2013 at 10:08 AM, Tom Lane wrote:
> Don Parris writes:
>
>
> 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. Perhaps the Ubu
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 chang
On Sat, Aug 10, 2013 at 10:05 AM, Tom Lane wrote:
> Chris Travers 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 something of a packaging issue and the
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 enable
On Thu, Aug 8, 2013 at 8:42 PM, Tom Lane wrote:
> Don Parris 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 reg
On Thu, Aug 8, 2013 at 6:30 PM, John R Pierce 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
>>
On Thu, Aug 8, 2013 at 5:45 PM, Rob Sargent 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 DAT
On Thu, Aug 8, 2013 at 5:44 PM, Thomas Kellerer 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 postg
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
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 program
On Thu, Jul 18, 2013 at 5:01 PM, Joshua D. Drake wrote:
>
> 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 re
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
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 focu
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 wrote:
> thx for sharing!
>
>
> On Fri, Jul 6, 2012 at 9:13 PM, Don Parris wrote:
>
>> Hi a
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
s
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 fi
26 matches
Mail list logo
