My DB is UTF8 and I cannot change it. When I try to insert accent letters like è ò ... I get Query failed: ERROR: invalid byte sequence for encoding...

aaaawwww

07-03-2010 08:46 AM
aaaawwww

What does optimizer do when it encounters a bind variable? Does it have a method of "peeking", like some other databases or it has some...

Mladen Gogala

07-02-2010 01:42 PM
Mladen Gogala

Hi, since there is a md5 function in PG, does anybody know if there is a plan to add the support for SHA family digest functions in PG>9?

Anselmo Canfora

06-29-2010 05:03 AM
Anselmo Canfora

I have one database (e.g. database1) with two schemas (e.g. schema1 and schema2). Each schema has distinct tables. For some reason my barin is...

gargoyle60

06-28-2010 04:35 AM
gargoyle60

I am a long time user of the PHP version of the library. Python version requires Psycopg while there is only Psycopg2. I tried importing as another...

Mladen Gogala

06-25-2010 07:59 AM
Mladen Gogala

Hi! I'm new to postgres and want to do something like select substring('MTWTFSS', from (Extract (dow from current_date)), for 1) I can't get the...

danfan46

06-19-2010 02:25 AM
danfan46

All the online resources I've found so far indicate that the way to call a function is through a query, eg, SELECT myFunction(parameter) Is there a...

Soral42

06-15-2010 06:31 PM
Soral42

anyone using scheme and postgresql? nice combo? is memcached needed?

quiet_lad

06-14-2010 05:34 PM
Mladen Gogala

my dba is importing some stuff with ora2pg.pl he gets this error: # xrealloc: cannot reallocate 1239560064 bytes (0 bytes allocated) what is...

quiet_lad

06-14-2010 01:21 PM
quiet_lad

I know that I can write one, using the information_schema or pg_catalog information, preferably the latter, and get DDL for tables, indexes...

Mladen Gogala

06-14-2010 01:10 AM
Thomas Kellerer

On 2010-06-13 10:54, Mladen Gogala wrote: I have very little experience with psql, but psql's behaviour seems similar to other vendors in this...

Lennart Jonsson

06-13-2010 08:21 AM
Matthew Woodcraft

Battleground was a machine running CentOS 5.5 and the two towers were 2 databases. First, PostgreSQL 8.4.4: scott=# select count(*) from emp e1,emp...

Mladen Gogala

06-09-2010 07:28 AM
Mladen Gogala

Watch the latest video in the DB2 vs. Oracle series. This one is an animated tale of two peasants from the “Village of Orrible” who want to break...

Anil Mahadev

06-02-2010 11:07 AM
Anil Mahadev

With Gartner's Business Intelligence group listing In-Memory analytics at the top of their recommended Business Intelligence requirements...

JTP PR

05-27-2010 07:15 AM
JTP PR

I am trying to create a Sphinx index on a fairly large Postgres table. My problem is the fact that the Postgres API is trying to put the...

Mladen Gogala

05-23-2010 05:22 PM
Mladen Gogala

One of my developers asked me for an equivalent to Oracle's "CONNECT BY" clause. Sure enough, there is a module called "tablefunc" which...

Mladen Gogala

05-22-2010 12:16 AM
Lennart Jonsson

For private databases, I'd like to create a tablespace in my encrypted /home directory. However, /home is only mounted on demand (through...

Michael Schuerig

05-10-2010 09:39 AM
Mladen Gogala

How does the PG back end treat local connections differently than it does TCP/IP connections? I'm using dbi-link to connect to a remote Oracle...

Barry Kline

05-09-2010 05:28 PM
Barry Kline

Hi, Take a look at this piece of code: create table tmp (a integer); create or replace function fun() returns void as $$ declare c cursor for...

kmehkeri

05-04-2010 03:35 AM
Jasen Betts

Hi, Goal: I am trying to offer a client of mine a full database export download for their database (scheme and data). The environment:...

Erwin Moller

04-28-2010 12:51 AM
Erwin Moller

Seeking help understanding Postgres rules and why my rule doesn't work. I have a table for 'person' and a person can have one or more...

KM

04-22-2010 09:37 AM
Mladen Gogala

Hello, I was wondering about using the IN operator with check constraints to restrict the values of a column to a certain number of...

Karsten Wutzke

04-14-2010 02:07 PM
Robert Klemme

Hi, I am using a combination of file based backup of my postgresql cluster location, and WAL archiving as my main backup system for my...

Jeroen Wilke

04-07-2010 04:18 AM
Jeroen Wilke

Hello, it's rather a standard SQL or best practices question I have: Given a column "name" in a table CREATE TABLE Prepositions ( name VARCHAR(4)...

Karsten Wutzke

04-01-2010 05:26 PM
Thomas Kellerer

Oracle Buys EnterpriseDB Redwood Shores, CA - April 1, 2010 Oracle Corporation (NASDAQ: ORCL) and EnterpriseDB announced today they have entered...

