pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
please help
10+ messages / 10 participants
[nested] [flat]

* please help
@ 2000-01-07 08:16 Shanthala Rao <S.Rao@toa.toasia.co.jp>
  0 siblings, 0 replies; 10+ messages in thread

From: Shanthala Rao @ 2000-01-07 08:16 UTC (permalink / raw)
  To: pgsql-admin

I had written a pgm in Java on a Windows m/c
which accesses data from a linux m/c.The database
is stored in the linux m/c.I added postgresql.jar file(from Linux m/c)
for my proj.But when I run the pgm,the following Exception 
is displayed.
 The postgresql.jar file does not contain the correct
JDBC classes for this JVM.
Try rebuilding.
Exception thrown 
   java.lang.ClassNotFound Exception.
I want to know is there any JDBC driver for Windows
in postgresql??
 If so,would u please let me know where is it available??

Thanking you,
Shanthala.

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Please help
@ 2001-11-16 02:18 Mr OCP <mr_ocp@yahoo.com>
  2001-11-20 15:44 ` Re: Please help Ferdinand Smit <ferdinand@telegraafnet.nl>
  0 siblings, 1 reply; 10+ messages in thread

From: Mr OCP @ 2001-11-16 02:18 UTC (permalink / raw)
  To: pgsql-admin

Hi

Can anyone help me write a trigger on a table, I have
created an audit table for a table and what I want
trigger to do is to whenever a record is deleted from
the table it should first be inserted into the audit
table, just to keep track of whatever records are
deleted.

Thanks so much for your time.

Mike

http://shopping.yahoo.com.au - Yahoo! Shopping
- Get organised for Christmas early this year!



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Please help
  2001-11-16 02:18 Please help Mr OCP <mr_ocp@yahoo.com>
@ 2001-11-20 15:44 ` Ferdinand Smit <ferdinand@telegraafnet.nl>
  0 siblings, 0 replies; 10+ messages in thread

From: Ferdinand Smit @ 2001-11-20 15:44 UTC (permalink / raw)
  To: Mr OCP <mr_ocp@yahoo.com>; pgsql-admin

Hi Mike,

> Can anyone help me write a trigger on a table, I have
> created an audit table for a table and what I want
> trigger to do is to whenever a record is deleted from
> the table it should first be inserted into the audit
> table, just to keep track of whatever records are
> deleted.

Is this something ?? This archives my adres changes.

  /* Archive function */
  DROP FUNCTION fn_archive();
  CREATE FUNCTION fn_archive() RETURNS OPAQUE AS '
    BEGIN
      /* TG_OP is the function (UPDATE, DELETE, SELECT) */
      INSERT INTO adres_archive
          VALUES (OLD.name,OLD.adres,OLD.tel,current_user,now(),tg_opt);
        NEW.modtime := ''now'';
      END IF;

      RETURN NEW;
    END;
  ' LANGUAGE 'plpgsql';

  /* Archive trigger */
  DROP TRIGGER tr_archive ON adres;
  CREATE TRIGGER tr_adres_archive BEFORE UPDATE OR DELETE
  ON adres FOR EACH ROW
  EXECUTE PROCEDURE fn_archive ();

Ferdinand Smit



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Please help
@ 2002-04-10 15:49 Tariq Muhammad <tmuhamma@mail.libertyrms.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Tariq Muhammad @ 2002-04-10 15:49 UTC (permalink / raw)
  To: pgsql-admin


Hi Folks

I am trying to write a function that should archive old values to an
archiving table before update on the orignal table but it inserts both old
and new values to the archiving table here is the code: 

  CREATE FUNCTION fn_archive_01() RETURNS OPAQUE AS '
    BEGIN
      /* TG_OP is the function (UPDATE, DELETE, SELECT) */
      INSERT INTO customer_archive
          VALUES
(OLD.id, OLD.name,current_user,now(),TG_OP);

     IF TG_OP = ''UPDATE''
      THEN
        RETURN NEW;
      END IF;

      RETURN OLD;
    END;
  ' LANGUAGE 'plpgsql';



CREATE TRIGGER tr_customer_archive_del BEFORE DELETE
   ON customer FOR EACH ROW
   EXECUTE PROCEDURE fn_archive_01();

Thanks for your help
Tariq





^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Please help!!!!!!!!!
@ 2004-11-15 04:45 jagbirs@chopraconsultants.com
  2004-11-16 19:50 ` Re: Please help!!!!!!!!! Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 10+ messages in thread

From: jagbirs@chopraconsultants.com @ 2004-11-15 04:45 UTC (permalink / raw)
  To: pgsql-admin

Hi, Im migrating our database from MSSQL7.0 to postgresql on Solaris 9(sparc).But we have got problem in compiling the source code of postgresql on solaris.Can we have precompiled package of postgresql stable version for solaris9 sparc plateform.
Its urgent, please help us.


Jagbir Singh
"The Chopras" - New Delhi
1006, Chiranjiv Towers
43 Nehru Place, 
New Delhi - ND
Pin - 110019              
Phone - 91-11-26478940,26280600
Fax - 91-11-26280361




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Please help!!!!!!!!!
  2004-11-15 04:45 Please help!!!!!!!!! jagbirs@chopraconsultants.com
@ 2004-11-16 19:50 ` Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 10+ messages in thread

