I have a question regarding the behaviour of CREATE DATABASE when used with
TEMPLATE and TABLESPACE options together.
The documentation describes the tablespace parameter as:
The name of the tablespace that will be associated with the new database, or
DEFAULT to use the template database's table
Tim Kane wrote
> The documentation describes the tablespace parameter as:
> The name of the tablespace that will be associated with the new database,
> or
> DEFAULT to use the template database's tablespace. This tablespace will be
> the default tablespace used for objects created in this database.
Tim Kane wrote
> However it seems this is not the case, and that the newly specified
> tablespace will only apply to objects that do not already have a
> tablespace
> defined in the templated database.
Note that all pre-existing objects have a tablespace by definition. If one
is not explicitly pr
Il 26/09/2013 13:27, Tim Kane ha scritto:
I have a question regarding the behaviour of CREATE DATABASE when used
with TEMPLATE and TABLESPACE options together.
The documentation describes the tablespace parameter as:
The name of the tablespace that will be associated with the new
da
On Wed, Sep 25, 2013 at 4:47 PM, Tom Lane wrote:
> Lonni J Friedman writes:
>> If I INSERT a new row into the local table (not the foreign table
>> version), without specifying the 'id' column explicitly, it
>> automatically is assigned the nextval in the sequence counter.
>> However, if I attemp
Hi Shigeru,
Thanks for your reply. This sounds like a relatively simple
workaround, so I'll give it a try. Is the search_path of the remote
session that postgres_fdw forces considered to be intentional,
expected behavior, or is it a bug?
thanks!
On Wed, Sep 25, 2013 at 7:13 PM, Shigeru Hanada
Lonni J Friedman writes:
> Thanks for your reply. This sounds like a relatively simple
> workaround, so I'll give it a try. Is the search_path of the remote
> session that postgres_fdw forces considered to be intentional,
> expected behavior, or is it a bug?
It's intentional.
Possibly more to
On Thu, Sep 26, 2013 at 8:52 AM, Tom Lane wrote:
> Lonni J Friedman writes:
>> Thanks for your reply. This sounds like a relatively simple
>> workaround, so I'll give it a try. Is the search_path of the remote
>> session that postgres_fdw forces considered to be intentional,
>> expected behavio
Greetings!
I've got a query that is behaving strangely, but that's not the reason for this
question. The update results in a trigger being fired, but I don't know which
one. I thought I disabled all of the triggers on the table being updated. So,
I wanted to find the trigger function that co
Greetings,
I've recently pushed a new postgres-9.3 (Linux-x86_64/RHEL6) cluster
into production, with one master, and two hot standby streaming
replication slaves. Everything seems to be working ok, however
roughly half of my pg_basebackup attempts are failing at the very end
with the error:
pg_b
On Thu, Sep 26, 2013 at 9:04 AM, Rob Richardson wrote:
> Select * from pg_proc where lower(prosrc) = '%%'
A slight revision should work:
select distinct proname from pg_proc where prosrc ilike '%%';
Hello All,
I have a string in a program that I have encrypted using Blowfish and I am
now trying to figure out the best way to store that in PostgreSQL so that I
can store it and retrieve it later for decryption. I have searched around
and have not found some good examples of how to go about this
Thanks very much. I was searching for a string containing an upper-case letter
without remembering that I used lower(). And your suggestion of ilike is much
better than like here.
RobR
From: bricklen [mailto:brick...@gmail.com]
Sent: Thursday, September 26, 2013 12:05 PM
To: Rob Richardson
Cc
2013/9/26 Craig Boyd
> Hello All,
>
> I have a string in a program that I have encrypted using Blowfish and I am
> now trying to figure out the best way to store that in PostgreSQL so that I
> can store it and retrieve it later for decryption. I have searched around
> and have not found some goo
Hi, I'm trying to install psycopg2 on a Centos 5, 64-bit machine. I have
both 2.4 and 2.7 Python versions on this machine. I attempted to install
using
easy-install2.7 psycopg2
The install is not working. (I can't import psycopg2 in a python 2.7
session). yum doesn't list it as installed.
Dmitriy,
Thank you very much for the reply!
Right...got the the data type...but how do I actually insert a binary
string into the column? What does the SQL look like?
For the moment assume I have the following bit of binary: 4PO„âÔ™ä²
What does the SQL look like to insert that into the bytea
On Thu, Sep 26, 2013 at 01:01:54PM -0400, Laura Tateosian wrote:
- Hi, I'm trying to install psycopg2 on a Centos 5, 64-bit machine. I have
- both 2.4 and 2.7 Python versions on this machine. I attempted to install
- using
- easy-install2.7 psycopg2
-
- The install is not working. (I can't im
On Thu, Sep 26, 2013 at 1:01 PM, Laura Tateosian wrote:
> Hi, I'm trying to install psycopg2 on a Centos 5, 64-bit machine. I
> have both 2.4 and 2.7 Python versions on this machine. I attempted to
> install using
> easy-install2.7 psycopg2
>
> The install is not working. (I can't import psy
Thanks, for the replies Chris and David.
Chris, I couldn't find any psycopg files under my Python installs, so I
decided to try David's advice and yum install python-psycopg2
It reported success, but it installed it under
../usr/lib64/python2.4/site-packages
I'm working with Python2.7.5, so psyco
Hi,
AIU we have no ability to drop a label from ENUM currently, and there
are no plans to add this feature in the nearest future.
I came to a workaround via DOMAIN, here it is:
CREATE TYPE ref AS ENUM ('aaa', 'bbb');
CREATE DOMAIN refdom AS ref DEFAULT 'aaa';
ALTER TABLE table1 ADD refdom_colu
On Thu, Sep 26, 2013 at 02:56:14PM -0400, Augori wrote:
- Thanks, for the replies Chris and David.
-
- Chris, I couldn't find any psycopg files under my Python installs, so I
- decided to try David's advice and yum install python-psycopg2
- It reported success, but it installed it under
- ../usr/l
Hi,
we are developing a Java based software with Postgres as a DB.
Could someone tell me if there will be a JDBC driver for 9.3 out soon or
is it safe and recommended to use the latest JDBC driver available?
Currently we are using:
PostgreSQL 9.2-1000 JDBC4 (build 1000)
Kind regards
Manuel
--
Ma
On 09/26/2013 11:56 AM, Augori wrote:
Thanks, for the replies Chris and David.
Chris, I couldn't find any psycopg files under my Python installs, so I
decided to try David's advice and yum install python-psycopg2
It reported success, but it installed it under
../usr/lib64/python2.4/site-packages
Okay, I'm sorry for the questions. But I'm really confused about where
things are being installed. I know that yum installed it under 2.4
site-packages because I checked for it inside there before and after I ran
the yum command.
There is an easy_install.pth file under /usr/local/lib/python2.7/s
I have setup pgbouncer successfully on CentOS6, PG9.2
pgbouncer.x86_64 1.5.4-1.rhel6 @pgdg92
I have a question regarding logging:
Currently I have 17MB of log and its growing.
17M -rw-rw-r--. 1 pgbouncer pgbouncer 17M Sep 26 12:17
/var/log/pgbouncer/pgbouncer.log
a) Is there a way (from
On 09/26/2013 02:14 PM, Augori wrote:
Okay, I'm sorry for the questions. But I'm really confused about where
things are being installed. I know that yum installed it under 2.4
site-packages because I checked for it inside there before and after I
ran the yum command.
There is an easy_install.p
On Sep 26, 2013, at 10:55 AM, Craig Boyd wrote:
> Dmitriy,
>
> Thank you very much for the reply!
>
> Right...got the the data type...but how do I actually insert a binary string
> into the column? What does the SQL look like?
> For the moment assume I have the following bit of binary: 4PO
On Sep 26, 2013, at 6:35 AM, "Kohler Manuel"
wrote:
> Hi,
> we are developing a Java based software with Postgres as a DB.
> Could someone tell me if there will be a JDBC driver for 9.3 out soon or
> is it safe and recommended to use the latest JDBC driver available?
> Currently we are using:
>
I think Python 2.4 was installed with the OS. I installed Python 2.7 from
an .egg file that I downloaded. I'm a bit new to this terminology, so not
sure if that considered Centos package management.
I think you're right about Python2.4 being set as the default. Does anyone
know how to persuade
On 9/26/2013 7:07 PM, Augori wrote:
I think you're right about Python2.4 being set as the default. Does
anyone know how to persuade it otherwise for installation purposes?
path.
absolutely do NOT replace the OS distribution python unless you want to
break lots of stuff (for instance, yum o
On 09/24/2013 02:57 AM, Adrian Klaver wrote:
Sort of late in the thread to ask this, but any reason you are not
using the precompiled binaries?
I couldn’t find Postgresql binaries built by MinGW... Do you know if
these binaries already exist?
--
Best Regards,
Muhammad Bashir Al-Noimi
--
Se
Hello all.
I updated my laptop to windows 8.1, my PostgreSQL version is 9.2.3 64 bit.
But my plpython function have "ERROR: ImportError: DLL load failed: A
dynamic link library (DLL) initialization routine failed." after import
pyodbc
My Python version is ActivePython-3.2.2.3-win64-x64, pyodbc ver
On 9/26/2013 7:53 PM, Muhammad Bashir Al-Noimi wrote:
On 09/24/2013 02:57 AM, Adrian Klaver wrote:
Sort of late in the thread to ask this, but any reason you are not
using the precompiled binaries?
I couldn’t find Postgresql binaries built by MinGW... Do you know if
these binaries already exis
On 9/26/2013 8:00 PM, tuanhoanganh wrote:
I updated my laptop to windows 8.1, my PostgreSQL version is 9.2.3 64
bit. But my plpython function have "ERROR: ImportError: DLL load
failed: A dynamic link library (DLL) initialization routine failed."
after import pyodbc
My Python version is Active
On 09/26/2013 07:07 PM, Augori wrote:
I think Python 2.4 was installed with the OS. I installed Python 2.7
from an .egg file that I downloaded. I'm a bit new to this
terminology, so not sure if that considered Centos package management.
No.
I think you're right about Python2.4 being set a
If i run import pyodbc from python command and run pyodbc sql command,
everything work well.
Please help me.
Tuan Hoang Anh
On Fri, Sep 27, 2013 at 10:05 AM, John R Pierce wrote:
> On 9/26/2013 8:00 PM, tuanhoanganh wrote:
>
>>
>> I updated my laptop to windows 8.1, my PostgreSQL version is 9.
I am new to Postgres but not to DBMS.
Running on Postgres 9.1 Ubuntu 13.04.
I log in as Postgres user: psql -h localhost -U postgres
and then I create a db and user and allow grants to the user like this:
create user import_dbms_user with password 'import_dbms';
create database import_dbms_db;
gr
On Sep 26, 2013, at 10:28 PM, mdr wrote:
>
> create user import_dbms_user with password 'import_dbms';
> create database import_dbms_db;
> grant all privileg
> However when I try to run psql from the command line:
> psql -h localhost -U import_dbms_user -WI enter password when prompted
> Passwo
38 matches
Mail list logo
