Re: [GENERAL] Dynamic SQL with pgsql, how to?

Am 03.05.2010 um 23:50 schrieb Andre Lopes: > Thanks for the reply's, > > I need to do a Dynamic SELECT INTO. There is a way of doing it? Yes. Plpgsql supports this: EXECUTE command-string [ INTO [STRICT] target ] [ USING expression [, ... ] ]; See http://developer.postgresql.org/pgdocs/postgr

Re: [GENERAL] GeSHi module for Postgresql?

Leif Biberg Kristensen wrote: Now I only need a list of the built-in functions. There doesn't seem to be a pg_get functions()? Try psql -E postgres (-E shows all queries psql does on the catalog) then \df regards, Yeb Havinga -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] GeSHi module for Postgresql?

On Monday 3. May 2010 23.50.55 Alvaro Herrera wrote: > Why wouldn't you simply ask Postgres? Because I didn't know how :D That's why we've got this wonderful list, isn't it? > select * from pg_get_keywords(); Cool! Thank you! I really only need the 'word' column. I'll separate the data types

Re: [GENERAL] Latest source RPMs for 8.1.20

On Mon, 2010-05-03 at 10:49 -0500, Justin Pasher wrote: > I'm looking for the latest source RPMs for Postgres 8.1.20 on RHEL http://yum.pgrpms.org/srpms/8.1/redhat/rhel-5Server-x86_64/repoview/postgresql.html Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer P

Re: [GENERAL] pg9 beta1, make check fails

I wrote: > I'd have thought that pg_regress would have a more obvious failure if it > was trying to use an old libpq.so version though --- it should have > looked similar to what you referenced for pg_dump, for instance. I think I see what's going on here. pg_regress itself doesn't link to libpq

Re: [GENERAL] Help with tracking!

2010/4/19 Đỗ Ngọc Trí Cường > Dear all, > > I've a problem but I search all the help file and can't find the solution. > > I want to track all action of a specify role on all or one schema in > database. > > Can you help me? > > Thanks a lot and Best Regard, > Setup your log_line_prefix and log

Re: [GENERAL] GeSHi module for Postgresql?

Leif Biberg Kristensen wrote: > On Monday 3. May 2010 23.05.54 Richard Broersma wrote: > > On Mon, May 3, 2010 at 1:49 PM, Leif Biberg Kristensen > > wrote: > > > I > > > wonder if there' s a compiled list somewhere of just the PostgreSQL > keywords > > > and function names. That would be of grea

Re: [GENERAL] Dynamic SQL with pgsql, how to?

Thanks for the reply's, I need to do a Dynamic SELECT INTO. There is a way of doing it? Best Regards, On Mon, May 3, 2010 at 10:05 AM, A. Kretschmer < andreas.kretsch...@schollglas.com> wrote: > In response to Andre Lopes : > > Hi, > > > > I need to write some dynamic SQL in pgsql. > > There i

Re: [GENERAL] GeSHi module for Postgresql?

On Monday 3. May 2010 23.02.05 Christophe Chauvet wrote: > hi > > i have begin this work, you can find it at > > http://svn.postgresqlfr.org/repos/tools/geshi/trunk/ Christophe, thank you very much! I've started to look at it, and have already taken your postgresql.php for a spin. You can see

Re: [GENERAL] GeSHi module for Postgresql?

Le 03/05/10 22:54, Leif Biberg Kristensen a écrit : > On Monday 3. May 2010 22.49.21 Leif Biberg Kristensen wrote: >> GeSHi is a system for > > Sorry about that link. It's of course . > > *blush* > hi i have

Re: [GENERAL] GeSHi module for Postgresql?

On Monday 3. May 2010 23.05.54 Richard Broersma wrote: > On Mon, May 3, 2010 at 1:49 PM, Leif Biberg Kristensen > wrote: > > I > > wonder if there' s a compiled list somewhere of just the PostgreSQL keywords > > and function names. That would be of great help. > > These are what I know of: Rich

Re: [GENERAL] GeSHi module for Postgresql?

On Mon, May 3, 2010 at 1:49 PM, Leif Biberg Kristensen wrote: > I > wonder if there' s a compiled list somewhere of just the PostgreSQL keywords > and function names. That would be of great help. These are what I know of: http://www.postgresql.org/docs/9.0/static/sql-keywords-appendix.html http:

Re: [GENERAL] GeSHi module for Postgresql?

On Monday 3. May 2010 22.49.21 Leif Biberg Kristensen wrote: > GeSHi is a system for Sorry about that link. It's of course . *blush* -- Leif Biberg Kristensen http://solumslekt.org/blog/ -- Sent via pgsql-g

