Is there a user group in Pittsburgh? This email was the first that
showed up in a Google Search.
Jim
On 2004-05-02 05:43:26, Tom Lane wrote:
> I've gotten a couple of inquiries lately about a Postgres users' group
> in my home town of Pittsburgh PA. There is not one (unless it's very
> well ca
You are inserting ((),()). It should be (),(). Skip the outer set of
parentheses.
On September 19, 2015 2:31:53 PM EDT, "FarjadFarid(ChkNet)"
wrote:
>Hi,
>
>
>
>I am getting errors trying to insert multiple records in single
>statement in
>table like this
>
>
>
>CREATE TABLE "Lookup"."CNEnum
Who were you logged I to psql as? Does the dump switch users?
On November 13, 2015 12:38:19 AM EST, Alex Luya
wrote:
>Hello,
> I created a new database by
>
> create database icare;
>
> then quit off psql and run:
>
>pg_restore --clean --create --exit-on-error --dbname
The method you use to store the data is irrelevant. Access to your network.
Logging. If you're encrypting the disk. How is the application presenting
this data. What kind of ACLs are you using. Asking if PG is good to store
HIPAA data is exactly as useful as asking if you can even store HIPAA data.
I'm trying to work out how to grant permissions to rows in a table
without having to rebuild the pg auth mechanisms (see below). One option
is to have many tables (each representing a row), and grant normally.
The other is, like I build below, uses a table and a recursive CTE to
resolve the PG grou
Of course I think of something as soon as I send it. Policies can be
granted to a specific role! So
create policy xx on table_1 for select to role_1 using (row_id = 1234);
Jim
On Sun, Jul 3, 2016 at 12:26 PM, James Keener wrote:
> I'm trying to work out how to grant permissions
So, millions is a lot, but it's not difficult to get to a place where
you have thousands or tables.
Image a case in which census data and the associated geometries.
https://github.com/censusreporter/census-postgres has 22 surveys, each
with 230+ tables. That's 5000+ tables right there. Now, the T
If we're talking about favourite bug https://bugs.mysql.com/bug.php?id=21153
is mine
Join with many tables hangs mysql (and taking 100% cpu)
> Description:
> the following query hangs the mysql server taking 100% cpu. also an
> "explain" of the query hangs the server!
It's "not a bug" because yo
What are you talking about? What business structure? Commercial offerings can
and will continue to exist in terms of custom features or consulting.
Firstly, it ceases to be a community version when there is a charge. Secondly,
it would damage our community by shrinking the size to effectively no
> My only aim is further progress of postgresql.
Charging for it would do exactly that. Most people would simply switch
to MySQL (or Maria) or stop upgrading/upgrade to a fork.
> As per Sun Microsystem’s case charging zero dollars (for Java and mysql)
> means there is zero income.
Why do you thin
n the first place, then I'm not sure
this is an argument worth continuing.
Jim
>
>
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of James Keener
> Sent: 06 January 2016 15:04
> To: Fa
> The coc sounds like a Washington politics play, but as long as the best
> still engage
> in this forum, I could care less. The list serves its purpose without
> overhead...a rare
> resource in today's flood of incoherent technical chatter.
Beyond "Hey! Look at us! We're telling people to play ni
> No, CoC by itself doesn't grow the community. That doesn't mean we
> shouldn't have one.
I'd agree with that. Thinking back over my previous points, it does make
sense to have one, if only to deal with people who represent the
community in some way, i.e. have some kind of commit or marketing acce
How does one "start a new thread"? I wasn't aware that changing the subject
wouldn't be enough. I tried :/
Jim
On January 6, 2016 12:17:54 PM EST, "Stéphane Schildknecht"
wrote:
>On 06/01/2016 16:54, James Keener wrote:
>> As Melvin mentioned, this belo
There was a side thread in the CoC thread about expanding the dev community
and making it easier for new devs to get involved. I would think that a bug
tracker, especially one where bugs can be labeled as "Newbie Friendly"
could go a long way towards that goal.
Additionally, a proper bug tracker w
> 3. A safe, respectful, productive and collaborative environment is free
of comments related to gender, sexual orientation, disability,
physical appearance,
body size or race.
why not
> 3. A safe, respectful, productive and collaborative environment is free
of ad hominem. (Tip: Ask your self "Wo
(Sorry for the dup post. I felt having a clean thread without having to
cross-reference was worth the minor faux pas.)
> 3. A safe, respectful, productive and collaborative environment is free
of comments related to gender, sexual orientation, disability,
physical appearance,
body size or race.
w
On January 11, 2016 5:44:56 PM EST, "Joshua D. Drake"
wrote:
>On 01/11/2016 02:30 PM, James Keener wrote:
>> (Sorry for the dup post. I felt having a clean thread without having
>to
>> cross-reference was worth the minor faux pas.)
>>
>>>3. A safe, respectf
> A safe, respectful, productive and collaborative environment is one
that focuses on the technical merit of ideas and solutions rather than
on the person behind them.
I still prefer this wording as there is no need for us to list the ways in
which someone can personally be attacked. Should the l
> We value the opinions of members who have contributed most more than we value
> the opinions of others.
A CoC is not the place to say some animals are more equal than others. A core
commiter calling someone the n- or b- words is just as bad as me, a non
commiter (if not worse!)
> While we do
Why must it be free of personal comments?
"Tom, I like the way you handed this issue. Good work!" Is a personal comment.
Why do we need lists? What specifically is wrong with "that focuses on the tech
and not the person" version?
Jim
On January 11, 2016 6:04:03 PM EST, "Joshua D. Drake"
wrot
>> We value the opinions of members who have contributed most more than
> we value the opinions of others.
>
>> A CoC is not the place to say some animals are more equal than others. A
> core commiter calling someone the n- or b- words is just as bad as me, a
> non commiter (if not worse!)
>
> Ye
>> That has nothing to do with the Code of Conduct, though. The
>> community accepting Tom saying "no" to Feature X is vastly
>> different than the community not calling Tom out for being mean.
>
>> The CoC is about the later situation and not the prior; and the
>> community should call Tom out.
>> That has nothing to do with the Code of Conduct, though.
>> The community accepting Tom saying "no" to Feature X is
>> vastly different than the community not calling Tom out
>> for being mean.
>> The CoC is about the later situation and not the prior;
>> and the community should call Tom out. (
Wow. I mean actually wow.
So many things. Just so many.
You still haven't explained why core contributors need to be treated like
special snowflakes. If someone acts inappropriately then they should be told
so, regardless of status. Why should we protect anyone in the wrong?
Moreover, your sc
This line has already been substantially changes. Can we keep discussion of the
language of the WIP in the thread meant for it? This way people don't waste
time discussing language which no longer exists.
Jim
On January 12, 2016 9:17:55 AM EST, Neil Tiffin wrote:
>
>> On Jan 12, 2016, at 7:50
>
>
> https://modelviewculture.com/pieces/codes-of-conduct-when-being-excellent-is-not-enough
>
That post seems to discuss why a written CoC is needed (as opposed to an
unwritten "act professional" one). I don't believe it applies to my
comment.
https://github.com/begriffs/postgrest also looks interesting!
On Fri, Feb 12, 2016 at 10:24 AM, Adrian Klaver
wrote:
> On 02/12/2016 03:00 AM, Peter van Eck wrote:
>
>>
>>
>> Hi, We are looking into setting up a PostgreSQL environment for an
>> application that inputs JSON through via http rest
>
>
> https://github.com/begriffs/postgrest also looks interesting!
>>
>
> I thought the purpose of Spring/Spring Boot was to provide the REST
> services in front of your choice of data store. Not sure how putting
> another server in the stack is going to help things.
I was simply responding to t
Do you want to know if a row is from the (a,b) or (c,d) group? All rows
will contain (a,b,c,d) but (a,b) will be NULL for the (c,d) grouping
sets, and vice-versa.
Jim
On 03/13/2016 09:45 PM, Tom Smith wrote:
> Hello:
>
> With JDBC, how can I tell which row is for which grouping sets or rollup
>
resultset has some param to mark which is which
> with the grouping sets index.
> for example, the results for (a,b,c,d) would be marked as for index =0,
> (b,c,d) would be index=1
>
> On Sun, Mar 13, 2016 at 9:52 PM, James Keener <mailto:j...@jimkeener.com>> wrote:
>
&
It just dawned on me that you may note have meant having them in a
specific sequence in the result set. Even still, I think it's much more
clear being explicit with what rows are included and which aren't.
Jim
On 03/13/2016 10:12 PM, James Keener wrote:
> Why? You're already
/me has learned something new!
Thanks!
On 03/13/2016 10:44 PM, Tom Lane wrote:
>>> On 03/13/2016 10:07 PM, Tom Smith wrote:
It would help if the resultset has some param to mark which is which
with the grouping sets index.
>
> I think you're looking for the GROUPING() function. See
>
Also, what did you run exactly (sanitized of course).
On March 14, 2016 5:38:19 PM EDT, John R Pierce wrote:
>On 3/14/2016 2:17 PM, Dustin Kempter wrote:
>> However my instances are not on the same server and I attempted to
>> simply add a host=(the ip) but that failed. Please help
>
>did you g
Is a uuid a valid value in the application making use of the data? Why can't
you add the column to table b and then import, or use create the uuid in the
import select clause? I'm also having trouble understanding the problem and why
you've discounted the options you've not even told us you've c
35 matches
Mail list logo
