I have two tables software.orders and software.products.
I created two views.
CREATE OR REPLACE VIEW software.o1 AS
SELECT orders.orderid, orders.productid, orders.amount
FROM software.orders;
CREATE OR REPLACE VIEW software.o2 AS
SELECT o1.orderid, o1.productid, o1.amount,
On 05/14/2012 12:12 PM, Pham Ngoc Hai wrote:
I'm running PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by
gcc (GCC) 4.4.6 20110731 (Red Hat 4.4.6-3), 64-bit
on CentOS release 6.2 (Final)
Recently we encountered postmaster segfault, what the core dump gives
me is:
Did you ever see
Hello,
We have problems (currently using 8.4, but also in latest 9.1.3) in
our application with Unicode word symbols in Lithuanian ('ąčęėįšųūž'),
Russian and of course potentially other languages.
For example, regex_replace('acząčž', E'\\W', '', 'g') removes ąčž.
lower() and ~* comparison works
On 05/21/12 2:09 AM, Vincas Dargis wrote:
We have problems (currently using 8.4, but also in latest 9.1.3) in
our application with Unicode word symbols in Lithuanian ('ąčęėįšųūž'),
Russian and of course potentially other languages.
For example, regex_replace('acząčž', E'\\W', '', 'g') removes
Aaron Burnett wrote:
I run a handful of queries overnight when traffic is at it's lowest
on our
system. One particular query will run perfectly fine (around 5
seconds0)
for several weeks, then suddenly decide to hang indefinitely and
never
finish. It needs to be killed manually after several
On 2012-05-18, J.V. jvsr...@gmail.com wrote:
I have a table with a varchar column.
I want to select the distinct values from this column and loop through
them (using as a variable) in a raise notice statement and also in an
update statement.
I have not been able to do this trying over 100
On 2012-05-16, John Townsend jtowns...@advancedformulas.com wrote:
*** So...the question: Is there a good reason why you might want to NOT
use libpq.dll, and just directly access the server through direct
function calls? ***
libpq binds you to using NUL terminated C strings, and, no doubt,
On Mon, May 21, 2012 at 02:44:45AM -0700, John R Pierce wrote:
support the bastardized UTF-16 'unicode' implemented by Windows NT
To be fair to Microsoft, while the BOM might be an irritant, they do
use a perfectly legitimate encoding of Unicode. There is no Unicode
requirement that code points
In that case, yes, there are such implementations around. Martijn
mentioned a few, and I mentioned the Pike one, all of which do indeed
bypass libpq and talk directly to the server. It is, as I understand
it, an open and stable protocol, so it's no different from writing a
program that connects
On Mon, May 21, 2012 at 9:05 PM, John Townsend
jtowns...@advancedformulas.com wrote:
I downloaded PIKE. The PostgreSQL direct network module for Pike,
pgsql.pike (and the other modules), shows how it was done.
Many thanks for the tip. I rarely step out of Delphi, so I was unaware of
the power
On Sun, May 20, 2012 at 2:52 PM, John Townsend
jtowns...@advancedformulas.com wrote:
By by-passing the dll (or so on Linux) library I mean you write function
or procedure calls to the server that is running as a service on Windows.
You don't use the library with its 160 exported functions. You
Sorry I have to write manual replay since I've messed up mailing
list settings (got Partial Digest...).
John R Pierce wrote:
your database encoding is UTF8 ? the language or environment you're using to
generate those strings such as 'acząčž' is also UTF8 ?
Database created using:
initdb -D
Sorry I have to write manual replay since I've messed up mailing
list settings (got Partial Digest...).
John R Pierce wrote:
your database encoding is UTF8 ? the language or environment you're using to
generate those strings such as 'acząčž' is also UTF8 ?
Database created using:
initdb -D
Vincas Dargis wrote:
We have problems (currently using 8.4, but also in latest 9.1.3) in
our application with Unicode word symbols in Lithuanian ('ąčęėįšųūž'),
Russian and of course potentially other languages.
For example, regex_replace('acząčž', E'\\W', '', 'g') removes ąčž.
lower() and
If Stored Procedures are equivalent to prepared statements [ as far as
preparing the query plan is concerned], then what i'm looking for is
perhaps a Global Prepared Statements at the client/driver side.
Specifically, It wold be good if the JDBC driver prepares all the queries
for invoking stored
I've forgot to mention I'm working on Windows XP SP3
Yes, we are using UTF8 encoding and regexp works wrong. It looks like
you replicated that.
2012/5/21 Albe Laurenz laurenz.a...@wien.gv.at:
I tried it with 9.1.3 on Linux:
upper() and lower() works fine, no matter what the
database
Vincas Dargis vin...@gmail.com writes:
Database created using:
initdb -D ../data -E utf-8 -U postgres
That looks fairly dangerous, as it will absorb the database's locale
settings (particularly LC_CTYPE, which is what you care about for these
operations) from your shell environment. If the
On Mon, May 21, 2012 at 8:55 AM, Samba saas...@gmail.com wrote:
If Stored Procedures are equivalent to prepared statements [ as far as
preparing the query plan is concerned], then what i'm looking for is perhaps
a Global Prepared Statements at the client/driver side.
Specifically, It wold be
Jasen Betts ja...@xnet.co.nz writes:
On 2012-05-16, John Townsend jtowns...@advancedformulas.com wrote:
*** So...the question: Is there a good reason why you might want to NOT
use libpq.dll, and just directly access the server through direct
function calls? ***
libpq binds you to using NUL
Hi all,
I don't fully understand how is the cost of a bitmap heap scan
computed. For instance when the explain output node is similar to the
following:
Bitmap Heap Scan on test (cost=17376.49..48595.93 rows=566707 width=6)
Recheck Cond: ((text1 = 'A'::text) OR (text1 = 'C'::text))
Filter:
On 5/21/2012 7:56 AM, Merlin Moncure wrote:
On Sun, May 20, 2012 at 2:52 PM, John Townsend
jtowns...@advancedformulas.com wrote:
By by-passing the dll (or so on Linux) library I mean you write function
or procedure calls to the server that is running as a service on Windows.
You don't use the
Le lundi 21 mai 2012 15:35:55, Luca Ferrari a écrit :
Hi all,
I don't fully understand how is the cost of a bitmap heap scan
computed. For instance when the explain output node is similar to the
following:
Bitmap Heap Scan on test (cost=17376.49..48595.93 rows=566707 width=6)
Recheck
Le lundi 21 mai 2012 16:08:27, Merlin Moncure a écrit :
On Mon, May 21, 2012 at 8:55 AM, Samba saas...@gmail.com wrote:
If Stored Procedures are equivalent to prepared statements [ as far as
preparing the query plan is concerned], then what i'm looking for is
perhaps a Global Prepared
On 05/20/2012 07:45 AM, Aaron Burnett wrote:
Hey Steve,
Just wanted to send a note of thanks for pointing me in a few new
directions on this.
Turns out that the query would swap but not all the time. When it swapped,
it wouldn't finish, if it didn't swap it would finish in the expected
time.
On Mon, May 21, 2012 at 9:54 AM, John Townsend
jtowns...@advancedformulas.com wrote:
On 5/21/2012 7:56 AM, Merlin Moncure wrote:
On Sun, May 20, 2012 at 2:52 PM, John Townsend
jtowns...@advancedformulas.com wrote:
By by-passing the dll (or so on Linux) library I mean you write function
or
I am searching for some logic behind the selection of an index in
postgres -- it seems that if I have a composite index based on both
columns in a join table, it's only referenced if I query on the first
term in the composite index. I've read
Hi,
So exactly what do I need to do here? I don't understand how the backup script
work and what exactly user do I need to create?
Can you please tell me more in detail?
Thanks,
Bach-Nga Catherine Vo
703-767-7009
mailto: bvo@dtic.mil
-Original Message-
From:
On Mon, May 21, 2012 at 3:34 PM, Bill Mitchell b...@publicrelay.com wrote:
I am searching for some logic behind the selection of an index in
postgres -- it seems that if I have a composite index based on both columns
in a join table, it's only referenced if I query on the first term in the
On Mon, May 21, 2012 at 2:34 PM, Bill Mitchell b...@publicrelay.com wrote:
I am searching for some logic behind the selection of an index in postgres
-- it seems that if I have a composite index based on both columns in a join
table, it's only referenced if I query on the first term in the
2012/5/22 Merlin Moncure mmonc...@gmail.com
On Mon, May 21, 2012 at 2:34 PM, Bill Mitchell b...@publicrelay.com
wrote:
I am searching for some logic behind the selection of an index in
postgres
-- it seems that if I have a composite index based on both columns in a
join
table, it's only
*
I am banging my head over this. I want to select distinct values from a
varchar column and iterate through the values.
*
*I want to select the distinct values from this column and loop through
them (using as a variable) in a raise notice statement and also in an
update statement.
I have
Greetings,
I have a 4 server postgresql-9.1.3 cluster (one master doing streaming
replication to 3 hot standby servers). All of them are running
Fedora-16-x86_64. Last Friday I upgraded the entire cluster from
Fedora-15 with postgresql-9.0.6 to Fedora-16 with postgresql-9.1.3. I
made no changes
On Mon, May 21, 2012 at 3:36 PM, Dmitriy Igrishin dmit...@gmail.com wrote:
So you can get fully index lookups on all of a, b, ab, and ba. the
primary key can't optimize ba because indexes only fully match if
candidate fields are supplied from left to right order. They can
still help
Thanks to everybody's input -- as a first-time poster to this listserv,
I wasn't sure how long it would take to get a response. ;)
I was frankly astonished to see that the composite index on (a,b) was
used when I searched for (a), but Chris' response makes total sense.
In this case, I don't want
On Mon, May 21, 2012 at 3:39 PM, J.V. jvsr...@gmail.com wrote:
I am banging my head over this. I want to select distinct values from a
varchar column and iterate through the values.
I want to select the distinct values from this column and loop through
them
(using as a variable) in a raise
On 18/05/2012 21:30, J.V. wrote:
update table set varcharid = ''' || tmp_var || '''
Others have answered your question, but there's a problem here too; you
don't need the quotes. This statement should be just:
update table set varcharid = tmp_var;
...assuming that the types match, of course.
deepak deepak...@gmail.com writes:
We could reproduce the start-up problem on Windows 2003. After a reboot,
postmaster, in its start-up sequence cleans up old temporary files, and
this step used to take several minutes (a little over 4 minutes), delaying
the writing of line 6 onwards into the
On 05/21/2012 06:59 PM, Andrew Sullivan wrote:
On Mon, May 21, 2012 at 02:44:45AM -0700, John R Pierce wrote:
support the bastardized UTF-16 'unicode' implemented by Windows NT
To be fair to Microsoft, while the BOM might be an irritant, they do
use a perfectly legitimate encoding of Unicode.
Hi,
We are using Postgres 9.1.1 on a board with Coldfire controller.
The postgres processes are crashing and restarting upon executing a particular
instruction and it keeps repeating. Even when we tried with Postgres 9.1.3,
same problem happens.
It works fine until the FINANCIALTRANSACTIONID
39 matches
Mail list logo