Sorry if my question is a little off topic.
I am reading my new "SQL for Smarties" book side by side with the PostgreSQL
8.1 manual. I
noticed that this particular feature is not included in PostgreSQL. Some of
the achieve threads
mostly discuss that this feature is currently not supported. My
On Sun, Aug 27, 2006 at 00:19:59 -0700,
Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> Sorry if my question is a little off topic.
>
> I am reading my new "SQL for Smarties" book side by side with the PostgreSQL
> 8.1 manual. I
> noticed that this particular feature is not included in Postgr
> You can accomplish what assertions do using triggers.
> I think the issue is generating triggers for general assertions that don't
> totally suck performancewise.
Ah, I see. So the points is that checking the integrity between two complete
data sets can become
a preformace killer.
Thanks for
On 8/24/06, Travis Whitton <[EMAIL PROTECTED]> wrote:
Hello all, I'm running the following query on about 6,000 records worth
of data, and it takes about 8 seconds to complete. Can anyone provide
any suggestions to improve performance? I have an index on
two columns in the transacts table (program_
On 8/24/06, Sumeet <[EMAIL PROTECTED]> wrote:
Hi Folks,sorry if this is a duplicate post, i've been tryin to find a solution of importing data into postgres from a csv file. The problem is, I have a database which consists of columns which contain newline characters (mac and unix). now when i expor
