Jeff Janes wrote
> I want to update some data in unique column. Some of the updates would
> conflict if applied to eligible rows, and for now I want to skip those
> updates, applying only one of a set of conflicting ones. I can use a not
> exists subquery to detect when the new value would confli
I want to update some data in unique column. Some of the updates would
conflict if applied to eligible rows, and for now I want to skip those
updates, applying only one of a set of conflicting ones. I can use a not
exists subquery to detect when the new value would conflict with an
existing one,
Hello,
The pg_catalog.concat() is defined as STABLE function.
As per my understanding a STABLE function cannot modify the database and is
guaranteed to return the same results given the same arguments for all rows
within a single statement.
Example:
current_timestamp family of functions qualify a
Hi, All
I like to pass the tablename to function but not using execute clause, here
is my script
CREATE OR REPLACE FUNCTION functions.pgsql_event_unpack_batch(IN _tbl text,
IN jobid bigint, IN jobtime timestamp with time zone, IN startid bigint, IN
stopid bigint)
RETURNS TABLE(events bigint, er
alecinvan wrote
> I like to pass the tablename to function but not using execute clause,
> here is my script
>
> [...]
>
> I want to pass the _tbl to the select query integrated in the unpacking(),
> how can I make it?
There is no way to perform a query with an unknown, at design time,
identifie
On 09/04/2014 04:42 PM, A L. wrote:
Hi, All
I like to pass the tablename to function but not using execute clause,
here is my script
CREATE OR REPLACE FUNCTION functions.pgsql_event_unpack_batch(IN _tbl
text, IN jobid bigint, IN jobtime timestamp with time zone, IN startid
bigint, IN stopid big
Hi, All
I like to pass the tablename to function but not using execute clause, here is
my script
CREATE OR REPLACE FUNCTION functions.pgsql_event_unpack_batch(IN
_tbl text, IN jobid bigint, IN jobtime timestamp with time zone, IN
startid bigint, IN stopid bigint)
RETURNS TABLE(events bigi
On 09/04/2014 08:03 AM, Alanoly Andrews wrote:
Thanks, Adrian for the response.
Yes, we are using the "large object" as per the specifications in the
special "lo" module that we installed on the backend server. The table
is created using the "lo" datatype for the image field and the table is
bei
On 09/04/2014 07:15 AM, David G Johnston wrote:
Adrian Klaver-4 wrote
On 09/04/2014 05:56 AM, Alanoly Andrews wrote:
Hi Adrian,
Thanks for that explanation of how the "relfilenode" changes after a
table reorganization. It is not surprising that this happens because the
table rows are being phy
Robin St.Clair
On 04/09/2014 20:44, Nelson Green wrote:
On Thu, Sep 4, 2014 at 9:48 AM, François Beausoleil
mailto:franc...@teksol.info>> wrote:
Hello Nelson,
Le 2014-09-04 à 10:39, Nelson Green mailto:nelsongree...@gmail.com>> a écrit :
> Good morning,
>
> Hopefully this
On Thu, Sep 4, 2014 at 9:48 AM, François Beausoleil
wrote:
> Hello Nelson,
>
> Le 2014-09-04 à 10:39, Nelson Green a écrit :
>
> > Good morning,
> >
> > Hopefully this is the correct place to ask this type of question.
> >
> > I am in the early stages of designing a system to track employee
> >
This is a super-interesting topic, thanks for all the info.
On Thu, Sep 4, 2014 at 7:44 AM, Shaun Thomas
wrote:
>
> Check /proc/meminfo for a better breakdown of how the memory is being
> used. This should work:
>
> grep -A1 Active /proc/meminfo
>
> I suspect your inactive file cache is larger th
Thank you both, I will look into alternative data types. I don’t think ltree
will work for my purposes but I am going to try out some others that might;
like cube.
—
Eric Fleming
On Thu, Sep 4, 2014 at 3:42 AM, Giuseppe Broccolo
wrote:
> Hi Eric,
> As Michael said, path data type does not supp
Thanks, Adrian for the response.
Yes, we are using the "large object" as per the specifications in the special
"lo" module that we installed on the backend server. The table is created using
the "lo" datatype for the image field and the table is being regularly used for
insertions and retriev
On Wed, 2014-09-03 at 21:27 -0700, Vinayak wrote:
> Hello Pavel,
>
> Thank you for reply.
> >postgres=# select 'abc '::char(7) || 'dbe '::char(6);
> >?column?
> >
> > *abcabc*
> >(1 row)
> but it gives the result "abcabc". It should be "abcdbe".
>
>
I believe the
Hello Nelson,
Le 2014-09-04 à 10:39, Nelson Green a écrit :
> Good morning,
>
> Hopefully this is the correct place to ask this type of question.
>
> I am in the early stages of designing a system to track employee
> information, including some aspects of their payroll, one of which is
> the s
On 09/03/2014 07:17 PM, Kevin Goess wrote:
Debian squeeze, still on 2.6.32.
Interesting. Unfortunately that kernel suffers from the newer task
scheduler they added to 3.2, and I doubt much of the fixes have been
back-ported. I don't know if that affects the memory handling, but it might.
Good morning,
Hopefully this is the correct place to ask this type of question.
I am in the early stages of designing a system to track employee
information, including some aspects of their payroll, one of which is
the source of the salary funds within the business. I need to make
this generic en
Adrian Klaver-4 wrote
> On 09/04/2014 05:56 AM, Alanoly Andrews wrote:
>> Hi Adrian,
>>
>> Thanks for that explanation of how the "relfilenode" changes after a
>> table reorganization. It is not surprising that this happens because the
>> table rows are being physically moved from one location to a
On 09/04/2014 05:56 AM, Alanoly Andrews wrote:
Hi Adrian,
Thanks for that explanation of how the "relfilenode" changes after a table reorganization. It is not surprising that this happens
because the table rows are being physically moved from one location to another. But such changes at the bac
You are going to have to help us by providing server (and any other) logs
with complete error messages and VB/ODBC code, with corresponding schema,
that will reliably reproduce the problem.
Note that since you are on an ancient 9.1 release it is possible that, if
this is indeed a bug, this has alr
Hi Adrian,
Thanks for that explanation of how the "relfilenode" changes after a table
reorganization. It is not surprising that this happens because the table rows
are being physically moved from one location to another. But such changes at
the backend should be transparent to the end user. The
2014-09-04 11:13 GMT+02:00 Vinayak :
> Hi,
>
> The || operator with arguments (character,character) works fine and even ||
> operator(character,varchar) also works fine.
> but || operator is not working as expected with arguments character data
> type and any other data type like integer,smallint,
Hi,
The || operator with arguments (character,character) works fine and even ||
operator(character,varchar) also works fine.
but || operator is not working as expected with arguments character data
type and any other data type like integer,smallint,date,text.
Example:
postgres=# select 'ab'::char(
On 09/02/2014 06:20 PM, swaroop wrote:
> To summarize - how do i replace the input strings in java (data is streamed
> in and i do a copy to postgres)
> so that CSV copy does not fail.
> a. words with comma
> b. words with double quotes in them
> c. words with \ (backslash)
Don't write the escapin
Hi Eric,
As Michael said, path data type does not support for gist operators.
Anyway, you could redefine data type using 'ltree' instead of 'path'. Take
a look on the following link:
http://www.postgresql.org/docs/9.1/static/ltree.html
Try to understand if this could be fine for you.
Cheers,
G
Hello,
As part of database evaluation one key requirements is as follows:
1. There are multiple thick clients (say 20 ~ 100) with their local
databases accepting updates
2. They sync data with a central database which can also receive updates itself.
3. They may not be connected to central databa
27 matches
Mail list logo