On Fri, Jun 03, 2005 at 16:04:26 -0500,
Peter Fein <[EMAIL PROTECTED]> wrote:
>
> Ok, this makes a lot of sense & is just cleaner. Would you continue to
> do it this way if there were around a dozen derived tables (most with
> one or two columns)? I remember reading somewhere (perhaps the PG
>
On Sat, 4 Jun 2005 09:25 am, Alvaro Herrera wrote:
> On Fri, Jun 03, 2005 at 05:55:36PM -0500, Gerald D. Anderson wrote:
[snip]
>
> I guess your build with the "use flag" wasn't successful. I think you
> have two choices:
>
> 1. really build with the patch installed, and dump your data using tha
Hrm, well, proof's in the pudding I guess. I went back and rebuilt with
pg-hier after reading this and I'm seeing the results you expect, seems
to be working. I don't know what I did yesterday, but I wasn't paying
attention somewhere. Currently working on backing up a test db, then
will try
On Fri, Jun 03, 2005 at 05:55:36PM -0500, Gerald D. Anderson wrote:
> Ok, you're over my head now so I'm just going to post the results in the
> hope that something clicks. Here ya go:
Ok, I diff'ed both and guess what:
("a" is your output, "b" is mine)
07:19 drizzt ~ 0$ diff a b
38c38
< :lim
On Fri, 2005-06-03 at 18:04, Matt Miller wrote:
> > > a way to enable a function to commit a unit of work that
> > > does not affect the caller's transaction.
>
> > accomplish autonomous transactions in PL/pgSQL
> > by just using dblink_connect, dblink_open, dblink_exec,
> > and dblink_close?
>
>
Tom Lane <[EMAIL PROTECTED]> writes:
> As it happens, the original Berkeley-era Postgres did indeed add
> creation and deletion timestamps to every row, as part of their "time
> travel" feature. That got ripped out very soon after the code left
> Berkeley, because the overhead was just unaccepta
> > a way to enable a function to commit a unit of work that
> > does not affect the caller's transaction.
> accomplish autonomous transactions in PL/pgSQL
> by just using dblink_connect, dblink_open, dblink_exec,
> and dblink_close?
My initial tests lead me to believe that dblink is a simple and
Ok, you're over my head now so I'm just going to post the results in the
hope that something clicks. Here ya go:
({QUERY :commandType 1 :querySource 0 :canSetTag true :utilityStmt <>
:resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable
({RTE :alias {ALIAS :aliasname *OLD* :col
On Fri, Jun 03, 2005 at 06:48:06AM -0500, Gerald D. Anderson wrote:
> Yup, was just going to respond this morning. It isn't enabled by
> default (at least in the ebuilds I've looked at). I've built it with
> pg_hier and without pg_hier and get the same results either way : /
> Might there be
Well first off can you break those 700 lines out into more stored functions?
Maybe you have logic that would be best in its own function and than call one function from another. Makes testing many times easier. I always think in small chuncks when I write code.
Once code gets to be more than
Well first off can you break those 700 lines out into more stored functions?
Maybe you have logic that would be best in its own function and than call one function from another. Makes testing many times easier. I always think in small chuncks when I write code.
Once code gets to be more than
I think it hits the press in June or July 2005???
On 6/3/05, Brad Nicholson <[EMAIL PROTECTED]> wrote:
Gevik babakhani wrote:> Dear All, Beside the documentation, which pg book would you recommend? Which one
> is your personal favorite pg book? Regards>> Gevik.>>>PostgreSQL by Korry Douglas
Tom Lane wrote:
> Peter Fein <[EMAIL PROTECTED]> writes:
>
>>Let's say I have a base table B (with a PK id, say) and two derived
>>tables D1 & D2 (with different cols). For a given B.id, I'd like to
>>allow only a corresponding row in *either* D1 or D2, but not both. Any
>>suggestions on how to
> > a way to enable a function to commit a unit of work that
> > does not affect the caller's transaction.
> Is dblink a possible answer? (it's a contrib package.)
Very interesting. When you earlier mentioned dblink I found only
DBLink-TDS on pgFoundry, and I dismissed it since I'm not accessin
On Fri, 2005-06-03 at 15:10, Matt Miller wrote:
> > > a way to enable a function to commit a unit of work that
> > > does not affect the caller's transaction.
>
> > you can establish an independent connection within a function in, say,
> > PL/Perl or PL/Python.
>
> Okay, multiple connections seem
> > a way to enable a function to commit a unit of work that
> > does not affect the caller's transaction.
> you can establish an independent connection within a function in, say,
> PL/Perl or PL/Python.
Okay, multiple connections seems to be my best shot. However, I would
like standard develope
Is anybody else thinking about the limits of SQL? As often I am probably
not the first to ask these questions. Any pointers?
Joe Celko (sp?) has a couple of books on this subject, SQL for Smarties. I
don't recall if he talks about graphs, but does discuss queries on tree
relationships.
I've go
On Fri, Jun 03, 2005 at 14:09:32 -0500,
Peter Fein <[EMAIL PROTECTED]> wrote:
> Hi-
>
> Let's say I have a base table B (with a PK id, say) and two derived
> tables D1 & D2 (with different cols). For a given B.id, I'd like to
> allow only a corresponding row in *either* D1 or D2, but not both.
Gevik babakhani wrote:
Dear All,
Beside the documentation, which pg book would you recommend? Which one
is your personal favorite pg book?
Regards
Gevik.
PostgreSQL by Korry Douglas and Susan Douglas is an excellent book, but
a little out of date. I beleive a new edition is in
Peter Fein <[EMAIL PROTECTED]> writes:
> Let's say I have a base table B (with a PK id, say) and two derived
> tables D1 & D2 (with different cols). For a given B.id, I'd like to
> allow only a corresponding row in *either* D1 or D2, but not both. Any
> suggestions on how to do this? Should I not
I really wasn't suggesting it be put in the table structure at the DB
level, more a sidebar suggestion for people building schemas for
companies. I can't count the number of times I've been asked when
something was inserted and we didn't have an answer for the
question. Wouldn't it be nice for a
True, although a trigger have the benefit of being able to capture the
value before it was changed allowing some measure of versioning in your
data which can be a lifesaver...
Alex Turner
netEconomistOn 6/3/05, Wiebe de Jong <[EMAIL PROTECTED]> wrote:
I don't use this for all tabl
Scott Marlowe <[EMAIL PROTECTED]> writes:
> On Fri, 2005-06-03 at 13:40, Alex Turner wrote:
>> One might even suggest that this should really be a default for all
>> tables everywhere, because at some time or another, someone wants to
>> know when something got put in the database...
> That kind o
Please reply on the bottom, it makes it much easier to follow the
responses...
On Fri, 2005-06-03 at 14:05, Wiebe de Jong wrote:
> I don't use this for all tables, only the ones with important
> information in them, like people, accounts, etc.
>
>
>
> I actually have two fields, tsCreated an
Title: Re: [GENERAL] Determining when a row was inserted
I don't use this for all tables, only the ones with important
information in them, like people, accounts, etc.
I actually have two fields, tsCreated and tsUpdated, both which default
to now(). When I do an update, I set the value
Hi-
Let's say I have a base table B (with a PK id, say) and two derived
tables D1 & D2 (with different cols). For a given B.id, I'd like to
allow only a corresponding row in *either* D1 or D2, but not both. Any
suggestions on how to do this? Should I not be using inheritance at all?
My thought
> On 6/3/05, Wiebe de Jong <[EMAIL PROTECTED]> wrote:
> >
> > The way I do it is to add a timestamp field with a default value of now().
> > Unfortunately, this won't help with any records that have already been
> > created.
On Fri, Jun 03, 2005 at 02:40:08PM -0400, Alex Turner wrote:
> One might
Dear All,
Beside the documentation, which pg book would you recommend?
Which one is your personal favorite pg book?
Regards
Gevik.
Reply at bottom...
On Fri, 2005-06-03 at 13:40, Alex Turner wrote:
> One might even suggest that this should really be a default for all
> tables everywhere, because at some time or another, someone wants to
> know when something got put in the database...
>
> Alex.
>
> On 6/3/05, Wiebe de Jong
Reply at bottom...
On Fri, 2005-06-03 at 12:53, Wiebe de Jong wrote:
> The way I do it is to add a timestamp field with a default value of now().
> Unfortunately, this won't help with any records that have already been
> created.
>
> Wiebe
>
> -Original Message-
> From: [EMAIL PROTECTED]
One might even suggest that this should really be a default for all
tables everywhere, because at some time or another, someone wants to
know when something got put in the database...
Alex.On 6/3/05, Wiebe de Jong <[EMAIL PROTECTED]> wrote:
The way I do it is to add a timestamp field with a defaul
The way I do it is to add a timestamp field with a default value of now().
Unfortunately, this won't help with any records that have already been
created.
Wiebe
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Terry Lee Tucker
Sent: Thursday, June 02, 2005
Sean Davis wrote:
>
> On Jun 3, 2005, at 12:32 PM, Joe Conway wrote:
>
>> Peter Fein wrote:
>>
>>> I want to do something like this (pardon my pseudocode):
>>> A=ARRAY[4, 5, 6, 7, 8]
>>> B=ARRAY[5, 6]
>>> is_sliceof(A, B), i.e., there exists a slice of A that equals B. My
>>> best thought ATM is
> Is anybody else thinking about the limits of SQL? As often I am probably
> not the first to ask these questions. Any pointers?
Joe Celko (sp?) has a couple of books on this subject, SQL for Smarties. I
don't recall if he talks about graphs, but does discuss queries on tree
relationships.
--
S
On Fri, 3 Jun 2005, Joshua D. Drake wrote:
Serial is a psuedo type to integer/big (depending on the type of serial).
Josh,
That's what I thought.
What you have above should work fine.
OK.
Many thanks,
Rich
--
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
<
Rich Shepard wrote:
Don't know why I've not come across this before, but I have now.
In a table definition I reference the primary key of another table. That
key is of datatype SERIAL. In the referencing table, do I define the column
as
col_name INTEGER REFERENCES other-table (primary_key
On Jun 3, 2005, at 12:32 PM, Joe Conway wrote:
Peter Fein wrote:
I want to do something like this (pardon my pseudocode):
A=ARRAY[4, 5, 6, 7, 8]
B=ARRAY[5, 6]
is_sliceof(A, B), i.e., there exists a slice of A that equals B. My
best thought ATM is to convert both to strings and use pattern
ma
Don't know why I've not come across this before, but I have now.
In a table definition I reference the primary key of another table. That
key is of datatype SERIAL. In the referencing table, do I define the column
as
col_name INTEGER REFERENCES other-table (primary_key_field),
or is the d
Peter Fein wrote:
I want to do something like this (pardon my pseudocode):
A=ARRAY[4, 5, 6, 7, 8]
B=ARRAY[5, 6]
is_sliceof(A, B), i.e., there exists a slice of A that equals B. My
best thought ATM is to convert both to strings and use pattern matching
- any better ideas?
I can't think of a r
Tony Caduto wrote:
Can't do that, it's a Delphi 7 application.
Have you heard of Kylix? You should be able to do an almost straight
native port to Linux.
SIncerely,
Joshua D. Drake
Huh, have you considered compiling it on Linux using libwine? That may
give you better results.
Hi-
I want to do something like this (pardon my pseudocode):
A=ARRAY[4, 5, 6, 7, 8]
B=ARRAY[5, 6]
is_sliceof(A, B), i.e., there exists a slice of A that equals B. My
best thought ATM is to convert both to strings and use pattern matching
- any better ideas?
--Pete
---
I used the wine from 5/24/2005 and it was certainly not slow, and I was only
running on a Athlon XP 1.8 (1.5gzh) which is
by no means top of the line hardware.
Russ Brown wrote:
Just tried it here at work with crossover office 3.0.0 and it was far
too slow to be usable (plus I had issues with
Can't do that, it's a Delphi 7 application.
Huh, have you considered compiling it on Linux using libwine? That may
give you better results.
--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql 8.x
http://www.amsoftwaredesign.com
---(end of bro
On Fri, 2005-06-03 at 04:38, Peter Eisentraut wrote:
> Am Freitag, 3. Juni 2005 00:36 schrieb Peter Eisentraut:
> > On a particular system, loading 1 million rows (100 bytes, nothing
> > fancy) into PostgreSQL one transaction at a time takes about 90
> > minutes. Doing the same in MySQL/InnoDB tak
=?ISO-8859-1?Q?Havasv=F6lgyi_Ott=F3?= <[EMAIL PROTECTED]> writes:
> select substring(proname from 1 to 1) as nevresz, count(*)
> from pg_proc
> where nevresz = 'a'
> order by nevresz
> group by nevresz;
> What is the problem? I cannot use column alias in where condition?
Exactly. Per the SQL
Havasvölgyi Ottó wrote:
Hi all,
I issued the following queries:
select substring(proname from 1 to 1) as nevresz, count(*)
from pg_proc
where nevresz = 'a'
order by nevresz
group by nevresz;
select substring(proname from 1 to 1) as nevresz, count(*)
from pg_proc
order by nevresz
group
Just tried it here at work with crossover office 3.0.0 and it was far
too slow to be usable (plus I had issues with text boxes showing
through to the window below).
I'll give it a go at home this weekend with a more recent version of
Wine and see if that improves things (I do actually want to be a
On Fri, Jun 03, 2005 at 07:44:56AM -0500, Tony Caduto wrote:
> It runs almost perfectly and pretty fast on a AMD Athlon XP 1.8
>
> http://www.amsoftwaredesign.com/gallery/wineshots?page=1
> (this is with the latest version of wine from 5/24/2005)
>
> The only issue I saw was that the text in the
Hi all,
I issued the following queries:
select substring(proname from 1 to 1) as nevresz, count(*)
from pg_proc
where nevresz = 'a'
order by nevresz
group by nevresz;
select substring(proname from 1 to 1) as nevresz, count(*)
from pg_proc
order by nevresz
group by nevresz;
The first que
On Thu, Jun 02, 2005 at 16:57:14 -0400,
Douglas McNaught <[EMAIL PROTECTED]> wrote:
>
> A serial column is basically just syntactic sugar for the above, so
> you're not losing anything.
In recent versions of postgres, I do think you lose something. I don't
believe the dependency will get tracke
On Fri, 2005-06-03 at 08:43 -0400, Christopher Browne wrote:
> After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Marco Colombo)
> belched out:
> > The hardware seems to be the bottleneck. Try improving the performance
> > of your disk systems. It's very unlikely to get _exactly_ the sam
"Marcelo" <[EMAIL PROTECTED]> writes:
> Hello,
> Using Postgres 7.4, I am trying to perform an "alter table temptable add
> column "myCol" serial"
>
> It gives the following msg
> ERROR: adding columns with defaults is not implemented
>
> You cannot add a column that is serial in a table whic
Have a look at Mysql gotchas...
http://sql-info.de/mysql/database-definition.html#2_4
So here's another little gem about our friends from Uppsala: If you create a
table with InnoDB storage and your server does not have InnoDB configured, it
falls back to MyISAM without telling you.
As i
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Marco Colombo)
belched out:
> On Fri, 2005-06-03 at 11:38 +0200, Peter Eisentraut wrote:
>> Am Freitag, 3. Juni 2005 00:36 schrieb Peter Eisentraut:
>> > On a particular system, loading 1 million rows (100 bytes, nothing
>> > fancy) into
It runs almost perfectly and pretty fast on a AMD Athlon XP 1.8
http://www.amsoftwaredesign.com/gallery/wineshots?page=1
(this is with the latest version of wine from 5/24/2005)
The only issue I saw was that the text in the data grids was coming back
the same color as the background, and I thin
On Fri, 2005-06-03 at 11:38 +0200, Peter Eisentraut wrote:
> Am Freitag, 3. Juni 2005 00:36 schrieb Peter Eisentraut:
> > On a particular system, loading 1 million rows (100 bytes, nothing
> > fancy) into PostgreSQL one transaction at a time takes about 90
> > minutes. Doing the same in MySQL/Inno
Yup, was just going to respond this morning. It isn't enabled by
default (at least in the ebuilds I've looked at). I've built it with
pg_hier and without pg_hier and get the same results either way : /
Might there be some other cause for this? Or even a dirty fix if this
is what it is?
G
On Fri, 3 Jun 2005 12:38 am, Tom Lane wrote:
> "Gerald D. Anderson" <[EMAIL PROTECTED]> writes:
> > So, the plot thickens. Is there somewhere I can go tweak a few bytes to
> > make it think it's 7.3?
>
> No. That's not what you want anyway; you want a late 7.4 build, just
> one without the hier
Peter Eisentraut wrote:
On a particular system, loading 1 million rows (100 bytes, nothing
fancy) into PostgreSQL one transaction at a time takes about 90
minutes. Doing the same in MySQL/InnoDB takes about 3 minutes. InnoDB
is supposed to have a similar level of functionality as far as the
Am Freitag, 3. Juni 2005 00:36 schrieb Peter Eisentraut:
> On a particular system, loading 1 million rows (100 bytes, nothing
> fancy) into PostgreSQL one transaction at a time takes about 90
> minutes. Doing the same in MySQL/InnoDB takes about 3 minutes. InnoDB
> is supposed to have a similar l
Title: RE: [GENERAL] Automate Postgres Backup In windows -> resolved
Thanks Richard.
For anyone interested
The link Richard was referring to can be found below.
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.Html
Kind Regards,
Shaun Clements
-Original Message-
Fr
Gevik babakhani wrote:
> Dear People,
>
>
>
> After a long time of various timeouts, I managed to get back on track
> developing the long promised PQDN website. As some of you might know. I
> was working on a project called the PostgreSQL Developer Network.
>
>
>
> The websites (which is a
Bruno Wolff III wrote:
On Thu, Jun 02, 2005 at 18:00:17 +0100,
Richard Huxton wrote:
Certainly, but if the text in the logfile row is the same, then hashing
isn't going to make a blind bit of difference. That's the root of my
concern, and something only Dinesh knows.
Sure it is. Because
Shaun Clements wrote:
Problem there is the pg_dump requires a password.
Ah - you'll be wanting the ".pgpass" password file - there's a section
in the manuals under Client Interfaces/libpq
Not the place you'd first look, I'll admit.
Oh - might be worth googling for .pgpass and windows in cas
64 matches
Mail list logo
