Neil Burrows wrote:
> Hi,
>
> I am having a problem trying to create a rule on a view and keep getting
>
> ERROR: DefineQueryRewrite: rule plan string too big.
>
> I've looked though the mailing list and docs and have seen mentions that
> the limit of a rule is 8192 characters. The rule (see be
Hello All,
I am looking for opinions and suggestions on setting up integration between
a back-end PostgreSQL database engine hosted on a web server and a client
using Excel spreadsheets to store and print internal product information and
pricing.
Here's the scenario: I am using a Linux web server
Hi,
I am having a problem trying to create a rule on a view and keep getting
ERROR: DefineQueryRewrite: rule plan string too big.
I've looked though the mailing list and docs and have seen mentions that
the limit of a rule is 8192 characters. The rule (see below) is no more
than 600 characte
On Fri, 14 Jan 2000, Jeff MacDonald wrote:
> hey folks,
>
> this is a security issue i'd like to get some info
> on, i'm sure it's more with cgi than postgres, but
> heck.
>
> issue: how to secure cgi's that access postgres
>
> problem: passwords for postgres database are stored
> in pl
have a query like so:
select crimeid, areaid,
sum( CASE when dateof='1-8-2000' then total else 0 end) as crimes1
from stats GROUP BY crimeid, areaid;
This works and gives me results like I want like so:
crimeid|areaid|crimes1
---+--+---
4| 2| 0
5| 2|
I'd like to grant read-access to every single DB object in a database
for one user. I'd hoped for
GRANT SELECT ON * TO
but the '*' syntax is wrong and I don't see an alternative in the
docs...
How is this done?
Cheers,
Ed Loehr
* Jeff MacDonald <[EMAIL PROTECTED]> [000114 14:07] wrote:
> alfred, that seems like a very reasonable solution,
>
> in regard to the other chaps responce, i'm not worried
> about web users anyway, cause they can't see the perl
> source. it's users on the system i'd like to protect
> against.
I'
Hello All,
I'm not really sure how joining the list works but I
wanted to say hello. I am new to databases and also to
Postgres. Started reading the book up on the site. Very
helpful.
I do have a question though. I am trying to take a DB
written for MySql and convert the format of statem
alfred, that seems like a very reasonable solution,
in regard to the other chaps responce, i'm not worried
about web users anyway, cause they can't see the perl
source. it's users on the system i'd like to protect
against.
On Fri, 14 Jan 2000, Alfred Perlstein wrote:
> * Jeff MacDonald <[EMAIL
Jeff MacDonald wrote:
>
> hey folks,
>
> this is a security issue i'd like to get some info
> on, i'm sure it's more with cgi than postgres, but
> heck.
>
> issue: how to secure cgi's that access postgres
>
> problem: passwords for postgres database are stored
> in plain text in scripts.
* Jeff MacDonald <[EMAIL PROTECTED]> [000114 13:38] wrote:
> hey folks,
>
> this is a security issue i'd like to get some info
> on, i'm sure it's more with cgi than postgres, but
> heck.
>
> issue: how to secure cgi's that access postgres
>
> problem: passwords for postgres database are store
On Fri, Jan 14, 2000 at 04:55:02PM -0400, Jeff MacDonald wrote:
> this is a security issue i'd like to get some info
> on, i'm sure it's more with cgi than postgres, but
> heck.
>
First off, if the server is set up correctly a casual user should not be
able to browse the cgi-bin directory and s
hey folks,
this is a security issue i'd like to get some info
on, i'm sure it's more with cgi than postgres, but
heck.
issue: how to secure cgi's that access postgres
problem: passwords for postgres database are stored
in plain text in scripts. (lets assume, perl,
not a compiled la
"Hojdar Karel Ing." wrote:
> Hi,
>
> how I can get some agregates (avg, min, max) for whole week (in specified
> year)?
> For example from table with two columns : time datetime and value float8.
> And I want to get average of value based on whole weeks. If I try to use
> date_part('week',time)
> Adriaan Joubert wrote:
> >
> > Yes oids get dumped with the -o flag. That is why I said automatically. Fact
> > remains that you cannot manipulate oids. Should you ever want to copy a table into
> > an exisiting system you would have to do a new initdb to make sure that the oids
> > in your tab
Someone posted a message here asking how you set the date style. We went
through
- environment variable PGDATESTYLE
- SET DateStyle TO
- the -e flag to the backend
but of course if you are using ISO it isn't necessary!! There is no
ambiguity in
test=> create table tab (t datetime);
CREATE
16 matches
Mail list logo
