it supposed to create an
INDEX? If so, you will need to create the indexes (not including the
PRIMARY KEY) after you create the table.
And just a quick editor view, you spelled description incorrectly in
product_descrition and your product_id is your primary key so you don't
have to set it NOT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 20 Mar 2008 16:51:57 +1300
"Brent Wood" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm interested in finding what would be involved on enhancing
> Postgres to allow queries run in one database in a cluster to access
> & join with tables in othe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 19 Mar 2008 16:40:30 -1000
"Tri Quach" <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am not sure which RHEL is on my server.
>
> [EMAIL PROTECTED] pq8.2.6]# uname -a
> Linux lyris3.k12.hi.us 2.4.21-20.EL #1 SMP Wed Aug 18 20:34:58 EDT
> 2004
rpm. I got error
> rpmbuild: command not found.
up2date install rpm-build I think.
> rpmbuild --rebuild --define 'buildrhel3 1'
> postgresql-8.2.6-1PGDG.f8.src.rpm
However... you are missing a great deal more than rpmbuild if you think
you are going to build 8.2.6 on RHEL3.
J
/ Talk: http://www.sun.com/
Talk: http://www.afilias.info
Talk: http://www.xtuple.com/
Food: http://www.otg-nc.com/
General: http://www.myemma.com/
Facilities: http://www.umd.edu/
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 17 Mar 2008 09:26:35 -0500
Erik Jones <[EMAIL PROTECTED]> wrote:
> > While I agree companies are likely to get annoyed - just like fast
> > food companies do when you say how much trans-fats their products
> > contain; I'm rather curious what
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 14 Mar 2008 02:00:39 -0600
Micah Yoder <[EMAIL PROTECTED]> wrote:
> Maybe it's nuts to consider such a setup (and if you're talking a
> major bank it probably is) ... and maybe not. At this point it's
> kind of a mental exercise. :-)
If you
t really annoyed if you do that when they
> didn't give you permission. This has actually happened, where
> someone has asked to be removed from the list of those using
> PostgreSQL.
Yes it has.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http
rse, we don't :) but then again that's why you don't
see our name attached to large rollouts (even though you can see large
rollouts attached to us.)
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conferenc
omething else as they're crap at raid 10.
>
> Use an actual LSI branded card instead of the Dell "improved" version.
>
+1
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlc
On Wed, 12 Mar 2008 21:30:57 -0700
"Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> You might want to keep this one on the list. I'm out of my league
> with this one I think
Can you pg_dump the database? What about vacuum? What does:
SELECT * FROM pg_database; Return?
J
>
> On Wed, Mar 12, 2008
t; > quickly from the community release of MySQL scared me.
>
> MySQL has incentives to _not_ make their community release
> production-quality.
>
This thread is making my talk at MySQLCon very interesting.
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.comm
ly driving the growth
of our "Community" which encompasses but is not anywhere near limited
to PostgreSQL.org and yet has everything to do with, "PostgreSQL"
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Co
reSQL.org doesn't do the community
or the project itself justice.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.or
hat the ITPUG folks, who for the most part do not participate
on these lists aren't part of our community?
Or perhaps you are saying that the very hard work by Elein via the old
Bits days are not part of the community just because it doesn't have
PostgreSQL.org address.
Tom with the utmos
pill
Lewis, all you have to do is this:
Log in to blogger.
Select Settings
Select Site Feed
Change Allow Blog Feeds to short
Problem solved.
You owe me a beer. I didn't have a blogger account until this argument.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 19
Well, it's obviously never
> been an issue before.
Robert has rights as do I but Devrim is by far the BDFL on this.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlco
sql-www, and Devrim has been pretty consistent
> in raising issues there before taking action. I don't know why he
> didn't this time; I've posted to pgsql-www inquiring.
Josh I invite you to see my reply on this.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 19
m isn't the length of your post as a blog. It's that you
aren't following headline rules.
Look here:
http://www.commandprompt.com/blogs/
You will see short headlines of the blog, that is the part that is
supposed to show up at planet. Not the whole blog.
Sincerely,
Joshua D. Dra
#x27;DB_PERSISTENCY', 'true');". Thanks
> for pointing me in the right direction.
That is what we are here for :). Glad we could help.
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.
er of allowed connections and not worry
> about apache holding sessions open even after the "client"
> has long gone?
It depends on how you are connecting. For example if you are doing this:
PDO::ATTR_PERSISTENT => true
Then... yeah :). You really shouldn't use a language
onsor
Emma http://www.myemma.com/
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Li
ays use
more).
http://www.postgresql.org/about/servers
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/don
the goals for 8.3 and the integrated tsearch was to remove
exactly this problem.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://w
On Sat, 1 Mar 2008 03:27:50 -
"Shane Wright" <[EMAIL PROTECTED]> wrote:
>
> The RPMs installed from are these:
>
> postgresql-8.3.0-1PGDG.rhel4
> postgresql-libs-8.3.0-1PGDG.rhel4
> postgresql-server-8.3.0-1PGDG.rhel4
You need postgresql-debug (
class support is
a non starter. That is what the companies surrounding the community
are for. If companies want the community and not the companies
surrounding the community to provide that kind of support, those
companies need to start paying for it.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Co
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 22 Feb 2008 16:49:10 -0500
"Kynn Jones" <[EMAIL PROTECTED]> wrote:
> Hi!
> Does PostgreSQL expose its hash function? I need a fast way to hash a
> string to a short code using characters in the set [A-Za-z0-9_].
> (I'm not sure yet how long t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 21 Feb 2008 19:49:29 -0500
"Alex Turner" <[EMAIL PROTECTED]> wrote:
> Yeah - I pressed tab to indent my code, and of course it tabbed to the
> next element on the page, which was the send button, then I hit a key,
> and it sent the message bef
(
No that would fail.
Did you forget the rest of your message? :)
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/d
On Fri, 15 Feb 2008 11:59:19 +0800
hewei <[EMAIL PROTECTED]> wrote:
> Can send email from stored procedure in Postgres?
Sure, see plperl.
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconfe
://www.continuent.org/
OTG: http://www.otg-nc.com/
Sun: http://www.sun.com/
Xtuple: http://www.xtuple.com/
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http
alk to the guys and see which
machine this needs to go on and I will get back with you.
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://ww
jor release. 8.3.1 would be a minor release.
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | S
On Fri, 8 Feb 2008 21:48:39 -0300
Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Hmm, did this go anywhere? I still look for the shiny new Pg polos on
> the mail every day, only to be disappointed.
>
Yes, they will be part of the larger run of shirts we do after SCALE.
Joshua D.
lity is for the majority of intro topics even the 6 year
old book is more than relevant. Where Practical falls down is talking
about things like background writer or vacuum. Those particular topics
are covered ad-naseum in the docs.
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.
t I feel it would be
> inappropriate to host a PostgreSQL documentation wiki on a shared
> host where the underlying database was *censored*.
>
CMD will host anything you need.
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreS
; PostgreSQL packaging @ SuSE.
>
> You are welcome to switch to Fedora/RHEL/CentOS btw ;)
Or a real linux like Ubuntu/Debian.
Joshua D. Drake
>
> Regards,
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconfere
ns in a corner where not everyone is subscribed. That's what
> happened recently on another topic and it seems to be what's
> happening now with this certification stuff.
Sincerely,
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
Postgre
o new
> topics as well as having already seen the solutions to issues well
> before I've encountered them.
>
Right, I believe that is a valid argument. I think the real
problem is that as a community we are not diligent in pushing people to
the contextually specific lists we alr
d you are not one of those.
Please let us be productive now.
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI L
On Mon, 04 Feb 2008 12:18:55 +
Gregory Stark <[EMAIL PROTECTED]> wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>
> > Guys, with respect this thread does nothing for us unless it is on
> > the certification list.
>
> Do we really need
tifying individuals.
>
> Microsoft seems to have something like that for their
> partners in their "Database Management competency"
> https://partner.microsoft.com/global/40012911
>
Guys, with respect this thread does nothing for us unless it is on the
certificat
the true spirit of OpenSource *BECAUSE* of what you list
> as a bonus of it ... the locking down of benefits reaped from
> OpenSource not getting back into the stream.
RMS wouldn't make any such argument at all. His argument would be
centered around FREE not OpenSource software.
Joshua D.
ents.
Unless you don't have access to /var/log (on linux) but do have access
to postgresql logs.
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project
they are
provided.
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 6: explain analyze is your friend
y)
>
> Why is this something to apologize for?
I think he was apologizing to himself. After that much self inflicted
pain, the inner psyche has to start to revolt.
:P
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http:
ies.
> * Non-availability of required assistance for PostgreSql hosting:
> Assistance is being provided via mailing lists. However there is no
> guarantee that the issue faced during PostgreSql hosting would be
> resolved.
Say what?
http://www.postgresql.org/support/professional_support
spoken with SRA or the Venezualan folks but am more than
happy to have them involved.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Pr
information please visit:
http://www.postgresqlcertification.org/
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
e looks hard at Tom Hart...
"Yep, looks like a volunteer to me" said Bob.
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql
s the docs, which personally I
> like).
The above sounds like you want a cookbook not a manual. In proper
open source fashion perhaps you could start documenting the things you
learn and post them to Techdocs :)
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, ht
h is bad for me (but I'll have to wait until the schedule
and costs are posted before I'll know for sure).
There is always PGday in July and August, plus West in October.
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 3:
ly sure where that is.
I thought last year was the year David started maintaining himself?
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.po
at all honestly. At least not by looking at
the queue of proposed talks we have.
Anyway my suggestion to Sim is to read about each conference on the
respective conference websites:
http://www.postgresqlconference.org/why/
http://www.pgcon.org/2008/
Sincerely,
Joshua D. Drake
- --
The Postgre
ubt I would ever publish through a
traditional house those. Something more along the lines of Lulu where
the book can give the most use to the community.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7
y and in a lot of
ways counter-intuitive (to a newbie) but if you have the terminology
down you aren't going to find a more comprehensive text.
Plus, when you find things that don't quite make sense you can submit
a doc patch to make the docs that much better.
Sincerely,
PostgreSQL 8.3 RC2 is now available
The community testing of RC1 has yielded positive results. We avoided
several nasty bugs and are now releasing 8.3 RC2. We need the entire
community to continue testing to help us get to the final release.
Please report your bugs before the end of the month! .
: http://www.sun.com
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'C
and they aren't the
same thing. I don't have a solution for that one.
I think adding help to the psql prompt is a very sane way to help
people. It is human.
Sincerely,
Joshua D. Drake
>
> Have a nice day,
- --
The PostgreSQL Company: Since 1997, http://www.commandprom
o
> write a quick patch...
+1
Joshua D. Drake
signature.asc
Description: PGP signature
ver product.
> 4 - I do want a good install structure and decent compile options that
> suites my target production platform (AMD64 on ubuntu 7.04).
>
Then I suggest you use what the debian packager provides you. Check
backports.
Sincerely,
Joshua D. Drake
signature.asc
Description: PGP signature
an tell you that in
terms of Oracle we are pretty far behind (plpgsql vs plsql).
Sincerely,
Joshua D. Drake
signature.asc
Description: PGP signature
s been deprecated for quite some time
> now. I suggest looking for a newer version of PgAccess...
IIRC PgAccess is long dead. They really need to move to PgAdmin or
OOBase or something like that.
Joshua D. Drake
>
> regards, tom lane
>
have long pushed to SAS on that scale.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training&#x
> connection?
>
> Well, as everyone knows, Pennsylvania is a haven for brilliant
> people. In fact, simply living in Pennsylvania makes you smarter.
Then why did Ben Frankly attach a key to a kite in the middle of a
thunderstorm?
Joshua D. Drake
- --
The PostgreSQL Company: S
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 16 Jan 2008 13:23:35 -0800 (PST)
dvanatta <[EMAIL PROTECTED]> wrote:
>
> What's up with 3 of the 7 being from Pennsylvania? What's the
> connection?
Its the closest the cult of the elephant will get to jersey.
Jos
7;m asking because I was always told EnterpriseDB employs now 5 out
> of 7 core committers.
What? They do employ more contributors than that (oh and just because
they are core doesn't mean they have commit rights).
They employ Dave Page and Bruce Momjian who are core members.
They also employ G
Alvaro Herrera wrote:
Joshua D. Drake wrote:
dvanatta wrote:
How much does Sun currently contribute to the project? Do they have
designated coders?
They employ a core member who is not a hacker.
They provide some machines etc..
They contributed a DTrace patch and the Sun hackers can be
dvanatta wrote:
How much does Sun currently contribute to the project? Do they have
designated coders?
They employ a core member who is not a hacker.
They provide some machines etc..
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 1
ave
official packages etc..
Sincerely,
Joshua D. Drake
---(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
Russ Brown wrote:
http://blogs.mysql.com/kaj/sun-acquires-mysql.html/
What does this mean for Sun's support of Postgres?
Does it matter? :) I am sure OmniTI and Command Prompt will be
happy to help any disgruntled customer :)
Sincerely,
Joshua D. Drake
---(e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 16 Jan 2008 00:29:16 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > If we are sure that this issue is apparent actual row insertion it
> > should be easy to
. All volumes show
online.
If we are sure that this issue is apparent actual row insertion it
should be easy to duplicate. I will do some testing on my box which is
similar. I have 2gig of ram, dual core and a raid 1 with SATA drives.
Sincerely,
Joshua D. Drake
will improve as well.
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 16 Jan 2008 01:12:07 +0100
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Among Drupal developer there is such kind of discussion over and over
> recently:
>
> http://drupal4hu.com/node/64
I commented here.
> I'd ask to all th
Group: http://www.otg-inc.com
Sun: http://www.sun.com/
Remember all registrations are direct donations to the PostgreSQL
Community!
Sincerely,
Joshua D. Drake
PostgreSQL Conference Organizer
PostgreSQL SPI Liaison
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Su
7;t suggest having more than a
1000 open at any given time though. Also take a look at connection
pooling.
> Are there some table where i can search it?
pg_stat_activity
> All users is connected in the database with postgres user.
>
Sincerely,
Joshua D. Drake
houghts, help?
select * from information_schema.columns?
table_catalog| information_schema.sql_identifier |
table_schema | information_schema.sql_identifier |
table_name | information_schema.sql_identifier |
column_name | information_schema
beta1
Sincerely,
Joshua D. Drake
--
Mark Walker
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
y a, process the result and send the answer to b.
There is a PostgreSQL project explicitly for this type of thing...
dbi-link: http://pgfoundry.org/projects/dbi-link/
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 9: In versions below 8.0,
table_catalog=? AND table_schema=? AND table_name=?
ORDER BY ordinal_position
I need this to lookup the column names and their ordinal position for a
given table (implementing a driver call).
Just curious... but why is ordinal position important here?
Joshua D. Drake
Thanks in advance,
Ken
ng idle in transaction, your vacuums are useless. You
need to fix your app.
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 09 Jan 2008 14:17:14 -0800
Jeff Davis <[EMAIL PROTECTED]> wrote:
> I posted to LKML here:
>
> http://kerneltrap.org/mailarchive/linux-kernel/2007/2/12/54202
>
> because linux has a behavior -- which in my opinion is a bug -- that
> causes t
is still there.
> Is there a way to get the count of the rows that *may be* there,
If you analyze regularly you can use pg_class. It isn't exact but is
usually close enough (especially if you are just using it for something
like pagination).
Joshua D. Drake
- --
The PostgreSQL Comp
find that if you are doing those items, you normally have a weird
design anyway.
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Ow Mun Heng wrote:
On Tue, 2008-01-08 at 23:16 -0800, Joshua D. Drake wrote:
Ow Mun Heng wrote:
On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote:
Another way of doing this, without dblink, is using an unsecured language
(plpython, for example) is to connect to the sql server using odbc and
Ow Mun Heng wrote:
On Tue, 2008-01-08 at 23:05 -0800, Joshua D. Drake wrote:
Sim Zacks wrote:
The reason companies go with the closed source, expensive solutions is
because they are better products.
Sometimes, sometimes not. It depends on your needs.
This is total FUD. Everything has a
both PG and MSSQL.
Perl or Python both would service this just fine or PHP (egads).
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
---(end of broa
Guido Neitzer wrote:
On 08.01.2008, at 23:40, Joshua D. Drake wrote:
There are OS level things you can do here.
They are normally not really easier and, more important, I don't have
them on my deployment environment.
http://www.continuent.org/HomePage
When I'm talking about
Sim Zacks wrote:
> That isn't really an extensibility argument. At least not in my mind.
> Further I don't know of anyone that can "easily" do it. You either
> suffer the possibility of catastrophic data loss (dolphins) or you
> suffer guaranteed bank account drainage (Oracle), or you suffer
Guido Neitzer wrote:
On 08.01.2008, at 23:20, Joshua D. Drake wrote:
That isn't really an extensibility argument.
I was thinking about that too - for me, it still is just an outstanding
issue with PostgreSQL. It is incredibly scalable on one machine but it
totally sucks when you want
Guido Neitzer wrote:
On 08.01.2008, at 17:36, Joshua D. Drake wrote:
2. What types of extensibility (possibly already available in
other DBMSs) are currently missing in PostgreSQL?
None that I am aware of.
Easy multi-master clustering with just two machines.
That isn't real
oice of PostgreSQL as a development
> platform based primarily on its extensibility features?
>
There is no other open source database that can compare with
PostgreSQL's extensibility, reliability and scalability.
Joshua D. Drake
> **
> E
Greg Smith wrote:
On Mon, 7 Jan 2008, Joshua D. Drake wrote:
Certainly and iptables gives you some flexibility in connection
availability "before" it hits the actual database but without having
to jimmy the production firewall.
4) Funky tricks with things like port forw
ind a
dedicated firewall.
Why not? Security in layers and all that. :)
Certainly and iptables gives you some flexibility in connection
availability "before" it hits the actual database but without having to
jimmy the production firewall.
Joshua D. Drake
---(e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 07 Jan 2008 20:25:45 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Scott Marlowe wrote:
> > On Jan 7, 2008 12:57 PM, Devrim GÜNDÜZ <[EMAIL PROTECTED]>
> > wrote:
> >> I want to announce PostgreSQL RPM Buildfarm today.
> >
> > This is very
hp is extremely rusty but I think you get the idea)
And then build out your where clause.
That seems to do what I want. Is it bad design? Something I'm missing
about indexing a NULL or something like that?
Sincerely,
Joshua D. Drake
-- Dante
to become corrupt?
Just curious...
Sincerely,
Joshua D. Drake
---(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
lect CURRENT_PID;
> 11682
>
> I want this so that I can log the psycopg2 connection pid, and kill it
> to test reconnection code.
postgres=# select procpid from pg_stat_activity;
procpid
- -----
30851
17510
4496
20237
1305
(5 rows)
Sincerely,
Joshua D. Drake
-
Glyn Astill wrote:
Where can I ask about pg/tcl?
What about it?
___
Support the World Aids Awareness campaign this month with Yahoo! For Good
http://uk.promotions.yahoo.com/forgood/
---(end of broadcast
801 - 900 of 2144 matches
Mail list logo
