| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | 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
|
Yesterday 05:47 AM
Jasen Betts  | 2 | 5 |
| | | 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 03:17 PM
Bjarne Jensen | 0 | 1 |
| | | 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 05:34 AM
Fredrik Jonson | 1 | 2 |
| | | 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
|
12-31-2011 06:40 AM
M. Strobel | 0 | 1 |
| | | 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 05:48 AM
Boris Kolpackov | 0 | 1 |
| | | 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 03:40 AM
Laurenz Albe | 6 | 7 |
| | | 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 03:48 AM
Laurenz Albe | 1 | 2 |
| | | 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
|
11-28-2011 03:42 AM
Laurenz Albe | 1 | 2 |
| | | 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 01:29 PM
Matthew Woodcraft | 3 | 4 |
| | | 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 07:34 AM
durumdara | 10 | 11 |
| | | 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 06:37 AM
Laurenz Albe | 8 | 9 |
| | | 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 07:47 AM
Boris Kolpackov | 0 | 1 |
| | | 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 07:01 AM
Bodo | 9 | 10 |
| | | 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 06:30 AM
M. Strobel | 3 | 4 |
| | | 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 10:21 PM
Mladen Gogala | 14 | 15 |
| | | 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 02:48 AM
Bjarne Jensen | 2 | 3 |
| | | 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 05:09 PM
Username | 1 | 2 |
| | | Need help!
I am going around in circles trying to get a SQL script to run.
I have installed PostgreSQL 9.0 in Ubuntu 11.04.
Beforehand I manually...
gargoyle60
|
08-22-2011 10:59 AM
Laurenz Albe | 13 | 14 |
| | | I have a table with one column as follows:
=# \d+ procedures
Table "public.procedures"
Column | Type | Modifiers | Storage |...
Bjarne Jensen
|
08-08-2011 08:03 AM
Mladen Gogala | 5 | 6 |
| | | Hi,
I am pleased to announce the release of ODB 1.5.0 with support for
PostgreSQL.
ODB is an open-source object-relational mapping (ORM) system for...
Boris Kolpackov
|
07-27-2011 07:12 AM
Boris Kolpackov | 0 | 1 |
 | | Mladen Gogala <no (AT) email (DOT) here.invalid> writes:
