> On 2010-12-16, pgsql(dot)30(dot)miller_2555(at)spamgourmet(dot)com
> wrote:
> > --0015174c1e4aaf077604977d7e62
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > Hi -
> >
> > Issue:
> > How to return a sequence value generated upon
Hi -
Issue:
How to return a sequence value generated upon INSERT of records into a
partitioned table using trigger functions (without having to insert into the
child table directly).
Current implementation:
The master table of the partitioned table uses a trigger function to
alter an inco
Hi -
I have a table for which I want to fit an exponential curve to values in
one column of the table and compute a correlation statistic on the fit of
the values to the exponential curve. The table consists of the following
three columns: {"ID","Date","Value"}. The desired result of the exerc
Hi -
I have a multi-threaded application that spawns child processes, inserts
information into the database, then disconnects. For whatever reason, some
of the children do not disconnect and the database is left with idle
connections (that eventually max out over time). How can I either force th
Tom Lane-2 wrote:
>
> miller_2555 writes:
>> So this does not work well apparently.
>
> The only obvious thing wrong with your example is failing to preserve
> ownership/permissions of the moved files. I think the upper directories
> are probably not readable by
miller_2555 wrote:
>
> Hi -
> I have a database and used symbolic links in the tablespace
> definitions. I just wanted to validate that I can move the database
> objects to a different physical volume by the following:
> 1) issuing `pg_ctl stop`
> 2) hard c
Richard Broersma wrote:
>
> For those experienced using natural primary key designs, what update
> strategies do you use when updating related tuples within a
> transaction when the primary key is also subject to changes?
>
> For example consider a table is vertically partitioned into two or
Scott Frankel-3 wrote:
>
> Is it possible to join tables in the where clause of a statement
>
> I've explored the "where exists" clause, but that's not supported by
> the application toolkit I'm using. AFAIK, I've only got access to
> where ...
>
> Thanks in advance!
> Scott
>
Not entire
Hi -
I have a database and used symbolic links in the tablespace definitions.
I just wanted to validate that I can move the database objects to a
different physical volume by the following:
1) issuing `pg_ctl stop`
2) hard copying the tablespace files from one drive to another
> On Thu, Jul 9, 2009 at 7:29 PM, Greg Stark wrote:
>> On Fri, Jul 10, 2009 at 1:28 AM, Scott Marlowe
>> wrote:
>>>
>>> $750 is about what a decent RAID controller would cost you, but again
>>> it's likely that given your bulk import scenario, you're probably ok
>>> without one. In this instance
Hi -
I'm running Postgres v8.3 on Fedora 10 (home machine - x86_64
architecture). After realizing that the storage requirements of one of
my databases will exceed 4Tb, I wanted to see if anyone had any
suggestions as to hardware setup that works well with Postgres running
on Linux. I have partitio
Tom Lane-2 wrote:
>
> miller_2555 writes:
>> I appreciate the clarification on the output. Given the assignment
>> appears
>> correct, what is the appropriate method to access the elements of the
>> multidimensional array?
>
> I think what you're mis
Tom Lane-2 wrote:
>
> It sounds like you are using some code that mistakenly thinks that
> double quotes have a semantic meaning here. They do not. They are just
> there to delimit members of the row value, not to tell you what type the
> members are.
>
Note: quoted text abridged per mailing
Hi -
I am trying to declare an array of the following compound type:
CREATE TYPE myschema.mytype AS (
sometexttext,
onedimarray text[],
multidimarray text[][]
);
The current assignment occurs as follows:
myvar mysch
14 matches
Mail list logo
