Re: [GENERAL] how to force an insert before Raise Exception?

2011-04-19 Thread Taras Kopets
use dblink (http://www.postgresql.org/docs/current/static/dblink.html), which will issue a separate connection to database to simulate autonomous transaction. Regards, Taras Kopets -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

Re: [GENERAL] create table sintax

2011-04-19 Thread Taras Kopets
le_like('original'::text, 'copied'::text); insert into copied(a, b, c) VALUES(1, 'hot dog', now()); /* error, as expected insert into copied(a, b, c) VALUES(2, 'hot cat', now()); */ -- ROLLBACK; Hope this helps, Taras Kopets -- 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] Alias name from subquery

2008-09-30 Thread Taras Kopets
I think you should look at crosstab contrib module. Regards, Taras Kopets On 9/30/08, Felix Homann <[EMAIL PROTECTED]> wrote: > Hi Sam, > > Sam Mason wrote: >> I think you may be trying to solve the wrong problem, what are you >> really trying to do? > > Here y

Re: [GENERAL] problem with custom_variable_classes

2008-09-24 Thread Taras Kopets
T set_config('olap.rownum_name', false); Regards, Taras Kopets -- 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] storing repeating dates / events

2008-09-06 Thread Taras Kopets
ure Sorry, if I misunderstood your question. Taras Kopets -- 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] creating a dumpfile from a view

2006-10-30 Thread Taras Kopets
temp_demtest TO 'output_file_path'; Taras Kopets

Re: [GENERAL] WAL Archiving under Windows

2006-10-30 Thread Taras Kopets
Hi!> archive_command = 'copy %p d:\\backup\\logs\\%f' I think you should try something like this:archive_command = 'copy %p d:/backup/logs/%f'(using single / instead of \\).In documentation it is said:restore_command = 'copy /mnt/server/archivedir/%f "%p"' # Windows So I think the same format of

Re: [GENERAL] Replicating changes

2006-10-27 Thread Taras Kopets
Hi!I think you should try to use triggers with dbi-link to achieve this.AFAIK there is no such replication with other RDBMS as you need.Taras Kopets On 10/27/06, Alban Hertroys <[EMAIL PROTECTED]> wrote: Hello list,We're investigating a ways to replicate changes to the database toseveral "outside"

Re: [GENERAL] Send email from PostgreSQL, may I ?

2006-10-27 Thread Taras Kopets
sent (look in attachment). You will need to install pltclu first. PS: Maybe anyone knows how to send a unicode characters in e-mail using Tcl?Taras Kopets CREATE OR REPLACE FUNCTION com_tcl_sendmail(text, text, text, text) RETURNS int4 AS $BODY$ set mailfrom $1 set mailto $2 set mailsubject $3

Re: [GENERAL] Link error: LNK2019: unresolved external symbol _pg_detoast_datum

2006-10-20 Thread Taras Kopets
file is called in a session, the dynamic loader loads that object file into memory so that the function can be called", so I think you should try to attach to postgres.exe (I'm not sure).Have a nice day,Taras Kopets

Re: [GENERAL] Link error: LNK2019: unresolved external symbol _pg_detoast_datum

2006-10-18 Thread Taras Kopets
g left to do is to create a procedure in PostgreSQL which will use this code.We can make it with this SQL code:CREATE OR REPLACE FUNCTION writetofile(text, text, text) RETURNS void AS '$libdir/writetofile', 'writelog_tofile' LANGUAGE C STRICT;   Use it. Best Regards, T