Re: [GENERAL] libpq (C++) - Insert binary data

thanks for this tip, but as far as I understand it libpqtypes is not part of the original lipq libary . This will result in the same problem as with the Qt libraries, it will add another dependecy to my plugin, which is not allowed. Chris On 2010/09/30 10:59 PM, Merlin Moncure wrote: On Thu,

Re: [GENERAL] libpq (C++) - Insert binary data

* GOO Creations wrote: This is what I have until now to insert data char *query = "insert into table1 (bytes) values ($1)"; QByteArray chip = ; const char *data = chip->data(); const char* params[]={data}; const int params_length[]={chip->length()}; const int params_format[]={1}; result = PQexe

Re: [GENERAL] Hosting options?

On Thu, Sep 30, 2010 at 11:53 AM, Donny Velazquez 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 pgsql-general m

[GENERAL] Kudos on the 64 bit PostgreSQL for Windows

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 same

Re: [GENERAL] libpq (C++) - Insert binary data

On Thu, Sep 30, 2010 at 11:42 AM, GOO Creations 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 restricts > Qt, no extra dep

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

Dave Page 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 "Administrator"

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

On Thu, Sep 30, 2010 at 7:41 PM, Dr. Peter Voigt wrote: > Dave Page writes: > >> On Thu, Sep 30, 2010 at 1:42 PM, Dr. Peter Voigt 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 develop

Re: [GENERAL] [9.0] hot standby plus streaming replication

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 possibil

Re: [GENERAL] No Relations Found Error

On 30/09/2010 20:59, Carlos Mennens wrote: On Thu, Sep 30, 2010 at 3:44 PM, Raymond O'Donnell 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

Re: [GENERAL] No Relations Found Error

On Thu, Sep 30, 2010 at 3:44 PM, Raymond O'Donnell 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 am

Re: [GENERAL] No Relations Found Error

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 pgsql-gener

Re: [GENERAL] No Relations Found Error

On 30/09/2010 20:33, Carlos Mennens wrote: On Thu, Sep 30, 2010 at 3:31 PM, Raymond O'Donnell 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

Re: [GENERAL] No Relations Found Error

On Thu, Sep 30, 2010 at 3:31 PM, Raymond O'Donnell 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 command:

[GENERAL] No Relations Found Error

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: car...@

Re: [GENERAL] custom analyze function

Michael Norman 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 look at that.

[GENERAL] Hosting options?

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.gbehost.com/ Does anyone have any good suggestions? Donny Velazquez | Civil Solutions,

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

Dave Page writes: > On Thu, Sep 30, 2010 at 1:42 PM, Dr. Peter Voigt 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

Re: [GENERAL] Missing path in pg_config

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 temporal

[GENERAL] custom analyze function

Are there any examples of a custom analyze function for a table? Thanks in advance, Mike Norman

Re: [GENERAL] where does postgres keep the query result until it is returned?

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 If you use "screen" (on linux) you can log out while your humongous query runs on the ser

[GENERAL] PgWest 2010 talk descriptions are up

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, En

Re: [GENERAL] ossp-uuid missing from one click windows x64 builds

On Thu, Sep 30, 2010 at 5:57 PM, Cheetah 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 > build, but not th

[GENERAL] ossp-uuid missing from one click windows x64 builds

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 pr

Re: [GENERAL] [9.0] On temporary tables

--- On Thu, 9/30/10, Vincenzo Romano wrote: From: Vincenzo Romano Subject: [GENERAL] [9.0] On temporary tables To: "PostgreSQL General" Date: Thursday, September 30, 2010, 11:09 AM Hi all. This is my case: -- begin snippet -- reset search_path; drop table if exists session cascade; create ta

Re: [GENERAL] Get next OID

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: http://www.postgr

Re: [GENERAL] libpq (C++) - Insert binary data

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 I

Re: [GENERAL] libpq (C++) - Insert binary data

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 an

