[GENERAL] Per-statement trigger in Foreign tables in Posgregsql 9.4 (through Foreign-data wrapper)

case generates more than one insert. Can someone please shed some light on this? Thanks in advance Andrea

Re: [GENERAL] CASE Statement - Order of expression processing

On Mon, Jun 17, 2013 at 11:11 PM, Stefan Drees wrote: > > pg924=# SELECT CASE WHEN 1 != 1 THEN 1/0 ELSE ((SELECT 1)=1)::integer END; > case > -- > 1 > (1 row) > > here the 1/0 is happily ignored. > It gets even stranger: template1=# SELECT CASE WHEN (SELECT 0)=0 THEN 0 ELSE 1/(select

[GENERAL] CASE Statement - Order of expression processing

ny subexpressions that are not needed to determine the result." Did I miss anything? Or is this really a bug? Thanks, Andrea Lombardoni

[GENERAL] PG 9.1.1 - availability of xslt_process()

Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù -

[GENERAL] Adding "quota user limit" using triggers

>on 06/08/11 11:14 PM, Andrea Peri wrote: >Hi, > > >Is possible the limit the size of an user (quota user) as space allocated in a tablespace ? >I don't find this option in the 9.0 version of PG, >so I think it is not available. > >Perhaps it should be possib

[GENERAL] Adding "quota user limit" using triggers

ave a confirm and if there is some documentation or information on this problem available. Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù -

[GENERAL] Need the binary of PG9.0 for Windows 32bit

Hi, I need to download the build of Postgres 9.0 compiled for win32bit. I see there is available the 9.0.1 version. But I'm searching specifically the 9.0 for a test. There some link with old binaries ? Thx, Andrea Peri. -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] Problem with temporary tables

> You need to use EXECUTE for the INSERT statement as well per error: > > CONTEXT:  SQL statement "INSERT INTO idmap (oldid, type, newid) VALUES(1, >  1, 1)" PL/pgSQL function "test" line 16 at SQL statement Thanks, this works and solves my problem. Still, I find this behaviour to be rather quirk

Re: [GENERAL] Problem with temporary tables

>> Am I doing something wrong or is this a bug? > > The plan is cached, to avoid this problem, use dynamic SQL. In your > case: > > EXECUTE 'CREATE TEMPORARY TABLE idmap ...' Nice idea, but the problem persists, see log below. I am beginning to mentally place this into the 'bug' area :) CREATE

[GENERAL] Problem with temporary tables

Hello. I am trying to use temporary tables inside a stored procedure, but I get a rather puzzling error. I am currently using PostgreSQL 8.2.7 and this is my stored procedure: CREATE OR REPLACE FUNCTION test() RETURNS bigint AS $$ DECLARE v_oid bigint; BEGIN -- create tmp-table used to ma

Re: [GENERAL] Query planner issue

Dear Richard, you are right. So Postgres takes a lot of time to get out an impossible result! The query I wrote is just a test, the concatenation is only a dummy. On 19/set/08, at 12:33, Richard Huxton wrote: Andrea Moretto wrote: I've got a table called DETAILS, the primary k

[GENERAL] Query planner issue

(co_id)::text) = '010076015372010076015372'::text) Same thing if I try to trick it using a view or a stored procedure. Query planner is not easy to trick! My question is : is there a way to use the index or isn't it possible? Thanks in advance. Andrea Moretto Andrea Moretto

[GENERAL] Pgpool-II and Slony-I : query lag, sequences and stored procedures need help

the pgpool mailing list, but so far no answer. Thanks in advance! Regards, Andrea Moretto Andrea Moretto [EMAIL PROTECTED] --- CONFIDENTIALITY NOTICE This message and its attachments are addressed solely to the persons above and may conta

[GENERAL] Help needed in PITR

a valid checkpoint record LOG: startup process (PID 22672) was terminated by signal 6 LOG: aborting startup due to startup process failure LOG: logger shutting down . Someone can help in understanding where is the problems ??? Thanks in advance, --Andrea -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

pgsql-general@postgresql.org

ot locate a valid checkpoint record LOG: startup process (PID 22672) was terminated by signal 6 LOG: aborting startup due to startup process failure LOG: logger shutting down . Someone can help in understanding where is the problems ??? Thanks in advance, --Andrea -- Sent via

