On Sat, Feb 19, 2011 at 5:03 AM, andrew1 andr...@mytrashmail.com wrote:
hi all, I need to load mysql dump to postgre 8.3 . Is there a script to do
that? I hoped to use my2pg.pl , but couldn't find it.
It looks like it's not a part of /contrib in debian lenny.
what shoud I use for 8.3?
Hi,
In any way may I ask to add information in protocol-message-formats.html that
for command status for queries like COMMIT, ROLLBACK, PREPARE TRANSACTION
status may be ROLLBACK. It is important for XA resources to check what
actually happend. I can't find this in documentation as well.
My application builds successfully in Xcode and runs without problems in my mac
(running snow leopard 10.6.6) because I have properly installed the postgres
9.0 software.
But when I am trying to run my application in an other mac (that hasn't the
postgres installed) I get the following error:
On 2011-02-03, Kenneth Buckler kenneth.buck...@gmail.com wrote:
One of the programmers I work with is interested in migrating from
Oracle to PostgreSQL as the backend for his applications.
Is there a PostgreSQL beginners guide available somewhere, which
might help him understand setting up a
On 02/18/2011 08:03 PM, andrew1 wrote:
hi all, I need to load mysql dump to postgre 8.3 . Is there a script to do
that? I hoped to use my2pg.pl , but couldn't find it.
It looks like it's not a part of /contrib in debian lenny.
what shoud I use for 8.3?
thanks.
I cannot convert the dump, but
On 18/02/2011 15:40, trex005 wrote:
I am trying to archive a schema, however there is a certain table that
gets skipped with pd_dump
The table's name is 'servers'. I checked to see if it is a reserved
word, and it does not appear to be...
Thinking I was missing something I tried using -t
On 02/19/2011 08:03 AM, Raymond O'Donnell wrote:
On 18/02/2011 15:40, trex005 wrote:
I am trying to archive a schema, however there is a certain table that
gets skipped with pd_dump
The table's name is 'servers'. I checked to see if it is a reserved
word, and it does not appear to be...
On Fri, 2011-02-18 at 21:03 -0500, andrew1 wrote:
I need to load mysql dump to postgre 8.3 . Is there a script to
do that?
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL
Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL
On Thu, 17 Feb 2011 07:58:46 -0800 (PST), Ahmed
ahmed.shinw...@gmail.com wrote:
I tried changing that one line to use UTF-8 encoder, but the password packet
didn't get fixed. It works smoothly if kept in byte array instead of string.
Yes, as SSPI uses binary bytes we have to avoid to convert
Thanks for the information..
However, I'm still unable to figure how to do a clean build of extensions on
Windows using VS 2008.
To start with, the main contrib module doesn't seem to have a
nmake-compatible Makefile, and
I don't seem to find any project under 'contrib' which has a
On Friday, February 18, 2011 7:40:59 am trex005 wrote:
I am trying to archive a schema, however there is a certain table that
gets skipped with pd_dump
What does the log file show when you do the dump?
Any output to the screen when the dump is being run?
If not maybe run with -v switch to get
I want to get the names, the type and the length of all columns in a postgres
query using c-api calls.
For example from:
SELECT customers.id, customers.name, transaction.date, transaction.amount FROM
customers, transactions
I must get:
customers.id,
customers.name,
transaction.date,
On Feb 19, 2011, at 4:42 PM, PANAGIOTIS GERMANIS wrote:
want to get the names, the type and the length of all columns in a postgres
query using c-api calls.
This documented pretty clearly in the libpq docs:
http://www.postgresql.org/docs/9.0/static/libpq.html
--
Scott Ribe
On 02/20/2011 05:30 AM, deepak wrote:
Thanks for the information..
However, I'm still unable to figure how to do a clean build of
extensions on Windows using VS 2008.
To start with, the main contrib module doesn't seem to have a
nmake-compatible Makefile, and
I don't seem to find any project
build.pl parses the Makefile to determine the list of sources, etc.
Essentially, your extension is built using the unix Makefile. Since you've
already built Pg its self from sources you will have used build.pl to do
it (right?) and it'll be easy for you to add the contrib module and re-run.
hello, i had defined user-defined function and type in database A by using user
Root.when i want to access the function and type in another database B by using
the same user Root, but found that i could't access them. How to make the
user-defined function or type being accessed in the global
My application builds successfully in Xcode and runs without problems in my mac
(running snow leopard 10.6.6) because I have properly installed the postgres
9.0 software.
But when I am trying to run my application in an other mac (that hasn't the
postgres installed) I get the following error:
On 02/19/11 5:57 PM, wrote:
hello, i had defined user-defined function and type in database A by
using user Root.when i want to access the function and type in another
database B by using the same user Root, but found that i could't
access them. How to make the user-defined function
On Feb 19, 2011, at 4:09 AM, PANAGIOTIS GERMANIS wrote:
Dyld Error Message:
Library not loaded: libpq.5.dylib
Referenced from:
/Volumes/Documents/Projects/Mac_Software/iMacProjects/macReport/build/Release/macReport.app/Contents/MacOS/macReport
Reason: image not found
There are two
On 02/20/2011 09:38 AM, deepak wrote:
build.pl http://build.pl parses the Makefile to determine the list
of sources, etc. Essentially, your extension is built using the unix
Makefile. Since you've already built Pg its self from sources you
will have used build.pl
On 02/20/2011 09:57 AM, wrote:
hello, i had defined user-defined function and type in database A by
using user Root.when i want to access the function and type in another
database B by using the same user Root, but found that i could't access
them. How to make the user-defined function
21 matches
Mail list logo