Hi all,
I would like to create a database based upon a template which also
contains some tables. After invoking
psql -T templateName -U dbuser -O dbowner test
the new database 'test' belongs to dbowner but all tables are still
belonging to the user who owns the template templateName. This
On Monday 27 March 2006 13:57, Jim C. Nasby wrote:
BTW, you might also find inheritance to be of use:
http://www.postgresql.org/docs/8.1/interactive/ddl-inherit.html
I'm not sure inheritance will help here or not. I need to aggregate all the
sub tables and add a field whose value depends on
On Monday 27 March 2006 12:13, Martijn van Oosterhout wrote:
You're using UNION rather than UNION ALL where. There's a big
difference and I imagine you actually want the latter. It also makes a
big difference in query optimisation.
If that doesn't fix it, come back with the EXPLAIN ANALYZE
On Tue, Mar 28, 2006 at 09:45:02AM +0100, Ashley Moran wrote:
On Monday 27 March 2006 12:13, Martijn van Oosterhout wrote:
You're using UNION rather than UNION ALL where. There's a big
difference and I imagine you actually want the latter. It also makes a
big difference in query
On Tuesday 28 March 2006 10:05, Martijn van Oosterhout wrote:
That's because it's decribed in the SQL standard. UNION ALL just joins
the results of the two queries. UNION removes duplicates which usually
means sorting and comparing the tuples. UNION ALL is faster and usually
what you want
hi all
please tell if it is possible to
Run your 32-bit applications against the 64-bit installed postgres
server.
I am using postgres 8.0.0 and for building my application i use the 32 bit
postgres server.
However those application will be running with the 64-bit installed postgres
server.
OK, thx...
27. března 2006, 14:51:26, napsal jste:
JCN On Sun, Mar 26, 2006 at 08:30:44PM +0200, David Hoksza wrote:
Hi, I would like to know, when ambulkdelete is run. I thought that
when tuple is deleted so bulkdelete is run, but when I set breakpoint
to
Hi,
I'm trying to figure out the best way to handle the following situation.
There are two processes, A, and B.
A is a daemon process that performs a select, and then slowly iterates
over the results, performing updates along the way.
It is possible that interactive process B comes along, and
Hello Folks,
I would like to know if deleting functions from pg_catalog.pg_proc with
the following SQL statement is advisable?
I would like a way of deleting my functions without using the DROP
FUNCTION statement.
--
delete from
Thank you ver much for you responase.
Yes, I had to change the client encoding for Postgres 8.1 (I had
forgotten) to Latin1 because of a client encoding mismatch error while
using the ODBC drivers on Windows. Stupid of me. Sorry for the bother -
I changed the client encoding to UTF8 and it
Having successfully got pg 8.1.3 to run, I'm simply trying to pg_restore
a dump from our live server. However, even very soon into the restore, I
get these messages from the autovacuum daemon once per minute:
2006-03-28 14:15:35 BSTLOG: autovacuum: processing database laterooms
Jebus scrisse in data 03/27/06 19:03:
I could be wrong but primary keys and other constraints are not inherited.
do you know if
this problem is solved in postgres 8.1?
No it isn't. But I remember reading on one of the lists that it was on the
to-do list for 8.2.
However, I do not know
On Tue, Mar 28, 2006 at 02:58:45PM +0200, Gevik Babakhani wrote:
Hello Folks,
I would like to know if deleting functions from pg_catalog.pg_proc with
the following SQL statement is advisable?
Offhand I think you're going to run into problem like the dependancies
not being removed which could
On Tue, 2006-03-28 at 14:56 +0200, David Welton wrote:
There are two processes, A, and B.
A is a daemon process that performs a select, and then slowly iterates
over the results, performing updates along the way.
It is possible that interactive process B comes along, and wants to
change
Try breaking down the A query with LIMIT/OFFSET so that it never holds
locks for long. That way B will not wait for long, if at all, and will
not fail.
Just as a remark, this will only work if the chunks can be processed in
separate transactions. If the whole thing is related and A must be
On 3/28/06, Alex Turner [EMAIL PROTECTED] wrote:
The solution that I have seen typical is to have both webserver and database
machine behind a firewall both NATed, with only HTTP and HTTPS ports open on
the webserver. SSH is not open, as trusted clients connect via the VPN in
the firewall.
Michael Talbot-Wilson wrote:
How, really, do people pronounce PostgreSQL?
http://www.serioustechnology.com/postgres.ogg
Or for those of you who have an inferior operating system:
http://www.serioustechnology.com/postgres.wav
--
Until later, Geoffrey
Any society that would give up a little
[ Oops, I missed the reply-to button the first time - sorry for the
repeat, Csaba ]
On 3/28/06, Csaba Nagy [EMAIL PROTECTED] wrote:
Try breaking down the A query with LIMIT/OFFSET so that it never holds
locks for long. That way B will not wait for long, if at all, and will
not fail.
Just
On Mon, 27 Mar 2006 07:31:36 -0600, Jim C. Nasby wrote:
On Mon, Mar 27, 2006 at 05:22:40PM +0400, Ivan Zolotukhin wrote:
Hello,
Does anybody know good comparison/review article of XML support in major
RDMBSes? I know that PostgreSQL's XML capabilities are quite weak, but
how far is it from
Tom
Dont think its large file support, I'm running on FC4, the problem existed on
FC1 too.
I'll try the custom format and see if that helps. Thanks for the
recommendation.
-bill
On Mon, March 27, 2006 4:35 pm, Tom Lane said:
beer [EMAIL PROTECTED] writes:
We have a medium sized database
Gavin Hamill wrote:
Having successfully got pg 8.1.3 to run, I'm simply trying to pg_restore
a dump from our live server. However, even very soon into the restore, I
get these messages from the autovacuum daemon once per minute:
[...]
2006-03-28 14:15:35 BSTERROR: out of memory
2006-03-28
Dick Kniep [EMAIL PROTECTED] writes:
Now when I try to access the tables/views in the schema as a user that
is NOT a member of the group adeuxproductie, I expect it to
fail. However, access is granted as if there is no authorization
specified.
Perhaps you tested this as a superuser? For
Richard Broersma Jr scrisse in data 03/28/06 15:18:
No it isn't. But I remember reading on one of the lists that it was on the to-do list for 8.2.
However, I do not know how high it is on the list of things to do. So I imagine that there is the
potential that it might not be added.
I'll
On Mar 28, 2006, at 4:47 AM, surabhi.ahuja wrote:However those application will be running with the 64-bit installed postgres server.They speak to each other via TCP/IP protocol which is CPU independent. so yes, it will work (and does work).
Gavin Hamill [EMAIL PROTECTED] writes:
Having successfully got pg 8.1.3 to run, I'm simply trying to pg_restore
a dump from our live server. However, even very soon into the restore, I
get these messages from the autovacuum daemon once per minute:
2006-03-28 14:15:35 BSTERROR: out of memory
On Mon, 2006-03-27 at 11:04, Stefan Fink wrote:
Hi all,
I would like to create a database based upon a template which also
contains some tables. After invoking
psql -T templateName -U dbuser -O dbowner test
the new database 'test' belongs to dbowner but all tables are still
belonging
On Tue, 28 Mar 2006 12:14:28 +1000 Klint Gore [EMAIL PROTECTED] wrote:
On Tue, 28 Mar 2006 10:10:15 +0930 (CST), Michael Talbot-Wilson [EMAIL
PROTECTED] wrote:
How, really, do people pronounce PostgreSQL?
we just use postgres.
Post Gress is what I've heard also.
They say that SQL
On Sunday March 26 2006 9:14 am, Tom Lane wrote:
Ed L. [EMAIL PROTECTED] writes:
With our set of 4 DBs, that amounts to once every 40 minutes
for the given database. I see LOG: autovacuum: processing
database xyz in the log, but I do not see any
analyze/vacuum commands being issued at
On Sat, 2006-25-03 at 10:11 -0800, Chris Travers wrote:
Leif Jensen wrote:
Hello,
I have with great interrest been following this thread. We have a
(small) flame war in house about this and I'm very happy about all the
arguments I have seen. I'm a long time user of PostgreSQL (which
Many of my tables have a timestamp column, which I store as
TIMESTAMP WITH TIME ZONE. Often I only want to return the date from
this field, and it may need a specific format.
All of the queries are passed through PLpqsql functions that return
either a record or a set of records. I find if I
ANSI has declared that the official pronunciation for SQL is /ɛs kjuː ɛl/
Klint Gore wrote:
Who's they? The only datbase vendor I've heard call their own product
sequel is MS.
SEQUEL (pronounced sequel) was a predecessor to SQL in IBM's 1970's
System R database; but isn't really the same
This is going to be an amateur question...
Could somebody explain me, or point me to a resource where I can find
out what is the recommended practice when a live db needs to be replaced
with a new version of it that has a slightly different structure?
My first guess would be to create the
[EMAIL PROTECTED] writes:
but that syntax doesn't work. I thought I might be able to create
my own type, and have an implicit conversion of DATE,
You can *make* an implicit cast from (or to) DATE, but there won't be
one made for you.
regards, tom lane
SunWuKing.
Could somebody explain me, or point me to a resource where I can find
out what is the recommended practice when a live db needs to be replaced
with a new version of it that has a slightly different structure?
Put the new database on a development machine.
Do a dump of the old
On Tue, Mar 28, 2006 at 03:34:18PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] writes:
but that syntax doesn't work. I thought I might be able to create
my own type, and have an implicit conversion of DATE,
You can *make* an implicit cast from (or to) DATE, but there won't be
one made for
Does anybody know good comparison/review article of XML support in
major RDMBSes? I know that PostgreSQL's XML capabilities are quite
weak, but how far is it from other products?
Could you please desribe a specific example of what you would like to
do and how you would not be able to do that
On Mon, Mar 27, 2006 at 10:03:27AM -0800, Leon Pu wrote:
do you mean PostgreSQL 7.3 is supported by RedHat on Advanced Server
2.1?
I only found PostgreSQL 7.1.3's rpms for RedHat Advanced Server 2.1, no
newer version anymore.
Tom has mentioned in the past that he's been backpatching stuff
On Tue, 2006-03-28 at 13:14, Jim C. Nasby wrote:
On Mon, Mar 27, 2006 at 10:03:27AM -0800, Leon Pu wrote:
do you mean PostgreSQL 7.3 is supported by RedHat on Advanced Server
2.1?
I only found PostgreSQL 7.1.3's rpms for RedHat Advanced Server 2.1, no
newer version anymore.
Tom has
Scott Marlowe [EMAIL PROTECTED] writes:
On Tue, 2006-03-28 at 13:14, Jim C. Nasby wrote:
Tom has mentioned in the past that he's been backpatching stuff to 7.3
as part of his job, so I would assume that RH will support any 7.3
version.
But only for supported OSes. I'm pretty sure 2.1 is
On Tue, Mar 28, 2006 at 09:28:12PM +0200, SunWuKung wrote:
This is going to be an amateur question...
Could somebody explain me, or point me to a resource where I can find
out what is the recommended practice when a live db needs to be replaced
with a new version of it that has a slightly
[EMAIL PROTECTED] writes:
Yes, that's what I'm looking for. How can I create an IMPLICIT
cast from date to my custom type? IOW, if I assing a date to a
varible of my type, it will be converted to the format I specify.
Make a function that does the conversion the way you want, and then
create
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
On Tue, Mar 28, 2006 at 09:28:12PM +0200, SunWuKung wrote:
This is going to be an amateur question...
Could somebody explain me, or point me to a resource where I can find
out what is the recommended practice when a live db needs
On Wed, Mar 29, 2006 at 12:24:04AM +0200, SunWuKung wrote:
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
On Tue, Mar 28, 2006 at 09:28:12PM +0200, SunWuKung wrote:
This is going to be an amateur question...
Could somebody explain me, or point me to a resource where I can
On Tue, 2006-03-28 at 16:24, SunWuKung wrote:
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
On Tue, Mar 28, 2006 at 09:28:12PM +0200, SunWuKung wrote:
This is going to be an amateur question...
Could somebody explain me, or point me to a resource where I can find
out
Hi,
I was testing MySQL and PgSQL performances on my home box (amd athlon
64 3000, 1gig ddr ram, sata I hdd, win xp (x86)), select and insert
times seeemed identical with innoDB.
But when i try to query both using php, there's a huge difference even
for a funny query like select 1
Here's the
On Tue, Mar 28, 2006 at 05:01:45PM -0800, Antimon wrote:
$pdo = new PDO('pgsql:host=localhost;dbname=test', testacc, pw);
for ($i = 0; $i 1; $i++)
{
$result = $pdo-query(Select +$i);
}
output is:
2.7696590423584
Ok, so that tells me that on this plain-vanilla hardware, you can
Try factoring the connect time out of the test. My experience is the
connect is more expensive for Postgres than MySQL. With that out of the
way, I'd wager the times will be closer.
Regards,
Paul
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Antimon
On Tue, 2006-03-28 at 19:01, Antimon wrote:
Hi,
I was testing MySQL and PgSQL performances on my home box (amd athlon
64 3000, 1gig ddr ram, sata I hdd, win xp (x86)), select and insert
times seeemed identical with innoDB.
But when i try to query both using php, there's a huge difference
On Tuesday 28 March 2006 17:31, Jim C. Nasby wrote:
On Wed, Mar 29, 2006 at 12:24:04AM +0200, SunWuKung wrote:
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
On Tue, Mar 28, 2006 at 09:28:12PM +0200, SunWuKung wrote:
This is going to be an amateur question...
Could somebody
Hi All,
All of our application now runs on postgresql7.4.xxx servers, I never
tried it on version 8.xxx
I wonder if there are any guidelines / step by step / special
considerations whether it applies to database structure or the
application it self if we want to upgrade to version 8.xxx ?
Luki Rustianto wrote:
Hi All,
All of our application now runs on postgresql7.4.xxx servers, I never
tried it on version 8.xxx
I wonder if there are any guidelines / step by step / special
considerations whether it applies to database structure or the
application it self if we want to upgrade
Hi,
I'm wanting to build a database and interface for a small business to
keep track of things such as clients, suppliers etc. The database will
be served on a Linux box, with users accessing/updating it over the
network from both Linux and windows.
I'm wondering if I could get some
Rory Hart wrote:
Hi,
I'm wanting to build a database and interface for a small business to
keep track of things such as clients, suppliers etc. The database will
be served on a Linux box, with users accessing/updating it over the
network from both Linux and windows.
I'm wondering if I
Chris wrote:
Rory Hart wrote:
Hi,
I'm wanting to build a database and interface for a small business to
keep track of things such as clients, suppliers etc. The database
will be served on a Linux box, with users accessing/updating it over
the network from both Linux and windows.
I'm
Rory Hart wrote:
Chris wrote:
Rory Hart wrote:
Hi,
I'm wanting to build a database and interface for a small business to
keep track of things such as clients, suppliers etc. The database
will be served on a Linux box, with users accessing/updating it over
the network from both Linux and
Chris wrote:
Of course. Shameless plug coming up ;)
http://www.designmagick.com/category/2/Starting-Out
Thanks ^_^
--
Rory Hart
Lifestyle Management Consultant
Professional Lifestyle Management
http://www.lifestylemanage.com
Phone 03 9879 5643 PO Box 4179
Fax03 9879
thank!
---(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
Chris Travers [EMAIL PROTECTED] writes:
Luki Rustianto wrote:
I wonder if there are any guidelines / step by step / special
considerations whether it applies to database structure or the
application it self if we want to upgrade to version 8.xxx ?
Depends on if your app depends on the
Hi,
I have the need to encrypt some columns in some tables. With Postgres 7.4,
using a tablespace on an encrypted partition is not an option, right?
Furthermore, the content would be contained unencrypted in any database
dump.
Thus, my idea is:
- put the encryption/decryption key in a temporary
59 matches
Mail list logo