It worked - Thank you
Bob
- Original Message -
From: William Yu [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Tuesday, November 15, 2005 11:06 AM
Subject: Re: [GENERAL] Is it databases in general, SQL or Postgresql?
Bob Pawley wrote:
Thank you.
What clause is acceptable
with duplicate rows?
Among other reasons not to have duplicate rows, I want to make
pipe.fluid_id a primary key.
Bob
CREATE TABLE pipe ( fluid_id int4 NOT NULL);CREATE TABLE process(
fluid_id int4 NOT NULL, process varchar, contain varchar);create
or replace function base() returns trigger
Uwe
In attempting to understand the underlying intent of the statement, I have a
question.
What purpose does the statement myrow serve in this expression.
Bob
- Original Message -
From: Uwe C. Schroeder [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: pgsql-general
r target?? Perhaps a temporary table??
Or am I completely screwed
up???
Bob
Thank you - what is the correct command???
Bob
- Original Message -
From: Uwe C. Schroeder [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Thursday, November 10, 2005 3:34 PM
Subject: Re: [GENERAL] Where
SELECT INTO
tries to create
By 'one record' do you mean one full row or one column of one row??
Bob
- Original Message -
From: Uwe C. Schroeder [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 10, 2005 5:05 PM
Subject: Re: [GENERAL] Where
Thanks again.
I'll give it a try.
Bob
- Original Message -
From: Uwe C. Schroeder [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 10, 2005 7:44 PM
Subject: Re: [GENERAL] Where
one full row - NOT two or more rows
.
Bob
create or replace function base() returns trigger as
$$begin
insert into specification (fluid_id) values (new.fluid_id);
create table pro as select fluid_id from process where
ip_op_reactor = 'ip';insert into pipe (fluid_id) values
(new.fluid_id);drop table pro ;return null
.
Bob PowellDatabase Administrator
instead.
CONTEXT: PL/pgSQL function "base" line 4 at SQL
statement
I would very much appreciate any
help as to where I am going wrong.
Thanks
Bob
Pawley
very easily. No need to write glue code such as connections and
state as the dev tool provides all this.
With that being said those of us who know better will not take that
over Postgresql, but it will buy Oracle more market share that is for
sure.
Bob
---(end of broadcast
.
Thanks again.
Bob Pawley
number generated inprocess.fluid_id to be transferred to
column specification.fluid_id.
A simple insert/select command
will transfer the serial number but enteringa second rowthen
employingan insert/select command violates the p_k unique rule.
What do I need to do?
Bob
I am running version 8 on Windows.
Why do I get error messages stating that functions and/or tables do not
exist when these tables and functions are visible, accessible and very much do
exist, as called?
Bob Pawley
N
process IS 'insert into specification (fluid_id)';
The error message reads - ERROR: function base() does not exist
The function name is listed under Functions as - base(int4)
Bob
I'm not sure what you mean.
base(int4) is the name of the function that I want to call. It follows the
format of an example in a Postgresql book I use (or perhaps misuse).
Are you saying that I need to redo the function???
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED
process entered into
specification as an integer.
I would like this to happen after each row in process has satisfied the
not null requirements.
I may not be employing the language you are use to using however, I hope
this explanation is somewhat clear.
Thanks for your help.
Bob
appreciate it.
Bob Pawley
[EMAIL PROTECTED]
, including one specifically for Postgres.
WhatI don't have is the language to look this function up.
Concepts like JOIN appear to used to create views not new rows on other
tables.
Help will be appreciated.
Bob Pawley
, but...
Cheers,
Bob
##!/usr/local/bin/perl
### SNIP set up %gwc ###
use DBI;
$dbh=DBI-connect('dbi:Pg:dbname=..') ||
die;
$stmt=qq(create temp table tt as select
key,acronym,start_date,end_date,duration,charging_policy from template_event);
$dbh-prepare($stmt
Postgresql book or through the
Postgre on-line help.
Thanks
Bob Pawley
The first question is do you really need all the columns. Most times
you don't need them. There will be network overhead for sure in
returning all columns instead of just the few that you want. Also
select * is not very clear with what is going on in the statement.
Where I work we have standards
everything.
-bob
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Language reflects the character of those who use it.
In this case, the language used also reflects on the community to which it
is directed.
I don't wish to be associated with a professional community, such as
Postgre, that holds such shallow values.
Bob Pawley
- Original Message
In the Postgre documentation I could find ODBC references only to Postgre
7.2 and older.
Can anyone point me to ODBC documentation for version 8?
Bob Pawley
Have you checked your pg_hba.conf file and add the correct entry to
allow the remote client ip address? Sorry don't have my file so I can't
show you an example. But I think the docs and/or a google will show
some examples.
Also you have to alter the postgresql.conf to allow tcp/ip connections.
I
Doesn't that really only save you from having someone come in at the OS
level and copying your data files and than moutning them on a differet
server/database. A person could still come in to psql as a dba or
anyone for that matter with the proper select grants and query off that
data and see it
Even though PostgreSQL is more like an Oracle which is a good thing.
It's like Oracle in function not in cost and adminstration. PostgreSQL
not only fits into the enterprice really well it also fits in the mom
and pop shops(dentist office,corner store, you name it that may not
have any IT folks.
Here is the link in case your fingers are broken and it hurts to type;)
http://www.postgresql.org/docs/8.0/interactive/encryption-options.html
On 7/13/05, Matt McNeil [EMAIL PROTECTED] wrote:
Greetings,
I need to securely store lots of sensitive contact
information andnotes in a freely
I have used PL/SQL for years. It's a great language that is easy to pick up and offers lots of ability/promise. The syntax seems very easy for new people to pick up who might know another language or are just starting out. Of course the same can be said of Ada code. It's just very easy to read.
I am new to databases and would like togain some idea of the sizes of
a typical singal database.
For instancewhat are the number of schemas, tables and views
that would constitute a databse considered to be small, medium or large?
Bob Pawley
PL/SQL is awesome just awesome no doubt about it.
But if you like to pay at a minium for 5 users 800 bucks then stick with PL/SQL. I personally can live with pl/psql and at a higher level postgresql to be honest. Not to mention the rate that things are being added and improved is mind numbing.
Keep in mind there is no built in API to debug PL/pgSQL like there is for PL/SQL. You will have to use the old true and tried output statements to debug your stored procs.
On 6/21/05, Sean Davis [EMAIL PROTECTED] wrote:
You might want to look at pgEdit.Sean- Original Message -From: Craig
an account and password but this is rejected
by a message "the account already exists". Further changing the account names in
the interface does not work.
Can someone direct me to the register that needs cleaning??
Bob Pawley
What are the opinions on a separate list just for pl/pgsql? Seems pl/pgsql deserves her own area.Just wondering if this would make sense, and if it did can we have a separate list?
world where volumes of books have been written on PL/SQL on it's own.
Bob
On 6/7/05, Douglas McNaught [EMAIL PROTECTED] wrote:
Bob [EMAIL PROTECTED] writes: What are the opinions on a separate list just for pl/pgsql?Seems
pl/pgsql deserves her own area. Just wondering if this would make sense
I think it hits the press in June or July 2005???
On 6/3/05, Brad Nicholson [EMAIL PROTECTED] wrote:
Gevik babakhani wrote: Dear All, Beside the documentation, which pg book would you recommend? Which one
is your personal favorite pg book? Regards Gevik.PostgreSQL by Korry Douglas and Susan
Well first off can you break those 700 lines out into more stored functions?
Maybe you have logic that would be best in its own function and than call one function from another. Makes testing many times easier. I always think in small chuncks when I write code.
Once code gets to be more than a
Well first off can you break those 700 lines out into more stored functions?
Maybe you have logic that would be best in its own function and than call one function from another. Makes testing many times easier. I always think in small chuncks when I write code.
Once code gets to be more than a
a server to access the database?
If so, what properties do I enter into the add server interface toadd
aserver? Everything I've tried so far has been rejected.
Bob Pawley
Sorry for short message, but I'm headed out for the weekend.
At my places of work we have use both a single table and one table for every table.
I personally liked the single table for every table approach. On 5/29/05, Zlatko Matic [EMAIL PROTECTED]
wrote:Hello.I must have audit trail of all
I can't wait!
On 5/11/05, John Dean [EMAIL PROTECTED] wrote:
HiThis is my first post to this mailing list. I would like all list membersthat I am the same person who used to work for MySQL AB. Even though I
worked for MySQL AB, PostgreSQL has always been my RDBMS of choice. Thereason for telling
with
my export to Excel. Any suggestions on how to avoid this
little snag?
Thanks for your help.
Bob Lee
--
I prefer email in plain text
[EMAIL PROTECTED] [EMAIL PROTECTED]
pgp:D3EE2269 certserver.pgp.com
pgpsRVszgS1YO.pgp
Description: PGP signature
On Apr 12, 2005 9:40 AM, Andrus [EMAIL PROTECTED] wrote:
The following statement runs VERY slowly on large tables.Any idea how to speed it up ?UPDATE rid SET dokumnr=NULL WHEREdokumnr NOT IN (SELECT dokumnr FROM dok);Tables:CREATE TABLE dok ( dokumnr INTEGER, CONSTRAINT dok_pkey PRIMARY KEY
On Apr 9, 2005 10:55 PM, Steve - DND [EMAIL PROTECTED] wrote:What is the general consensus on using table inheritance? I know it's there,but is it good, bad, or just dependent on how it's used? I need to trackcreation/update information for a large number of tables in my current DB. Iwas just
into this table. Anyone know how I would doe this
Then if I can get the document into the image field how would I retrieve it to display it in my HTML document
Thanks in advance.
Bob PowellDatabase Administrator
Title: Message
I use AS Tcl 8.4.9
on Windows and I would like to use Pg8 (since it is now native to Windows). What
do I need on the Tcl side of things?
Robert
HicksNorthrop Grumman
Mission Systems
Defense Mission SystemsSystems
Administrator (LIMS)304.264.7939 (Office)
304.264.2664
Hello everyone:
If I excute the following:
CREATE table Test_backup as
SELECT * FROM Test_Scores;
it creates my table without the original table's constraints or
triggers.
Is there a way to preserve them in the copy?
Thanks.
Bob Powell
Database Administrator
192.168.1.0 255.255.255.0 md5
coming before the other line, I can connect to the server database using
a password. However, if it follows the line, I cannot. Am I doing
something wrong here also?
Thanks for any help.
--
Bob Parnes
[EMAIL PROTECTED]
---(end
?
Also, my method for creating another superuser is to update the
pg_shadow files usesuper field to 't'. Are there any issues I should
be aware of for doing such a thing. Thanks.
Bob Powell
Database Administrator
---(end of broadcast)---
TIP 6
of it
there either.
I had a user who uses pgamind on occassion for quering the backend who
told me that he did not intterupt any of the criteria he was running.
Do I just chalk it up to a transient anomaly ?
Thanks for any help you can give.
Bob Powell
Database Administrator
the pltcl.so from my older 7.2 branch.
Thanks!
Bob PowellDatabase Administrator
this.
Thanks.
Bob Powell
Database Administrator
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi,
I need to give some partners to a read only subset of my data. I'm currently looking
at schemas, not something I've looked at or used before.
Can I use schemas to create a virtual DB (built by views) onto my main DB? Or is this
a dead end thought?
Cheers,
Bob
This message has been
Hi,
Is it possible to share some TCL proc's between a set of functions? Something like
proc mything {
}
proc otherthing {
}
create function wantsthings (text) returns text as
'
return [mything [otherthing fubar]]
' language 'pltcl';
Cheers,
Bob
This message has been scanned
I am experiencing a problem when I run my visual basic database
program on windows 2000.
The error message states activex components can not create an
object, I have installed mdac_typ 2.8 and reinstalled visual studio
2000 on my computer, but I still get he smae error message when I run
the
Over the weekend, I reviewed several of my database programs written
in visual Basic 6.0. Discovered that all had DAO 3.51 reference in
common. Aparantly this corrupted file was causing the error 429.
To solve the problem, copy the DAO 3.5 or DAO 3.6.dll Located on
C:\Program Files\Commons
I just want a general idea of what Postgresql can handle. I know the guru's
will say it depends on many different things, but in general what can this
bad boy handle?
50gb to 100gb is by no means small. But how does Postgresql 7.4 handle
database of 900G, or 1 Terabyte or greater?
How
My thoughts in a perfect world for having oracle style jobs in postgresql
would be a very loud yes. In the world called reality I say why waste
precious time on something that can already be accomplished by other means.
This feature at this time would just be icing on an already tasty cake.
Just my experience, but we when I have used Oracle as my database. My
processes that run in batch use shell scripts to kick of stored procedures
even though Oracle does provide jobs. Shell scripts can be much more
flexible in many cases. You can have dependancies on all kinds of things
Hi,
I have a very odd postgresql problem.
I have some subqueries contained within a function which are looking
for unrefernced data and then delete any rows that are found:
CREATE OR REPLACE FUNCTION housekeeping()
RETURNS TRIGGER AS '
BEGIN
DELETE FROM properties WHERE NOT EXISTS (SELECT
I won't say what is right or wrong to do. But some will say to store the
file location in a field such as /mydocs/mypictures/myimage.jpg and then
have your php or what ever open that file. by using a select statement.
Not sure how you would store them in the database and pull it righ out. I
infact the GUI tool choose the order. Just a thought
Bob Henkel 651-738-5085
Mutual Funds I/T Woodbury
Hartford Life
500 Bielenberg Drive
Woodbury, MN 55125
|-+--
| | Richard Huxton |
| | [EMAIL
for error
code logic here
check for error
Bob Henkel 651-738-5085
Mutual Funds I/T Woodbury
Hartford Life
500 Bielenberg Drive
Woodbury, MN 55125
He is talking about the MAC which in itself is supposed to be
globally unique. Nothing to do with IP numbers.
Supposed is the word...
Don't count on MACs being unique. Under some OS's you can set them to what you want.
Bob
==
When logic and proportion
Have
I couldn't agree with you more. I'm just a developer in a very large
company and getting anyone to listen and then understand that logic would
be a nightmare to say the least. If it was my company I would put money
toward those issues.
works fine, it's just when I try to create a table when I
runn into problems. Do I have to list all of the fields except the one I don't want,
or is there another way? Thanks in advance.
Bob Powell
---(end of broadcast)---
TIP 9: the planner
Is it possible to do something like:
select 1 as a, a*a;
in postgres?
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Bob
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
.
=== my command
$ pg_dump -U postgres demo demo.dump
=== resulting message ===
pg_dump: [archiver (db)] connection to database demo failed: FATAL: IDENT authentication failed for user postgres
Bob Nix, Technical Analyst
IntraNexus, Inc.
[EMAIL PROTECTED]
336-282-4415 Fax: 509-355
I've discovered this huge file 16Meg in the data/pg_xlog directory
but information for it is alluding my discover too.
What is it and how can i manage it? Can it be deleted or is some
tool necessary to deal with it?
--
Bob Himes
Pure Matrix, Inc.
303-245-1045ext. 105
http
: begin
CommitTransactionCommand
StartTransactionCommand
query: rollback
ProcessUtility: rollback
CommitTransactionCommand
proc_exit(0)
shmem_exit(0)
exit(0)
Cheers
Bob Parkinson
[EMAIL PROTECTED]
--
Technical Manager: Biome
/lib/pgsql
/usr/local/pgsql
Should I set up the path (in my profile) to point to /usr/bin or
/usr/local/pgsql ? I am presuming the former.
Slowly but surely!
Thanks
Bob Hartung
or because the chosen path isn't permitted
for databases
createdb: database creation failed
The shell is bash. What am I missing please?
Cheers,
Bob
Bob Parkinson
[EMAIL PROTECTED]
--
Technical Manager: Biome
queries like "SELECT * FROM users WHERE id IN
(SELECT USERS from FIRMS).
Can anyone help or advice me something?
Thanks for reading my message.
Sorry for taking your time.
---
Bob Zatolokin
, at:
ftp://cc.vic.purdue.edu/
omni:rwp lsof -i | grep post
postgres 14054 postgres3u inet 0x64b0f900 0t0 TCP *:5432
(LISTEN)
Bob Parkinson
[EMAIL PROTECTED]
--
Technical Manager: Biome http
47673,'CAB','breeders'' associations');
ERROR: parser: parse error at or near "associations"
Whats happening please? Its quoted correctly, isn't it? I've just read the
example/para about 'dianne''s horse'
Cheers,
Bob
Bob Parkinson
[EMAIL PROTECTED]
---
nd / -name
bug.template -print.
--
Bob Kline
mailto:[EMAIL PROTECTED]
http://www.rksystems.com
this priveledge and the result is somehow captured so that they
can either go on to a subroutine generating a HTML screen for deletion or a
subroutine informing them they do not have the correct priveledge status,
etc
Any hints?
Regards - Bob Kruger
,
you would still have to count the rows returned (which is easily
enough done with PHP $count = pg_NumRows($query_result)).
My guess is that SELECT DISTINCT might even be a bit quicker...?? (gurus)
Bob
Yes, I can connect via JDBC and via 'psql -h mypghost.com mydb'
Statistical Solutions wrote:
Are you running postgres with the -i option??? For postgres to work with
tcp/ip, you need to launch postmaster with the -i option.
steve
On Sat, 3 Apr 1999, Bob VonMoss wrote:
Bob VonMoss
The same thing is happening when I compile the sample program:
postgresql-6.4.2/src/test/examples/testlibpq.c
when I put my own database name and set some of the PG env. variables.
bash$ testlibpq
Connection to database 'mydb' failed.
Unsupported frontend protocol.bash$
Bob VonMoss wrote:
Yes
ntf(stderr, "Connection to database '%s' failed.\n",
dbName);
fprintf(stderr, "%s", PQerrorMessage(conn));
exit_nicely(conn);
}
...
}
--
Bob VonMoss
mailto:[EMAIL PROTECTED]
from Chicago, IL
Bob VonMoss wrote:
I'm trying to connect to a database from a C++ program compiled with
g++, linked to the libpq library on a Sun Solaris system. It is compiled
and run like this (my actual information has been changed to pseudonyms,
like mypghost.com, etc.)
bash$ gmake
g++ -c -I /usr
' and recompiled libpq.a
--
Bob VonMoss
mailto:[EMAIL PROTECTED]
from Chicago, IL
* FROM a WHERE '' = a AND a 'C';
--
Bob VonMoss
mailto:[EMAIL PROTECTED]
from Chicago, IL
println(
"closing connection to the PostGreSQL DB...");
try {
con.close();
} catch (SQLException se) {
System.out.println(""+se);
}
System.out.println(
"connection to the PostGreSQL DB closed successfully");
}
}
--
Bob VonMoss
mailto:[EMAIL PROTECTED]
from Chicago, IL
0 exceeded
good luck,
Bob
On Fri, 15 Jan 1999, Silvio Emanuel Barbosa de Macedo wrote:
Hi!
I was using psql to insert data into the database.
I have *.sql files with the necessary scripts, eg:
insert into descritor values (4992,'MARCHAS DE LISBOA','te','cl');
After many inserts..
me problem
you were having with the \i command:
query buffer max length of 2 exceeded
good luck,
Bob
On Fri, 15 Jan 1999, Silvio Emanuel Barbosa de Macedo wrote:
Hi!
I was using psql to insert data into the database.
I have *.sql files with the necessary scripts, eg:
Hey there,
I had some similar problems recently, try this
select someid, somemoneyfield * 2::float as product from table;
You cannot multiply money * money, apparently. But, money * float seems
to work fine. Same goes with division:
select someid, somemoneyfield / 2::float as quotient from
this to me?
Thanks in advance,
Bob
401 - 491 of 491 matches
Mail list logo