On Tue, 2008-02-05 at 12:11 -0500, Tom Lane wrote:
Csaba Nagy [EMAIL PROTECTED] writes:
I found an old post regarding the subject, where modifying the
pg_constraint entry was recommended:
http://archives.postgresql.org/pgsql-admin/2003-04/msg00339.php
Is this still safe to do ?
Dear Brothers, Sisters, and Friends,
Peace!
We would like to invite you to a dinner this Friday (02/08/2008) to
celebrate our Chinese New Year.
The dinner will start at 6:30PM. Please send your RSVP to me by end of
Wednesday, so that we can reserve table and place pre-orders.
Here is the
Hi,
I've would find it useful if check constraints and unique constraints
would give a value which is violating the constraint.
Foreign keys give a value that is failing for the foreign key, is there
a reason that other constraints don't do the same thing?
example psql session from
Am Dienstag, 5. Februar 2008 schrieb Pepe Barbe:
I am interested in deploying PG 8.3.0 on one of our in-house appliance
product that is managed using RPMs and openSuse. Will there be RPMs
for Suse from PostgreSQL or should I wait until Suse releases their
own RPMs?
The plan is to get
Peter Eisentraut escribió:
Am Dienstag, 5. Februar 2008 schrieb Pepe Barbe:
I am interested in deploying PG 8.3.0 on one of our in-house appliance
product that is managed using RPMs and openSuse. Will there be RPMs
for Suse from PostgreSQL or should I wait until Suse releases their
Hello dudes!!!
I would like to know where can i find pl/java tutorials or books.
Thanks.
--
View this message in context:
http://www.nabble.com/pl-java-tutorials-tp15306636p15306636.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---(end
[EMAIL PROTECTED] wrote:
Thanks for the reply. Unfortunately, the project I'm working is trying to provide database-as-a-service functionality, so I can't really tune the DB since the application/load will vary by customer (and the whole idea was to abstract all the low-level tuning parameters
Am 2008-01-31 12:03:00, schrieb Andre Nieder:
Hello,
we like to use PostgreSQL in an embedded system that runs - don't laugh
- on a compact flash.
I have this too...
Therefore we need to know how often PostgreSQL will write to the disc.
PostgreSQL in a normal installation of, e.g. a
On Feb 5, 2008, at 11:02 PM, Guy Rouillier wrote:
Greg Smith wrote:
On Mon, 4 Feb 2008, Dave Page wrote:
We intentionally have not done that as we wanted to ensure that all
documentation published under postgresql.org was appropriately
moderated first.
OK, so hosting a probably inaccurate in
On Feb 5, 2008, at 11:02 PM, Guy Rouillier wrote:
Greg Smith wrote:
On Mon, 4 Feb 2008, Dave Page wrote:
We intentionally have not done that as we wanted to ensure that all
documentation published under postgresql.org was appropriately
moderated first.
OK, so hosting a probably inaccurate
On Tue, 5 Feb 2008 23:07:37 -0500 (EST)
Greg Smith [EMAIL PROTECTED] wrote:
Can anyone think of another place a community docs wiki could go at?
I don't have any good web hosting facilities here right now. I just
took a look at buying a cheap host somewhere, but I feel it would be
Csaba Nagy [EMAIL PROTECTED] writes:
On Tue, 2008-02-05 at 12:11 -0500, Tom Lane wrote:
Csaba Nagy [EMAIL PROTECTED] writes:
Is this still safe to do ?
What kind of constraint?
The only ones left are foreign key constraints. I had a few not nulls
too, but those are not actually there
On Wed, 2008-02-06 at 11:03 -0500, Tom Lane wrote:
IIRC, the name of an FK constraint also appears in the arguments for its
triggers. If you didn't update those too, the behavior might be a bit
inconsistent, depending on which PG version you're using. In particular
I'm not sure which name
On Fri, 1 Feb 2008 20:16:50 -0500 (EST)
Greg Smith [EMAIL PROTECTED] wrote:
I think the market for a PostgreSQL book is limited by a few things:
1) There just aren't that many potential buyers (yet!)
As someone who *still* gets royalty checks for his 6 year old book, I
disagree.
2) The
Joshua D. Drake wrote:
On Tue, 5 Feb 2008 23:07:37 -0500 (EST)
Greg Smith [EMAIL PROTECTED] wrote:
Can anyone think of another place a community docs wiki could go at?
I don't have any good web hosting facilities here right now. I just
took a look at buying a cheap host somewhere, but I
Unfortunately there isn't a current version of Joshua Drake's book out
there (which I do own along with PostgreSQL Essential Reference by
Stinson), so alternatively, can anyone recommend a good DBA book
outlining best practices, physical design, etc? I would like something
that is relevant to
Joe Celko's SQL Programming Style is a good not vendor-specific book.
As for PostgreSQL-specific books, I can only speak for one I read before:
Bruce Momjian's PostgreSQL: Introduction and Concepts. It is a good
introductionary book, although it isn't based on PostgreSQL 8 series.
On 2/6/08, Ron
Olexandr Melnyk wrote:
Joe Celko's SQL Programming Style is a good not vendor-specific book.
As for PostgreSQL-specific books, I can only speak for one I read
before: Bruce Momjian's PostgreSQL: Introduction and Concepts. It is
a good introductionary book, although
it isn't based on
Olexandr Melnyk wrote:
Joe Celko's SQL Programming Style is a good not vendor-specific book.
And maybe a bit too Developer/User-ish but very good his SQL for Smarties.
Rod
--
As for PostgreSQL-specific books, I can only speak for one I read
before: Bruce Momjian's PostgreSQL: Introduction
Can anybody give us more detailed explanation about RETURN QUERY
syntax and usage with possible some non trivial samples.
Thanks in advance.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
Hello everybody.
I've written a script (see attachment) which creates operators
@ - ascending ordering
@ - descending ordering
that allows you to replace code like this
if condition1 then
for
select fields
from tables
where restrictions
order by
field1
I am attempting to install the Fossology http://fossology.org/ OSS license
analysis software on a server running Ubuntu Linux and PostgreSQL. I have
gotten to the point where I am at the final install command, and I get an
error on a dbcheck program that says:
# Checking database connectivity
Kurt Schroeder wrote:
I am attempting to install the Fossology http://fossology.org/ OSS license
analysis software on a server running Ubuntu Linux and PostgreSQL. I have
gotten to the point where I am at the final install command, and I get an
error on a dbcheck program that says:
# Checking
On Feb 6, 2008, at 11:54 AM, Ron St-Pierre wrote:
Unfortunately there isn't a current version of Joshua Drake's book
out there (which I do own along with PostgreSQL Essential Reference
by Stinson), so alternatively, can anyone recommend a good DBA book
outlining best practices, physical
Yes, I can:
[EMAIL PROTECTED]:/home/sandy# psql -d fossology -U fossy
Password for user fossy:
Welcome to psql 8.1.10, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate
Kurt Schroeder [EMAIL PROTECTED] writes:
On Feb 6, 2008 2:18 PM, brian [EMAIL PROTECTED] wrote:
Can you connect to the database with psql?
Yes, I can:
[EMAIL PROTECTED]:/home/sandy# psql -d fossology -U fossy
But does it work with -h localhost, which is also implied by your
connection
Kurt Schroeder wrote:
Yes, I can:
[EMAIL PROTECTED]:/home/sandy# psql -d fossology -U fossy
Password for user fossy:
Welcome to psql 8.1.10, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
Russell Smith [EMAIL PROTECTED] writes:
I've would find it useful if check constraints and unique constraints
would give a value which is violating the constraint.
Foreign keys give a value that is failing for the foreign key, is there
a reason that other constraints don't do the same
On Feb 6, 2008 2:48 PM, Erik Jones [EMAIL PROTECTED] wrote:
I like The Art of SQL by Stephane Faroult (http://www.amazon.com/Art-
SQL-eacute-phane-Faroult/dp/0596008945/ref=pd_bbs_sr_1?
ie=UTF8s=booksqid=1202330868sr=1-1). It's a fairly in depth book
that covers many different advanced design
On 05/02/2008, Scott Marlowe [EMAIL PROTECTED] wrote:
And a more generic version :}
88888888
#!/bin/bash
# split.sh: a shell script and wrapper for some (g)awk to extract a single
#database out of a dumpall file
30 matches
Mail list logo