Ezequiel Tolnay <[EMAIL PROTECTED]> writes:
>I tried to implement a trigger on pg_proc, but that is not possible.
> Adding a rule to the pg_proc table was successful but it never executes.
Sorry, we don't support either rules or triggers on the system catalogs.
regard
contrib is a directory? where is it?
Fabio Barón S.
DBA, Plataforma Tecnologica
Gerencia Corporativa de Tecnologia
Tel : 4-37-61-61 Ext. 5123
Cel : 311 2-54-74-00
Aviso de confidencialidad:
Este mensaje de correo electrónico contiene información estrictamente
confidencial no susceptibl
Hi,
We want to store images in Postgresql and the front-end will be Hibernate. Does
Hibernate support Bytea and then retrieval of images in Postgres with bytea
datatype.
Thanks in advance,
Ganti Raghunath.
---(end of broadcast)---
TIP 4: Don't 'k
Hi all,
From Redhad Linux 7, I copied all PostgreSQL
7.0.3 database
files and moved all the database files to
Fedora Linux 10.
I didn't take a dump using pg_dump.
Then, on Fedora Linux 10, I uninstalled
PostgreSQL 7.3.4 and installed PostgreSQL 7.0.3.
Postmaster is running a
I just discovered that in the public schema (which I don't use) there is
a table pg_version_history. Does anyone know about this table?
It has versions of two test functions I seem to have created a couple of
months ago when I first installed postgresql, but I have no idea how
this table was cr
On Thu, Apr 21, 2005 at 02:37:53PM -0400, Jodi Kanter wrote:
>
> I'd like to check field names for various tables in our code. Is there a
> system table that lists the field names of each table? ...some way to
> query this information to run an error check?
See the "System Catalogs" and "The Inf
Hi
We are likely to build a desktop application in
VB.Net and we are in a hunt to go for a database.We
need a free version basically if it dosnt meets our
demand then we can go for the developer versions.
For our application it may run as client server
application may be of 10 concurrent user
hi, which is the sentence to run a Database REINDEX from linux or from
script or shell,etc.
Thanks.
Fabio Barón S.
DBA, Plataforma Tecnologica
Gerencia Corporativa de Tecnologia
Tel : 4-37-61-61 Ext. 5123
Cel : 311 2-54-74-00
Aviso de confidencialidad:
Este mensaje de correo electrónico
On Thu, Apr 21, 2005 at 02:37:53PM -0400, Jodi Kanter wrote:
> I'd like to check field names for various tables in our code. Is there a
> system table that lists the field names of each table? ...some way to
> query this information to run an error check?
Yes, pg_attribute. Or you could check t
Hello,
I can't seem to figure out what to do, whenever I try to start rhdb service
I get:
Starting postgresql service: /usr/bin/postmaster: real and effective user
ids must match
postmaster successfully started
[ FAILED ]
I really am at a loss over here.
Thanks
Nuno Souto
---
I have a question to configuration of PostgreSQL 7.3
If in var/lib/pgsql/data/postgresql.conf the variable autocommit is set to
true, I cannot work with transactions, because all is commited immediately.
I set autocommit to false and set default_transaction_isolation =
'serializable', because thi
On Fri, Apr 22, 2005 at 11:04:03 -0500,
[EMAIL PROTECTED] wrote:
>
>
>
>
> hi, which is the sentence to run a Database REINDEX from linux or from
> script or shell,etc.
I think you can use:
psql -c 'REINDEX DATABASE database_name'
---(end of broadcast)---
Hi all you pg gurus and admins,
I'm trying to implement versioning of the code of objects that can be
"created or replaced" (functions, views, etc).
I tried to implement a trigger on pg_proc, but that is not possible.
Adding a rule to the pg_proc table was successful but it never executes.
I'd like to check field names for various tables in our code. Is there
a system table that lists the field names of each table? ...some way to
query this information to run an error check?
Thanks
Jodi Kanter
--
___
___
Jodi L Kanter
B
Title: Installing PostGres
Could you tell me whether Novell supports postgres 8.0? Could you tell me the procedure if it does?
DISCLAIMER and CONFIDENTIALITY CAUTION:
This e-mail and any attached files are confidential, proprietary, and may also be legally privileged information, and ar
Got it, thanks. - Sherwin
-Original Message-
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]
Sent: Monday, April 18, 2005 8:30 AM
To: Sherwin Chua
Cc: pgsql-admin@postgresql.org
Subject: Re: Pg7.1 to Pg7.2 Upgrade
On Thu, Apr 14, 2005 at 11:32:14 +0800,
Sherwin Chua <[EMAIL PROTECTED]>
On Fri, 2005-04-22 at 11:36, [EMAIL PROTECTED] wrote:
>
>
> thanks Bruno :
> I'm running the command with root
> psql -c "REINDEX DATABASE Clibelcorpco FORCE"
> psql: FATAL: La base de datos "root" no existe en el catalogo del
> sistema.(Traslate : The "root" database doesnÂt exsists)
>
> I e
On Fri, Apr 22, 2005 at 11:36:46 -0500,
[EMAIL PROTECTED] wrote:
>
>
>
>
> thanks Bruno :
> I'm running the command with root
> psql -c "REINDEX DATABASE Clibelcorpco FORCE"
> psql: FATAL: La base de datos "root" no existe en el catalogo del
> sistema.(Traslate : The "root" database doesn´
Am 2005-04-22 14:44:00, schrieb Chris Browne:
> One of my coworkers has built a really nice init script that's good at
> building the directory structure where the DBs will be stowed, hence...
>
> $ vi init_db3.sh
> [modify config]
> $ ./init_db3.sh mkdir
> [builds directory structure]
> $ ./init
I have a postgres installation with one database on a server. I'd need
to create another database; however, I'm curious if there's a way to
create the second database in a different directory than the existing
one. Is that feasible and how? Or does postgres only point to one data
directory? Than
On Fri, 2005-04-22 at 10:00, [EMAIL PROTECTED] wrote:
>
>
>
> contrib is a directory? where is it?
>
It's a subdirectory in the source file distribution. So, if you
downloaded postgresql-7.4.7.tar.gz it would be in
postgresql-7.4.7/contrib
---(end of broadcast)--
On Fri, 2005-04-22 at 11:10, Tomeh, Husam wrote:
> I have a postgres installation with one database on a server. I'd need
> to create another database; however, I'm curious if there's a way to
> create the second database in a different directory than the existing
> one. Is that feasible and how?
thanks Bruno :
I'm running the command with root
psql -c "REINDEX DATABASE Clibelcorpco FORCE"
psql: FATAL: La base de datos "root" no existe en el catalogo del
sistema.(Traslate : The "root" database doesn´t exsists)
I execute :
psql -d Clibelcorpco -c "REINDEX DATABASE Clibelcorpco FORC
On Fri, Apr 22, 2005 at 11:36:46AM -0500, [EMAIL PROTECTED] wrote:
>
> psql -d Clibelcorpco -c "REINDEX DATABASE Clibelcorpco FORCE"
> ERROR: REINDEX DATABASE: Can be executed only on the currently open
> database.
If the database name isn't all lowercase then you'll have to quote it.
psql -d C
[EMAIL PROTECTED] wrote:
hi, which is the sentence to run a Database REINDEX from linux or from
You could grab src/contrib/reindexdb
or
psql -U -c "reindex foo"
script or shell,etc.
Thanks.
Fabio Barón S.
DBA, Plataforma Tecnologica
Gerencia Corporativa de Tecnologia
Tel : 4-37-61-61 Ext. 512
I have a postgres installation with one database on a server. I'd need
to create another database; however, I'm curious if there's a way to
create the second database in a different data directory than the
existing one. Is that feasible and how? I have read you can have start
multiple postmaster
On Fri, Apr 22, 2005 at 09:10:35AM -0700, Tomeh, Husam wrote:
>
> I have a postgres installation with one database on a server. I'd need
> to create another database; however, I'm curious if there's a way to
> create the second database in a different directory than the existing
> one. Is that fe
[EMAIL PROTECTED] ("Tomeh, Husam") writes:
> I have a postgres installation with one database on a server. I'd need
> to create another database; however, I'm curious if there's a way to
> create the second database in a different directory than the existing
> one. Is that feasible and how? Or does
Thanks for the feedback. I have tried this way and seems to be working
just fine. For this approach, I have a postmaster for each databases,
correct?
The approach that another gentleman pointed out is the use of
alternative location where it actually uses one postmaster and creates a
symbolic link
Piotr Kabath wrote:
> UNSUSCRIBE
>
>
> Internet to skuteczna metoda poszukiwania pracy! Zajrzyj do serwisu
> Praca.wp.pl - Mamy dla Ciebie setki nowych ogłoszeń każdego dnia!
> http://klik.wp.pl/?adr=http%3A%2F%2Fadv.reklama.wp.pl%2Fas%2Frobota.
Hi,
We want to store images in Postgresql and the front-end will be Hibernate. Does
Hibernate support Bytea and then retrieval of images in Postgres with bytea
datatype.
Thanks in advance,
Ganti Raghunath.
---(end of broadcast)---
TIP 9: the pl
31 matches
Mail list logo