[GENERAL] GeSHi module for Postgresql?

GeSHi is a system for highlighting code. I've just installed the WP-Syntax plugin, which utilizes GeSHi, in my WP blog because I like code highlighting and am tired of doing it more or less by hand. However, I was disappointed when I didn't find Pos

Re: [GENERAL] Native DB replication for PG

On Mon, May 3, 2010 at 7:29 AM, Gauthier, Dave wrote: > So, back to the base note, as far as native replication support, I should > wait for v9 whic'll probably be out by the end of the summer? Yep. You should really start testing now though if you're gonna use it. -- Sent via pgsql-general m

Re: Fwd: [GENERAL] Tablespace Problem

Sir, I have tried to change the ownership of the postgres directories to postgresql account. But in windows , the posgresql account has no permission to take ownership of any directory. Because the postgresql service account is not under any group and not as a logon account. How can I set ownershi

Re: [GENERAL] pg9 beta1, make check fails

On 5/3/2010 1:21 PM, Tom Lane wrote: Andy Colson writes: Ok, not sure what order its supposed to be run in, but I had done: make make check which fails. But if I do: make make install make check it works and passes. That looks like a shared-library problem --- did the "make ins

Re: [GENERAL] pg9 beta1, make check fails

Andy Colson writes: > Ok, not sure what order its supposed to be run in, but I had done: > make > make check > which fails. > But if I do: > make > make install > make check > it works and passes. That looks like a shared-library problem --- did the "make install" overwrite an older version

Re: [GENERAL] pg9 beta1, make check fails

On 5/3/2010 12:59 PM, Tom Lane wrote: Andy Colson writes: $make check ... snip lots of output... ./pg_regress --inputdir=. --dlpath=. --multibyte=SQL_ASCII --temp-install=./tmp_check --top-builddir=../../.. --schedule=./parallel_schedule == removing existing temp installation===

Re: [GENERAL] pg9 beta1, make check fails

On 5/3/2010 12:59 PM, Tom Lane wrote: Andy Colson writes: $make check ... snip lots of output... ./pg_regress --inputdir=. --dlpath=. --multibyte=SQL_ASCII --temp-install=./tmp_check --top-builddir=../../.. --schedule=./parallel_schedule == removing existing temp installation===

Re: [GENERAL] pg9 beta1, make check fails

Andy Colson writes: > $make check > ... snip lots of output... > ./pg_regress --inputdir=. --dlpath=. --multibyte=SQL_ASCII > --temp-install=./tmp_check --top-builddir=../../.. > --schedule=./parallel_schedule > == removing existing temp installation== > =

Re: [GENERAL] Native DB replication for PG

On Mon, May 3, 2010 at 9:29 AM, Gauthier, Dave wrote: > So, back to the base note, as far as native replication support, I should > wait for v9 whic'll probably be out by the end of the summer? for 'native' replication waiting for 9.0 is your only option, because all of the other replication opt

[GENERAL] pg9 beta1, make check fails

$make check ... snip lots of output... ./pg_regress --inputdir=. --dlpath=. --multibyte=SQL_ASCII --temp-install=./tmp_check --top-builddir=../../.. --schedule=./parallel_schedule == removing existing temp installation== == creating temporary installation

Re: [GENERAL] information_schema.parameters

On fre, 2010-04-30 at 17:36 +0100, Grzegorz Jaśkiewicz wrote: > why specific_name column on that view contains also OID ? > This makes two databases that are identical, have different values > there. Is there any specific reason for that ? It was a convenient choice. You could propose a different

Re: [GENERAL] Latest source RPMs for 8.1.20

2010/5/3 Justin Pasher : > - Original Message - >> >> From: Vincenzo Romano >> Date: Mon, 3 May 2010 17:59:10 +0200 >> Subject: Re: Latest source RPMs for 8.1.20 >> To: Justin Pasher >> CC: pgsql-general@postgresql.org >> >> 2010/5/3 Justin Pasher : >> >>> >>> I'm looking for the latest s

Re: [GENERAL] Latest source RPMs for 8.1.20

2010/5/3 Vincenzo Romano : > 2010/5/3 Justin Pasher : >> - Original Message - >>> >>> From: Vincenzo Romano >>> Date: Mon, 3 May 2010 17:59:10 +0200 >>> Subject: Re: Latest source RPMs for 8.1.20 >>> To: Justin Pasher >>> CC: pgsql-general@postgresql.org >>> >>> 2010/5/3 Justin Pasher : >

Re: [GENERAL] Latest source RPMs for 8.1.20

