Scott Marlowe wrote:
On Sun, Feb 15, 2009 at 4:39 PM, Christophe wrote:
On Feb 15, 2009, at 2:47 PM, Stuart McGraw wrote:
I just hoping for some confirmation that the permissions based approach
did not have some holes in it that I am
not seeing.
Another possibility is to create a set of func
Hi Andreas!
--- On Fri, 2/13/09, A. Kretschmer wrote:
> In response to Eus :
> > Hi Ho!
> >
> > Is there a way to check whether or not a subquery
> returns an empty result set?
>
> You can use EXISTS for that:
>
> -- empty result
> test=*# select * from (select 1 where 1=2) foo;
> ?column?
>
Hi Craig!
--- On Fri, 2/13/09, Craig Ringer wrote:
> Eus wrote:
> > Hi Ho!
> >
> > Is there a way to check whether or not a subquery
> returns an empty result set?
>
> "EXISTS"
>
> SELECT blah FROM blah WHERE EXISTS (SELECT 1 FROM tablename
> WHERE ...);
Thank you. Previously I tried: "... W
On Sun, Feb 15, 2009 at 4:39 PM, Christophe wrote:
>
> On Feb 15, 2009, at 2:47 PM, Stuart McGraw wrote:
>
>> I just hoping for some confirmation that the permissions based approach
>> did not have some holes in it that I am
>> not seeing.
>
> Another possibility is to create a set of functions th
Woohoo! Glad you got it working...
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Feb 15, 2009, at 2:47 PM, Stuart McGraw wrote:
I just hoping for some confirmation that the permissions based
approach did not have some holes in it that I am
not seeing.
Another possibility is to create a set of functions that contain the
query operations you would like to allow, isol
Finally Success
Thanks everyone
Bob
- Original Message -
From: "John R Pierce"
To: "Bob Pawley"
Cc: "PostgreSQL"
Sent: Sunday, February 15, 2009 3:05 PM
Subject: Re: [GENERAL] Attempting to connect
# IPv4 local connections:
host all all
Scott Marlowe wrote:
On Sun, Feb 15, 2009 at 3:09 PM, Stuart McGraw wrote:
John R Pierce wrote:
Stuart McGraw wrote:
What is the best way to run an arbitrary query received from an untrusted
source, safely?
(I want a web page form with a textbox that
a user can enter an arbitrary sql statem
# IPv4 local connections:
host all all 0.0.0.0
255.255.255.255 md5
host all all127.0.0.1/32 md5
oh. that first HOST line will only allow IP 0.0.0.0, hardly likely
to be a valid address. if
On Sunday 15 February 2009 2:19:13 pm Adrian Klaver wrote:
> On Sunday 15 February 2009 1:41:14 pm Bob Pawley wrote:
> > Hi
> >
> > I do need some help here.
> >
> > I am still having trouble making a remote connection. The 'Server doesn't
> > listen' message comes up.
> >
> > The config files have
On Sun, Feb 15, 2009 at 3:29 PM, Bob Pawley wrote:
> The log file states "parameter "listen-adress" cannot be changed after
> server start; conf change ignored.
>
> I am getting this log entry after saving the file and reloading with the
> server shutdown.
>
> Does anyone have a procedure for maki
The log file states "parameter "listen-adress" cannot be changed after
server start; conf change ignored.
I am getting this log entry after saving the file and reloading with the
server shutdown.
Does anyone have a procedure for making changes to this file?
Bob
- Original Message -
On Sun, Feb 15, 2009 at 3:09 PM, Stuart McGraw wrote:
> John R Pierce wrote:
>>
>> Stuart McGraw wrote:
>>>
>>> What is the best way to run an arbitrary query received from an untrusted
>>> source, safely?
>>> (I want a web page form with a textbox that
>>> a user can enter an arbitrary sql statem
Thanks, Osvaldo and Fernando - your solution works!
> -Original Message-
> From: Osvaldo Kussama [mailto:osvaldo.kuss...@gmail.com]
> Sent: Saturday, February 14, 2009 8:24 PM
> To: Ken Winter
> Subject: Re: [GENERAL] Array in nested query
>
> 2009/2/14 Ken Winter :
> > I'm trying to look
--- On Sat, 2/14/09, Bob Pawley wrote:
> From: Bob Pawley
> Subject: Re: [GENERAL] pg_hba reload
> To: "John R Pierce" , "PostgreSQL"
>
> Date: Saturday, February 14, 2009, 11:31 PM
> I'm running 8.3 on Windows XP.
>
> I input > pg_ctl reload -D c:\program
> files\postgresql\8.3\data- or
On Sunday 15 February 2009 1:41:14 pm Bob Pawley wrote:
> Hi
>
> I do need some help here.
>
> I am still having trouble making a remote connection. The 'Server doesn't
> listen' message comes up.
>
> The config files have been changed as shown below.
>
> Postgresql.conf
>
> #listen_addresses = '*'
John R Pierce wrote:
Stuart McGraw wrote:
What is the best way to run an arbitrary
query received from an untrusted source,
safely?
(I want a web page form with a textbox that
a user can enter an arbitrary sql statement,
then run it .
just keep http://xkcd.com/327/ in mind.
Yes, exa
Removed #
Reloaded postmaster, restarted server.
Server still isn't listening.
Bob
- Original Message -
From: "John R Pierce"
To: "Bob Pawley" ;
Sent: Sunday, February 15, 2009 1:44 PM
Subject: Re: [GENERAL] Attempting to connect
Bob Pawley wrote:
Hi
I do need some help here.
Bob Pawley wrote:
Hi
I do need some help here.
I am still having trouble making a remote connection. The 'Server
doesn't listen' message comes up.
The config files have been changed as shown below.
Postgresql.conf
#listen_addresses = '*'
you'd need to remove that # (comment) from the fr
Hi
I do need some help here.
I am still having trouble making a remote connection. The 'Server doesn't
listen' message comes up.
The config files have been changed as shown below.
Postgresql.conf
#listen_addresses = '*'
pg_hba
# TYPE DATABASE USER CIDR-ADDRESs IP-Mask
Stuart McGraw wrote:
What is the best way to run an arbitrary
query received from an untrusted source,
safely?
(I want a web page form with a textbox that
a user can enter an arbitrary sql statement,
then run it .
just keep http://xkcd.com/327/ in mind.
--
Sent via pgsql-general
What is the best way to run an arbitrary
query received from an untrusted source,
safely?
(I want a web page form with a textbox that
a user can enter an arbitrary sql statement,
then run it but I want to prevent therm from
changing anything or escaping postgresql
and executing system comman
Michal Politowski writes:
> Is it normal that plans using a scan on a partial unique index
> estimate that much more than one row is returned?
There isn't currently any special logic to recognize that case;
the estimate is just whatever is going to come out of the normal
statistics-based estimati
2009/2/15 Michal Politowski :
> I'm using PostgreSQL 8.3.
> Is it normal that plans using a scan on a partial unique index
> estimate that much more than one row is returned?
>
> Eg. I see:
> -> Bitmap Index Scan on tmp_idx_oss_archive_object_id_current
> (cost=0.00..3.12 rows=4189 width=0)
> wh
I'm using PostgreSQL 8.3.
Is it normal that plans using a scan on a partial unique index
estimate that much more than one row is returned?
Eg. I see:
-> Bitmap Index Scan on tmp_idx_oss_archive_object_id_current
(cost=0.00..3.12 rows=4189 width=0)
where the tmp_idx_oss_archive_object_id_current
On Sun, 15 Feb 2009 08:47:36 -0700
Scott Marlowe wrote:
> On Sun, Feb 15, 2009 at 5:58 AM, Bjørn T Johansen wrote:
> > I can't find a way to do this, what am I missing?
>
> You can either issue the command when you open the connection, alter
> the user the connection uses, or alter the database
On Sun, Feb 15, 2009 at 5:58 AM, Bjørn T Johansen wrote:
> I can't find a way to do this, what am I missing?
You can either issue the command when you open the connection, alter
the user the connection uses, or alter the database to default to that
search path.
alter user bubba set search_path='
2009/2/15 Fernando Moreno :
> What error are you getting?
>
> I tried your query and I had to add an explicit cast to smallint[] to
> make it work. Like this:
>
> ... a.attnum = any ((select conkey FROM pg_catalog.pg_constraint WHERE
>> oid = 3708025)::smallint[]);
>
> It seems strange to me, I did
Onno Molenkamp wrote:
> Hi,
>
> I recently upgraded a database from 8.1.11 to 8.3.6, and I noticed the
> following statement stopped working:
>
> insert into test (b) select currval('test_a_seq'::regclass)
It's generally a REALLY bad idea to mix `nextval' and `currval' use on
the same sequenc
I can't find a way to do this, what am I missing?
Regards,
BTJ
--
---
Bjørn T Johansen
b...@havleik.no
---
So
Oleg Bartunov wrote:
>
> yOn Sat, 14 Feb 2009, searchelite wrote:
>
>>
>> Dear All
>>
>> i gave this kind of query
>>
>> select max(foo) from (select some statement) as foo
>>
>> but it gave me this error
>> ERROR: function max(record) does not exist
>>
>>
>> any help how i can select max val
On Sat, Feb 14, 2009 at 05:36:11PM -0500, Ken Winter wrote:
>I'm trying to look up the columns in a constraint in pg_catalog (of
>PostgreSQL 8.0.x). I can't figure out how to "join" the elements of the
>array that lists the `attnum's of the columns in the table to the `conkey'
>arr
Alban Hertroys wrote:
> On Feb 9, 2009, at 2:07 PM, Grzegorz Jaśkiewicz wrote:
>
>> On Mon, Feb 9, 2009 at 12:50 PM, Herouth Maoz
>> wrote:
>>> I hope someone can clue me in based on the results of explain analyze.
>>
>> Did you have a chance to run vmstat on it, and post it here ? Maybe -
>> if d
33 matches
Mail list logo
