DaVinci <[EMAIL PROTECTED]> writes:
> How can I pass a row of a view as an argument to function. I have tried
> something like:
> create function pepis(view_name) returns integer as .../...
This case turns out to have exposed a number of bugs in both the
planner and plpgsql. I think I'v
> My hard disk partition with the postgres data directory got full. I
> tried to shut down postgres so I could clear some space, nothing
> happened. So I did a reboot. On restart (after clearing some
> pg_sorttemp.XX files), I discovered that all my tables appear empty!
> When I check in the data
I'm currently using postgreSQL 7.0.2 and have big tables with a lot of
blobs. pg_dump does not cover this blobs.
When my system crashes or when I want to migrate to 7.1, will a pure
file-backup be enough or will I have to write my own tools for backup
and restore of this blobs and their oid's in
"P. A. Bagyenda" <[EMAIL PROTECTED]> writes:
> My hard disk partition with the postgres data directory got full. I
> tried to shut down postgres so I could clear some space, nothing
> happened. So I did a reboot. On restart (after clearing some
> pg_sorttemp.XX files), I discovered that all my ta
Hi folks, I've got a question regarding inheritance.
What are the advantages of using inheritance in the database
structure as opposed to using foreign keys? Doesn't
interitance mean that there will be much more duplication
of data in the database?
If anyone has any examples of proper usage of
Is it possible to use a SSL connection from the Windows ODBC driver to
PostgreSQL?
Or do I have to make a SSH link instead?
Poul L. Christiansen
Ron Peterson wrote:
>
> The BOFH wrote:
> >
> > Just installed 7.1 (first time) and enabled SSL support. Is there a way to
> > confirm that connect
following your indication I found what I was looking for...Thank you.
I made a simple trigger/function that:
on insert check if a particular field is already on one table if not it
will procede to make the insert otherwise not.
But it goes on loop. Now just because I do not have experience, I'm
Since I'm used to the MySQL security paradigm/model, I'm having a little
difficulty understanding the security with pgsql.
I noticed that once a db is created, any user able to log in to the server
can create tables within a database. The docs indicate that I can create a
file containing use
The BOFH wrote:
>
> Just installed 7.1 (first time) and enabled SSL support. Is there a way to
> confirm that connections are being made via SSL? The logfile shows a
> connection, but doesn't specify whether SSL was used or not.
>
> I used hostssl in the hba file.
You need to compile PostgreS
On Wed, Apr 18, 2001 at 09:01:21PM +0300, P. A. Bagyenda wrote:
> I am in the middle of a rather nasty experience that I hope
> someone out there can help solve.
>
> My hard disk partition with the postgres data directory got
> full. I tried to shut down postgres so I could clear some
> space
Steve Wampler <[EMAIL PROTECTED]> writes:
> One of the listed bug fixes is:
>Disallow INSERT/UPDATE/DELETE on views
> Can some one give me a little insight on what this
> implies?
It means that if you try to do INSERT/UPDATE/DELETE on a view that
doesn't have a rule to translate that action t
Just installed 7.1 (first time) and enabled SSL support. Is there a way to
confirm that connections are being made via SSL? The logfile shows a
connection, but doesn't specify whether SSL was used or not.
I used hostssl in the hba file.
Thanks,
---(end of broadca
I am in the middle of a rather nasty experience that I hope someone
out
there can help solve.
My hard disk partition with the postgres data directory got full. I
tried to shut down postgres so I could clear some space, nothing
happened. So I did a reboot. On restart (after clearing some
pg_sor
I am in the middle of a rather nasty experience that I hope someone
out
there can help solve.
My hard disk partition with the postgres data directory got full. I
tried to shut down postgres so I could clear some space, nothing
happened. So I did a reboot. On restart (after clearing some
pg_sor
Ah, thank you. I wasn't sure what the rc stood for. Thought it might
have been additional updates since 7.1 like how the Linux kernel will have
ac patchlevels whenever Alan Cox makes small updates.
-M@
--
There are more things in heaven and earth,
Horatio, than are dreamt of in your philosoph
Matthew Hixson <[EMAIL PROTECTED]> wrote:
>Which is the most recent version of Postgres, 7.1 or 7.1rc4 ?
7.1. (7.1 is the released version, 7.1rc4 was release candidate 4 for that
version)
HTH,
Ray
--
Do Microsoft's TCO calculations include TC of downtime?
---(end of b
7.1 is a release (the latest), 7.1rc4 is a *Release Candidate*.
-Mitch
Software development :
You can have it cheap, fast or working. Choose two.
- Original Message -
From: "Matthew Hixson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 1:28 PM
Subject: ver
Which is the most recent version of Postgres, 7.1 or 7.1rc4 ?
Thanks,
-M@
--
There are more things in heaven and earth,
Horatio, than are dreamt of in your philosophy.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http:
In <[EMAIL PROTECTED]> [EMAIL PROTECTED]
writes:
>Have you tried running PostGres with the -F option so that
>disk flushes are not performed every time. Maybe this will make a
>difference
>to insert performance.
In the DBI-connect I still have a -F in the options, but now I am running
7.1RC2 (d
One of the listed bug fixes is:
Disallow INSERT/UPDATE/DELETE on views
Can some one give me a little insight on what this
implies?
In particular, I currently (pg 7.0.3) have views with
trigger functions on insert and update that trap the
action and recast it to a table (after doing some che
Konstantinos Agouros writes:
> logs=> explain select distinct on (url) url, category, action from websenseflat
>where webhost='dir.yahoo.com' and datum >='1-26-2001' and datum < '1-27-2001';
> NOTICE: QUERY PLAN:
>
> Unique (cost=0.01..0.01 rows=1 width=36)
> -> Sort (cost=0.01..0.01 rows=
[EMAIL PROTECTED] (Konstantinos Agouros) writes:
> after this I created an index on the field webhost, now the query plan says:
CREATE INDEX updates the basic statistics about the table's size (number
of rows and disk blocks). The first plan was evidently generated using
statistics that claimed
Have you tried running PostGres with the -F option so that
disk flushes are not performed every time. Maybe this will make a
difference
to insert performance.
NB In 7.1 this is replaced by WAL which I don't know much about
MC
--
NOTICE: The information contained in this electronic mail tran
Konstantinos Agouros <[EMAIL PROTECTED]> said:
> On Wed, Apr 18, 2001 at 02:59:53PM +0200, Patrik Kudo wrote:
> > Hi!
> >
> > I'm not 100% sure, but I think it would be much faster if you use COPY
> > instead of INSERT when you read in a lot of data from a file.
> Well unless I am the database o
PryT wrote:
>
> hi all!
>
> i try to install postgresql-7.1.(rpm) on redhat 6.2, but it failed:
> error: failed dependencies:
> libpq.so.2 is needed by postgresql-7.1-1
There is more than one RPM needed for the install. You need, for a
'regular' server install 'postgresql-7.1-1', 'post
On Wed, Apr 18, 2001 at 02:59:53PM +0200, Patrik Kudo wrote:
> Hi!
>
> I'm not 100% sure, but I think it would be much faster if you use COPY
> instead of INSERT when you read in a lot of data from a file.
Well unless I am the database owner I only can do \copy and the script does
some manipulati
Hi!
I'm not 100% sure, but I think it would be much faster if you use COPY
instead of INSERT when you read in a lot of data from a file.
Regards,
Patrik Kudo
--
ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!
On Wed, 18 Apr 2001, Konstantinos Agou
On Wed, Apr 18, 2001 at 12:55:07PM +0200, Konstantinos Agouros wrote:
> I once read in Oracle Performance Tuning, that if one inserts or changes large
> amounts of data in a table, it might be better to drop indices before doing
> this and recreating them afterwards. Could someone give a hint on
On Wed, Apr 18, 2001 at 07:18:40AM -0500, Len Morgan wrote:
> >I once read in Oracle Performance Tuning, that if one inserts or changes
> large
> >amounts of data in a table, it might be better to drop indices before doing
> >this and recreating them afterwards. Could someone give a hint on how th
>I once read in Oracle Performance Tuning, that if one inserts or changes
large
>amounts of data in a table, it might be better to drop indices before doing
>this and recreating them afterwards. Could someone give a hint on how this
>is in Postgres 7.1? Currently I am experiencing a massive slowdo
Hi,
I once read in Oracle Performance Tuning, that if one inserts or changes large
amounts of data in a table, it might be better to drop indices before doing
this and recreating them afterwards. Could someone give a hint on how this
is in Postgres 7.1? Currently I am experiencing a massive slowd
Hello,
Two questions today:
1. In my ongoing quest to document Ultradev vs Postgresql =:-D I am
running into a problem that seems to be SQL related. As you may imagine
the code generated by Ultradev is not perfect...
My SELECT request gets passed like this
resultat.jsp?mnuAct=--&entName=BOUL&
psql no longer works the systax
$ psql dbname@hostname
In my DBI scripts I had
$d=DBI->connect('dbi:Pg:dbname=dbname@hostname','user')
That must be rewritten as
$d=DBI->connect('dbi:Pg:dbname=dbname;host=hostname','user')
---(end of broadcast)-
33 matches
Mail list logo