- Original Message - From: Vincenzo Romano Date: Mon, 3 May 2010 17:59:10 +0200 Subject: Re: Latest source RPMs for 8.1.20 To: Justin Pasher CC: pgsql-general@postgresql.org 2010/5/3 Justin Pasher : I'm looking for the latest source RPMs for Postgres 8.1.20 on RHEL. I can see 8.1.1

Re: [GENERAL] Latest source RPMs for 8.1.20

2010/5/3 Justin Pasher : > I'm looking for the latest source RPMs for Postgres 8.1.20 on RHEL. I can > see 8.1.19 here: > > http://yum.pgsqlrpms.org/srpms/8.1/redhat/rhel-4-i386/repoview/postgresql.html > > Would it be safe to say that I can download the 8.1.19 source RPM, replace > the postgresql-

[GENERAL] Latest source RPMs for 8.1.20

I'm looking for the latest source RPMs for Postgres 8.1.20 on RHEL. I can see 8.1.19 here: http://yum.pgsqlrpms.org/srpms/8.1/redhat/rhel-4-i386/repoview/postgresql.html Would it be safe to say that I can download the 8.1.19 source RPM, replace the postgresql-8.1.19.tar.bz2 tarball with the p

Re: [GENERAL] Native DB replication for PG

On 30/04/2010 21:30, Scott Marlowe wrote: > On Fri, Apr 30, 2010 at 12:17 PM, Gauthier, Dave > wrote: >> I believe v9 will have native DB master/slave DB replication (correct if >> wrong). If so, what’s the best guess on when will v9 be released? > > If I had to plan server deployments for the n

Re: [GENERAL] User defined type - analyze problem

Carsten Kropf writes: > I read somewhere, that this can be solved by preparing a operator class for > btree and passing a comparison function for equality there. I did this with > the following lines: > CREATE OPERATOR CLASS pointnd_btree_class > DEFAULT FOR TYPE pointnd USING btree AS >

Re: [GENERAL] Native DB replication for PG

So, back to the base note, as far as native replication support, I should wait for v9 whic'll probably be out by the end of the summer? -Original Message- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Saturday, May 01, 2010 12:16 PM To: Tom Lane Cc: Greg Smith; j...@commandp

Re: Fwd: [GENERAL] Tablespace Problem

Message from mailto:softlinne...@gmail.com Kalai R softlinne...@gmail.com at 05-03-2010 05:41:24 PM -- Hi, Sir, I have been checked pg_tblspc/86014 directory have no permission to create new folder. I am using Windows XP Os and VB.Net frontend. I created the tablespace folder by

Re: [GENERAL] Opened ports vs. Packages...

On 3/05/2010 7:58 PM, Durumdara wrote: 1.) Auth. - password trying. The clients are access PGSQL by Zeos, or by PGDAC. I don't know what auth. methods they are support, but I think that md5 and plain text is not enough here... Just make sure you have an ssl certificate for your server, and req

Fwd: [GENERAL] Tablespace Problem

Hi, Sir, I have been checked pg_tblspc/86014 directory have no permission to create new folder. I am using Windows XP Os and VB.Net frontend. I created the tablespace folder by programaticaly using vb.net. I tried to chang the user permission for that folder by programatically and manualy usin

[GENERAL] Opened ports vs. Packages...

Hi! I want to ask about PGSQL-crack/hack-web-database. So: We have a web site with python. The DB engine is PGSQL. The first theory was that PGSQL is locally used, and each of other operations are realized with encoded XML packages. These operations are: fill up partner data, fill up offer da

Re: [GENERAL] Dynamic SQL with pgsql, how to?

In response to Andre Lopes : > Hi, > > I need to write some dynamic SQL in pgsql. > There is documentation on how can I do this in pgsql? Sure, http://www.postgresql.org/docs/8.4/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN Regards, Andreas -- Andreas Kretschmer Kontakt: Hey

Re: [GENERAL] Dynamic SQL with pgsql, how to?

On Mon, May 3, 2010 at 10:44 AM, Andre Lopes wrote: > Hi, > > I need to write some dynamic SQL in pgsql. > > I have to do something like this: > > [code=SQL Server] >     SET @STRINGN = @STRINGN + ' AND A.' + @CAMPOFECINI + ' IN (SELECT > MAX(B.' + @CAMPOFECINI + ') >             FROM ' + @TABLA +

[GENERAL] Dynamic SQL with pgsql, how to?

Hi, I need to write some dynamic SQL in pgsql. I have to do something like this: [code=SQL Server] SET @STRINGN = @STRINGN + ' AND A.' + @CAMPOFECINI + ' IN (SELECT MAX(B.' + @CAMPOFECINI + ') FROM ' + @TABLA + ' B WHERE B.ID_SOCIEDAD = A.ID_SOCIEDAD AND B