Mladen Gogala

04-01-2010 12:53 PM
Mladen Gogala

Hi, I am just wondering how to have safe parameters avoiding to use parametrized queries. How to behave quote_literal against sql injection attempts?...

news

03-31-2010 09:30 AM
Laurenz Albe

I have postgressQL installed on my desktop for a poker program I want to access that database using the aame program installed on my laptop over my...

Arizona Willie

03-30-2010 02:37 PM
Arizona Willie

Hi, I am just wondering how to have safe parameters avoiding to use parametrized queries. How behaves quote_literal against sql injection attempts?...

news

03-29-2010 11:45 AM
news

Hello, My principale database is Postgres. I use a other database (no postgres) and i want "Synchronize" some tables. So i wrote a trigger in one...

JFT

03-29-2010 11:17 AM
Laurenz Albe

I have a view view1 with a column foo, among others. A rule intercepts an update on view1. Is there a way for the rule to distinguish between *...

KM

03-23-2010 03:22 AM
news

Can I somehow force PogSQL to do direct I/O on Ext3 file system? All those FS buffers are messing up free memory and swap...

Mladen Gogala

03-18-2010 08:31 PM
Mladen Gogala

Is there any way that I can trace a session from start to finish, recording each and every SQL, along with the duration, CPU consumption and,...

Mladen Gogala

03-18-2010 11:06 AM
Laurenz Albe

Hello, I'm searching for a solution for the following problem for several hours. But I can't find any example which corresponds to my Problem. With...

Volker Boehm

03-12-2010 03:09 AM
Laurenz Albe

Assuming I want to build a web based data repository to store, serve and provide interaction for all different kinds of datasets, possibly holding up...

André

03-11-2010 01:28 PM
Mladen Gogala

Assuming I want to build a web based data repository to store and serve all different kinds of datasets, possibly holding up to 1 million different...

André

03-11-2010 09:50 AM
André

I'm trying to combind a cascading delete and a constraint deferal. The hope is to have a cascading delete to clean up data, but only after a commit. ...

Paul

03-04-2010 09:37 AM
Laurenz Albe

Does anybody here know what is the definition of the DB block format and in which source file can I find it? Also, where in the source can I find the...

Mladen Gogala

03-01-2010 07:23 AM
Laurenz Albe

Hi,here: http://www.postgresql.org/docs/8.3/static/plpgsql-statements.html I can read that the FOUND variable it is set by any plain sql...

news

02-22-2010 12:58 PM
Mladen Gogala

Hi, does date_trunc return values related to current timezone? see this: db_atm=# select extract('epoch' from date_trunc('day', 'epoch'::timestamp...

news

02-18-2010 07:11 AM
news

Does anybody here has any experience with that? Any remarks, praises or words of caution? Postgres search engine seems to be unable to cope...

Mladen Gogala

02-12-2010 04:12 PM
Mladen Gogala

Where can I find the list of separator characters for the configuration named "english"? In other words, I need the list of characters which delimit...

Mladen Gogala

02-11-2010 08:30 AM
Laurenz Albe

I have a huge table, containing a text column and having text indexes, with 22 million rows. The table is partitioned into 4 tables. Is...

Mladen Gogala

02-04-2010 03:43 AM
Laurenz Albe

Hi, is this a bug or am I misunderstanding something? db_atm=# select length(to_char(552020, '000000000')); length -------- 10 (1 row) in my...

Anselmo Canfora

02-04-2010 02:49 AM
Anselmo Canfora

I am stuck to Postgres 8.3 because there is no pljava for the version 8.4, at least not in the RPM form. There are significant changes in 8.4.2 with...

Mladen Gogala

02-01-2010 01:34 PM
Mladen Gogala

I am looking into the PostgreSQL dictionary. The view pg_stat_activity is the PgSQL version of v$session. There are interesting views...

Mladen Gogala

01-28-2010 10:12 AM
Mladen Gogala

Hi, is it possible to join a table/view with table function, which has parameters? Something like select u.*, func_result.* from users u left join...

Pavel Chudnovskyy

01-28-2010 07:32 AM
Laurenz Albe

I created a trigger on a table and pg_trigger table will not show it as enabled. Here is the illustration. news_archive=# create trigger...

Mladen Gogala

01-27-2010 04:14 AM
Laurenz Albe

Hi every body, If : create table T(id int, x int, ..., ... ); alter table T alter id set default nextval('my_sequence'); alter table T alter x set...

LoZ

01-26-2010 12:54 AM
Laurenz Albe

Hi, just a curiosity, how does PG manage PL/Perl? Is it loaded on the same process space of PG (a la mod_perl) or is it called via IPC? This question...

Anselmo Canfora

01-25-2010 08:46 AM
Laurenz Albe

Hi, is there a way to have a default index name for columns? for example, instead of writing: create index foo on bar (foo); write only: create...

Anselmo Canfora

01-25-2010 06:56 AM
Anselmo Canfora