Package systems which create an automatic user account for your
postgresql instance, for example in OpenBSD:
system user: _postgresql (in accordance to OpenBSD ports rules)
db user: postgres
I always use:
initdb -U postgres
Because that's what everyone expects it to be...
On Sun, May 12, 2013
On Sun, Jan 13, 2013 at 10:37 PM, Robert James srobertja...@gmail.comwrote:
On 1/13/13, Ian Lawrence Barwick barw...@gmail.com wrote:
2013/1/14 Robert James srobertja...@gmail.com:
I have a lot of VALUES I want to INSERT. But only a subset of them -
only those that meet a JOIN criteria
I generally do:
DO $$
BEGIN
INSERT INTO ...;
EXCEPTION
WHEN UNIQUE_VIOLATION or EXCLUSION_VIOLATION THEN
NULL; /* ignore this record */
END;
$$;
On Sun, Dec 9, 2012 at 9:20 PM, Zbigniew zbigniew2...@gmail.com wrote:
Hello,
As I read while googling the web,
Obviously, it's not fast...
On Tue, Dec 11, 2012 at 5:42 AM, Abel Abraham Camarillo Ojeda
acam...@the00z.org wrote:
I generally do:
DO $$
BEGIN
INSERT INTO ...;
EXCEPTION
WHEN UNIQUE_VIOLATION or EXCLUSION_VIOLATION THEN
NULL; /* ignore this record
It's faster than restarting the big transaction, maybe...
On Tue, Dec 11, 2012 at 5:48 AM, Zbigniew zbigniew2...@gmail.com wrote:
2012/12/11, Abel Abraham Camarillo Ojeda acam...@the00z.org:
Obviously, it's not fast...
Well, the problem was exactly speed-related. If not this - I could
On Sun, Nov 18, 2012 at 1:29 AM, Tom Lane t...@sss.pgh.pa.us wrote:
David Johnston pol...@yahoo.com writes:
On Nov 17, 2012, at 20:43, John R Pierce pie...@hogranch.com wrote:
I think he meant a tiny tiny bit faster, primarily due to not having to
validate the length.
Maybe... But I would
On Tue, Apr 24, 2012 at 2:02 AM, Rafal Pietrak ra...@zorro.isa-geek.com wrote:
Hi all,
Recently I have fell onto a multicolumn update problem, earlier
discussed here:
http://postgresql.1045698.n5.nabble.com/UPDATE-of-several-columns-using-SELECT-statement-td1916045.html
But in my case,
On Sat, Apr 14, 2012 at 1:22 AM, haman...@t-online.de wrote:
Hi,
I am looking for a feature that would select from a table with
k1 a
k1 b
k1 c
k2 a
k3 b
k3 c
something like
k1 a b c
k2 a
k3 b c
(Just all elements next to each other, with a space in between)
or perhaps an
On Sat, Apr 14, 2012 at 1:28 AM, Abel Abraham Camarillo Ojeda
acam...@the00z.org wrote:
On Sat, Apr 14, 2012 at 1:22 AM, haman...@t-online.de wrote:
Hi,
I am looking for a feature that would select from a table with
k1 a
k1 b
k1 c
k2 a
k3 b
k3 c
something like
k1 a b c
k2
On Wed, Mar 21, 2012 at 2:46 AM, Geek Matter geekmat...@yahoo.com wrote:
i just wondering, why mysql is more popular than postgresql ?
Pretty blonde girls doing marketing
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Wed, Mar 14, 2012 at 9:28 PM, krz...@gmail.com krz...@gmail.com wrote:
Ok, but can someone comment, document something on security of
installing extensions for normal users? Does allowing access to
extension provides a way to circumvent security model? If not why
can't it be allowed for
11 matches
Mail list logo