Howdy;
We have written an application that uses PG as the backend database.
We currently embed the database servers IP address in a text file that
the installed (created using Inno) uses when setting up the client
programs (ie, stores this info in a local .ini file).
Is there a recommended way of
When I tried to install pg8.2 on Win2k3 service pack 2 using the
installer I received the error message window
Unable to connect to the test network socket : 100013
If I changed the port from the default '5432' to 5433 works fine.
- any suggestions ?
Google showed me an email regarding this
Any ideas now?
Are you *sure* you have checked the permissions of the os user_id that
is assigned to run the postgreSQL service ?
PG is very specific about the permissions it wants and just as
importantly it is very specific about the permissions it DOES NOT
want.
I would suggest you start
Does anyone have any suggestions for running PG2.9 on win2k3 running
as a guest on VMware ESX ?
Currently the system is shutting down and transactions are terminating
with the messages indicating there is not available disk space, when
in fact there is plenty of disk space available.
Google
Have you tried to duplicate it w a native install of w2k3?
This customer had been working with pg2.9 on win2k3 native for
several months without issue. Hardware company upgraded them to a new
server and used VMWare to copy the server and an instance ESX and then
move the entire server to a
Ah, but it's a record, so pass a record type in:
CREATE TYPE cobol_file_type AS (a integer, b text, c varchar, d date);
CREATE FUNCTION build_tables1(c cobol_file_type)...
Each existing table has its own type defined too (with the same name),
which might save you some time.
--
Richard
I am attempting to port and application that was designed for MS-SQL
to Postgres and bumped into a limitation of pg functions, namely that
pg functions can only support 32 parameters.
Our app takes records from a only cobol file(s) and populates an SQL
table(s), such that one table in the db =
On Apr 8, 12:20 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
Richard Huxton [EMAIL PROTECTED] writes:
imageguy wrote:
I am attempting to port and application that was designed for MS-SQL
to Postgres and bumped into a limitation of pg functions, namely that
pg functions can only support 32
On Jul 12, 4:03 pm, [EMAIL PROTECTED] (Steve Crawford)
wrote:
imageguy wrote:
I am building an application with Postrges as the backend foundation.
This is my first application and it has struck me that as we add
features/functionality to the application and database with each new
version
I am building an application with Postrges as the backend foundation.
This is my first application and it has struck me that as we add
features/functionality to the application and database with each new
version, we will need some method of obtaining the current structure
of the customers database
On Apr 7, 4:07 pm, [EMAIL PROTECTED] (RPK) wrote:
I am using PGSQL 8.2.3 on Windows XP. I want to know whether there is any way
of documenting the schema of PGSQL database so that I can get a printed copy
of the same.
--
View this message in
Tom Lane wrote:
imageguy [EMAIL PROTECTED] writes:
So... unless I am missing something, I would suggest you CANNOT us
plpython (or perhaps any other pl language ??) to process transactions
I think the point you are missing is that every function already runs
within a transaction. You
Tom Lane wrote:
imageguy [EMAIL PROTECTED] writes:
In my testing so far, it seems that each call to plpy.execute('INSERT
INTO ') is committed immediately.
On what do you base that (erroneous) conclusion?
The fact that a transaction can see its own updates does not mean
Does anyone have an example of using transactions with plpythonu ?
I want to create a function that receives data from a client app, and
then updates three different tables but I want to ensure they all get
updated before I commit.
In my testing so far, it seems that each call to
Martijn van Oosterhout wrote:
On Sun, Jan 21, 2007 at 04:56:23AM -0800, imageguy wrote:
Does anyone have an example of using transactions with plpythonu ?
In my testing so far, it seems that each call to plpy.execute('INSERT
INTO ') is committed immediately.
What happens if you do
What happens if you do:
plpy.execute(BEGIN);
before and after
plpy.execute(COMMIT);
Have a nice day,
--
Thanks for your reply Martin.
After making my post I decide not to be so lazy and set up a test
environment.
After try exactly what you suggested, I got the following error code
Clodoaldo wrote:
5 Jan 2007 06:59:18 -0800, imageguy [EMAIL PROTECTED]:
I think I know the answer,
If you know the answer please tell it as I have read some discussions
on the web and although I have decided on a solution I'm still not
sure about the best answer, if there is a best
Scott Ribe wrote:
Personally, I'd put them on the file system, because then backup software
can perform incremental backups. In the database, that becomes more of a
difficulty. One suggestion, don't use a file name from a hash to store the
image, just use the serial id, and break them up by
18 matches
Mail list logo