Johan,
Try the link below for a sample project clip which you should customise
for PostgreSQL. If you need further assistance feel free to contact me.
http://www.shepherdhill.biz/downloads/image.zip
Cheers.
Tope Akinniyi
CEO
ShepherdHill Software
Lagos, Nigeria
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 that
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 database
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
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
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.
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
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
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
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
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/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;
# [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 @qty
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
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;
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
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
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
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 to be
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 reset
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
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
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
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
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 hood
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
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
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
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 ...
and the
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 TEMPORARY TABLE...
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
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
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). If you can
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 on
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 .bat
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,
=?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
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 worry
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
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 status to
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
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 win if
--- 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 for all
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
44 matches
Mail list logo