pgsql-general@postgresql.org

ot locate a valid checkpoint record LOG: startup process (PID 22672) was terminated by signal 6 LOG: aborting startup due to startup process failure LOG: logger shutting down . Someone can help in understanding where is the problems ??? Thanks in advance, --Andrea -- Sent via

[GENERAL] Newby Help needed

om only archive-status directory... Some one can help in understanding these ?? Many thanks in advance to any one will post an answer.. --Andrea -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: regression in 8.8.2 [was Re: [GENERAL] Very strange error]

On Tue, Feb 06, 2007 at 03:23:29PM -0300, Alvaro Herrera wrote: > The fix is already in the REL8_2_STABLE branch, so Andrea can certainly > update and confirm if his problem is fixed. Confirmed, after the last cvs checkout it works fine. thanks! ---(end of bro

Re: regression in 8.8.2 [was Re: [GENERAL] Very strange error]

On Tue, Feb 06, 2007 at 01:19:28PM -0500, Bruce Momjian wrote: > This is a known bug in 8.2.2 and we are discussing methods of > distributing the fix as quickly as possible. Ok great! Take your time, thanks. ---(end of broadcast)--- TIP 3: Have you

regression in 8.8.2 [was Re: [GENERAL] Very strange error]

On Tue, Feb 06, 2007 at 10:09:16AM -0500, Michael Slattery wrote: > When does this error crop up? What is the query? Does this select > involve more than one table, or does it involve any homemade > functions? Or overriden functions? My application broke in a big way with the security updat

[GENERAL] [PHP] unsubscribe

unsubscribe LIBIA ANDREA RAMOS SÁNCHEZ INGENIERO DE SISTEMAS ESCUELA COLOMBIANA DE INGENIERIA CEL. 3103271242 OFC. 5452799 - 2550469 CMN-Consulting _ Charla con tus amigos en línea mediante MSN Messenger: http

[GENERAL] NT + cygipc + postgresql = boom!

es... Joost was right, it seems to be cygipc fault, the above error message is raised from sem.c in cygipc sources... Is there anyone who knows how to solve this problem? Andrea

[GENERAL] PostgreSQL on NT: new cygwin?

... is there anyone who has experience on that kind of installation? I've tried to download http://www.s34.co.jp/~luster/pgsql/cygwin32_ipc-1.03-bin-patched.tar.bz2 but bzip2 keeps telling me that this package is corrupted. Anyone has some experience? Bye Andrea

[GENERAL] count & distinct

... ;-) Thanks in advance Andrea PS: well, of course I can open a cursor on a "select distinct column from table" and then loop over the cursor couting how many values there are, but it seem a bit ugly...

[GENERAL] Lock record

an entire table. I'm using ADO, and it seem possible to lock a record by opening a recordset on it (with a proper query) and keeping that recordset open (I think that it's the cursor that keeps the lock on the db). Anyone knows a different/better method? Thanks Andrea

Re: [GENERAL] make[2]: *** [psql] Error 1

On 13-Oct-98 Marc G. Fournier wrote: >> > This is a compiler option that will tell the linker to link in the ncurses >> > routines. >> > >> > Hope this helps...james >> > >> >> >> >> >> Ok, now the question is: where? >> >> I add it in Makefile.global, but nothig. > > ave you patch

Re: [GENERAL] make[2]: *** [psql] Error 1

>|/usr/lib/libreadline.a(terminal.o): In function `_rl_enable_meta_key': >|terminal.o(.text+0x7ce): undefined reference to `tputs' >|/usr/lib/libreadline.a(terminal.o): In function `_rl_control_keypad': >|terminal.o(.text+0x7fb): undefined reference to `tputs' >|terminal.o(.text+0x822): undefine

[GENERAL] make[2]: *** [psql] Error 1

when I compile postgres 6.3.2 under linux I have this error with "make all" and "make install": from make install: /usr/lib/libreadline.a(terminal.o): In function `_rl_enable_meta_key': terminal.o(.text+0x7ce): undefined reference to `tputs' /usr/lib/libreadline.a(terminal.o): In function `_rl