On 29/03/12 23:28, Pavel Stehule wrote:
select anum from t1 where anum = 4
union all select 100 limit 1;
I'm not sure the ordering here is guaranteed by the standard though, is
it? You could end up with the 4 being discarded.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mail
2012/3/30 Richard Huxton :
> On 29/03/12 23:28, Pavel Stehule wrote:
>>
>> select anum from t1 where anum = 4
>> union all select 100 limit 1;
>
>
> I'm not sure the ordering here is guaranteed by the standard though, is it?
> You could end up with the 4 being discarded.
A order is random for only
leaf_yxj wrote:
> My bosses ask me to list all the users and all the privilege which
the superuser granted to the
> users.
> Then they can double check that I did right thing or not?
Unlike Oracle, PostgreSQL does not have a concept of "grantor",
so it is not possible to find out which privilege
Chris Angelico wrote:
> We have a number of varchar fields and I'm looking to see what the
> greatest data length in any is, after UTF-8 encoding. The two-argument
> length function appears (I think) to take a byte array, so it's the
> opposite of what I'm looking for (give it a UTF-8 encoded strin
On 30/03/12 08:46, Pavel Stehule wrote:
2012/3/30 Richard Huxton:
On 29/03/12 23:28, Pavel Stehule wrote:
select anum from t1 where anum = 4
union all select 100 limit 1;
I'm not sure the ordering here is guaranteed by the standard though, is it?
You could end up with the 4 being discarded.
another Q :
my app should display notifications to each user depends on his selected
cars. can i do that just using ajax and php ?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/user-get-notification-when-postgresql-database-updated-tp5600187p5606001.html
Sent from the
2012/3/30 Richard Huxton :
> On 30/03/12 08:46, Pavel Stehule wrote:
>>
>> 2012/3/30 Richard Huxton:
>>>
>>> On 29/03/12 23:28, Pavel Stehule wrote:
select anum from t1 where anum = 4
union all select 100 limit 1;
>>>
>>>
>>>
>>> I'm not sure the ordering here is guaranteed by t
On 30 Mar 2012, at 10:22, Richard Huxton wrote:
> On 30/03/12 08:46, Pavel Stehule wrote:
>> 2012/3/30 Richard Huxton:
>>> On 29/03/12 23:28, Pavel Stehule wrote:
select anum from t1 where anum = 4
union all select 100 limit 1;
>>>
>>>
>>> I'm not sure the ordering here is guaran
On 29 Mar 2012, at 11:43, Albert wrote:
> it a browser based application. so would you advice me about the best way to
> poll the database for notifications ?
>
> I've been read about DB triggers but still can't tell if it will help me.
The HTTP protocol doesn't have a push mechanism, so you c
gs <==
03/26/2012,00:00:00,133272,86411.1, 4.10, 0.18, 53.36, 93,
03/27/2012,00:00:00,1332806400,86406.9, 4.23, 0.21, 53.63, 96,
03/28/2012,00:00:00,1332892800,86409.0, 4.15, 0.18, 53.94, 93,
03/29/2012,00:00:00,1332979200,57606.0, 4.17, 0.17, 54.19, 78,
Hi Albe,
My bosses ask me to list
1)all the users and the roles associated with the users.
2) all the users and the privileges associated with that users.
Thanks.
Regards.
Grace
At 2012-03-30 16:07:08,"Albe Laurenz *EXTERN* [via PostgreSQL]"
wrote:
leaf_yxj wrote:
> My bosses ask me
Hi,
thanks so much for answering. I found a "segmentation fault" in my logs
so please check below:
> On Tue, 2012-03-27 at 11:47 +0200, Janning Vygen wrote:
>>
>> I am running postgresql-9.1 from debian backport package fsync=on
>> full_page_writes=off
>
> That may be unsafe (and usually is) d
"Albe Laurenz" writes:
> leaf_yxj wrote:
>> My bosses ask me to list all the users and all the privilege which
> the superuser granted to the
>> users.
>> Then they can double check that I did right thing or not?
> Unlike Oracle, PostgreSQL does not have a concept of "grantor",
> so it is not p
On 03/26/2012 07:41 PM, Martín Marqués wrote:
Any ideas?
Last year I had memory problems with this server (changed the faulty
bank), I wouldn't want it to be happening again.
It's a crash deep in memory management for inode storage used by the
ext3 filesystem code. Chances are it's a hardware
merlin : Thanks.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-pass-the-function-caller-s-parameter-to-inside-the-function-syntax-error-at-or-near-1-tp5601045p5606816.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-
Tom Lane wrote:
>>> My bosses ask me to list all the users and all the privilege which
>> the superuser granted to the
>>> users.
>>> Then they can double check that I did right thing or not?
>
>> Unlike Oracle, PostgreSQL does not have a concept of "grantor",
>> so it is not possible to find ou
I think they don't care about the grantee. they only care about the users (
for example the application team user, develop team user) and the privileges
they have. Thanks. Guys. Grace
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/double-check-the-role-has-what-s-kind-o
Surge 2012, the scalability conference, September 27-28, Baltimore, MD
has opened its CFP. Please visit http://omniti.com/surge/2012/cfp for
details.
--
Katherine Jeschke
Director of Marketing and Creative Services
OmniTI Computer Consulting, Inc.
7070 Samuel Morse Drive, Ste.150
Columbia, MD 210
Hey Everyone,
I've got an interesting issue. We're running postgres 9.1.1 linux x64
centos 5.8
aspdata=# select version();
version
--
Mike Roest writes:
> This dump is currently taking around 8 minutes. While dumping the pg_dump
> process is using 100% of one core in the server (24 core machine). Doing a
> -v pg_dump I found that the following stages are taking the majority of the
> time
> reading user_defined tables (2 minut
For sure I'll work on that now. One thing I noticed looking through the
pg_dump code based on the messages and the code one thing I noticed it
seems to be grabbing the full dependency graph for the whole db rather then
limiting it by the schema (not sure if limiting this would be possible)
This q
Hello All
Could you help me to automatically convert all db request into UTF8 encode ?
Thx
Prashant
Ok I just realized that's probably not going to be much help :)
0.00 0.00 0.005 0.00 0.00 canonicalize_path
0.00 0.00 0.005 0.00 0.00
trim_trailing_separator
0.00 0.00 0.003 0.00 0.00 strlcpy
0.00 0.00 0
Mike Roest writes:
> Ok I just realized that's probably not going to be much help :)
gmon.out would be of no value to anybody else anyway --- making sense of
it requires the exact executable you took the measurements with.
> 0.00 0.00 0.005 0.00 0.00 canonicalize_path
That was on the CentOS 5.8 x64 machine. The one I'm trying it from now is
Ubuntu 11.10 x64
On Fri, Mar 30, 2012 at 11:30 AM, Tom Lane wrote:
> Mike Roest writes:
> > Ok I just realized that's probably not going to be much help :)
>
> gmon.out would be of no value to anybody else anyway --- m
On Friday, March 30, 2012 10:00:31 AM Prashant Bharucha wrote:
> Hello All
>
> Could you help me to automatically convert all db request into UTF8 encode ?
>
Set your session client_encoding to match your data. That's about as close as
you can get to automatic.
http://www.postgresql.org/docs
Mike Roest writes:
> That was on the CentOS 5.8 x64 machine. The one I'm trying it from now is
> Ubuntu 11.10 x64
Hm. On current Red-Hat-derived systems I'd recommend oprofile, although
you need root privileges to use that. Not real sure what is available
on Ubuntu, but our crib sheet for opro
HI, i have a problem when using pg, thanks for help. :)
I used command initdb, but nothing was created in my pgdata directory.
however, I used command ps to list all the processes, and I found inidb
process kept running all the time.
I don't know what happened, and i want to read the log file
On Saturday, March 31, 2012 01:52:37 AM clover white wrote:
> HI, i have a problem when using pg, thanks for help. :)
>
> I used command initdb, but nothing was created in my pgdata directory.
> however, I used command ps to list all the processes, and I found inidb
> process kept running all t
On Fri, 2012-03-30 at 16:02 +0200, Janning Vygen wrote:
> The PANIC occurred first on March, 19. My servers uptime ist 56 days, so
> about 4th of February. There was no power failure since i started to use
> this machine. This machine is in use since March, 7. I checked it twice:
> Now power failur
I downloaded the stable version of postgresql-9.1.3.tar.gz, installed on a
CentOS 5.7 final server.
I used -with-openssl option with the configure, after starting the server,
Psql would cause a segmentation fault, createuser did too.
I don't think the postgresql log shows anything on this, plea
>
> That could be out-of-date info though. Here's some info about
> another possibility:
> http://wiki.postgresql.org/wiki/Profiling_with_perf
>
>
There we go this perf worked on the VM.
The file is 6 megs so I've dropped it here.
That was doing perf for the length of the pg_dump command and the
On Fri, 2012-03-30 at 20:11 +, Hu, William wrote:
> I used –with-openssl option with the configure, after starting the
> server,
...
> Psql would cause a segmentation fault, createuser did too.
Can you try with plain "./configure --prefix=/your/install/path" and see
if there is still a problem
33 matches
Mail list logo
