| | Rating Thread /
Thread Starter | Last Post | Replies | Views |
|  | What query can I use to find out the Postgres server version please?
Thanks
Walter Hurry
|
04-08-2013 05:42 AM
M. Strobel | 4 | 64 |
|  | Googler's Matt Cutts G+ https://plus.google.com/+MattCutts/posts
***************************
Auslogics System Information ...
Enoch Serin Debif
|
04-05-2013 08:08 AM
Enoch Serin Debif | 0 | 15 |
|  | In one of my background applications I keep getting a peer communication error stating that a
timeout occurred on a connection.
The program runs for...
gargoyle60
|
03-01-2013 07:16 AM
gargoyle60 | 3 | 71 |
|  | Hi,
how can I execute a function from another database?
SELECT * FROM dblink('dbname=mydb user=myself password=pw',
'SELECT fc_b_zone(12, 4711)')...
Stefan Wirrer
|
02-20-2013 06:01 AM
Stefan Wirrer | 1 | 51 |
|  | Hi
I need to get a list of pgsql data types like the one when you create a new function. I tried to look in the pg_catalog but to no...
ivan.sammut@credorax.com
|
02-13-2013 11:54 AM
Harry Tuttle | 1 | 52 |
|  | Hi ppl,
I have a function which returns a number of transactions which fall between 2 dates and when I run this in a normal query window it is quite...
ivan.sammut@credorax.com
|
01-15-2013 01:39 AM
Jasen Betts | 2 | 64 |
|  | Hey all,
I am a little rusty on my SQL and Database design. I've been working to
get a basic appplication back up and running, but I've run into...
Aaron W. Hsu
|
01-13-2013 01:04 AM
Jasen Betts | 3 | 39 |
|  | Hi Guys,
I have billions of tree like records in PostgreSQL 9.2 database on RHEL 5 X64, what is the best way to do the query in PostgreSQL, like :...
Ziliang Chen
|
11-23-2012 07:47 AM
Ziliang Chen | 3 | 37 |
|  | Hello,
our current problem is, how to forbid the use of short and/or weak
passwords ("abc123", "password", "1234", ...) by our users and we...
Andreas Kunert
|
11-06-2012 06:29 AM
Andreas Kunert | 0 | 27 |
|  | We just started to use PostgreSQL. For new table entries (type TEXT) we
find line breaks represented as \r\n (the Windows convention), wich is
OK...
Franz Kruse
|
11-01-2012 04:37 PM
Robert Klemme | 5 | 36 |
|  | I am considering various approaches to data backup on single-user standalone desktop Windows (XP)
file system and was wondering if it is safe to...
gargoyle60
|
10-22-2012 03:39 AM
gargoyle60 | 2 | 36 |
|  | Hi,
the psql docs say that a perl trigger can return one of the following:
return;
Execute the statement
"SKIP"
Don't execute the...
Marky Mark
|
09-26-2012 03:05 AM
M. Strobel | 1 | 38 |
|  | Hi,
I am pleased to announce the release of ODB 2.1.0.
ODB is an open source object-relational mapping (ORM) system for C++. It
allows you to...
Boris Kolpackov
|
09-18-2012 07:25 AM
Boris Kolpackov | 0 | 37 |
|  | Hi there,
I want to use a database for storing economic time series.
An economic time series can be thought of as something like this:
NAME ...
st.helldiver@googlemail.com
|
09-04-2012 03:29 PM
st.helldiver@googlemail.com | 0 | 248 |
|  | I am using postgresql 8.1.3 on redhat, and trying to use partitioned
tables to manage a multi-terabyte table. I've created the parent table
and the...
Greg Hennessy
|
08-17-2012 07:30 PM
Jasen Betts | 3 | 186 |
|  | I'm using postgresql 8.1.23 on a redhat 5 machine. I have some tables
that have a schema of:
PS1=# \d tmp_00
Table "public.tmp_00"
Column | Type...
Greg Hennessy
|
08-15-2012 07:59 AM
Greg Hennessy | 2 | 107 |
|  | Hi,
I am a beginner with pgadmin (version 1.14.3).
I would like to make a local DB on my computer.
But I do not manage to connect to serveur, I...
Vulcain
|
08-15-2012 05:07 AM
Vulcain | 2 | 100 |
|  | I have a rather large table (3 TB) that I need to split up.
I can do a bunch of
select yada into tmp_00 from centroids where value=0;
select yada...
Greg Hennessy
|
07-22-2012 05:57 PM
Greg Hennessy | 15 | 176 |
|  | Hi to all,
my mac book pro died and I recover my pg folder from the old HD.
Now under Imac I've tried to recover data replacing my data folder under...
pyarchinit@gmail.com
|
07-21-2012 06:37 AM
Jasen Betts | 1 | 103 |
|  | China Blue , Meersburg <chine.bleu (AT) yahoo (DOT) com> wrote:
You have to mark the beginning and the end of the code, usually...
Lennart Jonsson
|
07-10-2012 08:55 AM
Matthew Woodcraft | 4 | 117 |
|  | anyone doing this?
all logic in tables n db and html templated in the db?
quiet_lad
|
07-02-2012 07:09 PM
quiet_lad | 0 | 182 |
|  | Hi,
I have a custom base type that relies heavily on caching
for many of the functions derived from those values. I'm
looking for suggestions as to...
Don Y
|
06-28-2012 01:06 PM
Don Y | 0 | 200 |
|  | I've got a composite field:
CREATE TYPE my_type AS (
part1 varchar,
part2, varchar
);
and I'm going a db conversion that is taking an existing...
Steve Rogerson
|
06-28-2012 07:09 AM
Jasen Betts | 1 | 175 |
|  | Hi
I know postgresql but not enough to solve the following problem:
Here is a table with the fields: name char(20), c1 char(1), c2 char (1)
The...
meta
|
06-22-2012 04:46 PM
meta | 5 | 148 |
|  | Can you please help with advice?
I need to design a solution for a database which will grow and will requirea horizontal split at some moment.
Here...
igor.shmain@gmail.com
|
06-04-2012 06:17 PM
Mladen Gogala | 2 | 160 |
|  | Hi, I have a question about using SQL to check the missing values of over 400 fields. I really don't want to run a select sentence for each field. I...
Kenneth Zhang
|
05-25-2012 01:31 PM
Kenneth Zhang | 0 | 175 |
|  | I am pleased to announce the release of ODB 2.0.0.
ODB is an open source object-relational mapping (ORM) system for C++. It
allows you to persist...
Boris Kolpackov
|
05-02-2012 07:35 AM
Boris Kolpackov | 0 | 150 |
|  | Hi,
I'm stuck with a (maybe simple) problem of JOINing two tables.. The thing is that I need to join these tables on two different columns.
Let's...
Mateusz
|
04-12-2012 01:38 PM
Robert Klemme | 26 | 336 |
|  | Hi all,
I'm just wondering, what is the equivalent of the Oracle
Wait Interface (i.e. the V$<View_Name> system) in PostgreSQL?
TIA and...
Pol
|
03-22-2012 11:04 PM
Mladen Gogala | 3 | 154 |
|  | Le 15/03/2012 02:25, Mladen Gogala a écrit :
Good morning,
Sorry about my french explanation.
There was no old news in my reader and i have...
bcar
|
03-16-2012 04:49 AM
Jasen Betts | 2 | 152 |
|  | Having the choice is a good thing, but I wouldn't want to use a DBMS that is so crippled when it comes to SQL features as MySQL (CTE, recursive...
Mladen Gogala
|
02-18-2012 03:07 PM
Hans Castorp | 5 | 208 |
|  | Hi,
While in() and out() routines are required for a type,
recv() and send() are "optional".
Could someone clarify when recv/send are used in...
Don Y
|
02-14-2012 11:57 PM
Don Y | 4 | 130 |
|  | Hi,
I have a few types that aren't economically supported in
PostgreSQL that I'll be implementing as "user-defined
types" (NOT "composite types"). ...
Don Y
|
02-14-2012 09:53 PM
Don Y | 2 | 146 |
|  | Just installed it to my Windows 7. (During installation it alerted
about fatal error but it completed anyway), it has a NT service but
failed to...
justaguy
|
02-14-2012 11:50 AM
Mladen Gogala | 2 | 145 |
|  | Hi,
In my project I changed all timestamp columns to timestamp with
time zone.
I am used to test a lot using psql. Now the display of...
M. Strobel
|
02-10-2012 02:56 AM
Marcos PPa PPe | 1 | 141 |
|  | Hi,
For "non-standard" types (e.g., composite, user-defined), is there
any way of teasing the definition out of the system catalog?
E.g.,
CREATE...
Don Y
|
02-08-2012 02:18 AM
Don Y | 4 | 145 |
|  | I use to_char(real_value, 'FM999.9') to cut off the 2nd and subsequent
decimals.
Is there a way to format the above output so that negative...
Bjarne Jensen
|
01-23-2012 02:17 PM
Bjarne Jensen | 0 | 151 |
|  | Hello,
We gave a Postgres 8.4 database running under Linux Centos 5.4 and
defined so :
ENCODING = 'SQL_ASCII'
TABLESPACE = pg_default
LC_COLLATE =...
Alain Reymond
|
01-19-2012 04:34 AM
Fredrik Jonson | 1 | 117 |
|  | Hi,
I am pleased to announce the release of ODB 1.7.0.
ODB is an open-source object-relational mapping (ORM) system for C++. It
allows you to...
Boris Kolpackov
|
12-07-2011 04:48 AM
Boris Kolpackov | 0 | 150 |
|  | On Nov 25, 7:54*pm, Matt <hfr... (AT) syrius (DOT) org.invalid> wrote:
Thanks for the idea of postgresql, bad experience. It took 10+
minutes to...
justaguy
|
12-02-2011 02:40 AM
Laurenz Albe | 6 | 112 |
|  | Hi,
I'm installing postgresql (9.1) to my Windows 7, half way through my
system prompted me for permission to allow bcdedit.exe or not? What's
this...
justaguy
|
11-28-2011 02:48 AM
Laurenz Albe | 1 | 209 |
|  | Hi @ all,
When I do a "SELECT * FROM myTable WHERE ..." using psql I want to have
the columns displayed in a meaningful order by default. I want to...
Michael Hufschmidt
|
11-04-2011 12:29 PM
Matthew Woodcraft | 3 | 126 |
|  | Hi!
I continue the old theme what is named "When the session ends":
http://archives.postgresql.org/pgsql-general/2011-06/msg00913.php
I want to...
durumdara
|
11-03-2011 06:34 AM
durumdara | 10 | 183 |
|  | Hi,
Given largely static tables (etc.), how much of ./data
can I move onto R/O media? And, which types of operations
would a user then have to...
Don Y
|
10-25-2011 05:37 AM
Laurenz Albe | 8 | 131 |
|  | Hi,
I am pleased to announce the release of ODB 1.6.0.
ODB is an open-source object-relational mapping (ORM) system for C++. It
allows you to...
Boris Kolpackov
|
10-04-2011 06:47 AM
Boris Kolpackov | 0 | 129 |
|  | Yeah, they do. I'm most of the way through repairing a 57G table which
takes about a day and a half.
Hmmn. This suggests that you might want to...
Ignoramus5263
|
09-23-2011 06:01 AM
Bodo | 9 | 127 |
|  | Hi,
I just can not find the set based sql approach to the following
application logic:
I have a table of choices with id and text, say:
1 coffee
2...
M. Strobel
|
09-10-2011 05:30 AM
M. Strobel | 3 | 125 |
|  | I'm using Postgres and the end-users are complaining that the search
features provided by the web app are case-sensitive (via Postgres). Is
there a...
RVince
|
09-05-2011 09:21 PM
Mladen Gogala | 14 | 184 |
|  | I get a "new" database every 4 weeks. They all have the same schema.
I need to find out what changes were done to certain tables from one
issue to...
Bjarne Jensen
|
08-29-2011 01:48 AM
Bjarne Jensen | 2 | 126 |
|  | Hi folks,
I am trying to make regular ERD's of a changing PostgreSQL DB
available to developers at my organization.
Two questions:
1. Is there a...
Elisa
|
08-22-2011 04:09 PM
Username | 1 | 113 |