Hi,
I'v been playing with Visual Studio 2005 beta 2 recently. I'm evaluating
it as a RAD tool for developing GUI front-ends to Postgresql.
RAD means for me something similar to Delphi: you configure a database
connexion, drop a few objects on a form, controls, you bind the controls
to the datasou
"Philippe Lang" <[EMAIL PROTECTED]> writes:
> Although Npgsql seems to be a very nice library to access Postgresql, I
> was not able to do that. Adding a database to the project is fine for MS
> Access / SQL Server / Oracle databases, but I'm still searching how to
> do it for Postgresql.
>
> So m
Hervé Inisan wrote:
Hi everybody!
I have a trigger like this:
CREATE TRIGGER mytrigger
AFTER INSERT OR UPDATE OR DELETE
ON myschema.mytable
FOR EACH ROW
EXECUTE PROCEDURE myschema.myfunction(myarg);
It sends an argument to myfunction(), and I can retrieve this value in
TG_ARGV[0].
I have postgresql7.4.6 runing . I am not able to log into database using
psql and also tried to create new database using createdb but getting the
following error for both
psql: relocation error: psql: undefined symbol: get_progname
createdb: relocation error: createdb: undefined symbol: get_pro
Try using with ODBC works great for VS2005
On 5/27/05, Philippe Lang <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'v been playing with Visual Studio 2005 beta 2 recently. I'm evaluating
> it as a RAD tool for developing GUI front-ends to Postgresql.
>
> RAD means for me something similar to Delphi: you
Nageshwar Rao wrote:
> I have postgresql7.4.6 runing . I am not able to log into database
> using psql and also tried to create new database using createdb but
> getting the following error for both
>
> psql: relocation error: psql: undefined symbol: get_progname
>
> createdb: relocation error: cr
> Hervé Inisan wrote:
> > Hi everybody!
> >
> > I have a trigger like this:
> >
> > CREATE TRIGGER mytrigger
> >AFTER INSERT OR UPDATE OR DELETE
> >ON myschema.mytable
> >FOR EACH ROW
> >EXECUTE PROCEDURE myschema.myfunction(myarg);
> >
> > It sends an argument to myfunction(), a
Thanks for that!
Is there any way I can check if my Postgres was compiled using that
option or not?
Yateen V. Joshi
-Original Message-
From: Douglas McNaught [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 26, 2005 8:49 PM
To: Yateen Joshi
Cc: pgsql-general@postgresql.org
Subject: Re: [GE
>It should not be ... at least, assuming that Slony is using
>the standard DROP TRIGGER operation, rather than playing
>directly with the system catalogs ...
AFAICS, the slony uninstall command is not doing anything exotic, though
it DOES do a little bit of fiddling with pg_catalog to RESTORE
pr
On Thu, 26 May 2005, [iso-8859-1] Hervé Inisan wrote:
> It sends an argument to myfunction(), and I can retrieve this value in
> TG_ARGV[0]. Fine.
> What I'm trying to do is using TG_ARGV[0] to point to a field in NEW or OLD.
> Is it possible?
>
> Something like NEW.TG_ARGV[0]...
>
> I'm trying to
On May 26, 2005, at 5:04 PM, Hrishikesh Deshmukh wrote:
Is it possible to connect a DB in Postgresql to a DB in MySQL!
I know its a crazy idea!
H
http://pgfoundry.org/projects/dbi-link/
although you'll need a patch to make it work unless the author has
updated it.
--
Jeff Trout <[EMAIL
Hi,
we are planning to use Postgresql 8.0 on a SUN Fire v40z Server with 4
SingleCore Opterons. It will be later replaced by an DualCore
Opterons.
Would you prefer using Solaris or Linux?
Thanks in Advance,
Thomas
---(end of broadcast)---
TIP 2: y
See:
http://gborg.postgresql.org/pipermail/npgsql-general/2005-May/001374.html
Philippe Lang schrieb:
Hi,
I'v been playing with Visual Studio 2005 beta 2 recently. I'm evaluating
it as a RAD tool for developing GUI front-ends to Postgresql.
RAD means for me something similar to Delphi: you c
Hi All,
I have a huge database working on a debian linux machine, this machine
is going to get a hard drive wipe and new OS. I have another debian
linux machine (exact hardware + software). Is there a way to get
database "migrated" from machine 1 to machine 2 without much work?
Anxiously waiting
--- Philippe Lang <[EMAIL PROTECTED]> wrote:
>
> So my question is: is it reasonable to expect as much integration of
> Postgresql in Visual Studio than with the other databases? Does
> anyone
> work under Visual Studio as easily with Postgresql than with MS
> Access /
> SQL Server?
>
Open the
On May 27, 2005, at 12:10 PM, Hrishikesh Deshmukh wrote:
Hi All,
I have a huge database working on a debian linux machine, this machine
is going to get a hard drive wipe and new OS. I have another debian
linux machine (exact hardware + software). Is there a way to get
database "migrated" from
Both are good, I guess it depends what kind of expertise you have around
or are willing to pay for.
For me I would pick Linux because it is easier to install and maintain,
and there is much more articles etc on the web.
For a bullet proof Linux Install you could use CentOS which is a clone
of
Thomas Chille wrote:
Hi,
we are planning to use Postgresql 8.0 on a SUN Fire v40z Server with 4
SingleCore Opterons. It will be later replaced by an DualCore
Opterons.
Would you prefer using Solaris or Linux?
Thanks in Advance,
Thomas
---(end of broadcast)-
On Friday 27 May 2005 12:52, Jeff Trout wrote:
> On May 27, 2005, at 12:10 PM, Hrishikesh Deshmukh wrote:
> > Hi All,
> >
> > I have a huge database working on a debian linux machine, this machine
> > is going to get a hard drive wipe and new OS. I have another debian
> > linux machine (exact hardw
Hi everybody!
Recently I was struggling with client/server issues in MS Access/PostgreSQL
combination.
Although Access is intuitive and easy to use desktop database solution, many
problems appear when someone is trying to use it as front-end for real
server database systems such as PostgreSQL
tom lane wrote:
> Why does it think that only 159 of the 132245 rows in outages will have
> join partners in ipinterface? The actual results look like they all do.
> It might be worth looking at the pg_stats rows for the join columns to
> see if there's something odd about the statistics.
>
He
I know better what is happening now. I had the scenario slightly wrong.
Slony creates a trigger on all replicated tables that calls into a
shared library. The _Slony_I_logTrigger method in this library
establishes a saved plan for inserts into its transaction log table
sl_log_1. I can create the m
Added to TODO:
* Consider sorting hash buckets so entries can be found using a binary
search, rather than a linear scan
* In hash indexes, consider storing the hash value with or instead
of the key itself
---
Neil Conw
Folks,
if you go to the root of your postgresql distro
and type
./configure --version
what version of AutoConf was used?
thanks!
--Ross
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
j
Dave E Martin <[EMAIL PROTECTED]> writes:
> tom lane wrote:
>>> Why does it think that only 159 of the 132245 rows in outages will have
>>> join partners in ipinterface? The actual results look like they all do.
>>> It might be worth looking at the pg_stats rows for the join columns to
>>> see if
"David Parker" <[EMAIL PROTECTED]> writes:
> I can create the missing OID error with:
> 1) configure replication
> 2) establish a client connection, perform operations on replicated
> tables
> 3) remove replication (drops sl_log_1 table)
> 4) operations on replicated tables on client connection ar
"Mohan, Ross" <[EMAIL PROTECTED]> writes:
> if you go to the root of your postgresql distro
> and type
> ./configure --version
> what version of AutoConf was used?
For any reasonably recent PG release, it will be 2.53 if built from
source. Some RPM distributions may have re-autoconf'd though (I
27 matches
Mail list logo
