Re: [GENERAL] Postgres 8.4 stopped working---Please urgent help needed

2013-06-09 Thread dinesh kumar
On Sun, Jun 9, 2013 at 3:34 AM, g.si...@utwente.nl wrote: Hi All, I have a problem with PostgreSQL 8.4. It was working perfectly fine but after the restart (within a couple of minutes) of my system whenever I login to PostgreSQL 8.4 (localhost:5432) it gives error as under: *Server

[GENERAL] Postgresql - Currval Vs Session Pool

2013-06-09 Thread Gustavo Amarilla Santacruz
Hello, all. In the PostgreSQL documentation I found currval: Return the value most recently obtained by nextval for this sequence in the current session In other documentations (pgpool, for example), I found Connection Pooling pgpool-II saves connections to the PostgreSQL servers, and reuse

Re: [GENERAL] Postgresql - Currval Vs Session Pool

2013-06-09 Thread David Johnston
Gustavo Amarilla Santacruz wrote In the PostgreSQL documentation I found currval: Return the value most recently obtained by nextval for this sequence in the current session Then, I have the following question: PostgreSQL differentiates between sessions created for the same

Re: [GENERAL] User postgres unable to revoke privileges?

2013-06-09 Thread Tom Lane
=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= franc...@teksol.info writes: Le 2013-06-06 à 17:59, Tom Lane a écrit : Note where the fine manual says: schema_name The name of an existing schema. Each target_role must have CREATE privileges for each specified schema. There was some debate

[GENERAL] multilib environment with postgresql92 from CentOS-repos? (9.2.4)

2013-06-09 Thread Markus Renner
Hello everybody, since postgresql 9.2.x it seems such 32bit libs are gone for 64bit hosts on repository-level. In other words. They are not install-able via yum. I've recently installed postgresql92* from pgdg-centos92-repository. I used pgdg-centos92-9.2-6.noarch to setup the repo. We still

[GENERAL] pgxs question - linking c-functions to external libraries

2013-06-09 Thread Rad Cirskis
Hi John, have you managed to get it to link with external shared libs? tia, Rad Rad Cirskis Senior Software Engineer Level 2, Building A, The Millennium Building Phase 2, 600 Great South Road, Ellerslie Auckland City, Auckland, 1051 +64 9 926 2891 Office

Re: [GENERAL] Question on explain

2013-06-09 Thread Jeff Janes
On Saturday, June 8, 2013, Jeff Janes wrote: On Sat, Jun 8, 2013 at 8:06 AM, Enrico Pirozzi sscott...@gmail.comjavascript:_e({}, 'cvml', 'sscott...@gmail.com'); wrote: Hi all, I have 2 tables: table1 (field1,field2,.) table2 (field1,field2,field3,.) field1 is an uuid type

Re: [GENERAL] Sample database with difficult SQL questions

2013-06-09 Thread Craig Ringer
On 06/09/2013 07:42 AM, Alexander Gataric wrote: I need a sample database and hard practice SQL questions (multiple joins, window functions, subqueries, CTEs) to write ad hoc queries or perform database tasks. Any suggestions are welcome. Thanks in advance. One option would be to look through

[GENERAL] My function run successfully with cursor, but can't change table

2013-06-09 Thread 高健
Hello: Would somebody please kindly tell why my function run but can't update table via cursor: I have table like this: create table course_tbl(course_number integer, course_name varchar(4), instructor varchar(10)); insert into course_tbl values (1,'','TOM'), (2,'','JACK');