| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I apologize, I didn't see the beginning of this thread. If you have a problem
with Visual FoxPro accessing remote datas, you can ask your question on...
Jean MAURICE
|
Today 09:04 AM
Luiz K. Matsumura  | 2 | 4 |
| | | Hello List,
Trying to install 9.1.3 according to the INSTALL directions:
../configure
gmake
su
gmake install
adduser postgres
mkdir...
Victor Whiskey Yankee
|
05-26-2012 02:23 PM
Tom Lane | 1 | 4 |
| | | I want to migrate from MS Sqlserver 2008 r2 express to Postgresql
I use postgresql 9.1.3
I create this stored function (on Postgres side)
CREATEOR...
Ilija Vidoevski
|
05-26-2012 01:39 AM
Ilija Vidoevski | 8 | 10 |
| | | Hello,
PostgreSQL 9.0, Windows 2008
32 different PostGIS Databases
round about 20 active connections by duration
max_connections = 100
Memory load...
Susanne Ebrecht
|
05-25-2012 02:46 PM
Merlin Moncure | 1 | 4 |
 | | I have installed the windows version of PostgreSQL 8.4. Loging in as the superuser everytime. I want to use the enryption functions to mask some of...
Anoop Koshy
|
05-24-2012 01:39 AM
Anoop Koshy | 0 | 1 |
| | | Hi, I am pretty new to this mailing list so forgive me if I make dumb
questions here.
I would like to look at (and store) page usage information. I...
Alejandro Barragan
|
05-23-2012 06:50 AM
Bartosz Dmytrak | 1 | 12 |
| | | Try something like this
select acl1, no_accounts , Round(100*counter/total,2) as percentage
from (select count(1) as no_accounts , cl1
from xpto...
Humberto Carvalho
|
05-23-2012 06:40 AM
Oliveiros d'Azevedo Cristina | 1 | 2 |
| | | Hi,
Is it possible to have a query that that would run on a different table
every time it is executed? This query would be integrated in a...
Nart Tamash
|
05-22-2012 02:34 AM
Willy-Bas Loos | 1 | 11 |
| | | I am sure I am doing something wrong - because I cannot find anything aboutthis on Google or in the Community Archives - but here goes:
I am running...
lindsay.braine@emc.com
|
05-22-2012 02:10 AM
Willy-Bas Loos | 1 | 3 |
| | | hello,
I am working with PostgreSQL 9 in windows (pgAdmin3) and I'm trying to
execute EXPLAIN ANALYZE command on some queries that are
really time...
michel wildcat
|
05-22-2012 01:58 AM
Willy-Bas Loos | 1 | 11 |
| | | hello,
I am working with PostgreSQL 9 in windows (pgAdmin3) and I'm trying to
execute distinct EXPLAIN ANALYZE command on some queries that...
michel wildcat
|
05-21-2012 02:42 PM
michel wildcat | 2 | 21 |
| | | I am using the JDBC prepareStatement object to build a SQL statement that should update a users password in a postgres v8.1.21 database. (Based on...
Nelson, Howard C
|
05-17-2012 01:44 PM
Tom Lane | 1 | 14 |
| | | I can not access to postgresql server 9.1.3 form client computer with
front-end application written in MS Visual Foxpro 9 SP2.
Application made...
Ilija Vidoevski
|
05-17-2012 05:46 AM
Valentin Gjorgjioski | 6 | 18 |
| | | I'm working on project with some large text areas that will need to be
searched, and I'm trying to set up an indexed text search field to make
things...
Daniel Staal
|
05-16-2012 06:34 PM
Daniel Staal | 6 | 25 |
| | | Hi, I am starting to mess around with PostgreSQL source code and wanted to
print some information to console in relation to pages. I see that...
Alejandro Barragan
|
05-16-2012 08:04 AM
Tom Lane | 1 | 10 |
| | | Hello group
*
I have a large table indexed by a*varchar column
I would like to select*records that are around the hit value, say "Marriot"*by index...
Francisco Leovey
|
05-15-2012 12:51 PM
Francisco Leovey | 4 | 16 |
| | | Greetings!
I am in the eastern US trying to track down events that occurred at a customer site in Vietnam. I decided it would be easier to look at...
Rob Richardson
|
05-14-2012 10:46 AM
Steve Crawford | 2 | 15 |
| | | I am having what appears to be a deadlock in a client application
(i.e. psql) when I use it to query a PL/TCLu function that invokes a
Java...
Pat Pascal
|
05-14-2012 09:29 AM
Pat Pascal | 1 | 14 |
| | | I have a table foo (d,f,mj,mn) where (d,f) is the primary unique key and the only index. I've added a new sequence and a new integer column v and...
Benjamin Hurt
|
05-11-2012 05:51 PM
Benjamin Hurt | 0 | 12 |
| | | On 2012-05-10 08:43, Shawn Matthews wrote:
The simple answer is: No, and http://www.postgresql.org/docs/
That said, if you haven't done any...
Daniel Staal
|
05-10-2012 10:27 PM
Jayadevan M | 2 | 12 |
| | | Hi,
Documentation at
http://www.postgresql.org/docs/9.1/interactive/datatype-geometric.html#AEN65
66 provides an explanation of the PostgreSQL...
John W. Kitz
|
05-10-2012 12:07 PM
Merlin Moncure | 7 | 14 |
| | | Is there a way to select what authentication was applied when the user
connects to the database? We've recently added LDAP authentication for
our...
Bastiaan Olij
|
05-07-2012 09:40 PM
Bastiaan Olij | 0 | 12 |
| | | Hi
i tried to do streaming replication following the tutorial at
http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial
but i stoped at a...
Caio Boiteux
|
05-07-2012 04:24 PM
Caio Boiteux | 1 | 15 |
| | | My users are presented with a list of checkbox for 4 different attributes
(e.g. type of image, country, etc.)
For type of image they can choose JPG,...
DrYSG
|
05-07-2012 10:14 AM
Daniel Staal | 4 | 16 |
| | | I am beginning with Postgres database.
I create simple table (konta) with two fields
- customer_id char(9)
- customer_name char(45)
I made this SQL...
Ilija Vidoevski
|
05-07-2012 09:11 AM
Merlin Moncure | 1 | 20 |
| | | Hi all,
i am not really sure that this is the right forum, but anyway. We are
running a 200 GB Postgres 9.1 64bit database. We do lots of writing...
Frank Foerster
|
05-07-2012 08:39 AM
Tom Lane | 1 | 16 |
| | | Hi,
I have a problem importing some data. I have created a table with a
column which is called scheduled_depart_time and has the data...
James David Smith
|
05-04-2012 08:55 AM
Tom Lane | 5 | 10 |
| | | Where in the postgres source code should we make changes to run a sql query
like
create table test(a polygon2)
--
Regards,
Bibek behera
IIT Bombay
Bibek Behera
|
05-04-2012 07:21 AM
Willy-Bas Loos | 3 | 14 |
| | | Hi All,
I am trying to do something but cannot find the way.
Hopefully you have some suggestions :)
I have two tables, as follows:
pets: with...
Marta Pérez Romero
|
05-04-2012 06:43 AM
Oliveiros d'Azevedo Cristina | 8 | 13 |
| | | I've got a query that is joining data across 4 tables to provide data
based on test results. The query is working fine, except for the fact
that its...
Lonni J Friedman
|
05-03-2012 10:02 PM
Binand Sethumadhavan | 5 | 19 |
| | | Hi all,
I have a trigger function which is getting invoked on insert/update and
within that trigger I would like to know if some tuple, from a...
pg noob
|
05-03-2012 09:29 AM
Merlin Moncure | 1 | 17 |
| | | Made a SQL query that i run. However the data output is bit nasty to
read since the lenght of it so i want break it into a new line to make
it...
Paul .
|
05-02-2012 05:40 PM
Josh Kupershmidt | 1 | 13 |
| | | Readers,
Is it possible to apply the 'sum' function, but limit the value and
then show the tuples of the result? For example, the table has:
text1,...
e-letter
|
04-29-2012 02:39 PM
e-letter | 5 | 26 |
| | | Hi,
First of all excuse me if i'm not precise enough, english is not my native
language.
I have a small problem while using transactions. I'm doing...
Guillaume Henriot
|
04-25-2012 04:01 PM
Bartosz Dmytrak | 9 | 31 |
| | | Is it possible to use the original table indexes after a join?
I have a query like this:
SELECT lag(bar.d, 1) OVER (foo.a, foo.b, foo.c) FROM foo...
Alex Koay
|
04-25-2012 06:30 AM
Willy-Bas Loos | 1 | 12 |
| | | I'm currently running Postgres version 9.0.1 (haven't gone to 9.0.7 yet
but soon) in a Windows 7 Professional x64 environment.
I run a pg_dump of...
Owen Sleep
|
04-23-2012 12:46 PM
Jim Blizard | 2 | 25 |
| | | My mistake. Here's the other query that required parens in order to use the
index. But you'll see that it was parens in the WHERE clause, not in...
johnmudd
|
04-19-2012 09:31 PM
johnmudd | 0 | 13 |
| | | On 04/19/2012 03:58 PM, johnmudd wrote:
tables. Is it possible that you used a bit of a different
parenthesization, if there is such a word, when...
Steve Crawford
|
04-19-2012 06:31 PM
Steve Crawford | 0 | 13 |
| | | Thanks, that fixed it! That's good news. The bad news is that I had made it a
rule to add the parens because a similar query would "ignore" the an...
johnmudd
|
04-19-2012 05:58 PM
johnmudd | 0 | 11 |
| | | johnmudd <johnbmudd (AT) gmail (DOT) com> writes:
Try it without the parentheses in the ORDER BY. What you're ordering by
there is the expression...
Tom Lane
|
04-19-2012 05:11 PM
Tom Lane | 0 | 8 |
| | | I populated my table, then added the following index. I want to read the
first row based on this index but it takes 3 seconds to get the result....
johnmudd
|
04-19-2012 04:41 PM
johnmudd | 0 | 11 |
| | | Hi all!
I'm trying to understand how the escape_string is supposed to work.
After writing a file ('prova12000.memo') with this single...
Ennio-Sr
|
04-19-2012 11:32 AM
Willy-Bas Loos | 4 | 24 |
| | | Dear PostgreSQL Community,
I just started learning PostgreSQL, and I am trying to develop a extension for postgre using SRF but I am stuck that how...
Bilal Sadiq
|
04-18-2012 02:36 AM
Willy-Bas Loos | 1 | 23 |
| | | I'm trying to get the PGOLEDB to work.
The first issue is that I can't seem to find connection string examples.
I've found several references to...
Ken Benson
|
04-18-2012 02:22 AM
Willy-Bas Loos | 1 | 15 |
| | | On Tue, Apr 17, 2012 at 07:46:26PM +0200, Roberto Caravani wrote:
Hi Robert,
You may need to store a crypographic signature for the data and unique...
ktm@rice.edu
|
04-17-2012 02:18 PM
Tom Lane | 1 | 16 |
| | | Hello to everyone, yesterday I created my first montly partitioned table with
its insert trigger following the specific manual page.
At the moment...
mephysto
|
04-17-2012 02:28 AM
Chetan Suttraway | 3 | 16 |
| | | Le 14/04/2012 11:25, Leif Biberg Kristensen a écrit :
But I don't think that this list is the right place to discuss about that !!
--
Jean...
Jean MAURICE
|
04-16-2012 02:57 PM
Merlin Moncure | 3 | 14 |
| | | Hello Leif,
Thank you for your message - we will use your website as a reference. Yes, it was always our plan to learn PostgreSQL as fast as...
Kevin Salisbury
|
04-16-2012 12:33 PM
Kevin Salisbury | 1 | 11 |
| | | I have been looking at an application I downloaded from Sourceforge for
model railroading. So far it has two strikes against it. It uses
Python 3,...
Bob McConnell
|
04-15-2012 04:37 PM
Monte Milanuk | 5 | 19 |
| | | Fredag 13. april 2012 17.41.41 skrev Kevin Salisbury :
The most important step is to get a thorough grip on PostgreSQL, and
understand what it can...
Leif Biberg Kristensen
|
04-14-2012 04:25 AM
Leif Biberg Kristensen | 0 | 9 |
