unsubscribe pgsql-general@postgresql.org
Natural keys are in user data space. Thus they are not guaranteed invariant
and therefore cannot serve as persistent identity.
Also natural keys have the considerable defect of being of different type and
arity per logical entity type. This means that very nice things like dynamic
relationsh
On Aug 9, 2010, at 11:57 AM, Merlin Moncure wrote:
> On Mon, Aug 9, 2010 at 2:39 PM, samantha wrote:
>> I have been digging into NoSQL of late. For navigational queries it would
>> be great if there was a way to bypass SQL and directly pull from an
>> identifier for a record or arbitrary byte s
This touches on a question I would love to be able to answer
Why is MySQL so much more popular right now, especially in the OpenSource
community? As a database I find its architecture with multiple underlying
engines and other quirks to be rather dubious. Then there is the issue of
commercial
On Dec 24, 2007, at 11:15 PM, Greg Smith wrote:
This may be better because it isn't doing the query first. You may
discover that you need to aggressively run one of the VACUUM
processes (I'd guess regular and ANALYZE but not FULL) in order to
keep performance steady as the number of r
OK, I read it again. I don't see anything about how the timezone is
specified for this type of column.
On Dec 12, 2007, at 12:06 AM, Tom Lane wrote:
Samantha Atkins <[EMAIL PROTECTED]> writes:
How can it be a simple 8 byte int or float and specify a timezone?
It doesn't.
Less than useful. I did read the thread last night. What am I missing?
On Dec 12, 2007, at 12:06 AM, Tom Lane wrote:
Samantha Atkins <[EMAIL PROTECTED]> writes:
How can it be a simple 8 byte int or float and specify a timezone?
It doesn't. Read the t
How can it be a simple 8 byte int or float and specify a timezone?
This is only a time interval from a fixed date/time. Where is the
timezone part?
On Nov 8, 2007, at 7:18 AM, Tom Lane wrote:
Samantha Atkins <[EMAIL PROTECTED]> writes:
What can I expect for a date format
ng of
parameters and binary extraction of results for all major types in C
against lippq that would be a very useful thing to have in the
standard docs.
- samantha
On Nov 8, 2007, at 7:18 AM, Tom Lane wrote:
Samantha Atkins <[EMAIL PROTECTED]> writes:
What can I expect for a date fo
What can I expect for a date format from a PGresult containing binary
results? Specifically the Oid type is TIMESTAMPTZOID. In this case
what does the PQgetvalue actually return? What does the char* point to?
Thanks.
- samantha
On Nov 6, 2007, at 1:15 AM, Raymond O'Donnell wrote:
On 06/11/2007 08:54, Reg Me Please wrote:
What'd be the syntax to create a primary key on an already build
table?
ALTER TABLE test ADD CONSTRAINT test_pk PRIMARY KEY (f1);
So, ALTER TABLE test ADD PRMARY KEY(f1 [, ... ] )
isn't enough
I am probably overlooking something but where exactly are these found
for inclusion is libpq based programs? Poking around my installation
doesn't make it obvious.
- samantha
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, p
On Oct 29, 2007, at 10:14 AM, Richard Huxton wrote:
Samantha Atkins wrote:
First on prepared statements:
1) If I am using the libpq are prepared statements tied to a
connection? In other words can I prepare the statement once and
use it on multiple connections?
Per session (connection
First on prepared statements:
1) If I am using the libpq are prepared statements tied to a
connection? In other words can I prepare the statement once and use
it on multiple connections?
2) What is the logical scope of prepared statement names? Can I use
the same name on different table
14 matches
Mail list logo