That's the manual for a particular compiler. The text I quoted is from
the language...
Username
|
07-07-2011 03:34 AM
Don Y | 56 | 57 |
| | | Is timestamp with timezone a ANSI SQL (or some other) standard data
type ? I noticing a difference in the way it is implemented in
Postgresql and...
vinu
|
06-14-2011 05:43 AM
Laurenz Albe | 3 | 4 |
| | | Is anybody here using Pervasive? What ere the experiences? What are the
key features? I am slightly put off by their website which doesn't do a
swell...
Mladen Gogala
|
06-11-2011 12:24 AM
Mladen Gogala | 0 | 1 |
| | | I had the following statement to...
Mladen Gogala
|
06-09-2011 01:51 PM
Mladen Gogala | 0 | 1 |
| | | I have a partitioned table and the insert statements find the right
partition through the following trigger function:
CREATE OR REPLACE FUNCTION...
Mladen Gogala
|
05-18-2011 02:19 PM
Mladen Gogala | 3 | 4 |
| | | Hi,
I have been unable to understand any of solutions given for this problem. I have a function which creates/use temp tables. On the first query...
Chris Leverkuehn
|
05-11-2011 10:54 AM
Laurenz Albe | 1 | 2 |
| | | Hi,
on http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
{{{
For situations where a small amount of data loss is acceptable in return...
Thomas Guettler
|
05-11-2011 02:53 AM
Thomas Guettler | 2 | 3 |
| | | Good Morning, How do I run the windows Vacuum every day in a given
schedule
Pedro Henrique
|
05-06-2011 10:39 AM
Laurenz Albe | 1 | 2 |
| | | Hi,
I was trying to trap the SQL States as listed in
http://www.postgresql.org/docs/8.2/static/errcodes-appendix.html
in a normal pg/plsql script...
Dog is love
|
05-04-2011 04:21 AM
M. Strobel | 3 | 4 |
| | | Hi,
I am looking for a way to get the database messages and sqlstate
in pltcl, and I can't find it in the docs.
Must be something like "pg_result...
M. Strobel
|
05-04-2011 04:11 AM
M. Strobel | 3 | 4 |
| | | I have been looking at connecing to remote databases (all my databases are on the same machine at
localhost).
After reading the...
gargoyle60
|
05-03-2011 03:39 PM
gargoyle60 | 2 | 3 |
| | | Hi!
I want to ask that is pg supports dynamic usage of SQL, or variable as
SQL (or part of SQL) statement?
:tablename = call...
durumdara
|
05-03-2011 04:04 AM
Laurenz Albe | 1 | 2 |
| | | Hi,
I did not quite understand the use case of timestamp with time zone.
When do you need 'with time zone'? My tests show you can
calculate other...
M. Strobel
|
05-01-2011 07:33 AM
Jasen Betts | 9 | 10 |
| | | Hi all,
I apologize in advance for cross posting and for the rather long post.
I am loading some big tables (three tables with ~580000, ~468000,...
Anselmo Canfora
|
04-07-2011 12:53 PM
Anselmo Canfora | 0 | 1 |
| | | Dear PostgreSQL community,
Compiling the libpq client library (PostgreSQL version 8.4.6) by running
"./configure --without-zlib" and "make...
Julia Jacobson
|
04-01-2011 04:55 PM
Julia Jacobson | 0 | 1 |
| | | All,
I have a table analogous to this:
SALES
Column | Type |...
Chas.
|
03-26-2011 12:34 PM
Robert Klemme | 4 | 5 |
| | | Bonjour,
avez vous de l'expérience dans un Pachira en intérieur (croissance,
maladie, etc.). Qu'en pensez vous ?
merci
Pif - 34
|
03-21-2011 04:08 AM
Pif - 34 | 0 | 1 |
| | | Hi all
If I copy the contents of my PGDATA between installs on Windows and
Mac, will this work ok? Both would be running 9.0.3-1.
Thanks
Jason
Jason Syf
|
03-16-2011 03:06 PM
Harry Tuttle | 1 | 2 |
| | | I've just installed v9.0.3 on Windows XP and taking a quick look at the documentation I notice that
COMMIT is now listed as functional. I recall in...
gargoyle60
|
03-11-2011 08:29 AM
gargoyle60 | 4 | 5 |
| | | Hi,
There are a bunch of "issues" here but I will try to
reduce my question to the most important one(s)...
Almost *every* numeric datum in my...
D Yuniskis
|
03-10-2011 10:46 AM
D Yuniskis | 4 | 5 |
| | | select version()
"PostgreSQL 9.0.1 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit"
Hi,
should a...
Dog is love
|
03-09-2011 05:19 AM
Jasen Betts | 12 | 13 |
| | | Hi All,
I'm stumbling a bit over a concurrent behaviour in postgresql that I
didn't expect, and I wonder if there is a nice workaround to it.
I...
Fredrik Jonson
|
03-08-2011 01:53 AM
Harry Tuttle | 4 | 5 |
| | | Hi,
suppose I want to store log messages in a table, or I want to
have translations of messages in a table. To avoid duplicates,
many programmers...
M. Strobel
|
03-03-2011 01:27 PM
Anselmo Canfora | 5 | 6 |
| | | When trying to get the Windows version,
http://www.postgresql.org/download/windows leads me...
Carl Beck
|
02-26-2011 03:12 AM
Thomas Kellerer | 1 | 2 |
| | | Hi,
I have problem with deadlocks and don't know why it happens. Below is
the log (postgres 9.0, debian):
DETAIL: Process 11882 waits for ShareLock...
Roman
|
02-23-2011 09:34 AM
Mladen Gogala | 2 | 3 |
| | | Hi,
I need to store "dates" -- but, with the capability
of leaving portions as "unknown".
The easiest example I can think of to illustrate
this...
D Yuniskis
|
02-18-2011 07:15 PM
D Yuniskis | 7 | 8 |
| | | HI EVERYONE :
Anyone use xHarbour+SQLRDD connect to PostgreSQL ?
I want to transfer MYSQL to postgreSQL , but I never connect
PostgreSQL successful...
kokookao
|
02-16-2011 03:58 AM
kokookao | 0 | 1 |
| | | On 13 Feb., 10:57, Roy Hann <specia... (AT) processed (DOT) almost.meat> wrote:
one day ;-)
in the meantime you can discuss with Mladen.....
michaelnewport@yahoo.com
|
02-14-2011 01:49 AM
michaelnewport@yahoo.com | 0 | 1 |
| | | On Tue, 08 Feb 2011 14:32:58 -0700, D Yuniskis wrote:
Lovely analogy, but, unfortunately, analogy doesn't produce logically
valid results. How,...
Mladen Gogala
|
02-13-2011 11:58 AM
Mladen Gogala | 10 | 11 |
| | | There have been several high profile departures from EDB. Jim Mlodgensky,
the chief database architect, and Mason Sharp, the author of several...
Mladen Gogala
|
02-06-2011 05:35 PM
Mladen Gogala | 0 | 1 |
