I have a parent table that is inherited by a couple others... Would it be best to set up an index on the children tables column that is inherited by the parent, or should I index the parent column that is inherited by the children? The children tables are the ones called frequently, not the par
Dear list,
I'd like to ask you if there is any way to install the PostGre SQL Windows
Server silently. I mean by writing a one line command in the command line or
sg like this... The whole thing is because I'm writing an installer (a
Visual Studio 2003 Setup Project) for an application, which use
> Dear list,
>
> I'd like to ask you if there is any way to install the
> PostGre SQL Windows Server silently. I mean by writing a one
> line command in the command line or sg like this... The whole
> thing is because I'm writing an installer (a Visual Studio
> 2003 Setup Project) for an appl
OK. I get it. I copied libpq74.dll to system32 and now it works, bu only
partially, just for tables, not for queries. There is some runtime error for
queries, but I should ask about it in some Zeos and Lazarus newsgroups.
Thanks.
- Original Message -
From: "Tony Caduto" <[EMAIL PROTE
> This is a known problem - since pg_reload_conf() will ignore the lines
> with a # (comment), so the old value is kept.
I tried to add a line
archive_command=''
But after pg_reload_conf() postmaster still uses the old value which exists
in its memory.
Please confirm that it it not possible t
"Is anyone else having problems with 9? "
I use VFP 9 + Postgres 8.1 on XP + 105 version of Postgres Unicode ODBC
driver without problems.
Andrus.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
Hi,
(maybe an idiot question)
In my Linux bash backup scripts, I wish to send an e-mail when an error
occurs in pg_dump proccess. And if possible, I want to send the error
output via e-mail.
Anybody knows how to capture the output and send this to an e-mail ONLY
if an error occurs ?
Thank
Hi,
We at Codexpert Systems are developing a Commercial MIS system, and are planning to go for POSTGRESQL as the database system. We need some clarifications for the same.
1. What are licenses we need to have to as developers of a software that uses POSTGRESQL?
2. What are the licenses a user i
Title: Casting issue with aggregated function
Hi,
I'm facing a cast issue when using sub queries and I 'd like your opinion if this should be submittede as a Bug.
(Postgres version 8.1.0)
Compare:
A)
select sum(25665800) as c
=> 25665800 (int8)
B)
select sum(c) fr
Please read our FAQ and the license item in there.
---
Rajendra Talekar wrote:
> Hi,
> We at Codexpert Systems are developing a Commercial MIS system, and are
> planning to go for POSTGRESQL as the database system. We need s
http://www.postgresql.org/about/licence
On 1/2/06, Rajendra Talekar <[EMAIL PROTECTED]> wrote:
> Hi,
> We at Codexpert Systems are developing a Commercial MIS system, and are
> planning to go for POSTGRESQL as the database system. We need some
> clarifications for the same.
>
> 1. What are license
On Mon, Jan 02, 2006 at 11:18:53AM +0100, Marc Mamin wrote:
> select sum(c) from
> (
> select sum(25665800) as c
> )foo
>
> => 25665800 (numeric)
>
> I find the cast form int8 to numeric being strange.
It's documented to work that way:
http://www.postgresql.org/docs/8.1/interactive/functi
My understanding is that you will need to set up the indexes on the child
table in order to do any good for queries on the child table. Also, you have
foreign key (an other, like primary key, I think) constraints are not
inherited and have to be repeated on each table.
Think of it like this: table
On Mon, 2 Jan 2006, alexandre - aldeia digital wrote:
In my Linux bash backup scripts, I wish to send an e-mail when an error
occurs in pg_dump proccess. And if possible, I want to send the error output
via e-mail.
Anybody knows how to capture the output and send this to an e-mail ONLY if an
On Mon, Jan 02, 2006 at 08:45:28AM -0200, alexandre - aldeia digital wrote:
> In my Linux bash backup scripts, I wish to send an e-mail when an error
> occurs in pg_dump proccess. And if possible, I want to send the error
> output via e-mail.
>
> Anybody knows how to capture the output and send
"Andrus" <[EMAIL PROTECTED]> writes:
> Please confirm that it it not possible to set archive_command parameter to
> unset state from Postgres client.
It works fine for me. Maybe you got bit by that bug you pointed out
yesterday that there must be a newline after a postgresql.conf entry?
Rajendra Talekar wrote:
Hi,
We at Codexpert Systems are developing a Commercial MIS system, and
are planning to go for POSTGRESQL as the database system. We need some
clarifications for the same.
1. What are licenses we need to have to as developers of a software
that uses POSTGRESQL?
Any
> We at Codexpert Systems are developing a Commercial MIS system, and are
> planning to go for POSTGRESQL as the database system. We need
> some clarifications for the same.
>
> 1. What are licenses we need to have to as developers of a software that uses
> POSTGRESQL?
> 2. What are the licenses
Hello, there
I installed PostgreSQL on windows and when I try to
run some queries pgadmin says an error. I know that if I change the query this
it will work but is it possible to make this quey work in this
way
SELECT atthasdef FROM pg_attribute WHERE
attrelid=pg_class.oid AND pg
Hello, there
I installed PostgreSQL on windows and when I try to
run some queries pgadmin says an error. I know that if I change the query this
it will work but is it possible to make this quey work in this
way
SELECT atthasdef FROM pg_attribute WHERE
attrelid=pg_class.oid AND pg
On Mon, Jan 02, 2006 at 04:01:56PM -0500, Ardian Xharra (Boxxo) wrote:
> I installed PostgreSQL on windows and when I try to run some
> queries pgadmin says an error.
What version of PostgreSQL? What's the exact error message? That
often provides a clue as to what's wrong. I'll guess that the
W
I will need to insert multiple rows into a table from php.
The data will come in 'packages' of 50-500 rows (they are responses from
different questionnaires). As there will be many people sending their
results in at the same time I need an effective method for this.
What do you suggest is the m
On 1/1/06, Tony Caduto <[EMAIL PROTECTED]> wrote:
> Hi,
> Does anyone know of a good resource on how to use Postgresql as a
> destination for Syslogd messages?
>
> I am interested in putting all postfix logs to a table rather than a file.
I set this up by using syslog-ng, djb's supervise and psql.
I'm keeping config information for an application in a series of related
tables. I'd like a command that INSERTs data if it's new, or UPDATEs it if
the key is duplicated.
Copying the config info from one database to another virgin installation is
easy, of course. I can just use pg_dump on the
Hi,
You probably want something like "COPY table_name FROM STDIN";
here's an example from a table that defines flags:
COPY auth_flag (id, name, description) FROM stdin;
2 Admin System Administrator Access
4 New PasswordUser must change password on next login
8 Super
Julian Scarfe wrote:
> I'm keeping config information for an application in a series of
> related tables. I'd like a command that INSERTs data if it's new,
< or UPDATEs it if the key is duplicated.
Write a stored procedure called something like InsertUpdateConfigData.
Pick the operation that you
v8.0.3
OS: SuSE 10.0 Pro
I am new to PostgreSQL but fairly familiar with other RDBMS' such as
Ingres, Informix and MySQL.
I am attempting to switch from using MySQL to PostgreSQL with postfix. I
have created the postfix user using createuser with a password but denying
the ability to create da
Lucky Leavell wrote:
v8.0.3
OS: SuSE 10.0 Pro
I am new to PostgreSQL but fairly familiar with other RDBMS' such as
Ingres, Informix and MySQL.
I am attempting to switch from using MySQL to PostgreSQL with postfix. I
have created the postfix user using createuser with a password but denying
On Mon, 2 Jan 2006, Madison Kelly wrote:
> Lucky Leavell wrote:
> > v8.0.3
> > OS: SuSE 10.0 Pro
> >
> > I am new to PostgreSQL but fairly familiar with other RDBMS' such as Ingres,
> > Informix and MySQL.
> >
> > I am attempting to switch from using MySQL to PostgreSQL with postfix. I
> > hav
On 1/2/06, Julian Scarfe <[EMAIL PROTECTED]> wrote:
> I'm keeping config information for an application in a series of related
> tables. I'd like a command that INSERTs data if it's new, or UPDATEs it if
> the key is duplicated.
A MERGE trigger will do exactly what you are asking for.
http://arc
On 2006-01-03, Tony Wasson <[EMAIL PROTECTED]> wrote:
> On 1/2/06, Julian Scarfe <[EMAIL PROTECTED]> wrote:
>> I'm keeping config information for an application in a series of related
>> tables. I'd like a command that INSERTs data if it's new, or UPDATEs it if
>> the key is duplicated.
>
> A MERG
31 matches
Mail list logo
