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 wrote:
> On 1/13/13, Ian Lawrence Barwick wrote:
> > 2013/1/14 Robert James :
> >> I have a lot of VALUES I want to INSERT. But only a subset of them -
> >> only those that meet a JOIN criteria involving another table.
> >>
> >> I could INSERT them
It's faster than restarting the big transaction, maybe...
On Tue, Dec 11, 2012 at 5:48 AM, Zbigniew wrote:
> 2012/12/11, Abel Abraham Camarillo Ojeda :
>
> > Obviously, it's not fast...
>
> Well, the problem was exactly speed-related. If not this - I could
> si
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
>
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 wrote:
> Hello,
>
> As I read while googling the web, many people complaine
On Sun, Nov 18, 2012 at 1:29 AM, Tom Lane wrote:
> David Johnston writes:
>> On Nov 17, 2012, at 20:43, John R Pierce wrote:
>>> I think he meant a tiny tiny bit faster, primarily due to not having to
>>> validate the length.
>
>> Maybe... But I would presume a "varchar with no limit" does not
On Tue, Apr 24, 2012 at 2:02 AM, Rafal Pietrak 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, subselect does not h
On Sat, Apr 14, 2012 at 1:28 AM, Abel Abraham Camarillo Ojeda
wrote:
> On Sat, Apr 14, 2012 at 1:22 AM, wrote:
>>
>>
>> Hi,
>>
>> I am looking for a feature that would select from a table with
>> k1 a
>> k1 b
>> k1 c
>> k2 a
>>
On Sat, Apr 14, 2012 at 1:22 AM, 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 arr
On Wed, Mar 21, 2012 at 2:46 AM, Geek Matter 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:
http://www.postgresql.org/mailpre
On Wed, Mar 14, 2012 at 9:28 PM, 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 user installatio
11 matches
Mail list logo
