On Wed, 2010-09-29 at 21:57 -0500, Karl Denninger wrote:
That's actually ok - the update itself is a legitimate statement on the
master, posted to that table on a reply, and is part of a transaction.
Even if it's part of a transaction, you still have a race condition,
unless you're using a
Can you send the installation log (%TEMP%\install-postgresql.log)?
In case, Have you used the uninstaller to uninstall the previous instance or
manually removed the directories?
On Sep 30, 2010, at 12:53 PM, Vishnu S. wrote:
Hi,
I have uninstalled the PostgreSQL 8.4 and removed the
On Thu, Sep 30, 2010 at 00:55, Dave Page dp...@pgadmin.org wrote:
On Wed, Sep 29, 2010 at 7:23 PM, Turner, John J
jjtur...@statestreet.com wrote:
Hello,
I’ve installed the PostgreSQL 9.0 binary package for Windows XP 32-bit and
I’m trying to install the temporal extension module available in
Hi Peter,
We tried to reproduce this issue but could not do so. We have tried both the
cases but both were not reproducible. Can you please provide more
information which can help us in reproducing the issue,
Thanks,
Dharmendra
From: Dr. Peter Voigt pvo...@uos.de
Date: Tue, Sep 28, 2010 at
[Please keep the thread on the mailing list]
From the logs, the initdb is successful but there were some error while
creating the postgres service. I believe you are not using the latest 8.4.4
installer as that installer has some detailed logging which is helpful in
realizing where exactly is
Hi all.
This is my case:
-- begin snippet --
reset search_path;
drop table if exists session cascade;
create table session ( name text primary key, valu text not null );
create or replace function session_init()
returns void
language plpgsql
as $body$
declare
t text;
begin
select valu into
I have a query that returns many columns but few rows. I would like to
display output horizontally instead of vertically, i.e. rotating by 90
degress, so column headings appear in the left margin, and the output is not
'wrapped'.
Is this possible? I have had no luck searching for this as rotate
Ben Carbery wrote:
I have a query that returns many columns but few rows. I would like to
display output horizontally instead of vertically, i.e. rotating by 90
degress, so column headings appear in the left margin, and the output is
not 'wrapped'.
Is this possible? I have had no luck
On Thu, 2010-09-30 at 21:17 +1000, Ben Carbery wrote:
I have a query that returns many columns but few rows. I would like to
display output horizontally instead of vertically, i.e. rotating by 90
degress, so column headings appear in the left margin, and the output
is not
'wrapped'.
Is this
On Thu, Sep 30, 2010 at 9:19 PM, Tommy Gildseth
tommy.gilds...@usit.uio.nowrote:
Ben Carbery wrote:
I have a query that returns many columns but few rows. I would like to
display output horizontally instead of vertically, i.e. rotating by 90
degress, so column headings appear in the left
2010/9/30 Ben Carbery ben.carb...@gmail.com:
Strange if this can't be done, I would have thought it a common request!
Just curiosity. Is there any other DB capable of such a thing?
--
Vincenzo Romano at NotOrAnd Information Technologies
Software Hardware Networking Training Support Security
--
On 30/09/2010 12:17, Ben Carbery wrote:
I have a query that returns many columns but few rows. I would like to
display output horizontally instead of vertically, i.e. rotating by 90
degress, so column headings appear in the left margin, and the output is
not 'wrapped'.
Is this possible? I have
2010/9/30 Raymond O'Donnell r...@iol.ie:
On 30/09/2010 12:17, Ben Carbery wrote:
Googling on sql swap rows columns found this:
http://stackoverflow.com/questions/584232/t-sql-how-to-swap-rows-and-columns
...which you'll be able to adapt.
We also have the fantastic crosstab in tablefunc
On Thu, Sep 30, 2010 at 9:36 PM, Vincenzo Romano
vincenzo.rom...@notorand.it wrote:
2010/9/30 Raymond O'Donnell r...@iol.ie:
On 30/09/2010 12:17, Ben Carbery wrote:
Googling on sql swap rows columns found this:
2010/9/30 Ben Carbery ben.carb...@gmail.com:
On Thu, Sep 30, 2010 at 9:36 PM, Vincenzo Romano
vincenzo.rom...@notorand.it wrote:
We also have the fantastic crosstab in tablefunc module (see chapter
F.36.1.4 for v9.0.0)
..but these seem to be more pivot table functions that alter the data,
Hi list,
I'm trying the new features into a test environment for see how all
works and I'm finding first problems with setup.
After reading the various Streaming_Replication, Warm_Standby and
What's_new_in_PostgreSQL_9.0 on the wiki, one first question born: both
server (master and standby) need
Hi Dharmendra,
thanks for your reply. This kind of errors, which cannot be reproduced
on other machines are bad and leave no chance for developers to solve
them.
Unfortunately the installer does not leave any log files. The Windows
event log has no entries about the installation attempt as well.
On Thu, Sep 30, 2010 at 1:42 PM, Dr. Peter Voigt pvo...@uos.de wrote:
Hi Dharmendra,
thanks for your reply. This kind of errors, which cannot be reproduced
on other machines are bad and leave no chance for developers to solve
them.
Unfortunately the installer does not leave any log files.
On 30/09/2010 12:31, Vincenzo Romano wrote:
2010/9/30 Ben Carbery ben.carb...@gmail.com:
Strange if this can't be done, I would have thought it a common request!
Just curiosity. Is there any other DB capable of such a thing?
MySQL does this using an alternate end-of-statement character:
Hi,
I have uninstalled the PostgreSQL 8.4 and removed the related
directories from the system. Again I have installed the PostgreSQL 8.4
on the same folder. Now the PostgreSQL server is not starting. When I
tried to start the postgreSQL service from the Windows Service manager,
the
Hi,
On starting the server using pg_ctl command the following message is
shown.
server starting
C:\Program Files\PostgreSQL\8.4\bin2010-09-30 14:36:07 ISTLOG: could
not create file postmaster.opts: Permission denied.
Thanks Regards,
Vishnu S
From: Sachin
-Original Message-
From: Thom Brown [mailto:t...@linux.com]
Sent: Wednesday, September 29, 2010 2:08 PM
To: PGSQL Mailing List
Subject: Prepared statements and unknown types
Could someone explain why the following doesn't work?
test=# PREPARE meow(unknown) AS
test-# SELECT
Vincenzo Romano vincenzo.rom...@notorand.it writes:
create or replace function session_init()
returns void
language plpgsql
as $body$
declare
t text;
begin
select valu into t from session where name='SESSION_ID';
if not found then
create temporary table session ( like
2010/9/30 Tom Lane t...@sss.pgh.pa.us:
Vincenzo Romano vincenzo.rom...@notorand.it writes:
create or replace function session_init()
returns void
language plpgsql
as $body$
declare
t text;
begin
select valu into t from session where name='SESSION_ID';
if not found then
create
Hello
2010/9/30 Tom Lane t...@sss.pgh.pa.us:
Vincenzo Romano vincenzo.rom...@notorand.it writes:
create or replace function session_init()
returns void
language plpgsql
as $body$
declare
t text;
begin
select valu into t from session where name='SESSION_ID';
if not found then
2010/9/30 Pavel Stehule pavel.steh...@gmail.com:
Hello
2010/9/30 Tom Lane t...@sss.pgh.pa.us:
Vincenzo Romano vincenzo.rom...@notorand.it writes:
create or replace function session_init()
returns void
language plpgsql
as $body$
declare
t text;
begin
select valu into t from session
On 9/30/2010 8:52 AM, Vincenzo Romano wrote:
I was also thinking about using the catalog, but it looked to me
easier my way.
And, of course, if you have better advises for a session variables
solution, my ears are open.
More of a question: why use temp tables at all? What does that offer
On Thu, Sep 30, 2010 at 5:09 AM, Vishnu S. vishn...@nestgroup.net wrote:
On starting the server using pg_ctl command the following message is shown.
server starting
C:\Program Files\PostgreSQL\8.4\bin2010-09-30 14:36:07 ISTLOG: could not
create file postmaster.opts: Permission denied.
you can pass in/out very large set of data inside a transaction by
using temp tables. Temporary tables are one of the greatest features
of SQL dbs.
Here's one fact, it most often takes as long to transfer data from/to
a query/function as it takes to execute it. By storing data on the
server side,
2010/9/30 Andy Colson a...@squeakycode.net:
On 9/30/2010 8:52 AM, Vincenzo Romano wrote:
I was also thinking about using the catalog, but it looked to me
easier my way.
And, of course, if you have better advises for a session variables
solution, my ears are open.
More of a question: why
Hello
2010/9/30 Vincenzo Romano vincenzo.rom...@notorand.it:
2010/9/30 Pavel Stehule pavel.steh...@gmail.com:
Hello
2010/9/30 Tom Lane t...@sss.pgh.pa.us:
Vincenzo Romano vincenzo.rom...@notorand.it writes:
create or replace function session_init()
returns void
language plpgsql
as $body$
2010/9/30 Pavel Stehule pavel.steh...@gmail.com:
Hello
but if you need a session variables, then you can use a plperl
http://www.postgresql.org/docs/9.0/static/plperl-global.html
I will look into this. What I need is a set of variable for each connection.
understand - attention - session
Hello,
I'm using phpBB 3.0.7-PL1 with postgresql-server-8.1.21-1.el5_5.1 with
CentOS Linux 5.5, both under 32-bit (dev. VM) and 64-bit (prod. server)
One of the phpBB sub-forums grows quickly every day and I have problems
cleaning old messages there, because its phpBB's admin-script bails out
2010/9/30 Vincenzo Romano vincenzo.rom...@notorand.it:
2010/9/30 Pavel Stehule pavel.steh...@gmail.com:
Hello
but if you need a session variables, then you can use a plperl
http://www.postgresql.org/docs/9.0/static/plperl-global.html
I will look into this. What I need is a set of variable
2010/9/30 Pavel Stehule pavel.steh...@gmail.com:
2010/9/30 Vincenzo Romano vincenzo.rom...@notorand.it:
2010/9/30 Pavel Stehule pavel.steh...@gmail.com:
Hello
but if you need a session variables, then you can use a plperl
http://www.postgresql.org/docs/9.0/static/plperl-global.html
I will
On 30 September 2010 14:36, Igor Neyman iney...@perceptron.com wrote:
-Original Message-
From: Thom Brown [mailto:t...@linux.com]
Sent: Wednesday, September 29, 2010 2:08 PM
To: PGSQL Mailing List
Subject: Prepared statements and unknown types
Could someone explain why the following
2010/9/30 Vincenzo Romano vincenzo.rom...@notorand.it:
2010/9/30 Pavel Stehule pavel.steh...@gmail.com:
2010/9/30 Vincenzo Romano vincenzo.rom...@notorand.it:
2010/9/30 Pavel Stehule pavel.steh...@gmail.com:
Hello
but if you need a session variables, then you can use a plperl
Hi there,
I'm sitting for days now, and I can't get this to work:
I want to insert binary data (bytea) into my postgres DB via the c++ libpq.
What I have is a char* (actually a QByteArray) and I want to insert it
into the DB and the retrieve it from there again.
I can't find any good
2010/9/30 GOO Creations goocreati...@gmail.com:
Hi there,
I'm sitting for days now, and I can't get this to work:
I want to insert binary data (bytea) into my postgres DB via the c++ libpq.
What I have is a char* (actually a QByteArray) and I want to insert it into
the DB and the retrieve
If you use QT, it has PG connector classes I believe (it had in 3.x).
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2010/9/30 Vincenzo Romano vincenzo.rom...@notorand.it:
2010/9/30 GOO Creations goocreati...@gmail.com:
Hi there,
I'm sitting for days now, and I can't get this to work:
I want to insert binary data (bytea) into my postgres DB via the c++ libpq.
What I have is a char* (actually a
I've worked through that already, without any success.
This is what I have until now to insert data
char *query = insert into table1 (bytes) values ($1);
QByteArray chip = assignment of bytes;
const char *data = chip-data();
const char* params[]={data};
const int
On Sep 30, 2010, at 8:26 AM, GOO Creations wrote:
Hi there,
I'm sitting for days now, and I can't get this to work:
I want to insert binary data (bytea) into my postgres DB via the c++ libpq.
What I have is a char* (actually a QByteArray) and I want to insert it into
the DB and the
Yes there is a reason I'm not using Qt's libraries. Qt doesn't come
out with PSQL as default driver (meaning you have to manually download
the driver for Qt postgres). I'm developing a plugin for an app that
restricts Qt, no extra depedncies are allowed. But the app has libpq as
dependcy, so
On Sep 29, 2010, at 7:56 PM, Tom Lane wrote:
pg_controldata would tell you approximately where the OID counter is.
Just what I needed. Thank you so much Tom.
Dianne
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
--- On Thu, 9/30/10, Vincenzo Romano vincenzo.rom...@notorand.it wrote:
From: Vincenzo Romano vincenzo.rom...@notorand.it
Subject: [GENERAL] [9.0] On temporary tables
To: PostgreSQL General pgsql-general@postgresql.org
Date: Thursday, September 30, 2010, 11:09 AM
Hi all.
This is my case:
--
I just installed a copy of PostgreSQL 9.0 on Windows 7 x64 using the one
click installer, and found that the uuid-ossp contrib module is missing.
I took a look at the zip archives, and the uuid-ossp files are in the 32 bit
build, but not the 64 bit build.
Is this an oversight, or is there some
On Thu, Sep 30, 2010 at 5:57 PM, Cheetah fast...@gmail.com wrote:
I just installed a copy of PostgreSQL 9.0 on Windows 7 x64 using the one
click installer, and found that the uuid-ossp contrib module is missing.
I took a look at the zip archives, and the uuid-ossp files are in the 32 bit
Hey,
Just an FYI -- the talk descriptions for PostgreSQL Conference West are
now up: https://www.postgresqlconference.org/2010/west/talks
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development,
One thing that i think works is to create a table from your results.
That is, if your result is not one big chunk in one row that won't fit
in memory, but lots of rows.
like this:
create table foo as
select humongous query
If you use screen (on linux) you can log out while your humongous
query
Are there any examples of a custom analyze function for a table?
Thanks in advance,
Mike Norman
It sounds like I'm in quite a fix here. If PGXS is currently a no-go in
Windows, then that renders the temporal extension incompatible with Windows
since it uses PGXS to install...
OTOH, if there's some remote possibility of some workaround solution for
Windows to get PGXS and/or the
Dave Page dp...@pgadmin.org writes:
On Thu, Sep 30, 2010 at 1:42 PM, Dr. Peter Voigt pvo...@uos.de wrote:
Hi Dharmendra,
thanks for your reply. This kind of errors, which cannot be reproduced
on other machines are bad and leave no chance for developers to solve
them.
Unfortunately the
Looking for a good host for a project on Win2008 and PostgreSQL.
I found these 2 sites but they support older versions of PostgreSQL
http://www.jodohost.com/http://www.jodohost.com/windows.asp
http://www.gbehost.com/
Does anyone have any good suggestions?
Donny Velazquez | Civil Solutions, a
Michael Norman mwnor...@gmail.com writes:
Are there any examples of a custom analyze function for a table?
Um ... there's no such thing as a per-table custom analyze function.
Analyze functions are per-data-type. tsvector has a custom analyze
function in 8.4 and up (ts_typanalyze); you could
I created today a new database and user for my Wiki. Now I created
both the db user and actual db as 'carlos' even though the owner of
the db 'wiki' is a user named 'wiki'. My user 'carlos' is a superuser
however. So I then wanted to view and change some data but I keep
getting this error:
On Thu, Sep 30, 2010 at 3:31 PM, Raymond O'Donnell r...@iol.ie wrote:
Are the tables in a schema other than public? Enter \dn at the psql
prompt to see what schemas are there.
Perhaps not. I wasn't aware of that. When I created the database
before I created and tables, I used the following
On 30/09/2010 20:33, Carlos Mennens wrote:
On Thu, Sep 30, 2010 at 3:31 PM, Raymond O'Donnellr...@iol.ie wrote:
Are the tables in a schema other than public? Enter \dn at the psql
prompt to see what schemas are there.
Perhaps not. I wasn't aware of that. When I created the database
before I
On 30/09/2010 20:43, Raymond O'Donnell wrote:
http://www.postgresql.org/docs/9.0/static/ddl-schemas.html
Have a look at section 5.3.7 on the search path in particular, as this
Whoops, sorry - that's 5.7.3.
Ray..
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via
On Thu, Sep 30, 2010 at 3:44 PM, Raymond O'Donnell r...@iol.ie wrote:
On 30/09/2010 20:43, Raymond O'Donnell wrote:
http://www.postgresql.org/docs/9.0/static/ddl-schemas.html
Have a look at section 5.3.7 on the search path in particular, as this
Whoops, sorry - that's 5.7.3.
Thank you. I
On 30/09/2010 20:59, Carlos Mennens wrote:
On Thu, Sep 30, 2010 at 3:44 PM, Raymond O'Donnellr...@iol.ie wrote:
On 30/09/2010 20:43, Raymond O'Donnell wrote:
http://www.postgresql.org/docs/9.0/static/ddl-schemas.html
Have a look at section 5.3.7 on the search path in particular, as this
Ciao Michele,
both server (master and standby) need a common directory where read
and write the wal files?
Not necessarily. You can use for instance scp to ship the WAL file from
the master to the standby using the network.
Just another question about replication: there is the
On Thu, Sep 30, 2010 at 7:41 PM, Dr. Peter Voigt pvo...@uos.de wrote:
Dave Page dp...@pgadmin.org writes:
On Thu, Sep 30, 2010 at 1:42 PM, Dr. Peter Voigt pvo...@uos.de wrote:
Hi Dharmendra,
thanks for your reply. This kind of errors, which cannot be reproduced
on other machines are bad and
Dave Page dp...@pgadmin.org writes:
A couple of questions for you Peter (and thanks for bearing with us
while we figure this out):
- How are you running the installer? Are you logged in as
Administrator, or are you using Run As Administrator or something
similar?
I am logged in as
On Thu, Sep 30, 2010 at 11:42 AM, GOO Creations goocreati...@gmail.com wrote:
Yes there is a reason I'm not using Qt's libraries. Qt doesn't come out
with PSQL as default driver (meaning you have to manually download the
driver for Qt postgres). I'm developing a plugin for an app that
I installed the 64 bit PostgreSQL 9.0 on Windows Server 2008 and it seems to
perform wonderfully.
I moved 1.5 million records that are 3K wide from SQL*Server into PostgreSQL
and rebuilt 6 indexes all in less than 6 minutes.
I was thinking of using SQLite for the project, but I calculate the
On Thu, Sep 30, 2010 at 11:53 AM, Donny Velazquez dv...@arh-us.com wrote:
Looking for a good host for a project on Win2008 and PostgreSQL.
Does anyone have any good suggestions?
IIRC, hub.org is owned by one of the pg core team members:
http://hub.org/services/database-services
--
Sent via
* GOO Creations wrote:
This is what I have until now to insert data
char *query = insert into table1 (bytes) values ($1);
QByteArray chip = assignment of bytes;
const char *data = chip-data();
const char* params[]={data};
const int params_length[]={chip-length()};
const int
68 matches
Mail list logo