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 mess
> 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 wit
> 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 ne
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 tells
> 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.
>
> --
>
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, namel
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 = one
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 d
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
> context:http://www.nabble.com/Documenting-PG
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 tha
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 e
> 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 erro
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 co
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 plpy.execute('IN
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
> sur
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 b
18 matches
Mail list logo
