Tuesday, 23 January 2007
|
| Problems w/ Temp Tables Brian Stapel 20:25:21 |
| | Thanks for your time.
I have an access/VBA system accessing data stored in a PostGRESQL db via functions. One of the function uses temporary tables. If I execute the function repeatedly via my vba code, I receive an error. I found the following item on a PostGRESQL FAQ that describes my problem:
4.19) Why do I get "relation with OID ##### does not exist" errors when accessing temporary tables in PL/PgSQL functions?
PL/PgSQL caches function scripts, and an unfortunate side effect is that if a PL/PgSQL function accesses a temporary table, and that table is later dropped and recreated, and the function called again, the function will fail because the cached function contents still point to the old temporary table. The solution is to use EXECUTE for temporary table access in PL/PgSQL. This will cause the query to be reparsed every time.
Can you tell me where should I implement the EXECUTE commands - in my function or with in my vba code? My vba code typically uses - SELECT * from {function name}({parameters} to execute the postgresql function.
Thanks again.
_________________________________________________________________
Fixing up the home? Live Search can help.
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US&source=wlmemailtaglinenov06 |
| |  2 answer | Add comment |
|
| CREATE FUNCTION Fails with an Insert Statement in it Jasbinder Singh Bali 20:23:44 |
| | I have created the following function :
CREATE OR REPLACE FUNCTION sp_insert_tbl_l_header(int4,text)
RETURNS bool AS
$BODY$
INSERT INTO tbl_xyz
(unmask_id,email_from)
VALUES ($1,$2)
$BODY$
LANGUAGE 'sql' VOLATILE;
when i try to create this fucntion by running this script, i get the
following error:
ERROR: return type mismatch in function declared to return boolean
DETAIL: Function's final statement must be a SELECT.
CONTEXT: SQL function "sp_insert_tbl_xyz"
So i think there is some problem with the return type of the function
when it has an insert statement but really don't know what should be
the return type of this function.
Thanks,
Jas
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
|
| | 2 answer | Add comment |
|
| PostgreSQL 8.2 utilities with Java app on Windows XP Michael Schmidt 19:50:39 |
| | Folks,
Although this is not really a JDBC problem, I initially posted it on the JDBC group because I thought the Java folks would be there. I got no response, so am posting here.
I have a PostgreSQL Java client CRUD GUI app that does backup and restore by running pg_dump and pg_restore with a Process. A BufferedReader attached to stderr catches the Password: prompt, the password is provided, and the output is then captured for display. All worked fine with PostgreSQL 8.1. I updated to PostgreSQL 8.2, and the app is now broken.
I wrote a simple Java app (code available on request) to try to diagnose the problem by comparing Java Process results with those obtained from running the PostgreSQL utility from the command prompt.. It creates a Process, attaches BufferedReaders to stdout and stderr, and each reader is read character-by-character when its ready() returns 'true'. if ready() is false, three read attempts are made with brief timeouts between (Thread.sleep(100)). I tested Windows ipconfig.exe (as a control condition) and six PostgreSQL utilities. Here are the results.
Using the --help parameter always works (createdb, createuser, dropdb, initdb, pg_dump, and pg_restore). Output on stdout matches command-prompt results and stderr has a blank line output. Exit code is 0.
Using no parameters, dropdb produces an error message from the command-line that is not shown with the Java app (exit code is 1); createdb shows a password prompt on command-line, nothing on the Java app, throws exit error.
With a user (-Upostgres) parameter, the following utilities show a password prompt from the command-line and nothing on the Java app, throwing an exit error: createdb, pg_restore, pg_dump.
Incidentally findings. without command-line parameters, pg_restore hangs. Shouldn't it close with an error message? The help shown by the pg_dump utility doesn't entirely match the documentation in the manual.
The big problem is where has the utility output, specifically error messages and prompts, gone? Does this qualify as a bug? How to un-break my Java app (and other Java apps that may be doing similar things)?
Michael Schmidt |
| | Add comment |
|
| I can't log in Maximiliano Klemen 19:41:30 |
| | Hi everybody, I'm new here  .
I need some help because I installed postgresql in ubuntu dapper drake with no problems (i did with the repository of ubuntu). The postgres version that i installed is 8.1. I can log in postgres with the psql client with no problems. But when i try to connect to the server from pgadmin3, pgadmin tell me something like "there's an error with the password authentication of the user "postgres". I tried many options, Y modified the configuration file of the server to give at "postgres" user a "trust" authentication from the local machine, and still it told me the same (i have pgadmin in the same machine).
But the problem isn't just with pgadmin. I tried to connect with netbeans 5.5, and the same error raised. What can I do? :S
PD: Sorry for my poor english. I'm learning it.
---------------------------------
PreguntА. RespondИ. DescubrМ.
Todo lo que querМas saber, y lo que ni imaginabas,
estА en Yahoo! Respuestas (Beta).
Probalo ya! |
| | Add comment |
|
| PostgreSQL 8.1: createdb: xflush error ? Steven De Vriendt 19:22:40 |
| | Hi,
I'm trying to make a new database, yet when I try to do this I get the
following error:
ERROR: xlog flush request 0/827520 is not satisfied --- flushed only to
0/80D7B8
CONTEXT: writing block 5 of relation 1663/16893/1259
Can someone give me a clue of what it means ?
Regards,
Steven
|
| | Add comment |
|
| Performance with very large tables Jan van der Weijde 19:13:15 |
| | Hello all,
one of our customers is using PostgreSQL with tables containing millions
of records. A simple 'SELECT * FROM <table>' takes way too much time in
that case, so we have advised him to use the LIMIT and OFFSET clauses.
However now he has a concurrency problem. Records deleted, added or
updated in one process have an influence on the OFFSET value of another
process such that records are either skipped of read again.
The solution to that problem is to use transactions with isolation level
serializable. But to use transactions around a loop that reads millions
of records is far from ideal I think.
Does anyone have a suggestion for this problem ? Is there for instance
an alternative to LIMIT/OFFSET so that SELECT on large tables has a good
performance ?
Thank you for your help
Jan van der Weijde
|
| | 17 answers | Add comment |
|
| Regular expressions and arrays and ANY() question Webb Sprague 18:56:54 |
| | I am trying to figure out how to use a regex and an ANY(), without any
luck, to determine if at least one element of an array (on the right)
matches the given constant pattern (on the left).
I think the problem is because the pattern expects to be on the right
side with the target on the left, but I want to do it reversed. (ie I
want 'Corvalli%' like 'Corvallis', but for postgres the only thing is
'Corvallis' like 'Corvalli%'). Has anybody worked around this before?
See below for code. TIA. Feel free to email me directly.
or_gis=# select * from quads_w_cities where 'Corvallis' = any
(cities); -- this works like I want
ohiocode | cities
----------+-------------------------------------
44123e2 | {Albany,Corvallis,Tangent,Estacada}
44123e3 | {Corvallis,Philomath}
(2 rows)
or_gis=# select * from quads_w_cities where 'corv.*' ~ any
(cities); -- I want this to give me something just like the above
ohiocode | cities
----------+--------
(0 rows)
or_gis=# select * from quads_w_cities where 'corv.*' ~~ any
(cities); -- etc...
ohiocode | cities
----------+--------
(0 rows)
or_gis=# select * from quads_w_cities where 'corv.*' ~* any
(cities);
ohiocode | cities
----------+--------
(0 rows)
or_gis=# select * from quads_w_cities where 'Corv.*' ~* any
(cities);
ohiocode | cities
----------+--------
(0 rows)
or_gis=# select * from quads_w_cities where '.*Corv.*' ~* any
(cities);
ohiocode | cities
----------+--------
(0 rows)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
|
| | 4 answer | Add comment |
|
| Postgres processes have a burst of CPU usage Subramaniam Aiylam 18:47:26 |
| | Hello all,
I have a setup in which four client machines access
a Postgres database (8.1.1) (on a Linux box). So,
there are connections from each machine to the
database; hence, the Linux box has about 2 postgres
processes associated with each machine.
I am using the JDBC driver
(postgresql-8.1-404.jdbc3.jar) to talk to the
database. I am also using the Spring framework(1.2.2)
and Hibernate (3.0.5) on top of JDBC. I use Apache's
DBCP database connection pool (1.2.1).
Now, there is one particular update that I make from
one of the client machines - this involves a
reasonably large object graph (from the Java point of
view). It deletes a bunch of rows (around 20 rows in
all) in 4-5 tables and inserts another bunch into the
same tables.
When I do this, I see a big spike in the CPU usage
of postgres processes that are associated with ALL the
client machines, not just the one I executed the
delete/insert operation on. The spike seems to happen
a second or two AFTER the original update completes
and last for a few seconds.
Is it that this operation is forcibly clearing some
client cache on ALL the postgres processes? Why is
there such an interdependency? Can I set some
parameter to turn this off?
Regards and thanks,
S.Aiylam
____________________________________________________________________________________
Be a PS3 game guru.
Get your game face on with the latest PS3 news and
previews at Yahoo! Games.
http://videogames.yahoo.com/platform?platform=120121
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
|
| | 1 answer | Add comment |
|
| [pgsql-patches] vcbuild fmgrtab.c Magnus Hagander 18:44:25 |
| | This patch is required for vcbuild to work after the changes to
pg_proc.h (it's the same changes that's in gen_fmgrtab.sh in the unix
build)
//Magnus
Index: src/tools/msvc/Solution.pm
===================================================================
RCS file: /projects/cvsroot/pgsql/src/tools/msvc/Solution.pm,v
retrieving revision 1.6
diff -c -r1.6 Solution.pm
*** src/tools/msvc/Solution.pm16 Jan 2007 21:43:19 -00001.6
--- src/tools/msvc/Solution.pm23 Jan 2007 13:22:24 -0000
***************
*** 133,141 ****
oid => $p[0],
proname => $p[1],
prosrc => $p[$#p-2],
! nargs => $p[10],
! strict => $p[7],
! retset => $p[8],
};
}
close(I);
--- 133,141 ----
oid => $p[0],
proname => $p[1],
prosrc => $p[$#p-2],
! nargs => $p[12],
! strict => $p[9],
! retset => $p[10],
};
}
close(I);
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
|
| | 1 answer | Add comment |
|
| Tracking database activity Erik Jones 18:40:27 |
| | Hi, I'm hoping someone can help me wrap my head around some #s I'm using
to track database activity. I have a script that runs hourly and
queries pg_stat_database and checks age(datfrozenxid) in pg_database.
It logs those stats and the next hour, when it runs, it takes the
differences to check the amount of activity over the last hour and then
logs the new stats. I was previously under the impression that by
tracking age(datfrozenxid) in pg_database over time I'd be able to know
how many transactions were processed in a certain amount of time.
However, I've seend that pg_stat_database.xact_commit +
pg_stat_database.xact_rollback < pg_database.age(datfrozenxid) by a
factor of as much as 6 for any given time frame. Am I misunderstanding
something here? Where is the discrepancy coming from?
--
erik jones <erik@myemma.com>
software development
emma(r)
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
| | 2 answer | Add comment |
|
| regular expressions stranges Teodor Sigaev 18:27:00 |
| | Regexp works differently with no-ascii characters depending on server encoding
(bug.sql contains non-ascii char):
% initdb -E KOI8-R --locale ru_RU.KOI8-R
% psql postgres < bug.sql
true
------
t
(1 row)
true | true
------+------
t | t
(1 row)
% initdb -E UTF8 --locale ru_RU.UTF-8
% psql postgres < bug.sql
true
------
f
(1 row)
true | true
------+------
f | t
(1 row)
As I can see, that is because of using isalpha (and other is*), tolower &
toupper instead of isw* and tow* functions. Is any reason to use them? If not, I
can modify regc_locale.c similarly to tsearch2 locale part.
--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/
set client_encoding='KOI8';
SELECT'д' ~* '[[:alpha:]]' as "true";
SELECT
'Дорога' ~* 'дорога' as "true",
'дорога' ~* 'дорога' as "true";
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
| | 3 answer | Add comment |
|
| tripping an assert in 8.1.6 Brian Hurt 18:10:41 |
| | Hello all. It seems I'm tripping an assert in 8.1.6- the assert on line
219 of src/backend/executor/execScan.c (found by running gdb on a core
dump). This is on x86 and Redhat Linux (forget which version). Note
that if I recompile 8.1.6 with asserts turned off the query completes
just fine. I'm trying to put together an example which reproduces the
problem without requiring half our company's data- that should follow soon.
The gdb backtrace is:
#0 0xffffe410 in __kernel_vsyscall ()> (gdb) bt> #0 0xffffe410 in __kernel_vsyscall ()> #1 0xb7d2dee9 in raise () from /lib/ libc.so.6> #2 0xb7d2f4f1 in abort () from /lib/ libc.so.6> #3 0x0824f931 in ExceptionalConditio n (conditionName=Variable > "conditionName" is not available.> ) at assert.c:51> #4 0x081537ac in ExecAssignScanProjectionInfo (node=0x8426bec)> at execScan.c:219> #5 0x08161339 in ExecInitSubqueryScan (node=0x8412de4, estate=0x8426ad4)> at nodeSubqueryscan.c:212> #6 0x0814e0e4 in ExecInitNode (node=0x8412de4, estate=0x8426ad4)> at execProcnode.c:179> #7 0x0814c554 in ExecutorStart (queryDesc=0x842554c, explainOnly=1 > '\001')> at execMain.c:618> #8 0x081193f5 in ExplainOnePlan (queryDesc=0x842554c, stmt=0x839afe4,> tstate=0x83cbdac) at explain.c:243> #9 0x081198ac in ExplainOneQuery (query=0x83b88e4, stmt=0x839afe4,> tstate=0x83cbdac) at explain.c:214> #10 0x08119a92 in ExplainQuery (stmt=0x839afe4, dest=0x83b8a54)> at explain.c:121> #11 0x081da391 in PortalRunUtility (portal=0x83b67b4, query=0x839b07c,> dest=0x83b8a54, completionTag=0x0) at pquery.c:987> #12 0x081db6dc in PortalRun (portal=0x83b67b4, count=2147483647,> dest=0x839b030, altdest=0x839b030, completionTag=0xbf9efee8 "")> at pquery.c:637> #13 0x081d713c in exec_simple_query (> query_string=0x839a26c "explain SELECT action, bloomberg_code, > composite_bloomberg_code, reuters_code, cusip_code, sedol_code, > isin_code FROM vw_ca_generic_actions WHERE (action_date >= > '20070122'::date) AND (action_date <= "...)> at postgres.c:1004> #14 0x081d8bd3 in PostgresMain (argc=4, argv=0x83593f0,> username=0x83593b8 "postgres") at postgres.c:3232> #15 0x081aca37 in ServerLoop () at postmaster.c:2865> #16 0x081ad936 in PostmasterMain (argc=3, argv=0x8358560) at > postmaster.c:941> #17 0x0816c1c9 in main (argc=3, argv=Cannot access memory at address > 0x1515> ) at main.c:265>
This is mainly a "heads up- bug incomming" message. Thanks.
Brian
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
| | Add comment |
|
| odbc configuration to localhost [locally] Ezequias Rodrigues da Rocha 17:56:06 |
| | Hi list,
Is there any tip to set a localhost connection on the windows odbc
configuration to postgresql ?
I am using 127.0.0.1 and localhost and notthing.
Any suggest ?
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda И melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
|
| | 1 answer | Add comment |
|
| Odbc configuration on Localhost Ezequias Rodrigues da Rocha 17:52:50 |
| | Hi list,
Is there any tip to set a localhost connection on the windows odbc
configuration to postgresql ?
I am using 127.0.0.1 and localhost and notthing.
Any suggest ?
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda И melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
|
| | 1 answer | Add comment |
|
| pgAdmin-III 1.6.2 Peter Belbin 16:56:58 |
| | I noticed with 1.6.2 on windows, that when editing a text value in the 'Edit
Data' window that
a) If the currently edited field is of numeric type, the appearance is
changed to some sort of chiseled / 3d depressed looking thing, which,
because of the default dimensions for each row, causes the lower portions of
any value to become obscured. This may be a problem with other types of
column also.
b) If the column is a 'text' column, and is being edited, and has a
large amount of text, it seems that the editor does not allow the
positioning of the cursor all the way to the end of the text the row
contains. Selecting all of the text, copying it, and then pasting it into
another tool, reveals that all of the expected text is there. Pasting this
large body of text back into the field also seems to not be a problem. The
size of the text column in this case, is on the order of 30K in size, and is
essentially entirely occupied. I tried expanding the size to 60K, and it
didn't make any difference.
Keep up the good work, I think you're doing great.
Regards,
Peter Belbin.
NOTICE: This electronic mail transmission may contain confidential
information and is intended only for the person(s) named. Any use, copying
or disclosure by any other person is strictly prohibited. If you have
received this transmission in error, please notify the sender via e-mail.
|
| | Add comment |
|
| show all record between two date after group by and aggrigation... Deepak Pal 16:27:26 |
| | i am fatching record's from data base between two date range for
registration_date coloum and than group by an count it using
count(registration_date) i have to show all dates even if date is not there
in registration_date ,it should show date and 0 in count.,how can i do it
plz healp.......
|
| | 3 answer | Add comment |
|
| How to query by column names Richard Ray 15:01:45 |
| | This may be a simple but can I create a query such as
select (select attname from pg_attribute where attrelid = (select
relfilenode from pg_class where relname = 't1') and attisdropped =
false and attnum > 0) from t1;
I get
ERROR: more than one row returned by a subquery used as an expression
Thanks
Richard
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
|
| | 11 answers | Add comment |
|
| Re: Planning aggregates which require sorted or distinct Stefan Kaltenbrunner 13:52:06 |
| | Karen Hill wrote:> Gavin Sherry wrote:>> Recenly, I've been researching and putting together a proposal for window>> functions.>
Implementing NULLS FIRST and NULLS LAST appears like another> challenging step to getting window functions wrapped up. Has your> research lead you to any ideas on what your strategy for NULLS FIRST> and NULLS LAST likely would be?
maybe I'm missunderstanding your question but tom implemented that
already in -HEAD:
http://archives.postgresql.org/pgsql-committers/2007-01/msg00123.php
Stefan
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
|
| | 19 answers | Add comment |
|
| linked tables in MS Access Ji Nouza 13:48:33 |
| | Hello,
I've read a post [1] about how MS Access is enjoyable and efficient when tables are connected to MS SQL.
But I have MS Access front end containing linked tables to Postgres via ODBC. And I'm struggling with slow performance. When I want to open a table which contains about 8000 records it takes more then 20 sec. When I want to move cursor at the last record it takes more than 60 extra seconds.
I'm not able to bind comboboxes directly to larger (more than 60 records) linked table because unrolling takes 20 sec.
All tables has defined primary key, of course.
I was trying to change indexes without any result.
I've already checked Postgres server log and MS Access queries are executed quickly (<500 ms).
Is this normal behavior? Does MS Access cooperates with MS SQL such better than with other DBMS via odbc?
Does anybody have better experience?
I was trying to communicate from ASP.NET with Postgres via OLE DB driver and it was without any performance problems.
Thank you
Jirka
[1]
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=53&Number=1321886&Zf=&Zw=odbc%20myth&Zg=0&Zl=a&Main=1321886&Search=true&where=&Zu=&Zd=g&Zn=&Zt=1&Zs=a&Zy=#Post1321886&Zp=
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
| | 6 answers | Add comment |
|
| installing pgAdmin3 1.6.2 on FC6 Willy-Bas Loos 12:28:59 |
| | Hi,
I am a novice FC6 user, and trying to upgrade pgAdmin3 from version
1.4.3(default) to
1.6.2
However, it seems yum doesn't find the libs that it depends on (e.g.
wxWidgets 2.8, yum output below)
Since you are offering binaries for FC6 i figure that i should't have to
build the deps from source?
Am i missing a repository where these can be found? I've been reading about
all kinds of trouble with installing wxWidgets 2.8 on FC6, but why offer
ready-built pgAdmin3 1.6.2 if there can be no wxWidgets 2.8??
thx,
Willy-Bas Loos
-- yum errors--
Error: Missing Dependency: libwx_baseu-2.8.so.0 is needed by package
pgadmin3
Error: Missing Dependency: libwx_gtk2u_adv-2.8.so.0(WXU_2.8) is needed by
package pgadmin3
Error: Missing Dependency: libwx_gtk2u_xrc-2.8.so.0 is needed by package
pgadmin3
Error: Missing Dependency: libwx_gtk2u_ogl-2.8.so.0 is needed by package
pgadmin3
Error: Missing Dependency: libwx_gtk2u_adv-2.8.so.0 is needed by package
pgadmin3
Error: Missing Dependency: libwx_gtk2u_core-2.8.so.0 is needed by package
pgadmin3
Error: Missing Dependency: libpq.so.5 is needed by package pgadmin3
Error: Missing Dependency: libwx_gtk2u_stc-2.8.so.0(WXU_2.8) is needed by
package pgadmin3
Error: Missing Dependency: libwx_gtk2u_core-2.8.so.0(WXU_2.8) is needed by
package pgadmin3
Error: Missing Dependency: libwx_baseu_net-2.8.so.0(WXU_2.8) is needed by
package pgadmin3
Error: Missing Dependency: libwx_gtk2u_qa-2.8.so.0 is needed by package
pgadmin3
Error: Missing Dependency: libwx_baseu_xml-2.8.so.0 is needed by package
pgadmin3
Error: Missing Dependency: libwx_gtk2u_html-2.8.so.0(WXU_2.8) is needed by
package pgadmin3
Error: Missing Dependency: libwx_gtk2u_aui-2.8.so.0(WXU_2.8) is needed by
package pgadmin3
Error: Missing Dependency: libwx_baseu-2.8.so.0(WXU_2.8) is needed by
package pgadmin3
Error: Missing Dependency: libwx_gtk2u_html-2.8.so.0 is needed by package
pgadmin3
Error: Missing Dependency: libwx_gtk2u_aui-2.8.so.0 is needed by package
pgadmin3
Error: Missing Dependency: libwx_baseu_net-2.8.so.0 is needed by package
pgadmin3
Error: Missing Dependency: libwx_gtk2u_xrc-2.8.so.0(WXU_2.8) is needed by
package pgadmin3
Error: Missing Dependency: libwx_gtk2u_ogl-2.8.so.0(WXU_2.8) is needed by
package pgadmin3
Error: Missing Dependency: libwx_gtk2u_stc-2.8.so.0 is needed by package
pgadmin3
-- end of yum eerors --
|
| | 4 answer | Add comment |
|
| array_to_string return is different between Windows and Linux systems Pascal Lequeux 12:01:21 |
| | Hi all,
The *array_to_string *function used to compare the content of arrays of
doubles doesn't return the same result if the OS is Windows or if it is
a Linux system.
Here is an example using the same table content:
Result 1: "0,0.000263,*8e-06*,*8e-06*,0.000146,0.000321" [PostgreSQL
8.0.4 (redhat) or 8.1.5 (OpenSuse 10.2)]
Result 2: "0,0.000263,*8e-006*,*8e-006*,0.000146,0.000321" [PostgreSQL
8.1.4, 8.1.5 or 8.1.6 (Windows)]
The string compare fails!
Is there a way to fix the exponent size ?
--
Best regards,
Pascal Lequeux
plequeux@zti.fr
----------------------------------------
ZTI
1 Bd d'Armor
BP 20254
22302 LANNION Cedex
FRANCE
----------------------------------------
Tel.: +33 2 96 48 43 43
Fax.: +33 2 96 48 14 85
Web: http://www.zti.fr ou http://www.zti-telecom.com
----------------------------------------
|
| | 1 answer | Add comment |
|
| MSSQL/ASP migration Robert Fitzpatrick 11:28:11 |
| | I have a customer who is wants to migrate his MSSQL database to
PostgreSQL and we'll replace his application ASP with PHP. The issues
should be limited as there are no stored procedures or triggers in
MSSQL, just structure and data should be all that is needed to migrate.
I have never migrated from MSSQL or to PostgreSQL, but have handled
database migration in the past for other DB's. I know there is
mssql2pgsql script out there somewhere and I find lots of info on the
subject. Of course, when we rebuild his application, some db structure
will change, I was planning to do all the changes to structure after a
successful migration of his current structure now w/o data. After the
new application is done, then create a migration path for the data. Is
that the best way to handle these types of migrations? The customer will
want to continue working on the old system during the several months of
development in the new. Any docs or other helpful info is welcome, just
looking for some advise.
Thanks in advance,
--
Robert
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
|
| | 6 answers | Add comment |
|
| Re: The jdbc Guest 10:10:27 |
| | Hi,
Thanks for the reply.
I still work on it, but i guess this problem may on my application side not the db server. I mean the appserver connection pool or jdbc configuration. I still can not nail it. Because I have another web application with the same iBATIS jdbc configuration to the appserver connection pool and connect to the same postgres 8.1.6 server, this application runs ok with the current_timestamp.
At this time, I found the time insert into this kind of column is slower than the real time and it is closer to the web appserver start time. The start time is also the connection pool start time. If I restart the appserver, the next row that i insert into the time will update to about the appserver start time. It is not looks like a time zone problem.
Thanks.
regards, Steve Yao
-----т й сй Ч-----
Чхк:"Tom Lane" <tgl@sss.pgh.pa.us>
кмй Д:2007-01-17 22:38:51
йу Чхк:"Richard Huxton" <dev@archonet.com>
Ё км:stevegy@126.com,pgsql-general@postgresql.org
жВлБ:Re: [GENERAL] The jdbc and current_timestamp
Richard Huxton <dev@archonet.com> writes:> The time is fixed at the start of the transaction. This lets you do> several inserts having the same timestamp.
I think there's another problem here, which is that he's declared
"currenttime" as a timestamp without time zone, but the
CURRENT_TIMESTAMP function yields timestamp with time zone,
meaning there's a TimeZone-dependent conversion going on. It sounds
to me like there's a difference between the TimeZone setting between
his web app and his psql, leading to an hour's offset, plus a smaller
offset having to do with time-since-transaction-start.
And read the preceding chapter's discussion of the different datetime
data types.
regards, tom lane |
| | 1 answer | Add comment |
|
| New US DST Rules & PostgreSQL Adam Gordon 09:18:49 |
| | Hi-
Anyone know where to find info about whether or not the new US DST rules
impact certain versions of Postgres and what needs to be done to ensure
observance of the new rules? Thanks.
-- adam
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
| | 2 answer | Add comment |
|
| pg_dump ANALYZE statements Simon Riggs 09:08:55 |
| | There is currently a performance tip to run ANALYZE after a pg_dump
script has been restored.
ISTM that pg_dump should default to have ANALYZE statements for a table,
when both table definition and data are dumped. If only data (-a) or
only table definition (-s) is dumped the default should be to *not* add
an ANALYZE statement.
There doesn't seem to be any reason to skip the ANALYZE, but I'll
implement it as an option.
-z on | off
--analyze=on | off
This would add a table-specific ANALYZE statement following each table's
actions.
I'm not aware of a strong argument against such an option. Performance
surely can't be one because the time saved on the ANALYZE will quickly
bite back on time lost on poorly planned queries.
What does the panel think?
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
|
| | 6 answers | Add comment |
|
