[ADMIN] \i running on windows

2006-05-26 Thread jerome
n order to Postgres top find them ? It 's very annoying... I tried several notations (windows or Unix ones), I tried absolute & relative paths ? I set up some env vars (PG_HOME & PG_DATA) soi I tried to put scripts on the PG_HOME directory but it doesn't work

Re: [ADMIN] \i running on windows

2006-05-27 Thread jerome
your script in (or there may be an "open script" option to read it from >file) - I haven't used PgAdmin, I use SQL Manager's PostgreSQL Manager Lite >- it's much more intuitive. > >Andy > >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EM

Re: [ADMIN] \i running on windows

2006-05-27 Thread jerome
Andy Shellam a écrit : >Have you tried running your script in PgAdmin (or similar GUI)? e.g. >copy and paste your script into a new query? > > > yes the script is perfectly right .. it was just a test of table creation in order to try this aspect but whatever the location is, I can't even exe

[ADMIN] my query is so slow,It costs 944,319.072 ms,Can someone Help!!

2013-01-03 Thread Jerome
noutline.m_inout_id)::text) Filter: (((m_warehouse_id)::text = '50657AE0F49A421A9F10154C8632A726'::text) AND (issotrx = 'N'::bpchar)) -> Index Scan using c_bpartner_key on c_bpartner (cost=0.00..7.57 rows=1 width=56) (actual time=

[ADMIN] my query is so slow,It costs 944,319.072 ms,Can someone Help!!

2013-01-07 Thread Jerome
noutline.m_inout_id)::text) Filter: (((m_warehouse_id)::text = '50657AE0F49A421A9F10154C8632A726'::text) AND (issotrx = 'N'::bpchar)) -> Index Scan using c_bpartner_key on c_bpartner (cost=0.00..7.57 rows=1 width=56) (actual time=

[ADMIN] Installation & perf tuning under Linux PPC

2000-07-13 Thread Jerome Slangen
kind of tweak is welcome. Thanks. J. --- Best Regards, Jerome Slangen Software Designer Ex Machina Information Architects 155a, Rue de Fierlant 1190 Brussels (Belgium) Tel: 02.340.66.95 Fax: 02.344.07.93 Web: http://www.exmachina.net

Re: [ADMIN] tablename.columnname support

2000-09-16 Thread Jerome Slangen
The Hermit Hacker wrote: > > On Sat, 16 Sep 2000, vijayendra mohan agrawal wrote: > > > Hi all, > > > > say, we have a table created by : > > create table a ( a char(11), b char(22) ); > > > > For adding data into table 'a', ORACLE supports column name format as > > tablename.columnname as follo

[ADMIN] pgsql and net-snmp

2008-01-17 Thread Jerome Blomart
Hello, I really should ask if i am mailing to the correct mailing list in regarding the question i will ask. But ... I am working for a small company offering IT services. We are in the acceptance stage for a migration of an old UNIX app managing a huge load of data. This acceptan