Issues with the link aside, there's an interesting comment entitled
"MySQL has the better license", which reads:
Someday PostgreSQL might be "embraced and extended" by a predatory
company that will turn it into a closed product, because it uses the
(defective IMHO) BSD license. That can't happen w
Ron Peterson <[EMAIL PROTECTED]> writes:
> Do the multiple actions within a multiple action rule implicitly reside
> within a transaction?
Yes. In the current code it is actually not possible for a single SQL
command issued by the client to give rise to more than one transaction.
(This might chan
> suspected the original link you posted:
> Mike Mascari
Excuse me. But I dont tried to spoof the vote.
I only copied the link after I voted, so the site returned this link.
Maybe someone can corret the link on my initial post.
Marcelo Cid
---(end of broadcast)--
I have a requirement from my security manager but I can't seem to find a good
solution. So I wondered if someone had done something similar.
We have a web portal and a DB in PostgreSQL (obviously) which contains user
data. The portal is accessed by account managers who have access to only
speci
> > http://www.newsforge.com/pollBooth.pl?qid=54
> >
> >
> > I see strange line below results:
> > "(You've already voted.)"
> >
> > I don't believe such results because I do know I didn't been here :)
>
> Marcel's link did the favor of voting for you. Not good
>
> Mike Mascari
No. The link
I am using PG version 8.0 beta 1 and I have run into some problems.
I have 2 RedHat 8 servers running the same PG version, I built them both
from source, and I believe I used the same configure parameters.
I have a database on one of them and want to move it to the second one, but
it is not workin
I'm working on a database that will contain companies (group) and the
relevant listing (securities-> id) and related periodic information. I want
the end users of the data to see the relationship between the 2 (comp A,
security 01, security 02;comp B, security 01, security 02) in the key
(company,s
Hi
Sorry for my English..
I need to organize database structure for saving statistic data for objects. I
have about 24 * 31 * 4 fields (4 month, 31 days, 24 hours) of data for one
object. Each field contain 8 numbers (N in general). So:
object1 -> data -> field1, field2,...
object2 -> data ->
Are there going to be any PostGreSQL events/people at the Go-Linux
conference in Israel this Wednesday?
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not matc
On Mon, Dec 20, 2004 at 23:15:39 -0500,
Ron Peterson <[EMAIL PROTECTED]> wrote:
> Do the multiple actions within a multiple action rule implicitly reside
> within a transaction? I notice that if I brace my multiple actions with
> BEGIN; and COMMIT;, that I get a syntax error, so I'm assuming tha
Do the multiple actions within a multiple action rule implicitly reside
within a transaction? I notice that if I brace my multiple actions with
BEGIN; and COMMIT;, that I get a syntax error, so I'm assuming that's
because they are superfluous in that context... ?
(I want to be sure that I can cou
Hi,
having a small problem in a trigger i want to automatically update a
date field but when i use for example
update table
set field = current_date
where table.pk = new.pk
or
update table
set field = now()
where table.pk = new.pk
this crashes think link between server and db, i have tried using
Hi all!
I recently started using pg_autovacuum instead of scheduling vacuum
analyzes in a system that needs to be taken to production soon.
However, I have noticed something funny that happens while using this.
sometimes, some database operations take an unreasonably long time to finish.
I have n
Hi,
Any body has successfully installing postgres 8 using Remote Desktop
Connection for windows 2003 server web edition?
I am keep getting rdp session instead of console. Even using command : mstsc
/v:servername /console.
with this command I can see several others rdp sessions. which means I might
Steve Atkins <[EMAIL PROTECTED]> writes:
> IF TG_OP='INSERT' OR NEW.foo != OLD.foo THEN
> -- do stuff
> Is there anything that guarantees that the NEW.foo != OLD.foo won't
> be evaluated (and hence fail, as there is no OLD) on an insert?
The only way is to split the expression into two IF c
Jeff MacDonald <[EMAIL PROTECTED]> writes:
> well, i did a "delete from email_log" and then a vacuum and the files
> are still lingering around...
TRUNCATE would be better. A VACUUM FULL would shrink the tables all
right, but probably not do much for the indexes.
regards,
VACUUM or VACUUM FULL. Only the second actually reclaims diskspace...
On Mon, Dec 20, 2004 at 03:21:51PM -0400, Jeff MacDonald wrote:
> well, i did a "delete from email_log" and then a vacuum and the files
> are still lingering around...
>
> still huge. the postmaster did die due to a diskspace i
I have some triggers. They need to do stuff when a new row is inserted
or when the value of a particular field changes.
So, something like:
IF TG_OP='INSERT' OR NEW.foo != OLD.foo THEN
-- do stuff
END IF;
RETURN NEW;
Is there anything that guarantees that the NEW.foo != OLD.foo won't
b
well, i did a "delete from email_log" and then a vacuum and the files
are still lingering around...
still huge. the postmaster did die due to a diskspace issue, so i
wonder if it's still just keeping a wierd lock on those files or
something.. idea's ?
On Mon, 20 Dec 2004 11:01:32 -0300, Alvaro H
Scott Marlowe <[EMAIL PROTECTED]> writes:
>> Some GUC parameters are integers, boolean, or floats, that don't need
>> quotes, and some are strings that do.
> What confused me was the constants that don't need quotes (like
> client_min_messages) and can be set to many different string constants.
>
On Fri, 2004-12-17 at 22:10, Bruce Momjian wrote:
> Scott Marlowe wrote:
> > On Fri, 2004-12-17 at 16:18, Tom Lane wrote:
> > > Scott Marlowe <[EMAIL PROTECTED]> writes:
> > > >> Not sure, but I think you need quotes:
> > > >> unix_socket_directory = '/home/pgmaster/tmp'
> > >
> > > > Wow, that wa
"Guy Rouillier" <[EMAIL PROTECTED]> writes:
>> Not to mention SET SESSION AUTHORIZATION.
> Chris, all the options you mention require the entry of a password, or
> for SET SESSION AUTHORIZATION, that the original connection was made by
> a superuser (which in turn would have required entry of a pa
Tom Lane wrote:
> Christopher Browne <[EMAIL PROTECTED]> writes:
>> Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] ("Jim C.
>> Nasby") would write:
>>> In PostgreSQL, there's currently no way to assume the identity of
>>> another user.
>
>> I'm confused at that...
>
>> There seem to b
On Mon, Dec 20, 2004 at 04:31:59PM +0300, ON.KG wrote:
> I need to make function which emulates table and returns setof columns
> of this "table"
Please start a new thread with a descriptive subject -- the message
you posted was a followup to a thread covering a different topic.
--
Michael Fuhr
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:
> But as I say the file with copy commands contains
> [EMAIL PROTECTED]@[EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL
> PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL
> PROTECTED]@[EMAIL PROTECTED]@COPY "tracking_base" FROM
>
But as I say the file with copy commands contains
[EMAIL PROTECTED]@[EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@COPY "tracking_base" FROM
stdin;
[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:
> You are right. I coleage of mine has added the delete column after the
> schema was created and it ptobably was on the bottom of the table and
> dumped there. But now when I restore the schema this column is on the
> top and the copy command woul
On Mon, 20 Dec 2004 13:32:57 +, Russ Brown <[EMAIL PROTECTED]> wrote:
> On Mon, 20 Dec 2004 14:13:40 +0100, Együd Csaba <[EMAIL PROTECTED]> wrote:
> > Hi,
> > as far as I can remember I somewhere read an article - maybe somwhere on a
> > dbforum or the postgresql.org - which stated that after t
Kaloyan Iliev Iliev wrote:
Hi ,
I have the following problem.
DBVersion: PostgreSQL 7.2.3 on i386-pc-bsdi4.0.1, compiled by GCC 2.7.2.1
I have a dump of a database on two parts.
Here are the dump commands:
pg_dump -s -S postgres "db_name" |gzip > "db_name.shema.sql"
pg_dump -S postgres -a -Fc "db
Thanks Tom,
You are right. I coleage of mine has added the delete column after the
schema was created and it ptobably was on the bottom of the table and
dumped there. But now when I restore the schema this column is on the
top and the copy command wouldn't work. So I must change the schema file
Kaloyan Iliev Iliev <[EMAIL PROTECTED]> writes:
> [ details omitted ]
The easiest way around this is to use a recent (7.4 or 8.0) pg_dump to
dump from the 7.2 database. That will produce a dump using copy-with-
column-list commands which will be proof against the schema
rearrangement that you see
OK, now I am well informed. Thank you.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Christopher Browne
Sent: Monday, December 20, 2004 3:06 PM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG8 final when
The world rejoiced as [EMAIL PROTECTED] (Együd
The world rejoiced as [EMAIL PROTECTED] (Együd Csaba) wrote:
> as far as I can remember I somewhere read an article - maybe somwhere on a
> dbforum or the postgresql.org - which stated that after the RC1 the final
> version is required to be announced at around 15. dec. May be I'm
> misinformed.
Hi ,
I have the following problem.
DBVersion: PostgreSQL 7.2.3 on i386-pc-bsdi4.0.1, compiled by GCC 2.7.2.1
I have a dump of a database on two parts.
Here are the dump commands:
pg_dump -s -S postgres "db_name" |gzip > "db_name.shema.sql"
pg_dump -S postgres -a -Fc "db_name" > "db_name.data.dump
You must be right and I must remeber wrong. Sorry.
Despite of this I'm very happy with the new estimated deadline. :)
Bye,
-- Csaba
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Russ Brown
Sent: Monday, December 20, 2004 2:33 PM
To: [EMAIL PROTECTED]
On Mon, Dec 20, 2004 at 09:57:35AM -0400, Jeff MacDonald wrote:
> # select relname,relfilenode,relpages from pg_class where relfilenode
> = 13312279;
> relname | relfilenode | relpages
> ---+-+--
> email_log |13312279 |36821
>
> It just so happens that em
pg_class tells me
select relname,relfilenode,relpages from pg_class where relfilenode = 13312283;
relname | relfilenode | relpages
---+-+--
pg_toast_13312279 |13312283 | 367639
So now I guess I have to find out what 13312279 is..
Ah HA !
On Mon, Dec 20, 2004 at 09:48:57AM -0400, Jeff MacDonald wrote:
> I'm using 7.3.4
And what about pg_class?
--
Alvaro Herrera (<[EMAIL PROTECTED]>)
"Industry suffers from the managerial dogma that for the sake of stability
and continuity, the company should be independent of the competence of
ind
I'm using 7.3.4
Jeff.
On Mon, 20 Dec 2004 10:48:18 -0300, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> On Mon, Dec 20, 2004 at 09:39:15AM -0400, Jeff MacDonald wrote:
>
> Hi,
>
> > select * from pg_statio_user_tables where relid = 13312283;
>
> See the pg_class table, using the relfilenode col
On Mon, Dec 20, 2004 at 09:39:15AM -0400, Jeff MacDonald wrote:
Hi,
> select * from pg_statio_user_tables where relid = 13312283;
See the pg_class table, using the relfilenode column.
> So I guess my question is, how do i find out what 13312283.* are, are
> they safe to delete ?
Probably none.
Hi,
We after some more reading I learned that this huge file is my TOAST table..
Is there a way to schrink that down ?
Thanks.
Jeff.
On Mon, 20 Dec 2004 09:39:15 -0400, Jeff MacDonald <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a database that is about 3.5 gigs big. And I have a pretty
> ser
Hi,
I have a database that is about 3.5 gigs big. And I have a pretty
serious hunch that there isn't that much data.
I did a "du -s *|sort -n " in /usr/local/pgsql/data/base/9039913
And got a list that ends with these entries.
55648 18070582
137296 13312252
294736 13312279
845648 13312283.
On Mon, 20 Dec 2004 14:13:40 +0100, Együd Csaba <[EMAIL PROTECTED]> wrote:
> Hi,
> as far as I can remember I somewhere read an article - maybe somwhere on a
> dbforum or the postgresql.org - which stated that after the RC1 the final
> version is required to be announced at around 15. dec. May be I
Hi,
as far as I can remember I somewhere read an article - maybe somwhere on a
dbforum or the postgresql.org - which stated that after the RC1 the final
version is required to be announced at around 15. dec. May be I'm
misinformed.
Bye,
-- Csaba
-Original Message-
From: Clodoaldo Pi
Hi All!
I need to make function which emulates table and returns setof columns
of this "table"
for example, i'm making query: "SELECT * FROM my_table(user_id)"
and function
CREATE OR REPLACE FUNCTION my_table (integer)
RETURNS setof text
AS '
DECLARE
check_date date;
max_date date;
On Fri, 17 Dec 2004, Ben wrote:
I have many such tasks. Depending on implementation, it has the potential
to be a TINY amount of less work to schedule such tasks from inside
the database, but it takes all of about a minute to schedule it through
cron. Including the amount of time it takes to refer
On Mon, Dec 20, 2004 at 09:56:35AM +0200, Vitaly Belman wrote:
> I have two tables. "Books" and "Book_Authors" (which links between
> book_id and author_id).
Is there a third table, perhaps Authors?
> Book_authors has a foreign key on book_id to the Books table. On key
> violation it is set to d
Marcelo Cid wrote:
http://www.newsforge.com/pollBooth.pl?qid=54
I see strange line below results:
"(You've already voted.)"
I don't believe such results because I do know I didn't been here :)
Marcel's link did the favor of voting for you. Not good
Mike Mascari
No. The link dont do the voting.
im just replying just to get this thing on record.. so if someone looks for
the answer this would help..
try installing this thing..
libtermcap-devel-2.0.8-35.i386.rpm
i really dont know why this package needed..
On Tuesday 21 January 2003 00:59, mike wrote:
> Hi again,
>
> I show more about
49 matches
Mail list logo