From: Michael Fuhr @ 2004-11-16 19:50 UTC (permalink / raw)
  To: jagbirs@chopraconsultants.com; +Cc: pgsql-admin

On Mon, Nov 15, 2004 at 10:15:30AM +0530, jagbirs@chopraconsultants.com wrote:

> Hi, Im migrating our database from MSSQL7.0 to postgresql on
> Solaris 9(sparc).But we have got problem in compiling the source
> code of postgresql on solaris.Can we have precompiled package of
> postgresql stable version for solaris9 sparc plateform.

First of all, please use a meaningful subject line.  Many people
decide whether to read a message based on its subject, and if they're
busy then they'll simply delete messages whose subjects contain no
more detail than "Please help!"  Some of the people most qualified
to help probably won't even see your plea.

You say you have a problem compiling PostgreSQL on Solaris 9.  Rather
than give up and rely on somebody else to provide you with a
pre-compiled package, why not solve the problem so you can be more
self-sufficient?  What problems are you having?  What commands did
you run and what errors or warnings resulted?  What compiler are
you using and what version of PostgreSQL are you trying to build?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Please help
@ 2005-09-10 07:58 ajith kumar <ajih_t@yahoo.com>
  0 siblings, 0 replies; 10+ messages in thread

From: ajith kumar @ 2005-09-10 07:58 UTC (permalink / raw)
  To: bugs@postgreSQL.org

Sir/Madam
 i need to take back up (dump file) using sql command.
i am using vb as front end. So i need to take the back
up using front end. so i need the sql command. I need
the same command for restore also. Please help me.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Please help
@ 2006-01-13 11:17 Dragos Pruteanu <pruteanu@ecircle-ag.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Dragos Pruteanu @ 2006-01-13 11:17 UTC (permalink / raw)
  To: pgsql-admin

I try to restore a backup, but I got the following error:
pg_restore: [custom archiver] could not read data block -- expected 
4096, got 2353

I run
pg_ctl (PostgreSQL) 8.0.3

I've tried the same with different backups ( one day before or after ) ,
and I tried also with -i flag ( ignore version ), but I got the same error.

Thank you for help,
Dragos Pruteanu




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Please help
@ 2007-01-11 14:05 raphael ferrer <raphael_ferrer@hotmail.com>
  2007-01-11 14:17 ` Re: Please help Adam Witney <awitney@sgul.ac.uk>
  0 siblings, 1 reply; 10+ messages in thread

From: raphael ferrer @ 2007-01-11 14:05 UTC (permalink / raw)
  To: pgsql-admin

Hello,

I would like to stop receive emails from pg forum.

How could i do that?

Thanks

_________________________________________________________________
Die MSN Homepage liefert Ihnen alle Infos zu Ihren Lieblingsthemen. 
http://ch.msn.com/




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Please help
  2007-01-11 14:05 Please help raphael ferrer <raphael_ferrer@hotmail.com>
@ 2007-01-11 14:17 ` Adam Witney <awitney@sgul.ac.uk>
  0 siblings, 0 replies; 10+ messages in thread

From: Adam Witney @ 2007-01-11 14:17 UTC (permalink / raw)
  To: pgsql-admin; +Cc: raphael_ferrer@hotmail.com


You can unsubscribe here

http://www.postgresql.org/community/lists/subscribe


On 11/1/07 14:05, in article BAY121-F371B28CFF5FB83F3EB90E4E7B10@phx.gbl,
""raphael ferrer"" <raphael_ferrer@hotmail.com> wrote:

> Hello,
> 
> I would like to stop receive emails from pg forum.
> 
> How could i do that?
> 
> Thanks
> 
> _________________________________________________________________
> Die MSN Homepage liefert Ihnen alle Infos zu Ihren Lieblingsthemen.
> http://ch.msn.com/
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 




^ permalink  raw  reply  [nested|flat] 10+ messages in thread


end of thread, other threads:[~2007-01-11 14:17 UTC | newest]

Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-07 08:16 please help Shanthala Rao <S.Rao@toa.toasia.co.jp>
2001-11-16 02:18 Please help Mr OCP <mr_ocp@yahoo.com>
2001-11-20 15:44 ` Re: Please help Ferdinand Smit <ferdinand@telegraafnet.nl>
2002-04-10 15:49 Please help Tariq Muhammad <tmuhamma@mail.libertyrms.com>
2004-11-15 04:45 Please help!!!!!!!!! jagbirs@chopraconsultants.com
2004-11-16 19:50 ` Re: Please help!!!!!!!!! Michael Fuhr <mike@fuhr.org>
2005-09-10 07:58 Please help ajith kumar <ajih_t@yahoo.com>
2006-01-13 11:17 Please help Dragos Pruteanu <pruteanu@ecircle-ag.com>
2007-01-11 14:05 Please help raphael ferrer <raphael_ferrer@hotmail.com>
2007-01-11 14:17 ` Re: Please help Adam Witney <awitney@sgul.ac.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox