On 12/09/2011 10:35 PM, Adrian Klaver wrote:
First question, are you sure you are connecting to same database in
both the remote and local case?
It strikes me that this is another use case for being able to get the
system identifier from SQL :-)
--
Craig Ringer
--
Sent via pgsql-general mail
On 12/08/2011 09:48 AM, Satoshi Nagayasu wrote:
For examples, I've been working on investigating PostgreSQL LWLock
behaviors
precisely for a few weeks, and it could not be obtained within PostgreSQL
itself, therefore, I picked up SystemTap. However, SystemTap could not be
used in a production sy
On 12/09/2011 02:48 PM, Jack Christensen wrote:
CREATE TABLE people(
id serial PRIMARY KEY,
name varchar NOT NULL
);
INSERT INTO people(name) VALUES('Adam'), ('Adam'), ('Adam'), ('Bill'),
('Sam'), ('Joe'), ('Joe');
SELECT name, count(*), random()
FROM people
GROUP BY name;
I would expect this
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jack Christensen
Sent: Friday, December 09, 2011 5:48 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Why does aggregate query allow select of non-group by or
aggregat
On Fri, Dec 9, 2011 at 5:48 PM, Jack Christensen wrote:
> CREATE TABLE people(
> id serial PRIMARY KEY,
> name varchar NOT NULL
> );
>
> INSERT INTO people(name) VALUES('Adam'), ('Adam'), ('Adam'), ('Bill'),
> ('Sam'), ('Joe'), ('Joe');
>
> SELECT name, count(*), random()
> FROM people
> GROUP B
CREATE TABLE people(
id serial PRIMARY KEY,
name varchar NOT NULL
);
INSERT INTO people(name) VALUES('Adam'), ('Adam'), ('Adam'), ('Bill'),
('Sam'), ('Joe'), ('Joe');
SELECT name, count(*), random()
FROM people
GROUP BY name;
I would expect this query to cause an error because of random(
On 9 December 2011 18:46, Rob Sargent wrote:
> I would like the "file" command to tell me something other than "data",
> yes even though I can tell by the name (and the directory of course).
> Hoping someone has something I can slip into /usr/share/misc/magic.mgc
> or that directory.
You mean som
On Fri, Dec 09, 2011 at 12:13:59PM -0500, James B. Byrne wrote:
> I really want to get a sense of how prevalent using GRANT
> PRIVILEGE, beyond the minimum required, is. And this
> seems like a very good place to discover it. Again, please
> reply off-list if you wish.
I used it this year in a sy
On 9 December 2011 18:46, Rob Sargent wrote:
> Along the same lines, what info is embedded in the file name? I see that
> the second non-zero recently went from 2 to 3. Significance?
>
>
> 0001003000CF
> ^
> --|
The WAL file name consists of timeline, segment
On Fri, Dec 09, 2011 at 12:13:59PM -0500, James B. Byrne wrote:
> I really want to get a sense of how prevalent using GRANT
> PRIVILEGE, beyond the minimum required, is. And this
> seems like a very good place to discover it. Again, please
> reply off-list if you wish.
I used it this year in a sy
I would like the "file" command to tell me something other than "data",
yes even though I can tell by the name (and the directory of course).
Hoping someone has something I can slip into /usr/share/misc/magic.mgc
or that directory.
Along the same lines, what info is embedded in the file name? I se
On Fri, Dec 9, 2011 at 10:43 AM, James B. Byrne wrote:
>
> On Fri, December 9, 2011 12:13, James B. Byrne wrote:
>
> Just to clarify the question. What I am asking basically
> comes down to if separate user ids are added for most
> individuals that access the database or not.
Most of the time I
On Fri, December 9, 2011 12:13, James B. Byrne wrote:
Just to clarify the question. What I am asking basically
comes down to if separate user ids are added for most
individuals that access the database or not.
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
On Thu, December 8, 2011 20:23, Craig Ringer wrote:
On Thu, December 8, 2011 17:28, Andy Colson wrote:
These are the only replies I received. Am I to conclude
that most of the people on the list do not use GRANT
PRIVILEGE to implement anything more than the minimal
authorization scheme required t
Phil Couling writes:
> Is there a way to set a different cast for an array?
I think it should work to declare a cast explicitly for the particular
case.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
Thanks
I'm having trouble finding any reference to array_out and array_in in
the documentation.
Is there a way to set a different cast for an array?
Regards
On 9 December 2011 15:09, Tom Lane wrote:
> Phil Couling writes:
>> I'm struggling to understand why this casts is not immutable:
>
>> i
Am 09.12.2011 16:02, schrieb Andre Lopes:
> I'm using PostgreSQL 8.3 and I need to reduce the timeout. How can I
> configure the connection timeout?
Which connection timeout you like to change? Most likely this should be
an option you can change on your client.
Cheers,
Frank
--
Sent via pgsql-
Phil Couling writes:
> I'm struggling to understand why this casts is not immutable:
> integer[]::text[]
> text[]::integer[]
Because it's implemented via array_out/array_in rather than any more
direct method, and those are marked stable because they potentially
invoke non-immutable element I/O f
Hi,
I'm using PostgreSQL 8.3 and I need to reduce the timeout. How can I
configure the connection timeout?
Best Regards,
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thursday, December 08, 2011 1:40:08 pm Chris Deadlock wrote:
> Hello, I have installed postgres version 8.4.9 from the debian repository.
>
> I set up a username and password, and was able to create my tables and add
> information to the database from a java application running through a
> remo
Yeah, it would be easy enough to write a custom extension to do it. I was
hoping for something built-in so I wouldn't require a pre-req extension be
installed on all servers by the superusersysadmins tend to resist
making such changes. But oh well what you gotta do you gotta dothanks
guys
Hello, I have installed postgres version 8.4.9 from the debian repository.
I set up a username and password, and was able to create my tables and add
information to the database from a java application running through a
remote SSH tunnel.
Then I moved this same command line program onto the same
On Thu, Dec 8, 2011 at 2:54 PM, Merlin Moncure wrote:
> On Wed, Dec 7, 2011 at 8:52 PM, Rodrigo E. De León Plicet
> wrote:
>> http://www.dbms2.com/2011/11/23/hope-for-a-new-postgresql-era/
>>
>> Some of the points mentioned:
>> - MySQL is narrowing the gap, but PostgreSQL is still ahead of MySQL
Am 08.12.2011 19:54, schrieb John R Pierce:
On 12/08/11 10:14 AM, Joshua D. Drake wrote:
- shared-storage clustering. Dunno if anyone still cares about this one
though.
This one seems to be moving into the legacy category over the next 3-5
years.
um, I believe this is referring to Oracle R
Hi
I'm struggling to understand why this casts is not immutable:
integer[]::text[]
text[]::integer[]
The following are all immutable:
integer::text
text::integer
integer[]::float[]
integer::float
I hit on this while trying to make a gin index which cast from one to the other.
Why does the enc
On Thu, Dec 8, 2011 at 3:11 PM, Marc Cousin wrote:
> Le Thu, 8 Dec 2011 12:27:22 +,
> Simon Riggs a écrit :
>
>> On Thu, Dec 8, 2011 at 11:24 AM, Craig Ringer
>> wrote:
>>
>> > Areas in which Pg seems significantly less capable include:
>>
>> Please can you explain the features Oracle has in
FWIW, a couple of months ago the anti-spam mail filters on our server
started to reject "anything yahoo" (including loads of legit stuff,
obviously). And I still see a lot of messages announcing that Ive just been
subscribed to this or that yahoo discussion group. However, this is all OT,
I suppose
Le Fri, 09 Dec 2011 11:11:12 +0800,
Craig Ringer a écrit :
> On 12/08/2011 08:27 PM, Simon Riggs wrote:
> > On Thu, Dec 8, 2011 at 11:24 AM, Craig
> > Ringer wrote:
> >
> >> Areas in which Pg seems significantly less capable include:
> > Please can you explain the features Oracle has in these ar
On 12/08/11 7:54 PM, Bruce Clay wrote:
Is there a "proper" encoding type that I should use to load the word lists so
they can be interoperable with the WordNet dataset that happily uses the UTF8 encoding?
some of your input data may be in other encodings, not UTF8, for
instance, LATIIN1. if
29 matches
Mail list logo