Re: [GENERAL] libpq (C++) - Insert binary data

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 = ; const char *data = chip->data(); const char* params[]={data}; const int params_length[]={chip->lengt

Re: [GENERAL] libpq (C++) - Insert binary data

2010/9/30 Vincenzo Romano : > 2010/9/30 GOO Creations : >>  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 >>

Re: [GENERAL] libpq (C++) - Insert binary data

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

Re: [GENERAL] libpq (C++) - Insert binary data

2010/9/30 GOO Creations : >  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

[GENERAL] libpq (C++) - Insert binary data

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 exampl

Re: [GENERAL] [9.0] On temporary tables

2010/9/30 Vincenzo Romano : > 2010/9/30 Pavel Stehule : >> 2010/9/30 Vincenzo Romano : >>> 2010/9/30 Pavel Stehule : 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 in

Re: [GENERAL] Prepared statements and unknown types

On 30 September 2010 14:36, Igor Neyman 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 doesn't

Re: [GENERAL] [9.0] On temporary tables

2010/9/30 Pavel Stehule : > 2010/9/30 Vincenzo Romano : >> 2010/9/30 Pavel Stehule : >>> 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 varia

Re: [GENERAL] [9.0] On temporary tables

2010/9/30 Vincenzo Romano : > 2010/9/30 Pavel Stehule : >> 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. >>> >> >>

[GENERAL] Working around in-statement with temporary tables

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 wit

Re: [GENERAL] [9.0] On temporary tables

2010/9/30 Pavel Stehule : > 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 variab

Re: [GENERAL] [9.0] On temporary tables

Hello 2010/9/30 Vincenzo Romano : > 2010/9/30 Pavel Stehule : >> Hello >> >> 2010/9/30 Tom Lane : >>> Vincenzo Romano writes: create or replace function session_init() returns void language plpgsql as $body$ declare   t text; begin   select valu into t from

Re: [GENERAL] [9.0] On temporary tables

2010/9/30 Andy Colson : > 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 te

Re: [GENERAL] [9.0] On temporary tables

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, y

Re: [GENERAL] PostgreSQL server not starting.

On Thu, Sep 30, 2010 at 5:09 AM, Vishnu S. wrote: > On starting the server  using pg_ctl command the following message is shown. > > > > server starting > > > > C:\Program Files\PostgreSQL\8.4\bin>2010-09-30 14:36:07 ISTLOG:  could not > create file "postmaster.opts": Permission denied. > Are you

Re: [GENERAL] [9.0] On temporary tables

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

Re: [GENERAL] [9.0] On temporary tables

2010/9/30 Pavel Stehule : > Hello > > 2010/9/30 Tom Lane : >> Vincenzo Romano 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 fo

Re: [GENERAL] [9.0] On temporary tables

Hello 2010/9/30 Tom Lane : > Vincenzo Romano 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 se

Re: [GENERAL] [9.0] On temporary tables

2010/9/30 Tom Lane : > Vincenzo Romano 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 (

Re: [GENERAL] [9.0] On temporary tables

Vincenzo Romano 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 public.session including al

Re: [GENERAL] Prepared statements and unknown types

> -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-

Re: [GENERAL] PostgreSQL server not starting.

Hi, On starting the server using pg_ctl command the following message is shown. server starting C:\Program Files\PostgreSQL\8.4\bin>2010-09-30 14:36:07 ISTLOG: could not create file "postmaster.opts": Permission denied. Thanks & Regards, Vishnu S From: Sachin S

[GENERAL] PostgreSQL server not starting.

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 following

Re: [GENERAL] rotate psql output

On 30/09/2010 12:31, Vincenzo Romano wrote: > 2010/9/30 Ben Carbery : >> 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: ';' or '\g' gives

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

On Thu, Sep 30, 2010 at 1:42 PM, Dr. Peter Voigt 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. Please

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

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.

[GENERAL] [9.0] hot standby plus streaming replication questions

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

Re: [GENERAL] rotate psql output

2010/9/30 Ben Carbery : > On Thu, Sep 30, 2010 at 9:36 PM, Vincenzo Romano > 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, > rather than displaying it differently

Re: [GENERAL] rotate psql output

On Thu, Sep 30, 2010 at 9:36 PM, Vincenzo Romano < vincenzo.rom...@notorand.it> wrote: > 2010/9/30 Raymond O'Donnell : > > 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-colu

Re: [GENERAL] rotate psql output

2010/9/30 Raymond O'Donnell : > 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 module (

Re: [GENERAL] rotate psql output

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 ha

Re: [GENERAL] rotate psql output

2010/9/30 Ben Carbery : > 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 -- NON QVIETIS MARIBVS

Re: [GENERAL] rotate psql output

On Thu, Sep 30, 2010 at 9:19 PM, Tommy Gildseth wrote: > 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

Re: [GENERAL] rotate psql output

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

Re: [GENERAL] rotate psql output

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 searching

[GENERAL] rotate psql output

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 usu

[GENERAL] [9.0] On temporary tables

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 t

Re: [GENERAL] PostgreSQL server not starting.

[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

Re: [GENERAL] PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install

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 > Date: Tue, Sep 28, 2010 at 11:53 PM > S

Re: [GENERAL] Missing path in pg_config

On Thu, Sep 30, 2010 at 00:55, Dave Page wrote: > On Wed, Sep 29, 2010 at 7:23 PM, Turner, John J > 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 >> pg_Foundry.  One problem I c

Re: [GENERAL] PostgreSQL server not starting.

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