среда, 10 февраля 2010 г.
|
| along with other ways to keep your data safe, you may also... Guest 16:28:07 |
| | along with other ways to keep your data safe, you may also try the how to repair sql server 7 database program: http://www.recoverytoolbox.com/how_repaire_database_not_connected_to_sql_server.html, the service of data recovery prevents the corruption of specified files |
| | Add comment |
воскресенье, 24 января 2010 г.
|
| I would like to share my experience with regard to fix pdf... Guest 16:21:00 |
| | I would like to share my experience with regard to fix pdf, it is here: http://www.recoverytoolbox.com/how_to_convert_pdf_corrupted_file_into_uncorrupted_file.html, this program quickly parses corrupted database files and retrieves the data when possible |
| | Add comment |
суббота, 23 января 2010 г.
|
| I would like to share my experience with regard to how can... Guest 15:41:18 |
| | I would like to share my experience with regard to how can i import sql scripts in other database? it is here: http://www.recoverytoolbox.com/how_do_you_import_information_into_a_sql_database.html. this program quickly parses corrupted database files and retrieves the data when possible. |
| | Add comment |
пятница, 20 ноября 2009 г.
понедельник, 2 ноября 2009 г.
|
| Hello!Just a question. What is wrong with this code? This... Guest 05:27:13 |
| | Hello!
Just a question. What is wrong with this code? This is part of trigger function:
attnum[3] = SPI_fnumber( tupdesc, "arfolyam" );
datums[3] = _selectFunctionB( "SELECT ertek FROM foo WHERE parameter='rate'" ); // This get back Datum type from select - PG_RETURN_FLOAT8( b ); is return where b is double type
arfolyam = DatumGetFloat8( datums[3] );
elog( INFO, "2.5.0 arfolyam = %f", arfolyam );
if ( attnum[3] == PointerGetDatum( NULL ) ) {
elog( ERROR, "Hianyzo arfolyam" );
SPI_finish();
return PointerGetDatum(NULL);
}
elog( INFO, "2.5.1 Datums[3] = %f", DatumGetFloat8( datums[3] ) );
rettuple = SPI_modifytuple( trigdata->tg_relation, tmptuple, 4, &attnum[0], &datums[0], &isNull[0] );
SPI_freetuple(tmptuple);
SPI_finish();
return PointerGetDatum( rettuple );
The output is the next after insert:
INFO: string vissza : 1.000000
INFO: 2.5.0 arfolyam = 1.000000
INFO: 2.5.1 Datums[3] = 1.000000
INSERT 0 1
ELES=# SELECT * FROM pgsor;
ERROR: invalid memory alloc request size 4294967293
Thanks in advance!
Josef Dudas |
| | Add comment |
четверг, 18 декабря 2008 г.
|
| I want to Install D-Space using a platform named Xampp... Guest 17:44:32 |
| | I want to Install D-Space using a platform named Xampp. Xampp has the apache server and uses a Java Compiler. But can i use Xampp's MySQL instead of postgre or Oracle?
|
| | Add comment |
среда, 22 октября 2008 г.
|
| This is a very old thread but as far is I know the lack of... Guest 14:20:15 |
| | This is a very old thread but as far is I know the lack of record introspection still exists and people are still looking for answers.
One cumbersome solution is to get the table field names using the Postgres meta data.
Then loop trough the field names and for every field name execute a select query with a filter on the record id like: 'select '|| fieldName || ' as fieldValue from table where id = x' ....etc. Because fieldValue always exist you are now able to access it trough: record.fieldValue
Using this method you can build your dynamic insert query.
Performance note: Almost superfluous to state that for each field a select statement is executed.
Greetz,
Marco Wayop |
| |  1 answer | Add comment |
вторник, 19 августа 2008 г.
|
| I didnt get anything al last. Guest 14:35:25 |
| | I didnt get anything al last. |
| | Add comment |
вторник, 1 июля 2008 г.
|
| a Obe 6 October 2006 11:59:42 I'm moivng over SQL Server... Guest 09:31:32 |
| | a Obe 6 October 2006 11:59:42
I'm moivng over SQL Server 2000 32-bit databases over to SQL Server 2005 64-bit and ran into a small problem.
In the old setup, I had a linked server configuration to a Postgresql server which used the 32-bit driver. In the new setup, the SQL Server 2005 64-bit can't see the 32-bit drivers (unless I run in 32-bit mode) and I don't think its possible for it to since its runing in 64-bit SQL Server. So I'm guessing I need to get a 64-bit PostGreSQL ODBC driver, somehow get the pgsql .NET driver to be seen as an option, or possibly the 32-bit.
Thanks,
Regina
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any compute |
| | Add comment |
суббота, 21 июня 2008 г.
|
| anyone who read this check case of 'phpPgAdmin' in link... Guest 08:34:11 |
| | anyone who read this check case of 'phpPgAdmin' in link 'http://192.168.3.22/phpPgAdmin/index.php' maybe it heve to be 'phppgadmin' ;) |
| | Add comment |
вторник, 17 июня 2008 г.
|
| hey if u not interested, dont visit this page.... dont... Guest 19:32:12 |
| | hey if u not interested, dont visit this page.... dont comment others... 
Never mind Sandhya ... |
| | 2 answer | Add comment |
понедельник, 24 сентября 2007 г.
|
| CREATE OR REPLACE FUNCTION array_int(_int4) RETURNS int4 AS... Guest 23:43:45 |
| | CREATE OR REPLACE FUNCTION array_int(_int4)
RETURNS int4 AS $$
DECLARE
start_char INTEGER DEFAULT 4;
len_char INTEGER;
array_count INTEGER;
val_tmp VARCHAR;
tmp INTEGER;
BEGIN
SELECT INTO val_tmp array_dims( $1 ) ; --get the length of the array => [x:y]
SELECT INTO len_char ( position(']' in val_tmp) - start_char ) ; --get the length of y
SELECT INTO array_count substring(val_tmp from start_char for len_char); --get the value of y
FOR tmp IN 1..(array_count) LOOP
RAISE NOTICE 'current value = %' , $1[tmp] ;
END LOOP;
RETURN array_count ;
END;
$$ LANGUAGE plpgsql; |
| | Add comment |
понедельник, 18 июня 2007 г.
|
| I got the same problem with MySQL 5.0 and don't have a... Guest 12:16:32 |
| |
I got the same problem with MySQL 5.0 and don't have a solution till now.
Titus
|
| | Add comment |
понедельник, 5 марта 2007 г.
|
| look pg_resetxlog!!!! Guest 10:13:26 |
| | look pg_resetxlog!!!! |
| | Add comment |
вторник, 12 декабря 2006 г.
|
| OpenExchange Postgresql problem Guest 15:41:20 |
| | After a recent power failure, we are unable to run our SuSE OpenExchange email program from the webmail interface. The OutlookExpress interface still functions. The postgresql log file is filled with the message,"mdfd_getrelnfd:can not open pg_shadow_usename_index No such file or directory" Do you know what this file is and where it is supposed to be located?
thanks |
| | Add comment |
пятница, 7 июля 2006 г.
|
| HiJoe,do you have a manual for dblink functions, say how to... Guest 11:24:30 |
| | HiJoe,
do you have a manual for dblink functions, say how to set dblink_connect, dblink_exec etc.
Thanks. |
| | 2 answer | Add comment |
четверг, 22 июня 2006 г.
|
| is there any way where i can get a plugin for my mac os x... Guest 15:04:12 |
| | is there any way where i can get a plugin for my mac os x computer to download pacific poker please let me know thanxs |
| | Add comment |
пятница, 16 июня 2006 г.
|
| I have a HP-UX 10.20 (9000 series) server. How can I change... Guest 10:09:18 |
| | I have a HP-UX 10.20 (9000 series) server. How can I change the Ip address of that server. I am running some old COBOL application on that server. |
| | Add comment |
четверг, 4 мая 2006 г.
|
| what is dynamic and static linkage?jess .. stuck on I.T... Guest 23:42:36 |
| | what is dynamic and static linkage?
jess .. stuck on I.T homework
.. =P x |
| | Add comment |
понедельник, 10 апреля 2006 г.
|
| I'm getting this error. Guest 12:31:42 |
| | I'm getting this error. |
| | Add comment |
понедельник, 20 марта 2006 г.
|
| About pg_hba.conf file Guest 12:52:28 |
| | Hi,
How to add an entry that is another computer (for e.g the IP address of a machine is 200.200.200.1 and its subnet mask as 255.255.255.0). |
| | Add comment |
вторник, 7 марта 2006 г.
|
| I have lot of problem i try to open to adminstrative... Guest 16:25:58 |
| | I have lot of problem i try to open to adminstrative perissions.
and system adminstratrator
than i try to download password assistant i got stuck with adminstrator lock
it up what i do ?
From
Mike Donato |
| | Add comment |
среда, 1 марта 2006 г.
|
| Hi Beautiful......... Remember me Hows it goin? Hope ur... Guest 19:58:16 |
| | Hi Beautiful.........
Remember me
Hows it goin? Hope ur doin well. Like 2 see u again.
If u get this mail me 2
Cloud_a3@yahoo.com
I'll b waiting
B-GOOD & take care |
| | Add comment |
|
