On Thu, Nov 04, 2010 at 03:35:11PM -0700, Magnus Hagander wrote:
- On Thu, Nov 4, 2010 at 15:30, David Kerr wrote:
- > On Thu, Nov 04, 2010 at 02:07:29PM -0700, Magnus Hagander wrote:
- > - >
- > - > I'm trying to translate that to the old syntax of:
- > - >
I would say that if you pick any of the big four you will be fine.
CentOS
Ubuntu Server LTS
Red Hat
Suse
Debian can also be a good choice.
We used to be an OpenSuse shop but we are now moving everything to
Ubuntu Server LTS. I can not say enough good things about CentOS as far
as stability and long
On 11/9/2010 10:27 AM, Graham Leggett wrote:
This is covered by the GPL license. Once you have released code under
the GPL, all derivative code - ie upgrades - have to also be released
in source form, under the GPL license.
Sorry but this is 100% not true. It may be true for a 3rd party (you
In addition to the license a product is currently available under,
you need to also consider who owns its copyright; who owns
its test suite (which may not be open source at all); who
employs all the people who understand the code and who owns
the trademarks that identify the product.
Red Hat own
On 11/9/2010 10:45 AM, Andy wrote:
As a condition of getting European Commission's approval of its acquisition of
Sun/MySQL, Oracle had to agree to continue the GPL release.
In case anyone is interested in what specifically Oracle agreed to do,
this is the text
from the decision (they agreed
On 11/9/2010 11:10 AM, Sandeep Srinivasa wrote:
It was about the technical discussion on Highscalability - I have been
trying to wrap my head around the concept of multiple core scaling for
Postgres, especially beyond 8 core (like Scott's Magny Coeurs
example). My doubt arises from whether Pos
Also there's the strange and mysterious valley group-think syndrome.
I've seen this with several products/technologies over the years.
I suspect it comes from the VCs, but I'm not sure. The latest example
is "you should be using EC2". There always follows a discussion where
I can present 50 concr
On 11/9/2010 11:36 AM, Sandeep Srinivasa wrote:
If it is independent of the OS, then how does one go about tuning it.
Consider this - I get a 12 core server on which I want multiple
webserver instances + DB. Can one create CPU pools (say core 1,2,3 for
webservers, 4,5,6,7 for DB, etc.) ?
I
On 11/9/2010 5:05 PM, Scott Marlowe wrote:
Note that you're likely to get FAR more out of processor affinity with
multiple NICs assigned each to its own core / set of cores that share
L3 cache and such.Having the nics and maybe RAID controllers and /
or fibre channel cards etc on their own se
you need to do is start that process and work to make it shorter
for PostgreSQL upgrades, or failing that, find something to do with
your life, because processes like that are a bright red warning sign
of the kind of dysfunction that tanks organizations, no matter how big
or important they ar
ZFS has an option to use an SSD as cache for the spinning drives. ZFS
under Solaris has turned in some really good IO numbers. The problem is
with the new Sun I am not feeling so good about the open nature of
Solaris. ZFS performance under BSD I have read does not match ZFS under
Solaris.
On 11/11
00MB
> max_prepared_transactions = 100 # guideline: same number as max_connections
This should be either 0 (no 2PC) or the bounded from below by
max_connections.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMP
On 11/13/2010 3:31 PM, LazyTrek wrote:
Do the long standing members not have problems with spam?
As you can see I use a list alias. However, in my experience the notion
that you can avoid spam by not frequenting mailing lists is quaint to
say the least. The spammers have had ways to find, ste
how to do this or even whether you can do this.
You can do it like this:
BEGIN;
ALTER TABLE foo DROP CONSTRAINT your_constraint;
ALTER TABLE foo ADD FOREIGN KEY ...;
COMMIT;
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype:
o
production, or a solid evidence that you need to find another gig.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
esting on things that work
for the vast majority of people. :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Re
l address will be plastered all over the internet, guaranteed to
> be picked up by spiders, make sure you have a good anti-spam."
If you imagine that not signing up for a mailing list in any way
alleviates this need, I have a bridge to sell you. It connects
Manhattan with Brooklyn.
Cheers,
Davi
Is it possible to extend the COALESCE() function? I would like to support for
coalescing an int into a Boolean, but I get syntax errors if I don't wrap
coalesce in quotes.
CREATE OR REPLACE FUNCTION coalesce(boolean,int) RETURNS boolean AS $$
SELECT CASE WHEN $1 IS NOT NULL THE
string so
that it isn't special for LIKE, or is it a case of regexing and putting
a \ before each \, _ or %?
David
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
f PostgreSQL
are 9.0, 8.4, 8.3, etc., not 9 and 8 :)
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vo
I've recently configured Postgres (8.3) to authenticate against OpenLDAP
this is my pg_hba.conf entry:
host all all 0.0.0.0/0 ldap
"ldap://ldapserver/dc=mydomain,dc=com;uid=;,ou=postgresql,dc=mydomain,dc=com";
Things are working fine most of the time.
However, every once in a while i'm getting
On Mon, Dec 06, 2010 at 07:03:59PM +0100, Rados?aw Smogura wrote:
- Try with configuration parameter
- conn_max_pending (number of connections waiting for processing thread)
- conn_max_auth (same, but for authenticated)
ok sounds good, i'll give that a shot!
- If you are using anonymous auth then
ot; habit
of using the argument.function notation, so you called the "name"
function, i.e. the one that casts to name, on the entire row from your
accounts table.
Cheers,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfe
On Wed, Dec 15, 2010 at 03:43:45PM -0800, Adrian Klaver wrote:
> On Wednesday 15 December 2010 1:27:19 pm David Fetter wrote:
> > On Wed, Dec 15, 2010 at 01:50:54PM -0600, Jack Christensen wrote:
> > > I was just surprised when accidentally selecting a non-existent name
> &g
rg/dfetter/index.php?/archives/59-Partitioning-Glances.html
Cheers,
David (hoping PostgreSQL will be able to infer how to automate this some day).
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fet...@gmail.com
iCal: we
We're using UUID for primary keys in PG 8.4 without any issues. I have
no real insights into the details or performance issues, but always
figured it was stored as a binary 128-bit value, but with added benefits
of being able to enter and view them using a standard string format. We
don't sor
%PDF-'" message appears.
I can think of some possible variations and causes for this but figured
before I go running for the cliff I'd see if anyone can at least point me in
the right direction.
Thank You
David Johnston
d change my Java code (JDBC) to use the newly default "hex"
format that appears to be preferred over the "escape" format.
Dave
-Original Message-
From: Andy Colson [mailto:a...@squeakycode.net]
Sent: Tuesday, February 01, 2011 4:59 PM
To: David Johnston
Cc: pgsql-general
If random sampling is desirable would the following construct limit locking
only to the sampled rows?
SELECT id
FROM tasktable
WHERE id IN (SELECT random_id_sample())
FOR UPDATE
The "random_id_sample" would supply a configurable group of IDs off of
tasktable which the FOR UPDATE would then lock
You also don't have to import the source files directly into the live table.
Instead you could create a "staging" table that has no constraints where you
can import everything, do some review and updates, then merge that table
over to the live one. Depending on how many files you are dealing with
The main concern to consider is whether there are any shared relationships
that the different projects all have (e.g., common logon users). Since you
cannot query across different databases if there is shared information then
a single database would be preferred. I think the concept you want to
c
are
implicitly starting with zero (0) and incrementing and then seeing whether
the first step falls inside the specified range.
David J
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thom Brown
Sent: Thursday, February 03, 2011 8
difficult or outright impossible; you really need to use the procedural
facilities built into the server OR your application environment. In other
words put down the hammer and go find yourself a chainsaw :)
David J
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql
ropping) without any additional
permissions required so unless you see that carlos cannot I would say you
are good.
David J
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Carlos Mennens
Sent: Friday, February 04, 2011 1:28
DE | RESTRICT ]
David J
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Carlos Mennens
Sent: Friday, February 04, 2011 12:52 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Remove Role Membership
I've
ponding to this message with a
BUG# would be welcomed.
Thanks,
David J
howdy all,
I'm getting the above error in one of my dev DBs.
I've read in the archives that to stop the error from happening I can just
delete entries in pg_type and pg_class, however there seemed to be some
community interest in doing some debugging.
(mentioned in this thread:
http://archiv
On Tue, Feb 08, 2011 at 10:16:02PM -0500, Tom Lane wrote:
- David Kerr writes:
- > I'm getting the above error in one of my dev DBs.
-
- Would you poke around in the system catalogs and find where the dangling
- reference is located? Have you got any idea of how to reproduce this
- fail
On Wed, Feb 09, 2011 at 09:42:36AM -0800, David Kerr wrote:
- On Tue, Feb 08, 2011 at 10:16:02PM -0500, Tom Lane wrote:
- - David Kerr writes:
- - > I'm getting the above error in one of my dev DBs.
- -
- - Would you poke around in the system catalogs and find where the dangling
- - refe
On Wed, Feb 09, 2011 at 02:15:06PM -0500, Tom Lane wrote:
- David Kerr writes:
- > Ok, I found the bad entries, 2 tables a sequence and 2 primary key indexes
are associated
- > with the wrong (invalid / nonexistant ) schema.
-
- > However, there are correct entries for those objects as
n the server to load in a local
file you should specify that and wait (or look) for a proper response as I
do not know how or if that can be done.
David J
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Carlos Mennens
the FOR UPDATE to
avoid having the same record "dispatched" multiple times. It worked just
fine in 8.2.X and 8.4.X - supported or not.
David J
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Wednesd
and why you are doing that so alternative solutions can
be presented.
David J
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adarsh Sharma
Sent: Friday, February 11, 2011 6:14 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Auto-Increment
On 02/09/2011 11:23 AM, David Kerr wrote:
On Wed, Feb 09, 2011 at 02:15:06PM -0500, Tom Lane wrote:
- David Kerr writes:
-> Ok, I found the bad entries, 2 tables a sequence and 2 primary key indexes
are associated
-> with the wrong (invalid / nonexistant ) schema.
-
-> However,
compiles).
Somehow (from the error) it appears that PostgreSQL is trying to assign the
entire (composite) result of the function call to the "first" component of
variable (the bigint/integer) and failing: ' invalid input syntax for
integer: "(92,)" '
All behavior
Tom,
BTW, with the quick response you provided (THANKS!) I probably should have
pinged the list sooner in my search...
David J.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Saturday, February 12, 2011 5:33 PM
To: David Johnston
Cc: pgsql-general@postgresql.org
r behavior occurred when the sole
output for the called function was a compositetype.
9.0.3/plpgsql
Thanks.
David J
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
tly exists and the "creating function" and tweak its use of the
composite type without requiring every possible caller of the "creating
function" to change if the type has additional components added to it.
David J.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
VOKE ALL . FROM impotent so what am I
missing?
Thanks,
David J
rther responses from the list (after you
describe what indexes you have already defined on relevant tables - and
maybe provide the raw query as well).
David J
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ahmed Ossa
ETURN true;
END;
$$ LANGUAGE 'plpgsql';
SET ROLE impotent;
SELECT testfunc(); -- SUCCEEDES
SET ROLE postgres;
REVOKE ALL ON ALL FUNCTIONS IN SCHEMA public FROM PUBLIC, impotent;
SET ROLE impotent;
SELECT testfunc(); --FAILS
David J
g the problem.
Thanks again for helping me get my head around some of this stuff.
David J
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Monday, February 14, 2011 7:05 PM
To: David Johnston
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Alter Default Privileges
kinds of levels is dependent upon the
domain but it is generally safe to be too-fine since you can readily
aggregate into less-fine groups but once you have a given level of fineness
getting more-fine is difficult.
David J
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...
On Fri, Feb 11, 2011 at 03:17:51PM -0500, Tom Lane wrote:
- David Kerr writes:
- > So i removed the 5 entries from pg_class, but i still get that error
- > when trying to pg_dump:
-
- > pg_dump: schema with OID 58698 does not exist
-
- > Any other ideas where i could look?
-
- We
)
David J
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alpha Beta
Sent: Tuesday, February 15, 2011 5:01 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] subset of attributes
Hi,
while reading about databases, I didn't under
should remain permanently but since you do not want to violate
those anyway the problem is not relevant.
The only other option to consider is to make all the relevant constraints
deferrable - though this may not always be possible.
David J
-Original Message-
From: pgsql-general-ow
Try just using the string function "position". You'll need to check the
documentation or wait for others to determine which specific system views
you will need to obtain the column name (if you do not already know that
part).
position(substring in string) int
Non-Zero (or maybe >= 0) indic
On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote:
- Hi all -
-
- I am trying to write a query to find all the column names in
- database that has a underscore in it (_) example souce_id. I know like will
- not work , if where column_name like '%_%' Can you please help?
-
- Regar
where required.
A column "CHECK" constraint, however, seems like it should work just find if
you use a regular expression - and I cannot imagine it would be that
performance limiting.
Without a more specific model in mind choosing between different approaches
is difficult.
Da
8, 2011 4:51 PM
To: David Johnston; pgsql-general@postgresql.org
Subject: Re: [GENERAL] constraining chars for all cols of a table
>>Restrict access to the table (for inserts) to a function that does the
verification and then executes the insert in addition to any kind of logging
and
into those tables.
Whether the application logic CAN be represented in a SQL function is
another matter but it is at least something to consider.
From: Gauthier, Dave [mailto:dave.gauth...@intel.com]
Sent: Friday, February 18, 2011 5:46 PM
To: David Johnston; pgsql-general@postgresql.org
rrant changing an existing database unless large binary
processing takes up a significant portion of the processing (as opposed to
simple document storage and retrieval which is what I am doing).
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-gener
essing
tables before (I assume if access is being done via VIEWs that incorporating
the function calls into the views would work just fine).
David J
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Melvin Davidson
Sent: Tuesday, February
On Tue, Feb 22, 2011 at 04:40:36PM +, Howard Cole wrote:
- Hi,
-
- a puzzle to solve...
-
- I have a table with a primary key, and a timestamp, e.g.
-
- idstamp
- 1 2011-02-01 10:00
- 2 2011-02-01 09:00
- 3 2011-02-01 11:00
-
- Now for reasons too painful to go into, I need
erstanding
issue due to the fact that you need to do this persistently.
You may be able to accomplish a similar result without the use of a sequence
by using WINDOW but for a one-off scenario the sequence should suffice.
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[ma
- though maybe a simplified version but
one that still exhibits the behavior in question.
You also do not provide the minor release level which may be relevant.
David J.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ralph Smith
Sent
ing
"true" for both tests then this is the reason and the solution.
David J.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Tuesday, February 22, 2011 5:56 PM
To: pgsql-general@postgresql.org
Subject: [GEN
ccessful records
that might point you further in the correct direction.
If THAT fails you might want to see if anyone will receive the testing file
and "CREATE TABLE" and try to independently diagnose the cause of the
problem. That or do the Access export and skip your conversion rou
a null/blank field between "SIERRA MANOR" and "11/15/1948"
Thus everything after "SIERRA MANOR" is off-by-two in column position
(SIERRA MANOR itself of off by 1) which seems to match what you are seeing
during the import. You can add a "|" in those two locatio
generation.
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber
Sent: Thursday, February 24, 2011 1:31 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Adding a column with constraint
Hello,
It may help to specify why you feel that array_upper and array_lower are
insufficient for your use. I mean, you could " count( unnest( array ) ) "
but whether that is better or worse than array_upper really depends on your
needs.
David J.
From: pgsql-general-ow...@post
the first explain
was checking a condition: ((filetaskinstance.fr_name)::text =
(filereference.fr_name)::text); but the filetaskinstance.fr_name column (a
foreign key) had not been indexed. I added the index thinking the first
query may choose to use that index (on fr_name instead of ti_id) but it did
not - it sti
s
behavior using my live data just let me know and I'll try and do what I can.
BTW, for the test case I used all the same tables that are referenced in the
two views but with many of the non-key attributes removed. I then loaded
10,000+ records into the relevant tables and ran the exp
e designed for. If you really
need to create the "index id" at the time of record creation you should
write you own ID generator routine - making sure you deal with concurrency
issues.
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-
sted. You will probably want to externally enforce a "no duplicate names"
policy if you do this since the database only checks for duplicate names
within a SCHEMA
Look at the documentation for (RULE, FUNCTION, SCHEMA) to get more details
on what each of these features offer.
David J.
-
RNING" for some reason you can issue a select - assuming you can
identify the record in tdir_uris_files that you need.
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andre Lopes
Sent: Sunday, February 27,
;RAISE" events. Alternatively, you could output a
multi-column row with a Boolean true/false as one of the fields for
"reservation made" and have other message field for cases where it was not
made.
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:
Along the same lines where are you seeing errors related to these
images - and what are they? You also say "some" but is that because you
have only tested a few or are there some that are coming across just fine?
David J.
-Original Message-
From: pgsql-general-ow...
t; (1 row)
Hint: Consider the results of:
SELECT literal FROM table1;
AND
SELECT
t1.*,
(SELECT t2.col2 FROM t2 WHERE t2.id = t1.id)
FROM t1;
David J.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ing even if you
restricted initial development to standard SQL.
My estimate is that it is possible that PostgreSQL would meet your needs -
though as you say the use of various tools to connection pool and such are
going to be critical.
As for recommendations - buy as much hardware as you can a
You could try online yellow-pages and extract names from the HTML; I did
this a long time ago for some reason. There may be copyright issues to
consider but if you are using it for internal test data...
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general
Either script run alone works just fine - it is just when run in tandem as
described is neither able to complete.
What am I doing/understanding incorrectly or is this undesirable behavior?
Thanks,
David J.
===
--Transaction 1
begin;
delete from lock
OK, so I try the same scripts with pgAdminIII and they work as expected.
Sorry for the noise.
David J.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Monday, March 07, 2011 1:20 PM
To: David Johnston
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL
again for that a
zero weight is impossible so the above would only apply to the net-weight.
Just some thoughts.
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of James B. Byrne
Sent: Tuesday, March 08, 2011 9:55 A
meone else to opine on that particular option.
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andre Lopes
Sent: Tuesday, March 08, 2011 1:29 PM
To: postgresql Forums
Subject: [GENERAL] Using bytea field...
Hi,
from phpbb_user for BOTH these
conditions.
Decide how you want to modify those records so that can be imported into
drupal_users.
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber
Sent: Wednesd
SELECT username, count(username) FROM phpbb_users
GROUP BY username
HAVING count(username) > 1;
If anything shows up then (phpbb_users .username) is not a unique field but
you are trying to insert it into one that is (drupal_users.uid)
-Original Message-
From: pgsql-general-ow...@postgr
n the values.
Since created does appear to be a timestamp field if you have any control
I'd recommend changing it to be one and modify whatever program inputs that
value so that it uses actual dates instead of what appear to be second or
milliseconds since some epoch time.
David J.
-Original
Set autocommit to "true/on". That will give you the desired behavior of
allowing all those things that succeed to remain committed.
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Vogt, Michael
Se
needs and what PostgreSQL provides.
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver
Sent: Tuesday, March 15, 2011 12:44 PM
To: pgsql-general@postgresql.org
Cc: Merlin Moncure; Bruce Momjian; Alphad
Don't know if this would work but could you check to see if the corresponding
PK exists on A?
It may also help to explain why you would want to do such a thing so that
someone may be able to provide an alternative solution as opposed to simply
responding to a generic feature question.
used. It is much harder to
deconstruct data than to construct more complex data from simpler parts.
Lasty, remember that learning takes time and energy (though the bright-side
is that actual cash outlay is minimal if you can provide enough of the other
two items)
David J.
-Original Me
the shoulders of the conference organizers, who are
> > already working hard just to pull off the live show.
>
> never said that it's not so just that i'm surprised/disappointed that
> it's so low priority.
Who proposes, volunteers! How are you going to help?
On Mon, Mar 21, 2011 at 11:55:20PM +0100, Aljoša Mohorović wrote:
> On Mon, Mar 21, 2011 at 9:45 PM, David Fetter wrote:
> > Who proposes, volunteers! How are you going to help?
>
> being on a different continent and unable to attend doesn't actually
> enable me to do s
e advantage of clearly showing that the two tables
represent properties for identical entities but that some meta-data like
factor necessitates keeping the data on two separate tables (otherwise you
should just put them onto the same table).
David J.
From: pgsql-general-ow...@postgresq
to account?
David J.
From: salah jubeh [mailto:s_ju...@yahoo.com]
Sent: Wednesday, March 23, 2011 10:29 AM
To: David Johnston
Cc: pgsql
Subject: Re: [GENERAL] General question
Dear Johnston,
Thanks for the reply, I really get a lot of benefit from it. In my design, I
have several
: Wednesday, March 23, 2011 11:02 AM
To: David Johnston
Cc: pgsql
Subject: Re: [GENERAL] General question
It is a user accounts, which might then become customer accounts, accounting
accounts, etc. I will use specialization and generalization concepts in
database. I did not complete the design
s design decision in order to address the complexity of
making a DO statement possible at all or is it an oversight that is or could
be planned for future correction? Or should it work except for some
limitation of JDBC? I am not sure how I'd go about testing a parameterized
query without using
IRC).
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Stephen Frost
Sent: Thursday, March 24, 2011 4:56 PM
To: Yang Zhang
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Default permissions for CREATE SCH
single record per ID
that an ID cannot be associated with the same date more than once. The
second query mitigates this by using a PRIMARY KEY along with a "LIMIT 1"
clause. The first query, however, can return multiple records with the same
ID if they share the same date.
David J.
---
401 - 500 of 3946 matches
Mail list logo
