Hi,
I want to install Tsearch2 and follow this command :
1.cd contrib/tsearch2
2. make; make install
It doesn't work and display this messages :
Makefile:5: ../../src/Makefile.global: No such file or directory
Makefile:47: /contrib/contrib-global.mk: No such file or directory
make: *** No rule t
If I put the pg_xlog directory on its own disk, then that disk fails,
does that mean the postgres is hosed or does it just mean that postgres
no longer safe from a power outage? Does pg detect a problem with the
wal and then call fsync() on the database files if wal isn't working?
---
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > I'm using plphpu and I'd like to allow the regular
> > database user to use it, but since it's
> "untrusted" it
> > requires users to be superusers. If I have to do
> this,
> > I don't want the user to be a superuser f
"Logan Bowers" <[EMAIL PROTECTED]> writes:
> In my case, the "raw" data is on the order of hundreds of gigabytes and
> the increased write activity is a HUGE penalty.
And you think the extra activity from repeated clog tests would not be a
huge penalty?
AFAICS this would only be likely to be a wi
CSN <[EMAIL PROTECTED]> writes:
> I'm using plphpu and I'd like to allow the regular
> database user to use it, but since it's "untrusted" it
> requires users to be superusers. If I have to do this,
> I don't want the user to be a superuser for all
> databases. Is it possible to grant superuser sta
Thanks for the quick responses everyone. It did turn out to be the
commit bit as the table was just loaded (never accessed) and subsequent
SELECTs did not incur any write activity.
As a side note, I saw in the archives a past conversation about adding
an option to disable touching the commit hin
I'm using plphpu and I'd like to allow the regular
database user to use it, but since it's "untrusted" it
requires users to be superusers. If I have to do this,
I don't want the user to be a superuser for all
databases. Is it possible to grant superuser status to
a user for a specific database? All
On Wed, Aug 03, 2005 at 06:51:42PM -0700, CSN wrote:
> AND p.proname ~ '^+$'
> ORDER BY 1, 2, 3, 4;
>
> It's greek to me ;). Any idea what caused this error,
> and if there's some sort of problem?
Looks like somebody ran the command "\df +" in psql. Shouldn't
be anything to
=?iso-8859-2?Q?Havasv=F6lgyi_Ott=F3?= <[EMAIL PROTECTED]> writes:
> My queries were written in multi-line mode like this:
> insert into t1 values(1,
> 2,
> 3);
> I don't know, what effect this has to performace..
I tried my test again that way, and it made no difference at all.
Can anyone else
I saw this in my log file:
ERROR: invalid regular expression: quantifier operand
invalid
STATEMENT: SELECT n.nspname as "Schema",
p.proname as "Name",
CASE WHEN p.proretset THEN 'setof ' ELSE ''
END ||
pg_catalog.format_type(p.prorettype, NULL)
as "Result data type"
Hi,
If the psql program is always going to be in C:\Program
Files\PostgreSQL\8.0\bin, couldn't you eliminate the "cd", and just specify
the full path (if psql is not in the current PATH) as needed? Or, add it
to the PATH:PATH %path%;C:\Program Files\PostgreSQL\8.0\bin
If you running the .ba
On Wed, 2005-08-03 at 23:29 +0200, Zlatko Matić wrote:
> Hello.
>
> I would like to install database schema on a server using files with
> dumped schema and globals (produced by dumpall), that are placed on
> CD. The installation script (batch file) that restores these two files
> is also placed
"Aaron Harsh" <[EMAIL PROTECTED]> writes:
>> Tom Lane <[EMAIL PROTECTED]> 08/03/05 1:33 PM >>>
>> OID wraparound would explain that ...
> Fantastic. Will our plan ('set without oids', pg_dump, pg_restore) take care
> of the problem?
Only temporarily (ie, till the counter wraps around again). I
Tom,
My queries were written in multi-line mode like this:
insert into t1 values(1,
2,
3);
I don't know, what effect this has to performace..
Regards,
Otto
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Havasvölgyi Ottó" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, Au
Hello.
I would like to install database schema on a server
using files with dumped schema and globals (produced by dumpall), that are
placed on CD. The installation script (batch file) that restores these two
files is also placed on the same CD, (let's say E:) in the same
folder.
cd C:\
Hi!
I have have two questions:
1.
What is the best approach to trigger a service script wich will clean
up something in the db after every db (re-)start? Has PG its own
mechanism for such things or have i to use my /etc/init.d/postgresql
script?
2.
Sometime i read something about locks on transa
> Tom Lane <[EMAIL PROTECTED]> 08/03/05 1:33 PM >>>
> "Aaron Harsh" <[EMAIL PROTECTED]> writes:
> > We've just recently started seeing sporadic constraint violations on system
> > tables. For example:
> > duplicate key violates unique constraint "pg_class_oid_index" [for
> > Statement "CREATE
"Aaron Harsh" <[EMAIL PROTECTED]> writes:
> We've just recently started seeing sporadic constraint violations on system
> tables. For example:
> duplicate key violates unique constraint "pg_class_oid_index" [for
> Statement "CREATE TEMPORARY TABLE...
OID wraparound would explain that ...
> a
Where does import_sharedata() come from? AFAIK, it's not a part of
standard PostgreSQL. PostgreSQL functions for this is COPY, where just
this fact is documented at
http://www.postgresql.org/docs/8.0/static/sql-copy.html, under "Notes".
//Magnus
> -Original Message-
> From: [EMAIL PROTEC
We've just recently started seeing sporadic constraint violations on system
tables. For example:
duplicate key violates unique constraint "pg_class_oid_index" [for Statement
"CREATE TEMPORARY TABLE...
and
duplicate key violates unique constraint "pg_toast_4292803267_index" [for
Statement
"Luca Stancapiano" <[EMAIL PROTECTED]> writes:
> I have this error:
> psql: could not open certificate file "/root/.postgresql/postgresql.crt":
> No such file or directory
You need a client certificate (if you don't want the server demanding
client certificates, remove its root.crt file). See
htt
Tom Lane wrote:
Peter Wilson <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Oh? Could you provide a test case for this? I can certainly believe
that the planner might choose a bad plan if it has no statistics, but
it shouldn't take a long time to do it.
On investigation the problems occurs on
Kevin Murphy <[EMAIL PROTECTED]> writes:
> I'm no expert, but per Peter's request, here is a generic
> array-unpacking function that works in PostgreSQL 8.0.
> [snip]
> I would imagine that a type-specific version would be faster.
No, actually it'd be exactly the same. What happens under the ho
Peter Fein wrote:
Kevin Murphy wrote:
As an example, I wrote a function to explode, or unpack, the elements of
an array onto separate rows (its return type is SETOF whatever), but it
took me a while to figure out how to use it effectively in queries.
Mind posting it? I know I've had
Martijn van Oosterhout wrote:
On Wed, Aug 03, 2005 at 09:40:26AM -0400, Kevin Murphy wrote:
You have to wrap a scalar subquery in its own parentheses even where you
might think it to be unnecessary, such as when the subquery is the sole
argument to a function.
It first guess I imagin
Is it possible to dump specific function definitions
using pg_dump? Any other items that can be
specifically dumped, besides just tables?
Thanks,
CSN
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/
On Wed, Aug 03, 2005 at 09:40:26AM -0400, Kevin Murphy wrote:
> You have to wrap a scalar subquery in its own parentheses even where you
> might think it to be unnecessary, such as when the subquery is the sole
> argument to a function.
It first guess I imagine it is because the syntax becomes a
On Wed, 2005-08-03 at 13:30 -0300, marcelo Cortez wrote:
> folks
>
> what is preferible value for
> stats_reset_on_server_start ?
depends on whether you want stats to be accumulated for longer periods
than between restarts. I imagine that 'on' is what most people need.
in any case, you can res
Kevin Murphy wrote:
> I thought this might be helpful in the future to other duffers such as
> myself.
>
> The following is my big contribution to the documentation of the use of
> scalar subqueries ;-):
>
> You have to wrap a scalar subquery in its own parentheses even where you
> might think it
hello.I use postgresql 8.0 . I've created the server.key and
server.crt in this manner:
openssl req -new -nodes -keyout server.key -out server.csr
openssl req -x509 -key /home/data/server.key -in /home/data/server.csr -out
server.crt
and I put theese in my data home.
I launch postgres in th
folks
what is preferible value for
stats_reset_on_server_start ?
what is default value?
best regards
MDC
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
-
Thanks. Can see the logic but many users are going to presume that they
can load from "their" desktop. For now I can operate around the issue
but will have to place instructions in big letters unless I want to
answer this adnauseum.
Magnus Hagander wrote:
Windows XP SP2 with Postgresq
Greetings!
Table definitions were included in the original post. I can repost (or
send directly) if desired.
I am using to implement database partitioning based on the day.
Postgresql 8.0.1 (and previous) has a number of issues when it comes to
very large tables. Currently we have anywhere from
On Tue, 2005-08-02 at 17:32 +0300, Victor wrote:
> Hello.
>
> I use psql (PostgreSQL) 7.4.5.
>
> I have a cost problem.
>
> A simple select lasts too long.
> I have a table with aprox 900 rows.
> All rows are deleted and reinserted once a minute.
>
> EXPLAIN ANALYZE SELECT * FROM logati;
>
post your table definitions. I suspect you are
indexing the parent table but not the children.
btw, we tried using inherited tables in our
application and quickly found out that they are more
trouble then they are worth (at least the way they are
implemented in postgresql). There are other, more
p
# [EMAIL PROTECTED] / 2005-08-02 10:01:34 -0400:
> I made it happen in MicrosoftSQL using the first code below. The only
> difference is I had to create variables. Which I'm having a hard time
> trying to replicate it in psql.
>
> __Microsoft Code___
> USE test
> GO
> DECLARE @
On 8/2/05, Victor <[EMAIL PROTECTED]> wrote:
> Hello.
>
> I use psql (PostgreSQL) 7.4.5.
>
> I have a cost problem.
>
> A simple select lasts too long.
> I have a table with aprox 900 rows.
> All rows are deleted and reinserted once a minute.
>
> EXPLAIN SELECT * FROM logati;
>
Hello.
I use psql (PostgreSQL) 7.4.5.
I have a cost problem.
A simple select lasts too long.
I have a table with aprox 900 rows.
All rows are deleted and reinserted once a minute.
EXPLAIN SELECT * FROM logati;
QUERY PLAN
--
On 8/3/05, Vahe Ghorghorian <[EMAIL PROTECTED]> wrote:
> Hello Sir,
>
> I am using PostGreSql ,I want an oledb provider for the postgre in order to
> connect through.net to a postgre Database, I installed the pgoledb.dll and I
> registered it and in the connection string I am using the
> "Provider
I thought this might be helpful in the future to other duffers such as
myself.
The following is my big contribution to the documentation of the use of
scalar subqueries ;-):
You have to wrap a scalar subquery in its own parentheses even where you
might think it to be unnecessary, such as whe
Vahe Ghorghorian wrote:
Hello Sir,
I am using PostGreSql ,I want an oledb provider for the postgre in order
to connect through.net to a postgre Database, I installed the
pgoledb.dll and I registered it and in the connection string I am using
the �Provider=PostgreSQL.1 . . . ,but the followi
Samuel Thoraval wrote:
Is it possible to change this behavior so that the VIEW will dynamically
use the search_path variable (when the schema was not specifically set) ?
In this case, when user nsp2 loggs in, the VIEW vtest would be using
VIEW nsp2.test, when user nsp3 loggs in it would use VI
Hello Sir,
I am using PostGreSql ,I want an oledb provider for the postgre in order to
connect through.net to a postgre Database, I installed the pgoledb.dll and I
registered it and in the connection string I am using the
Provider=PostgreSQL.1 . . . ,but the following error is occurring.
Hi,
I'd like views to behave differently according to the user and schema.
For instance, having 3 schemas corresponding to 3 users :
-- AS USER nsp1 :
CREATE TABLE nsp1.test (id integer);
CREATE VIEW nsp2.test AS SELECT * FROM nsp1.test WHERE id <= 10;
CREATE VIEW nsp3.test AS SELECT * FROM nsp
Ying Lu wrote:
Greetings,
I have a question about whether I am able to create an *anonymous*
procedure/function under postgreSQL 8. Something like:
Begin
... ...
update ...
IF ... THEN
rollback
END IF;
... ...
END;
No
I'd like to do a series of operations. If any one of the ope
> I'm trying to setup a "safe" testing database environment for
> some unit testing of a web application. I would like to have
> the unit tests restore the database to a known state before
> every test. The simplest way I thought would be to have the
> testing tools drop/create the testing da
> Windows XP SP2 with Postgresql 8.0.3
> Two commands on fails the other succeeds:
>
> Fails :
>
> select import_sharedata('C:\\Documents and
> Settings\\Richard\\Desktop\\EzyChart-20050721');
>
> Succeeds:
>
> select import_sharedata('C:\\EzyChart-20050721');
>
> is it the spaces in the path
47 matches
Mail list logo
