On Friday, May, 2001-05-18 at 20:42:57, Shaun Thomas wrote:
> On Fri, 18 May 2001, Tom Lane wrote:
>
> > Given the inherent inaccuracy of the cost estimates, I'd be real
> > hesitant to rely on them to suppress overly-expensive queries.
>
> That's just it. You don't have to be that accurate. I
Dear All,
I am trying to configure the access to the postgreSQL server through web. I
would like that someone could give
a general idea of how the password politic works in PostgreSQL.
Let me explain what I have tried so far.
I want to do access to PostgreSQL using password encryption. What
On Fri, 18 May 2001, Tom Lane wrote:
> Given the inherent inaccuracy of the cost estimates, I'd be real
> hesitant to rely on them to suppress overly-expensive queries.
That's just it. You don't have to be that accurate. If an estimate
goes into the millions or billions, something is obviously
Shaun Thomas <[EMAIL PROTECTED]> writes:
> I can't seem to find it in the docs, so I'll ask here. Is there a
> way in postgres to impose a limit on query costs? I'd noticed some
> horribly disfigured queries hitting my poor database from one of our
> developers, and corrected him. But many of o
>echo 'createuser becky -d -a' | su postgres
maybe you'd like it the otherway round? ;)
$ su - postgres -c "createuser becky -d -a"
Stefan
--
"On the Internet, there is no 'they'. There's only a very,
very large 'us'." --- Douglas Adams
---(end of broadcast)---
Hi!
At 15:45 2001-05-18 +0200, Muhammed Yazici wrote:
> > createdb -D /other/path dbname
> > ERROR: The database path '/other/path' is invalid. This may be due to a
>character that is not allowed or because the chosen
> > path isn't permitted for databases.
Have you done an
$ initlocation /othe
Hi,
I'm looking for a documentation of plpgsql, trigger, functions. I
found: Bruce's book, pgsql doc, and that's all. Does anybody have
other related docs?
--
CZW
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an a
D0 <[EMAIL PROTECTED]> writes:
> ERROR: Relation 'analytics_bud_analytics_bud_seq' already exists
> agi_db=# drop sequence analytics_bud_analytics_bud_seq;
> ERROR: Relation 'analytics_bud_analytics_bud_seq' does not exist
What PG version are you running? This looks like the classic catch-22
f
hi all ,
when i do
> createdb -D /other/path dbname
I got the Message:
> ERROR: The database path '/other/path' is invalid. This may be due to a
character that is not allowed or because the chosen
> path isn't permitted for databases.
when i try to create a database anywhere else than the sta
> Also how do I get a listing of the sequences already created?
>
> TIA
\ds
You can always get a list of commands with \?, and help with \h.
Serge
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/se
Hello All,
I am running Redhat 7.0.
I am trying to create a script that will add a user. My script looks like
this:
echo 'createuser becky -d -a' | su postgres
When I run my script, I receive the following message even though the user
is created.
bash: /home/username/. bashrc: Permission de
In article <9dutbv$2hdu$[EMAIL PROTECTED]>, Alexander Dederer wrote:
> Prashant Sinha wrote:
>
>> This is a multi-part message in MIME format.
>>
>> --=_NextPart_000_0021_01C0DE12.BB861C80
>> Content-Type: text/plain; charset="iso-8859-1"
>> Content-Transfer-Encoding: quoted-printable
>>
>>
Hey all,
I can't seem to find it in the docs, so I'll ask here. Is there a
way in postgres to impose a limit on query costs? I'd noticed some
horribly disfigured queries hitting my poor database from one of our
developers, and corrected him. But many of our users are not so
easily contacted.
INM1=# explain select ref_num from grls where ag_id in (24);
Index Scan using grls_ag_id on grls (cost=0.00..597.87 rows=849 width=12)
IMN1=# explain select ref_num from grls where ag_id in (select 24);
Seq Scan on grls (cost=0.00..992.44 rows=30195 width=12)
SubPlan
-> Materialize (cos
Help me, please.
Can I create a 2 Parallel Server with clustrering DB PostgreSQL?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Jo?l Francken wrote:
> I'd like to know if it is possible to select data from a db on a server
> and then to insert it on an other server ?
> Is there somth like
>
> SELECT * INTO backup FROM server.database.table;
>
> Is there an alternate solution ?
As I know it's in 7.1.1 not working.
Try Per
agi_db=# create table analytics_budget
agi_db-# (
agi_db(# analytics_budget_id serial not null primary key,
agi_db(# triangulation int2,
agi_db(# sales_order_id int4 not null references
sales_order(sales_order_id) default
atoi(currval('sales_order_sales_order_id'))
agi_db(# );
NOTICE: CREATE TABL
Prashant Sinha wrote:
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0021_01C0DE12.BB861C80
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi,
> I am a new postgre user. I had used sql commands to create database and
>
18 matches
Mail list logo
