greSQL administration and development tool!
I'd be happy to use EMS products, but I really need Linux versions.
Any plans regarding *nix platforms support?
Ditto, when will we see the *nix versions?
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.comwww.andromeda-project.org
631-689
ck real "development" features.
Is there advice for a better tool to be run under Linux/KDE?
MTIA!
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.comwww.andromeda-project.org
631-689-7200 Fax: 631-689-0527
cell: 631-379-0010
---(end of broa
end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat
th.uk.msn.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.comwww.andromeda-project.org
631-689-7200 Fax: 631-689-0527
cell:
dvance,
Paolo Saudin
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
Kenneth Downs
Secure Data Software, Inc.
www.se
makes the code
significantly simpler...
That's all, now back to our regularly scheduled mailing list.
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.comwww.andromeda-project.org
631-689-7200 Fax: 631-689-0527
cell: 631-379-0010
OWER(dob) FROM 1 FOR 2)='ke') ORDER BY patient
Limit 20
Eventually I will be driven to optimize that, but on tables < 10,000
rows it is still well within the threshhold of the human attention span
of < .5 second or so.
Naz Gassiep wrote:
This may be useful to me and ot
Tom Lane wrote:
Kenneth Downs <[EMAIL PROTECTED]> writes:
Basically, it "knows what you mean" when you do substrings on dates and
numbers, doing an implicit cast for you.
Implicit casts to text are evil, and are mostly going to be gone in 8.3.
So try not to rely
terializes
derived information in columns, so my tables are more fat to begin with,
and so this hits me harder.
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.comwww.andromeda-project.org
631-689-7200 Fax: 631-689-0527
cell: 631-379-0010
---(end of
Tom Lane wrote:
Kenneth Downs <[EMAIL PROTECTED]> writes:
Speaking as an end-user, I can give only one I've ever seen, which is
performance. Because of MVCC, Postgres's write performance (insert and
update) appears on my systems to be almost exactly linear to row size.
rface: plain old SQL.
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.comwww.andromeda-project.org
631-689-7200 Fax: 631-689-0527
cell: 631-379-0010
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
---
TIP 2: Don't 'kill -9' the postmaster
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.comwww.andromeda-project.org
631-689-7200 Fax: 631-689-0527
cell: 631-379-0010
come into play as overhead in firing the trigger.
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.comwww.andromeda-project.org
631-689-7200 Fax: 631-689-0527
cell: 631-379-0010
---(end of broadcast)---
TIP 3: Have you checked our
Diego de Blas wrote:
Hello,
I'm trying to set a new trigger for "pg_authid" connected as
"postgres" but system returns always the same error "Permission
denied: "pg_authid" is a system catalog"... I have checked privileges
and I can teorically add new triggers. I don't know whta's wrong...
Not sure if this one is fixable, but a user of my GPL'd package was
unable to run our install.
Eventually we pinned it down to a failed load of a sproc written in
plperl. He says he's running a Red Hat 9 system with Postgres 8.1 and
perl is 5.8.5. When he takes the plperl sproc and attempts
Dhaval Shah wrote:
I am in a situation where we have to deploy a hot standby to a
postgres db server. There is no custom tablespace and all data files
are in $PGDATA
I was thinking of using PITR
[]http://www.postgresql.org/docs/8.1/static/backup-online.html] to
achieve that and here are my thoug
Peter Eisentraut wrote:
The proper fix for this problem is to insert explicit SET search_path
commands into each affected function to produce a known safe schema
search path. Note that using the default search path, which includes a
reference to the "$user" schema, is not safe when unqualified
Tom Lane wrote:
"David Legault" <[EMAIL PROTECTED]> writes:
I thought it would transfer that CREATEROLE privilege too.
I've been dying to get 2 cents in on this. Tell me if this suggestion
makes any sense.
We use real database users in our systems, we don't connect in with an
Tom Lane wrote:
Kenneth Downs <[EMAIL PROTECTED]> writes:
Except for the hole. On a public site that lets users register, we have
to have way to let the web server assume the role of somebody who has
createuser privelege, and that's pretty much the end of the no-root
pol
once into the table? So the argument can be reduced to:
1) Load into tables for transactional support, con is the write-time hit
2) Load into filesystem for faster load, but you have to provide
integrity by another route
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com / www.andr
s are the GL transaction rows. When you post an AP
voucher, do the same thing. Same for checks received, checks paid,
etc, all of them have different batch types.
In short, the problem of too many parents is inverted to produce many
children instead, and the problem goes away.
--
Ken
Karl O. Pinc wrote:
On 02/25/2007 06:21:45 PM, Kenneth Downs wrote:
Martin Winsler wrote:
This is a real world situation where referential
integrity needs to be broken in theory, I believe. Does anybody
have any experience or knowledge of building financial accounting
databases? Am I
on't pay back, you pay forward."
-- Robert A. Heinlein
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com / www.andromeda-project.org
Office: 631-689-7200 Cell: 631-379-0010
::Think you may have a problem with programming? Ask yourself this
::question: do you w
it is a simple
foreign key and no action on a row ever affects another row, unlike the
other two. If we could query out a list using WITH RECURSE it would
become very powerful.
best regards,
depesz
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com / www.andromeda-project.org
hubert depesz lubaczewski wrote:
On 3/1/07, Kenneth Downs <[EMAIL PROTECTED]> wrote:
Better? I think perhaps different. There is materialized path, which
requires a very problematic unlimited-length column to hold the path,
and there is upper/lower bounds, which again requires client-si
Adam Rich wrote:
Is there any way to define custom variables per session scope?
In oracle, we do this using package variables.
This would be so cool to have.
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com / www.andromeda-project.org
Office: 631-689-7200 Cell: 631-379-0010
hubert depesz lubaczewski wrote:
On 3/2/07, Kenneth Downs <[EMAIL PROTECTED]> wrote:
This reminds me of another advantage of the WITH RECURSIVE, which is
that it pushes to overhead to SELECT, with no associated write-time
overheads.
hmm .. why do you consider this as advantage? i wou
database to its
current state?
If your scripts contain data modification code, they can be preserved,
but using a dictionary smooths over a lot of the quirkiness of the
scripts-based approach.
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com / www.andromeda-project.org
Office: 631
a M:M)
between all pairs of tables, and then having a view that UNIONs them
together?
This way you don't have to re-invent the foreign key to get it all working.
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com / www.andromeda-project.org
Office: 631-689-7200 Cell: 631-379-001
Bradley Kieser wrote:
I hope that someone has cracked this one because I have run into a
brick wall the entire week and after 3 all-nighters with bad
installations, I would appreciate hearing from others!
I am looking for a decent OpenSource CRM system that will run with
Postgres. SugarCRM se
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/08/07 20:38, Kenneth Downs wrote:
[snip]
Management and we are about to add the CRM to it so that the
scheduling/billing database also serves the doctor's public website,
Is that wise? One bug and a crack
Karsten Hilbert wrote:
On Fri, Mar 09, 2007 at 08:08:11AM -0500, Kenneth Downs wrote:
First, security is defined directly in terms of tables, it is not
arbitrated by code. The "public" group has SELECT access to the
articles table and the schedules tables, that's it. If a
Karsten Hilbert wrote:
If the user figures out our URL scheme, they might try something like
"?gp_page=patients" and say "Wow I'm clever I'm going to look at the
patients table", except that the public user has no privilege on the
table. The db server will throw a permission denied error.
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/09/07 10:02, Kenneth Downs wrote:
Karsten Hilbert wrote:
On Fri, Mar 09, 2007 at 08:08:11AM -0500, Kenneth Downs wrote:
First, security is defined directly in terms of tables, it is not
arbitrated by
Kevin Hunter wrote:
If a user has not logged in, that is, if they are an anonymous
visitor, the web framework will connect to the database as the
default "public" user. Our system is deny-by-default, so this user
cannot actually read from any table unless specifically granted
permission. I
Bill Moran wrote:
If a user has not logged in, that is, if they are an anonymous visitor,
the web framework will connect to the database as the default "public"
user. Our system is deny-by-default, so this user cannot actually read
from any table unless specifically granted permission. In the
Kevin Hunter wrote:
What about an SQL injection bug that allows for increased privileges?
Um, web programming 101 is that you escape quotes on user-supplied
inputs. That ends SQL injection.
Pardon my naivete (I'm fairly new to web/DB programming) . . . is this
the current standard method o
Tom Lane wrote:
Kenneth Downs <[EMAIL PROTECTED]> writes:
The biggest security limitation we have is actually a weakness in
Postgres - the inability to restrict the abilities of a user with
CREATUSER rights, they can make somebody who can do anything. For
higher security this requi
Awesome! That never occurred to me. This is really cool.
Tom Lane wrote:
Kenneth Downs <[EMAIL PROTECTED]> writes:
Perhaps a lesser form of CREATEROLE, CREATEROLE_LIMITED, who can create
roles and only grant to the roles he himself is a member of.
You can make that out of
Alvaro Herrera wrote:
David Legault escribió:
That's basically what I've done with my past questions on the ROLE system in
place. Since roles are global, I wanted it fine grained to the DB level so I
had to append DB_ in front of each role name and by using current_database()
inside my functi
I'm guessing that there is no step-wise debugger for pgsql. If there
is, then glory be and call me a dummy for not R'ing TFM.
In fact, I've never heard of a step-wise debugger for any DB server, am
I wrong?
As I grovel through some plPerl code in a statement level trigger that
depends on an
Consider the case where an AFTER STATEMENT trigger calls a plperl
function which performs a loop. Inside of the loop it updates at least
one other table.
The table being updated has an AFTER STATEMENT trigger that calls the
same plperl function (w/different parms of course), which goes into
Martijn van Oosterhout wrote:
On Wed, Mar 14, 2007 at 08:09:24PM -0400, Kenneth Downs wrote:
What I have noticed is that once the innermost instance exits, none of
the outer instances execute any further, suggesting that the plperl
routine is not "re-entrant" (if I am using
Kev, we have a GPL'd product targeting Postgres that has significant
overlap with what you want, though in other areas we went in another
direction. The site is www.andromeda-project.org, and I've put some
comments below:
Kev wrote:
Hi everyone,
I'm still in the design phase of a project.
Randal L. Schwartz wrote:
"Kenneth" == Kenneth Downs <[EMAIL PROTECTED]> writes:
Kenneth> This in effect makes the web server a proxy to the database, which
Kenneth> sounds like what you are after. The "P" portion for us is PHP, not
Kenneth> Pe
Merlin Moncure wrote:
On 3/27/07, Randal L. Schwartz wrote:
>>>>> "Kenneth" == Kenneth Downs <[EMAIL PROTECTED]> writes:
Kenneth> This in effect makes the web server a proxy to the database,
which
Kenneth> sounds like what you are after. The "P&
I truly hoping I'm missing something silly here. I've got a cron job to
run a dumpall each early am. It fails, and I get a handful of emails.
The first reads like this:
pg_dump: [archiver (db)] connection to database "adocs" failed: FATAL: sorry,
too many clients already
pg_dumpall: pg_dum
opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?
---(end of broadcast)---
TIP 6: explain analyze is your friend
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.comwww.andromeda
simpler to follow the trace of updates.
What you suggest?
Regards,
--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.comwww.andromeda-project.org
631-379-7200 Fax: 631-689-0527
---(end of broadcast)---
TIP 2: Don't 'ki
Martijn van Oosterhout wrote:
On Wed, Mar 14, 2007 at 08:09:24PM -0400, Kenneth Downs wrote:
What I have noticed is that once the innermost instance exits, none of
the outer instances execute any further, suggesting that the plperl
routine is not "re-entrant" (if I am using
event fraud, but I
just don't like that idea of running anonymously and committing
financial data.
In this case it seems creating a stored procedure will not automatically
help, as then we just execute the SP anonymously, and it strikes me as
no different.
Has anybody pondered this and
Dave Page wrote:
Kenneth Downs wrote:
The last one left that I have is the sticky issue of a paypal IPN
transaction coming in. I believe it applies generally to financial
transactions. The user is sent by our application to the Paypal site.
When they pay, paypal sends a POST with various
Richard Huxton wrote:
Kenneth Downs wrote:
Richard Huxton wrote:
Kenneth Downs wrote:
The last one left that I have is the sticky issue of a paypal IPN
transaction coming in. I believe it applies generally to financial
transactions. The user is sent by our application to the Paypal
site
Richard Huxton wrote:
Kenneth Downs wrote:
The last one left that I have is the sticky issue of a paypal IPN
transaction coming in. I believe it applies generally to financial
transactions. The user is sent by our application to the Paypal
site. When they pay, paypal sends a POST with
make a long story short, the request might not have been made in the most
diplomatic way, but it would, if adopted, solve some real anomalies that
confuse newcomers to this group and its relatives.
--
Kenneth Downs
Use first initial plus last name at last name plus literal
trying to help the list
> subscribers.
>
> This is my last post to news.groups about this.
--
Kenneth Downs
Use first initial plus last name at last name plus literal "fam.net" to
email me
---(end of broadcast)---
TIP 7: d
and
> learn how to configure a newsreader in order to vote in favor, instead
> of posting through google all the time. That should speed my access to
> usenet up quite a bit. Oh, well.
>
> JouDanZuki
Joe, your access to ng's will speed up *dramatically* when you go through a
new
t are also named after various OIDs.
Can such things be picked up the way you would pick up a Microsoft database?
--
Kenneth Downs
Use first initial plus last name at last name plus literal "fam.net" to
email me
---(end of broadcast)---
;t use Mac or Windows, so I guess we're even ;).
>>
>
> I hope to do a Linux in the near future, so I'll be looking forward to
> your feedback :).
>
> Best,
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power T
Hi folks,
I cannot find this in Google, Google groups, online docs, or the
archive, so I hope somebody can help me.
If I define a per-statement AFTER INSERT trigger, how are the new rows
exposed to the trigger?
Put another way, what is the equivalent to the row-level variables NEW
and OLD
If there are triggers writing to %_SHARED within a transaction, and the
transaction is rolled back, do the changes to %_SHARED roll back also?
If not then I assume I should manually clear it at the start of
transactions, no?
begin:vcard
fn:Kenneth Downs
n:Downs;Kenneth
email;internet:[EMAIL P
SunWuKung wrote:
In article <[EMAIL PROTECTED]>, dev@archonet.com says...
SunWuKung wrote:
Select Into max_option parameter_value From parameters Where methodid=
999 And parameter_name='max_option'
and so on for each parameter.
What you are trying t
Ian Harding wrote:
I am fascinated by your post. I have never heard a bad thing said
about RoR.
I have been meaning to investigate it because it is the only system
I've heard of that makes the same claim that I do, which is to have
eliminated entire categories of labor through automation.
E
[EMAIL PROTECTED] wrote:
you should play around with phpPgAdmin for a while and let us know
specifically what we can help you with.
in pg_hba.conf you can set it so that users have access to any database
if they are in a group (or do we say "role" now?) that has the same
Merlin Moncure wrote:
It has been
more or less proven that functional, declaritive style coding has less
errors and is more reliable than mixed sql/procedural applciation code
given developers with equal skill.
I did not know there were empirical studies on this, I would love to be
able to re
Bert wrote:
Hi list
I have a table construction like the one seen below, when i am updating
or inserting i get a recurion, logical. But how to manage it that the
rule is just doing it one time. Or is it possible to do the sum of a
and b in an other way?
Bert, i do this with triggers. There
Bert wrote:
This rule is creating first of all the insert and then i can run an
Update on this insert, so far its functioning. Your definition is quite
good but what are doing when you change the table definition? Rewrite
all Rules?
I actually use a data dictionary processor that automaticall
Hi folks I'm hoping somebody can demystify something for me.
I've got a test database that is going live.
During development I have not vacuum'd much, so to get started I did
"Vacuum verbose analyze".
At the end of the process it told me that vacuum needed max_fsm_pages to
be set at about 2
Benjamin Smith wrote:
I have a customer table (very important) and have numerous fields in other
tables FK to the serial id of the customer table.
What you need is a list of the foreign key definitions, out of which you
build SQL selects that check each child table based on foreign key. T
Jim Fitzgerald wrote:
Hello -
Probably would be better to ask, "how do I store this data?"
Then the query writes itself. Put people in one table, put aliases in
another.
CREATE TABLE people (
person_id int
,first varchar(20)
,last varchar(20)
)
CREATE TABLE aliases (
person_id in
Karen Hill wrote:
What is your favorite front end for end users to interact with your
postgresql db? Is it java, .net, web apache + php, MS-Access, ruby on
rails? Why is it your favorite? Which would you recommend for end
users on multiple OSes?
I use PHP for the same reason I use Postgre
Bart Butell wrote:
Is there a GUI interface to the database like
Enterprise Manager for
Microsoft SQL Server?
A couple of big ones are pgAdmin3 and phppgadmin
pgAdmin3 is a desktop app and looks like Enterprise Mgr. If you are
used to Enterprise mgr, it can be almost good e
Dave Page wrote:
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Kenneth
Downs
Sent: 12 May 2006 02:09
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
The longer you use it, the longer it takes to
Dave Page wrote:
On my linux box, it
also has the dubious honor of being the only program I have ever seen
that can lock X hard, with killing the X server being the only rescue
(if you call that a rescue). It can connect over networks, but on mine
it always seems to hang afte
Tony Caduto wrote:
Dave Page wrote:
Only runs on Windows though doesn't it?
Regards, Dave
Hardly a limitation since Linux and other Unix based operating systems
account for a trivial percent of the desktop market.
I guess it depends on your definition of trivial. Linux represents 1
Florian G. Pflug wrote:
Tino Wildenhain wrote:
Kenneth Downs schrieb:
Dave Page wrote:
On my linux box, it also has the dubious honor of being the only
program I have ever seen that can lock X hard, with killing the X
server being the only rescue (if you call that a rescue
Dave Page wrote:
Wow this is good to know.
I'm also glad to know I'm not the only person this is happening to.
Kenneth; what platform are you running on, and ehich window manager are you using?
Regards, Dave
gentoo linux on an AMD. here are
Dave Page wrote:
kernel 2.6.8
KDE 3.3.2
gtk+ 2.4.14
pgadmin3 1.2.2
The window manager would be whatever the default for KDE is.
OK, the first thing you really should do is
upgrade to pgAdmin 1.4.2 and (if building form source) wxWidgets 2.6.3.
There have b
Kenneth Downs wrote:
Dave Page wrote:
kernel 2.6.8
KDE 3.3.2
gtk+ 2.4.14
pgadmin3 1.2.2
The window manager would be whatever the default for KDE is.
OK, the first thing you really should do is
upgrade to pgAdmin 1.4.2 and (if
Csaba Nagy wrote:
[leaving the original text, as it is reply to an older posting]
On Fri, 2006-03-31 at 21:26, Jim Nasby wrote:
On Mar 29, 2006, at 3:25 AM, Csaba Nagy wrote:
Could somebody explain me, or point me to a resource where I can find
out what i
Hello folks,
My company has developed an application development framework that
targets PostgreSQL as its back-end, with PHP in the web layer.
We are inviting any early adopters who may wish to experiment to
download and install the code. You may contact me off-list with any
support or oth
Joshua D. Drake wrote:
Kenneth Downs wrote:
Hello folks,
My company has developed an application development framework that
targets PostgreSQL as its back-end, with PHP in the web layer.
We are inviting any early adopters who may wish to experiment to
download and install the code. You
I participate regularly on three mailing lists, including
pgsql-general. I use thunderbird for mail.
pgsql-general has the peculiar property, when I hit reply, of replying
not to the list, but the individual who emailed to the list.
Is this me, or is this the list?
begin:vcard
fn:Kenneth D
Joshua D. Drake wrote:
Sounds great! But why GPL? Are you looking to sell licenses?
GPL is to spread it as far and wide as possible as fast as possible.
LGPL?
My concern would be, I can't use this toolkit for a closed source
application if it is GPL.
That may be your intent (which I
Scott Marlowe wrote:
On Tue, 2006-05-16 at 15:04, Kenneth Downs wrote:
I participate regularly on three mailing lists, including
pgsql-general. I use thunderbird for mail.
pgsql-general has the peculiar property, when I hit reply, of replying
not to the list, but the
Tom Lane wrote:
Kenneth Downs <[EMAIL PROTECTED]> writes:
If it turns out that nobody can release a closed source app, I will
definitely reconsider and look again at LGPL, but I am not convinced you
cannot do so.
If you seek to provide a closed sour
Anastasios Hatzis wrote:
Kenneth Downs wrote:
My company has developed an application development framework that
targets PostgreSQL as its back-end, with PHP in the web layer.
Is this product somehow related to AndroMDA (which is usually
pronounced 'Andromeda')?
http://www.an
Florian Weimer wrote:
* Joshua D. Drake:
Sounds great! But why GPL? Are you looking to sell licenses?
GPL is to spread it as far and wide as possible as fast as possible.
LGPL?
My concern would be, I can't use this toolkit for
Florian Weimer wrote:
* Kenneth Downs:
If you seek to provide a closed source app that is built upon
Andromeda, you are required to provide the source code to Andromeda
itself. However, your app is not a derivative work in the strict
sense because your code is not mixed in with
Florian G. Pflug wrote:
It took me a while to find out how exactly to reproducte the hang (It
would happen to me about once a day when using pgadmin3 heavily on
gnome/metacity, but when trying to reproduce it, I couldn't).
You have to select some text, and then _doubleclick_ on the selected
I've gotten a chance to upgrade wxGTK to 2.6.3.2. I can no longer
deliberately reproduce the freezeup caused by a double-click on selected
text in the query analyzer.
This btw is using pgadmin3 1.2.
begin:vcard
fn:Kenneth Downs
n:Downs;Kenneth
email;internet:[EMAIL PROTECTED]
tel;work:631-
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Kenneth Downs
Sent: 23 May 2006 12:24
To: pgsql general
Subject: [GENERAL] More confirmation: pgadmin3 freezeup fixed
by wxgtk 2.6.3
I've gotten a chance to up
Rafal Pietrak wrote:
So if I may re-phrase the question: "is there a way to have a trigger,
that, when launched, can check if it's already running in backgroung for
some other INSERT, return imediately if so, but turn into background for
a long-lasting job if not".
Rafal, I'm wondering why y
Alban Hertroys wrote:
When encountering this problem I usually wonder why there isn't a data
type that can store a timestamp and can be used to create a UNIQUE
INDEX over it's values. That'd be wonderful.
Well, maybe one day I'll actually have time to create one...
I tried this at trigger l
Rafal Pietrak wrote:
A plain INSERT of batch takes 5-10minutes on desktop postgresql (800MHz
machine, ATA disks). When I attach trigger (*Very* simple funciton) to
update the accounts, the INSERT take hours (2-4). But when I make just
one single update of all accounts at the end of the batch ins
Alban Hertroys wrote:
Kenneth Downs wrote:
Alban Hertroys wrote:
When encountering this problem I usually wonder why there isn't a
data type that can store a timestamp and can be used to create a
UNIQUE INDEX over it's values. That'd be wonderful.
Well, maybe one day I&#
Rafal Pietrak wrote:
On Wed, 2006-05-24 at 07:41 -0400, Kenneth Downs wrote:
Why not have the INSERT go to an "inbox" table, a table whose only job
is to receive the data for future processing.
Actually, it 'sort of' works that way.
You
e ought to be a way on windows I
would think.
Kenneth Downs wrote:
Rafal Pietrak wrote:
A plain INSERT of batch takes 5-10minutes on desktop postgresql (800MHz
machine, ATA disks). When I attach trigger (*Very* simple funciton) to
update the accounts, the INSERT take hours (2-4). But when
Tim Allen wrote:
Holger Hoffstaette wrote:
On Thu, 25 May 2006 08:55:51 +0200, Sim Zacks wrote:
Does anybody know when postgresql 8.1 will be considered stable on
gentoo
for x86?
No, maybe ask in gentoo-users or -dev? Anyway just because it's not
marked
"stable" does not mean it isn't.
Josue E. Maldonado wrote:
Benjamin Smith wrote:
How can I set up a user so that Bob can update his records, without
letting Bob update Jane's records? Is it possible, say with a view or
some other intermediate data type?
I've done something similar using a separate control table where I s
1 - 100 of 127 matches
Mail list logo
