Best unofficial Apache Server developers community |
Home >> discussions >> PostgreSQL beginners help
PostgreSQL beginners help Recent threads
| Threads | Replies | First post | Last post | |
|---|---|---|---|---|
|
return values(table) from stored function from MS visual foxpro By: Ilija Vidoevski 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)
CREATE OR REPLACE FUNCTION public.a_getkonta_table ( mkontoa char,
mkontob char ) RETURNS TABLE ( konto…
|
4 | May 24 2012 05:49 |
May 25 2012 07:49 |
|
|
Unknown winsock error 10061 By: Susanne Ebrecht Hello, PostgreSQL 9.0, Windows 2008 32 different PostGIS Databases
round about 20 active connections by duration max_connections = 100
Memory load around 30% CPUs load around 50% Network load less then 20%
No firewall installed at all Randomly…
|
0 | May 24 2012 04:15 |
May 24 2012 04:15 |
|
|
Installing PGCRYPTO and using functions By: Anoop Koshy 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 sensitive columns. I have created the necessary bytea columns,
run the pgcrypto SQL (without any…
|
0 | May 24 2012 02:01 |
May 24 2012 02:01 |
|
|
Page Usage Information By: Alejandro Barragan 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 see that pages have a PageHeader that holds most of
the information that I would like to store. …
|
1 | May 18 2012 13:11 |
May 23 2012 06:52 |
|
|
Re: How to compute percentages By: Oliveiros d'Azevedo Cristina This is a multi-part message in MIME format. Hi, Sindile, Could you
please try this variation of your own query, please? Best, Oliver
SELECT cl1, count(cl2) as no_accounts, count(cl2) * 100.0 / (SELECT
count(cl2) FROM tbl1) as…
|
0 | May 23 2012 06:40 |
May 23 2012 06:40 |
|
|
How to compute percentages By: Sindile Bidla I have a query that is like this: SELECT cl1, count(cl2) as
no_accounts, sum(cl2) as consumption FROM tbl1 WHERE cl2 != 0 GROUP BY
cl1 ORDER BY cl1; this gives me the following output cl1
no_accounts consumption a 2 …
|
1 | May 23 2012 06:24 |
May 23 2012 06:39 |
|
|
SELECT FROM 'varying_table' By: Nart Tamash 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 trigger function that would serve a trigger that fires
every time a new table is inserted in the database.…
|
1 | May 18 2012 08:04 |
May 22 2012 02:34 |
|
|
PG_DUMP producing incorrect SQL By: Lindsay.braine I am sure I am doing something wrong - because I cannot find anything
about this on Google or in the Community Archives - but here goes: I
am running postgres-9.1.3 I have one database, two schemas. When
using pg_dump -format plain to create an…
|
1 | May 17 2012 12:40 |
May 22 2012 02:11 |
|
|
EXPLAIN ANALYZE in batch file By: michel wildcat 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 consumming. I would like to do it at once and send the
results to a single file. can anybody help me…
|
1 | May 19 2012 04:03 |
May 22 2012 01:58 |
|
|
Fwd: sequential explain analyze command execution By: michel wildcat ---------- Forwarded message
|
0 | May 21 2012 14:42 |
May 21 2012 14:42 |
|
|
sequential explain analyze command execution By: michel wildcat hello, I am working with PostgreSQL 9 in windows (pgAdmin3) and I'm
trying to execute distinct EXPLAIN ANALYZE command on some queries
that are really time consumming, and send the results to a single
file. can anybody help me to solve this please?…
|
1 | May 19 2012 06:15 |
May 19 2012 22:00 |
|
|
Updating a chkpass column in postgres v8.1.21 By: Nelson, Howard C 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 what I have read, chkpass became a "contrib module" starting
at 8.3, but I have to use an older…
|
1 | May 17 2012 12:45 |
May 17 2012 13:45 |
|
|
Re: remote connection problem By: Valentin Gjorgjioski On 17.05.2012 11:27 Michael Wood wrote: > Hi > > On 17 May
2012 09:28, Ilija Vidoevski<ili### @fructal.com.mk> wrote:
>> Thank's Michael. >> >> How can I be so blind.
Connection is made. > > Good. > >>…
|
0 | May 17 2012 05:47 |
May 17 2012 05:47 |
|
|
Re: remote connection problem By: Ilija Vidoevski This is a multi-part message in MIME format. Thank's Michael. How
can I be so blind. Connection is made. But speed through LAN is
disaster. On the PC where postgresql server is installed, postgre is
little slower then MS SqlSerever 2008 r2…
|
0 | May 17 2012 05:27 |
May 17 2012 05:27 |
|
|
Re: remote connection problem By: Michael Wood Hi On 17 May 2012 09:28, Ilija Vidoevski <il###
@fructal.com.mk> wrote: > Thank's Michael. > > How can I
be so blind. Connection is made. Good. > But speed through LAN is
disaster. > On the PC where postgresql server is…
|
0 | May 17 2012 04:28 |
May 17 2012 04:28 |
|
|
Text search language field By: Daniel Staal 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 a bit smoother. Only one of the top requirements is that
this has to be multi-lingual, so I…
|
2 | May 12 2012 19:09 |
May 16 2012 18:36 |
|
|
remote connection problem By: Ilija Vidoevski This is a multi-part message in MIME format. 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
connection when work on PC where is postgresql server…
|
3 | May 16 2012 10:04 |
May 16 2012 16:26 |
|
|
How to select by proximity By: Francisco Leovey 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 order How can I retrieve the prior and next in
order? Is there a goto "Marriot" and then a goto +1…
|
4 | May 14 2012 13:01 |
May 15 2012 12:52 |
|
|
Console Output By: Alejandro Barragan 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 the buffer manager (specifically in bufmgr.c) is the best
place to access this information and I believe…
|
0 | May 15 2012 12:14 |
May 15 2012 12:14 |
|
|
Unwanted time zone conversion By: Rob Richardson 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 their database on my machine instead of wrestling with a
VNC connection half way around the world. …
|
2 | May 14 2012 08:53 |
May 14 2012 10:47 |