Hi!
I am still working on this problem. With the installer of postgres,
it is not possible for me to install a second postgresql(maybe i just
try it in the wrong way?)!
With the binary, there are some showstoppers for me (executing as
postgres-user and adding a service with activated panda-
1) Run PgAgent.sql script in maintenance database (Postgres database by
>default).
I copied that script and executied in Query tool, it is executed and i
get that job icon tab.
2) Install PgAgent service using the following command on command >prompt -
"C:\Program Files\
Hello Andrew
> You can see things that happened in your own transaction, but nobody
> else can. If you're working READ COMMITTED, you can also see work
> that other transactions commit while you were working. Could any of
> that be affecting you? Unless your own function is doing something
> wi
Hello,
I have a problem with the postgreSQL Source Code when I compile the
fuzzystrmatch.c. I want to try to replace all german umlauts for the soundex
algorithm. But when I want to compile the C Code, I get an error on the
following line in the fuzzystrmatch.c:
PG_MODULE_MAGIC;
And her
Dear Vishal, Ashish,
I need one more help also...
I already connected two systems (one is server that is ip address of
172.16.84.76/32, another is like a client 172.16.85.243/32) this connection is
working fine... now i want to connect one more system in to 172.16.84.76/32
The new system
Dear Vishal, Ashish,
In third point u mentioned (
start>>shutdown>>Logoff your machine and login as postgres user (operating
system) I tried that, That is not working,because here the domain name is
standard so it is checking that user name globely and reject that user name.
What is the next
Jürgen Ulrich wrote:
Hello,
Hi,
I hope this is what you're looking for:
add to your C code:
#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
Regards,
Marcin
I have a problem with the postgreSQL Source Code when I compile the
fuzzystrmatch.c. I want to try to replace all german umlauts for
Re: [ADMIN] PgAgent Job Scheduling-BackupJay,
dont login to domain using postgres user login to youe syatem, anyways as u
see sql file is there means ur job has successfull , its a backup file,
be care full with what are things u want to include in ur backup with pg_dump
command parametrs in
=?iso-8859-1?Q?J=FCrgen_Ulrich?= <[EMAIL PROTECTED]> writes:
> In function 'Pg_magic_func': 'PG_VERSION_NUM' undeclared (first use in
> function)
Perhaps you forgot to include postgres.h? That should always be the
very first #include in any backend module.
regards, tom la
On Tue, Jul 17, 2007 at 07:59:32AM +0200, De Leeuw Guy wrote:
> the COPY start a transaction
Yes. _Everything_ is in a transaction in PostgreSQL. If you don't
explicitly do BEGIN. . .COMMIT, then the system does it implicitly
for each statement.
> if yes each time my trigger select a data
> an
Can someone help? Need a plpgsql debugger.
Thanks
Danny Abraham
CTM&D BU
972-52-4286-513
[EMAIL PROTECTED]
> Yes. _Everything_ is in a transaction in PostgreSQL. If you don't
> explicitly do BEGIN. . .COMMIT, then the system does it implicitly
> for each statement.
>
>> if yes each time my trigger select a data
>> and update then the value returned by the read are the value before the
>> transacti
On Tue, Jul 17, 2007 at 05:49:15PM +0200, De Leeuw Guy wrote:
> > Your trigger function runs inside the transaction of the calling
> > statement, unless you have explicitly started a transaction.
> >
> Not possible from a trigger
Yes, sorry, I phrased that wrong. Let me put it differently: y
Hi Danny,
I think there is commercial GUI tool from EMS which supports plpgsql
debugging. download the trial version & check this.
http://www.sqlmanager.net/en/products/postgresql/manager
Thanks,
Umesh
- Original Message -
From: Abraham, Danny
To: pgsql-admin@postgresql.org
Hello,
What if you just rolled your own installer so that you would have control
over everything.
You could follow my blog (that was referenced earlier in this thread) to
some degree.
The first think that I would do is to get an install just the way you want
it on a DEV machine. Then I would
I have a huge table to load (30+M rows).
Dropping indexes before loading will speed up my process, but I am not sure
about the primary key that was created with the table creation. Is the Postgres
primary key treated like an index? If yes, dropping the primary key might help
my loading as well
Jessica Richard wrote:
I have a huge table to load (30+M rows).
Dropping indexes before loading will speed up my process, but I am not
sure about the primary key that was created with the table creation. Is
the Postgres primary key treated like an index? If yes, dropping the
primary key might
> Yes, sorry, I phrased that wrong. Let me put it differently: your
> trigger runs only inside the transaction of the calling statement,
> unless that statement itself is inside a longer explicitly-called
> transaction. For example:
>
> t1t2
>
> BEGIN
ALTER TABLE tableName ADD CONSTRAINT pkname_pkey (column1, column2,
...);
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jessica Richard
Sent: Tuesday, July 17, 2007 2:44 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Can primary key be dropped
On Tue, Jul 17, 2007 at 08:45:13PM +0200, De Leeuw Guy wrote:
> I have :
> table test ( int code, int qte);
Right, I remember that part.
> t1
Is that BEGIN;? If not, this is _not_ one transaction. It's two.
> INSERT test values(1, 150)
>call my trigger that SELECT WHERE code=3 (does not
I'm installing an application that provides a ".sql" script to create tables
and other objects in a postgresql database. When I run the script as user
"postgres" the script executes without errors. But then all the tables and
other objects are owned by "postgres". A user that I created to access t
On Tue, Jul 17, 2007 at 06:45:29PM +0300, Abraham, Danny wrote:
> Can someone help? Need a plpgsql debugger.
You can get our debugger from the bottom of
http://www.enterprisedb.com/downloads.do
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprise
> Is that BEGIN;? If not, this is _not_ one transaction. It's two.
>
Ok
> You're not actually _calling_ the trigger, right? It just happens
> automatically? Also, I don't have the slightest clue how this code=3
> (does not exist) works. AFAICT code=1. So code=3 is never true, no?
>
Yes
Hi Paul,
i did not received a eMail with the answer and the Link to your Blog
from the postgres list. But a link within this eMail lead me to the
correct answer and link.
Your blog entry looks pretty suitable. Especially the "postgres
register" could be a nice way to deploy just the binarie
km4hr написа:
I'm installing an application that provides a ".sql" script to create tables
and other objects in a postgresql database. When I run the script as user
"postgres" the script executes without errors. But then all the tables and
other objects are owned by "postgres". A user that I crea
km4hr <[EMAIL PROTECTED]> writes:
> What privileges does "newuser" need to create functions? I can't find that
> described in the postgres manual?
The GRANT reference page has most of the details you want, I think.
regards, tom lane
---(end of bro
Jim C. Nasby a écrit :
> On Tue, Jul 17, 2007 at 06:45:29PM +0300, Abraham, Danny wrote:
>> Can someone help? Need a plpgsql debugger.
>
> You can get our debugger from the bottom of
> http://www.enterprisedb.com/downloads.do
But he needs to use EnterpriseDB Advanced Server to use EnterpriseDB
PL
Hi all,
In order to save a fair amount of space I am creating a schema
against which I will want to run the following simplified query. Think
of the size of the tables as data ~ 30 M rows, series has 10,00
entries, data_has_dimensions has 300 K rows, dimensions is tiny
select populati
Great... Good luck...
Just an additional note, I've chosen a naming convention with the folders
for all of my PostgreSQL installs that matches the ports that they are
running on. For instance, I have a pgdata folder that has a 5432 and a 5433
folder in it. I then copy the binaries into those fo
PostgreSQL Manager from EMS has one.
I recommend getting their Studio product, which integrates all of their
tools.
Definitely worth the price.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Dear Vishal, Ashish,
Thanks for the GREAT HELP... I am in Satyam-Hyderabad..Actually i am a Sybase
DBA.. My Native is Chennai.. For job sake only i came here.. If any job wise
any help, kindly let me know I will help u guys... I want to continue this
friendship for ever...
Thanks & Regar
On 7/17/07, Guillaume Lelarge <[EMAIL PROTECTED]> wrote:
Jim C. Nasby a écrit :
> On Tue, Jul 17, 2007 at 06:45:29PM +0300, Abraham, Danny wrote:
>> Can someone help? Need a plpgsql debugger.
>
> You can get our debugger from the bottom of
> http://www.enterprisedb.com/downloads.do
But he needs
Scott Marlowe a écrit :
> On 7/17/07, Guillaume Lelarge <[EMAIL PROTECTED]> wrote:
>> Jim C. Nasby a écrit :
>> > On Tue, Jul 17, 2007 at 06:45:29PM +0300, Abraham, Danny wrote:
>> >> Can someone help? Need a plpgsql debugger.
>> >
>> > You can get our debugger from the bottom of
>> > http://www.en
33 matches
Mail list logo
