"Marcel Gsteiger" <[EMAIL PROTECTED]> writes:
> Is this a known problem? If the problem is unknown, I could probably help to
> find out what's going wrong. The base tables (in schema pg_catalog) appear to
> be ok at first sight. Perhaps the information_schema dictionary views have
> not yet been
Nilesh Doshi wrote:
> My question is about schemas in oracle and postgres. Does every
> schema in oracle becomes a separate database in postgres ? OR it is
> still like oracle, where all schemas are part of big database ?
You can have multiple schemas in a single PostgreSQL database. Unlike
Orac
On Tue, Dec 07, 2004 at 09:25:20AM +0100, Per Jensen wrote:
> Den Tue, Dec 07, 2004 at 03:13:04AM - eller der omkring skrev Andrew -
> Supernews:
> > On 2004-12-07, Stephen Frost <[EMAIL PROTECTED]> wrote:
> > > Is there a way to say "just take the value of this function at the start
> > > of
On Tue, Dec 07, 2004 at 02:35:58PM -0500, [EMAIL PROTECTED] wrote:
> I have created a function in postgresql
See comments below.
> CREATE OR REPLACE FUNCTION public.insert_vpn_masteraccount(varchar, varchar,
> varchar, varchar, varchar, varchar, varchar, varchar, varchar)
> RETURNS varchar AS
Clodoaldo Pinto wrote:
Javascript is not only client side. IIS has two script languages
installed as default: VBScript and JScript(MS version of Javascript).
Only does you good if you're running on a IIS platform. The server side
Javascript engine worked on the Netscape web server product, which
Chris Travers wrote:
Geoffrey wrote:
Chris Smith wrote:
[EMAIL PROTECTED] wrote:
Does anyone know how to connect javascript to a postgresql
database
You can't connect javascript to any sort of database.
Actually you can, with server side javascript, although I don't know
if it supports postgre
On Sat, Dec 11, 2004 at 02:20:06PM -0800, Pablo Santiago Blum de Aguiar wrote:
> Ok. I read the CREATE INDEX manual section and I could
> create an index but then I get an error message
> telling that relation "pk_cliente" already exists when
> creating the table. How do I explicitly request
> Pos
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Fri, Dec 10, 2004 at 06:31:15PM -0300, Pablo
> Santiago Blum de Aguiar wrote:
>
> > I'm getting boring notices when creating tables:
>
> [snip]
>
> > NOTICE: CREATE TABLE / PRIMARY KEY will create
> > implicit index "pk_cliente" for table "clie
On Sat, 2004-12-11 at 01:54 -0200, itamar wrote:
> when I run
>
> select * from "table"
>
> I get this error.
>
> ERROR: relation "table" does not exist
The table name is is folded to lowercase, unless it is in quotes.
so if the name of the table is TABLE, you need select * from "TABLE"
Is
On Fri, Dec 10, 2004 at 11:26:09PM -0500, Ron Peterson wrote:
> I have a simple table, a view, and an on insert rule. These work fine,
> ordinarily. But when I attempt to to insert a value into thesis_ps_v
> via libpq_sql, nothing happens.
Fixed. I didn't set the schema search path properly in
No, you can't do this, at least not if you expect the two database
processes to run at the same time.
There are High Availability systems that work in somewhat this
fashion; both servers access the same disk. But with a very precise
set of semantics:
-> The database filesystem is only mounted
> file-names:
> I know it doesn't matter, but mostly it seems to make sense to put
> stuff in .sql files. I've seen some reference to people putting stuff
> in .sp files. What works best for people in terms of organization?
GnuMed uses *.sql and we haven't had anyone wondering about it
if that's
On Tue, Dec 07, 2004 at 10:42:29AM +0330, Elnaz Shafipour wrote:
> I want to create database in postgreSQL but I get the following error:
> relation "sql_features" does not exist.
How are you creating the database, and is that the operation that
fails or do you get the error when doing something
Den Tue, Dec 07, 2004 at 03:13:04AM - eller der omkring skrev Andrew -
Supernews:
> On 2004-12-07, Stephen Frost <[EMAIL PROTECTED]> wrote:
> > Is there a way to say "just take the value of this function at the start
> > of the transaction and then have it be constant" in a query?
>
> Why not
Javascript is not only client side. IIS has two script languages installed as
default: VBScript and JScript(MS version of Javascript).
Indeed at my work I have already written hundreds of javascript server pages.
We use MS SQL Server.
I understand Robert Stewart's question, and the only advice I
> Define "latest PgSQL". The query plans look like 7.3 or older results
> to me. 7.4 should do the IN with a hash join ...
"latest" is the last minor release, which I know worked well for us :) So, I
have "latest" from 7.3.x... I will try to upgrade to latest 7.4.x and try
all SQL's again. Thank
On Wed, Dec 08, 2004 at 09:45:53 -0800,
Mark <[EMAIL PROTECTED]> wrote:
> Hi,
> What are recommendations about running vacuumdb?
You need to VACUUM tables to reclaim space created by DELETE and UPDATE
commands. You need to run ANALYZE tables when their distribution of
data changes. If you are do
On Fri, Dec 10, 2004 at 06:15:50PM -0800, Eric Brown wrote:
> Option 1:
> create table a (id serial, hosts text[]);
>
> OR
>
> Option 2:
> create table a (id serial);
> create table hosts (id int references a, host text);
Option 2 will save a lot of developer & query time, as it's much more
stan
On Wed, Dec 08, 2004 at 08:58:49 -0800,
Mark <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I guess is simple, but cannot find out how to run scripts in psql(
> Linux)
>
> What I would like to do is following:
>
> 1. Create a table structure from scripts ?
> 2. Preload data to remote Linux box (IP added
On Wed, Dec 08, 2004 at 14:50:04 +0100,
Julian Legeny <[EMAIL PROTECTED]> wrote:
> Hello,
>
>Then I want to process command
> select count(*) from UNIQUE_COLUMN_TEST
>that I want to know how many records was already inserted before id
>faied.
>
>But when I try to process t
On Wed, Dec 08, 2004 at 08:58:49AM -0800, Mark wrote:
> I guess is simple, but cannot find out how to run scripts in psql(
> Linux)
Create a file with the SQL statements you'd like to run. There are
several ways to get psql to read the file:
Redirection:
psql < foo.sql
Command-line option:
On Dec 10, 2004, at 4:26 AM, Vikas Kumawat wrote:
Dear Sir /Madam,
We are working on Linux suse 9.0 and we have installed Postgres 7.3 through yast with the privileges of "root" user. But we are not able to start / configure the postgres database, Kindly help us in configuring and starting the
On Thu, Dec 09, 2004 at 18:32:19 +0100,
Janning Vygen <[EMAIL PROTECTED]> wrote:
>
> "id" should be positive
> "id" should not have gaps within the same account
> "id" should start counting by 1 for each account
>
> i cant use sequences because they are producing gaps and doesn't start
> coun
Dear Sir /Madam,
We are working on Linux suse
9.0 and we have installed Postgres 7.3 through yast with the privileges of
"root" user. But we are not able to start / configure the
postgres database, Kindly help us in configuring and starting the same database
and how can we create database
Hello,
I have a following table with unique column:
CREATE TABLE UNIQUE_COLUMN_TEST (
TEST_ID INTEGER,
CONSTRAINT TEST_ID_UQ UNIQUE (TEST_ID)
)
Then I insert few records into the table, and then I try to insert
duplicate record. There is correct error occured:
org.p
Christopher Browne wrote:
Why do you think that's useful in limiting vulnerability?
In order for the system to mount the filesystem, the key has got to be
there.
It does not have to be locally on the system. If I wanted to secure
such a system, I would have a private key for decrypting the fil
"Lada 'Ray' Lostak" <[EMAIL PROTECTED]> writes:
> I don't understand why following '3' statements are SOO different. We
> run latest PgSQL, OpenBSD 3.4, AMD XP 2000+ and plenty of RAM... CPU was
> fully dedicated to PG.
Define "latest PgSQL". The query plans look like 7.3 or older results
to
On Sat, Dec 11, 2004 at 08:54:40AM -0800, Stephan Szabo wrote:
> old.series_id IS DISTINCT FROM new.series_id may do what you want
> depending on how you want NULLs to compare (IS DISTINCT FROM would be
> false).
I forgot about IS DISTINCT FROM. I like that better than using
COALESCE, as I had s
On Tue, Dec 07, 2004 at 14:49:14 -0300,
MaRCeLO PeReiRA <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> I have a table with two integer fields (field1 and
> field2)...
>
> I would like to construct a function that perform an
> operation with this two fiels (field1 + fields2), and
> return the string
True. It does seem more proper.
Thanks.
On Sat, 11 Dec 2004 10:57:25 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Sat, Dec 11, 2004 at 08:54:40AM -0800, Stephan Szabo wrote:
>
> > old.series_id IS DISTINCT FROM new.series_id may do what you want
> > depending on how you want NULLs to comp
HOW CAN I RESOLV THIS PROBLEM? (IF I HAVE POSTGRES ON WINDOWS XP)
psql: could not connect to server: Connection refused
Is the server running on host "" and accepting
TCP/IP connections on port 5432?
THANK'S
_
Platica con
Hi,
I guess is simple, but cannot find out how to run scripts in psql(
Linux)
What I would like to do is following:
1. Create a table structure from scripts ?
2. Preload data to remote Linux box (IP added to conf file)
Thanks,
Mark
__
Do you
Den Tue, Dec 07, 2004 at 03:13:04AM - eller der omkring skrev Andrew -
Supernews:
> On 2004-12-07, Stephen Frost <[EMAIL PROTECTED]> wrote:
> > Is there a way to say "just take the value of this function at the start
> > of the transaction and then have it be constant" in a query?
>
> Why not
Hi All,
I'm new to postgres, so I need your help.
We are in the process of migrating from oracle to postgres. DB size is about
400gb.
My question is about schemas in oracle and postgres. Does every schema in
oracle becomes a separate database in postgres ? OR it is still like oracle,
where all s
Hi,
What are recommendations about running vacuumdb?
How frequently it need be executed and how will I know I have to run
it.
Can I run vaccumdb on production system or I need to do it on DB with
no users connected?
Thanks,
Mark.
__
Do you Yaho
Hi,
I want to create database in postgreSQL but I get
the following error:
relation "sql_features" does not
exist.
As I look for solving this problem I find out that
I should
add information_schema to the shema search
path.
but I don't kow how!
Elnaz
Hi. It seems that when google did its beta update, the pgsql.* hierarchy
went missing. Is there anyway to restore it?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Vitaly Belman <[EMAIL PROTECTED]> writes:
> What can I do to check inequality even in the case that old or new
> series_id is NULL?
Try IS DISTINCT FROM.
regards, tom lane
---(end of broadcast)---
TIP 5: Have you checked our
On Wed, Dec 08, 2004 at 08:41:19 -0600,
Don Isgitt <[EMAIL PROTECTED]> wrote:
>
> I have received no posts from GENERAL since yesterday morning; is the
> list broken? Thank you.
When you suspect a problem with a list it is generally best not to send
a message to the list asking if it is down o
On Sat, 11 Dec 2004, Vitaly Belman wrote:
> I have the following code in one of my trigger functions
>
> ---
> IF old.series_id<>new.series_id THEN
> ...
> ...
> END IF;
> ---
>
On 12/9/04 9:23 AM, "Peter Haworth" <[EMAIL PROTECTED]> wrote:
> It runs RHEL ES v3, kernel 2.4.21-20.ELsmp
> It's generally a very stable box which runs a number of postgresql
> instances. But last night we hit very high low averages - 10+, vs the
> normal 0-2.
> The culprit appeared to be kswap
COALESCE is good enough for me. Thanks.
On Sat, 11 Dec 2004 09:33:32 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Sat, Dec 11, 2004 at 02:42:21PM +0200, Vitaly Belman wrote:
>
> > IF old.series_id<>new.series_id THEN
> > ...
> > The problem is that series_id can change to be NULL in which
On Sat, Dec 11, 2004 at 02:42:21PM +0200, Vitaly Belman wrote:
> IF old.series_id<>new.series_id THEN
> ...
> The problem is that series_id can change to be NULL in which case I
> have problems as "NULL <> 7" doesn't return "true".
>
> What can I do to check inequality even in the case that old o
As far as i can see my mail was not sent to list. I forward it:
-- Forwarded message --
Date: Fri, 10 Dec 2004 05:15:42 +0200 (EET)
From: Ioannis Theoharis <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Clustering in the presence of hierarchies
I'd like to ask you about
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Nageshwar Rao)
wrote:
> I would like to use shared disk for two Postgresql database. I mean
> that two Postgresql Database point to same $PGDATA directory. Is
> this possible in Postgresql Clarification is appreciated.:p>
No, you can'
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Fri, 10 Dec 2004, Tomas [iso-8859-1] Skäre wrote:
>
> > I have a table that looks like this:
> >
> > Table "public.cjm_object"
> > Column | Type| Modifiers
> > ---+---+---
> > timestamp | bi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 10 Dec 2004, John Allgood wrote:
I am looking for Postgres 7.4.6 x86_64 RPMS for Redhat ES 3.0. I Think
7.4.6 will be included in Redhat ES 4.0 but I am not sure when that will be
released and we may not upgrade at that time. I have foun
I have the following code in one of my trigger functions
---
IF old.series_id<>new.series_id THEN
...
...
END IF;
---
The problem is that series_id can change to be NULL in whic
Rory Campbell-Lange wrote:
Hi. I'd like to return a result set from a plpgsql function constructed
out of a 'virtual table' joined to an actual table, and struggling to
find a sane approach.
I have a table 'recs' with records like this.
day | nums
---
2 | 1
5 | 3
On Wednesday 08 Dec 2004 2:42 am, Jimmie H. Apsey wrote:
> I got a server from DELL which contained a Red Hat Linux AS 3 in the box.
>
> It contained no postgresql server which I got from an earlier link,
> http://archives.postgresql.org/pgsql-admin/2003-11/msg00368.php
> When I did rpm of everythi
That happens when
you type:
\d
From the PSQL sql
prompt, like this:
connxetl=# \d
List of relations
Name | Type | Owner
---+--+--
ActiveRange
| table | datasync
Active
Hi there,
I want to know that is a posibillity to test if a statement is prepared in
PL/PgSQL.
I have create a function:
.
PREPARE PSTAT_SAVE_record(INTEGER, INTEGER, DATE, VARCHAR) AS INSERT INTO
table VALUES($1, $2, $3, $4);
.
When I try to execute it second time I got an er
Good day to all ...
I hope any one can give me an advice ... to optimize my database...
im having a problem when i'm backing up my DB and also using vacuum for my
DB...
my CPU load goes up and no one can use my DB... most of the transaction
comes from web server..
I just need ur good advice
Good day to all ...
I hope any one can give me an advice ... to optimize my database...
im having a problem when i'm backing up my DB and also using vacuum for my
DB...
my CPU load goes up and no one can use my DB... most of the transaction
comes from web server..
I just need ur good advice ...
el elefante nunca olvide :)
the elephant never forgets
On Fri, Dec 10, 2004 at 04:02:42PM -0500, Mirko Coz wrote:
> Amigos:
>
> ¿Qué significado tiene el logo de PostgreSQL?
>
> Saludos,
>
> --
> Mirko Coz Berrospi
>
> ---(end of broadcast)---
Yes actualy.. This is also going to be one of the items on our future FAQ
database.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joachim Zobel
Sent: Tuesday, December 07, 2004 11:34 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Reusable database design
Hi Robert,
This might help you get started:
http://developer.apple.com/internet/webcontent/xmlhttpreq.html
Keep us posted!
Beau
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail c
On Wed, Dec 08, 2004 at 05:53:51PM -0600, Karl O. Pinc wrote:
> Hi,
>
> I can't seem to get postgresql to use shared memory and performance is
> terrrible.
The shared column in free doesn't represent the amount of SysV shared
memory used. If the system can't allocate the amount you ask it'll tell
Nageshwar Rao <[EMAIL PROTECTED]> writes:
>Hi,
>
>I would like to use shared disk for two Postgresql database. I mean
>that two Postgresql Database point to same $PGDATA directory. Is this
>possible in Postgresql Clarification is appreciated.
No, this is not possible.
You may wan
On my system signal 4 is SIGILL (Illegal instruction), maybe you're
triggering a compiler error. Can you run the backend under gdb or get a
core file to see where it's dying. Trying it compiled with gcc would be
a good test too...
On Thu, Dec 09, 2004 at 04:27:18PM +0100, [EMAIL PROTECTED] wrote:
60 matches
Mail list logo
