On 2010-12-16, pgsql(dot)30(dot)miller_2555(at)spamgourmet(dot)com
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 INSERT of records
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
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 exercise
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
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
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 entirely sure of
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
more
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 copying the tablespace files
Tom Lane-2 wrote:
miller_2555 nabble.30.miller_2...@spamgourmet.com 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
On Thu, Jul 9, 2009 at 7:29 PM, Greg Starkgsst...@mit.edu wrote:
On Fri, Jul 10, 2009 at 1:28 AM, Scott Marlowescott.marl...@gmail.com
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
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
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 list
Tom Lane-2 wrote:
miller_2555 nabble.30.miller_2...@spamgourmet.com 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 missing
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
14 matches
Mail list logo