Hey,
> Does anyone have experience with report writers? It's not something I
> know much about yet.
Crystal Reports (www.seagate.com) is quite good, can do any sort of report
you're after. You can use an ODBC driver for accessing the database, so
accessing pgsql wouldn't be a problem..
Oops
Hi guys,
Does anyone have experience with report writers? It's not something I
know much about yet.
Regards and best wishes,
Justin Clift
Original Message
Subject: Re: [ANNOUNCE] New PostgreSQL Review at epinions.com
Date: Thu, 26 Apr 2001 21:19:08 -0400 (EDT)
From: Patrick
"Clayton Vernon" <[EMAIL PROTECTED]> writes:
> Thanks, but can I specify each port? I've only seen the one documented
> command option "-p" which I assume was for the TCP/IP port.
Well, Unix sockets don't have a "port". The port number you specify
is appended to the name of the socket in the fi
Hello,
I have some problems to display the accents in my db, using the JDBC and
postgres 7.1.
Apparently, all accents are replaced by a '?'.
Thanks .
Loic Courtois
Netpartage
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, pl
"Clayton Vernon" <[EMAIL PROTECTED]> writes:
> Related question: how do you run postgreSQL to simultaneously support a Unix
> socket and TCP/IP?
Just add '-i' to the postmaster startup options. The Unix socket will
still be available.
-Doug
--
The rain man gave me two cures; he said jump ri
Try this command at the psql command line:
CREATE SEQUENCE atable_id_seq;
ALTER TABLE atable ALTER COLUMN id SET DEFAULT
nextval('"atable_id_seq"'::text);
Jeff
-Original Message-
How can I make the insert
command automatically update the 'id' to the next highest number?
---
"John Oakes" <[EMAIL PROTECTED]> writes:
> Anyone have any ideas how to speed up performance using the JDBC driver? A
> query that takes me 20 seconds to execute from command line takes 1 full
> minute with the jdbc driver. Thanks.
Since you don't guve any details of your query or network setu
"solo" <[EMAIL PROTECTED]> writes:
> If i use the -h option to specify the hostname it always fails to connect.
> [solo@zoot /root]$ psql -h localhost
> Connection to database 'solo' failed.
> connectDB() -- unknown hostname: localhost
> My localhost is configured properly
> [root@zoot /root]#
is there in postgres a way to create a constant like CURRENT_DATE for
general use?
-tfo
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]
"Geoff Caplan" wrote:
>Peter, thanks for your patience with a newbie. I think my stuckness stems
>from 2 issues:
>
>1) Starting environment
>
>> The environment initdb runs in when it runs at system startup is probably
>> not the one you set up. Check the /etc/init.d/postgresql file
On Thu, Apr 26, 2001 at 02:01:46PM -0500, will trillich wrote:
> On Thu, Apr 26, 2001 at 05:20:53PM +0200, Peter Eisentraut wrote:
> > will trillich writes:
> >
> > > i know "password" can be used in creating/altering user
> > > information (as used via GRANT and REVOKE) but is there any
> > > fa
On Thu, 26 Apr 2001, Clayton Vernon wrote:
> Joel-
>
> In all fairness, there aren't any good HTML-based Unix tutorials. I've
> looked for them. In particular, Sun is worthless here, curious since their
> Java tutorial is (IMO) really well done.
>
> I'm hoping PostgreSQL is MORE stable than Ora
yes, but my tables have long names, i've already done as suggested by you.
why not have a schema table created for us to extract these info.
>From: Joel Burton <[EMAIL PROTECTED]>
>To: "V. M." <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
>Subject: Re: [HACKERS] Re: unanswered:
On Thu, 26 Apr 2001, Wendy wrote:
> I backed up a database at night and noted the size to be about over 300MB.
Backuped with pg_dump, or dumped the raw database files ? In the latter
case you want to stop the PostgreSQL server first.
> The following morning, I again backed up the same database
Ahhh, but I didn't use a double quote identifier. This statement worked fine
for me:
CREATE TABLE atable (
title VARCHAR(20),
name VARCHAR(20),
id SERIAL PRIMARY KEY,
date DATE);
Greg
- Original Message -
From: "Joel Burton" <[EMAIL PROTECTED]>
To: "Gregory Wood" <[EMAIL PROTECTED]>
Cc:
will trillich <[EMAIL PROTECTED]> wrote:
>On Thu, Apr 26, 2001 at 05:20:53PM +0200, Peter Eisentraut wrote:
>> See contrib/pgcrypto for hashing functions.
>Care to explain -- in terms a Debian newbie might grok -- what
>"contrib/pgcrypto" means?
Peter is referring to a directory in the PostgreSQ
On Fri, 27 Apr 2001, Justin Clift wrote:
> Newbies have interesting ideas sometimes too. After all, they've spent
> their time learning about something OTHER than Unix. :-)
something... other... than... unix ?
Justin, I'm not clear on what you mean. Can you give us an example? ;-)
But r
On Thu, 26 Apr 2001, Boulat Khakimov wrote:
> Hi,
>
> I've discovered a bug in Postgres. When you rename
> a table, the corresponding triggers for that table
> are not updated.
Yep.
Use ALTER TABLE ADD CONSTRAINT to add 'em back in.
More info can be found in the Ref Int tutorial I just subm
On Thu, Apr 26, 2001 at 05:20:53PM +0200, Peter Eisentraut wrote:
> will trillich writes:
>
> > i know "password" can be used in creating/altering user
> > information (as used via GRANT and REVOKE) but is there any
> > facility within postgres to CRYPT() a value?
>
> See contrib/pgcrypto for ha
Hi,
I'm having a problem when i try to connect to the database.
If i use the -h option to specify the hostname it always fails to connect.
[solo@zoot /root]$ psql -h localhost
Connection to database 'solo' failed.
connectDB() -- unknown hostname: localhost
My localhost is configured properly
On Thu, 26 Apr 2001, Gregory Wood wrote:
> > I don't know if you can name a column "date" because I think it's a
> > reserved word.
>
> Oddly enough, it *does* work (at least on my version of 7.1), although I
> would recommend against doing it if for no other reason than it's confusing.
If you
> I don't know if you can name a column "date" because I think it's a
> reserved word.
Oddly enough, it *does* work (at least on my version of 7.1), although I
would recommend against doing it if for no other reason than it's confusing.
Greg
---(end of broadcast)---
> > I'm surprised that works at all... the name of the table is "atable",
isn't
> > it? Try this:
> >
> > INSERT INTO atable (title,name,date) VALUES ('SQL3','Toy',date('now'));
> >
> > Greg
>
> Thanks for the help. I wrote the command out wrong in the post, I did try
the
> one that you wrote out
Hi,
I've discovered a bug in Postgres. When you rename
a table, the corresponding triggers for that table
are not updated.
For example:
CREATE TABLE tblParent (
ID SERIAL NOT NULL,
Name text,
PRIMARY KEY (ID)
);
CREATE TABLE tblChild (
ID int4 NOT NULL,
email text,
FOREIGN KEY
Got it...
It seams those triggers were created to handle the types I used for the
columns: int2 and bytea...
I realy should check out the types section in the postgres docu :))
> -Original Message-
> From: Gregory Wood [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 26, 2001 7:59 P
I got good results in a test case, just using a standard PostgreSQL dump
file created with INSERT statements (pg_dump -d). All it needed was a
little editing to change some of the data types in the table definition,
e.g. from text and varchar to varchar2 (if your Oracle table is set up, you
won't
Hello,
I have the following java source code:
This one work with pg 7.0.3 , but not with 7.1, with the following error
message:
java.lang.NullPointerException
at org.postgresql.jdbc2.ResultSet.next(ResultSet.java:116)
at ouah.stats.Stats.go(Stats.java:242)
at daily.main(
Geoff Caplan writes:
> > The environment initdb runs in when it runs at system startup is probably
> > not the one you set up. Check the /etc/init.d/postgresql file for
> > details.
>
> This is certainly true, as my settings are overridden. I have had a look at
> this file, but I am still not cl
Can anyone tell me what this notice means?
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s) ?
greetings
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I've created a plpgsql function that takes 2 args as follows:
CREATE FUNCTION insert_default(text,text) RETURNS OPAQUE AS 'BEGIN new.$2 =
new.$1; RETURN new; END;' LANGUAGE 'plpgsql';
When I try to reference this function when creating a trigger:
CREATE TRIGGER "iep_district_insert" BEFORE I
On Thu, 26 Apr 2001, Christian Marschalek wrote:
> Can anyone tell me what this notice means?
>
> NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
> check(s) ?
The foreign key constraint checks are handled by triggers on the
pk and fk table. The warning just lets you know
> Can anyone tell me what this notice means?
>
> NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
> check(s) ?
It means that PostgreSQL will automatically create triggers to perform your
foreign key checks :)
Seriously though, PostgreSQL has to have some mechanism to check t
hiroko wrote:
> we're now developping a system on Linux, using PostgreSQL.and the
> question this time is abouthow to connect to the DBserver through the
> network (ex,ethernet) from clients.especially on CODINGS. we found a
> lot of info about the way of connecting between DBserver on Linux and
Oliver Elphick
> There is an enormous amount of background knowledge assumed when
> you document an application, and this is necessary, or else every document
> would become a Windows-like spoon-feeder, which would spend so much
> time on basic stuff that it would never cover the real meat.
>
> I
> Use the "tableoid" pseudo-column.
Ah! Awesome.
A little playing with pg_class, and we have table/class names too.
PostgreSQL has cool new things to find every day...
Thanks Tom!
- Jeff
--
Web development with PHP is like injecting pure rust with a
hig
On Thu, Apr 26, 2001 at 09:15:45AM -0500, will trillich wrote:
> i know "password" can be used in creating/altering user
> information (as used via GRANT and REVOKE) but is there any
> facility within postgres to CRYPT() a value?
At the moment no. You should patch your PostgreSQL source for
that
Jason writes:
> Hi , I'm a postgreSQL newbie. I have a table called "atable" that has
> the columns:
> title varchar(20)
> name varchar(20)
> id serial
> if I do:
> INSERT INTO TABLE atable VALUES('SQL1','Jason')
> the 'id' gets updated with a new number automatically. I then later
> added a n
"Clayton Vernon" <[EMAIL PROTECTED]> writes:
> 1) Do you have to specify in advance the full number of processes, or does =
> it dynamically manage them ala Apache?
You have to set an upper limit on the max number of server processes.
This is mainly to prevent Postgres from taking over your syste
I am new user of linux. and I am interested in Postgresql
recently I download ver7.1 and setup
I do it step by step according some docunment in www.Linuxfab.cx
the docunment I read is in below link
http://linuxfab.cx/indexBookData.php?BID=5&G1=5&G2=2&G3=0&G4=0&PAGEID=1
The problem I got is
On Wed, Apr 25, 2001 at 09:32:07AM +0200, Berényi Gábor wrote:
> I have been inserting records into a table using the SQL insert statement.
> One of the field types is serial, and I have been
> trying to figure out how to get the value that was assigned in the field as
> a result of the insert. Th
i know "password" can be used in creating/altering user
information (as used via GRANT and REVOKE) but is there any
facility within postgres to CRYPT() a value?
create rule new_folk as on insert to view_folk do instead
insert into folk_table
(create
Hi folks
Having a nightmare changing the default data location in 7.1
I uninstalled and re-installed 7.1 on RedHat 6.2 from the rpms with a
clean system. With the help of this list, I have set $PGDATA in my
shell config file and exported the value.
Postgres utilities such as initdb now recognis
"Dr. Evil" wrote:
>
> I'm trying to use CREATE TABLE AS under 7.03. There are no
> examples in the guide, so I tried a few things:
>
> CREATE TABLE foo (test INT4) AS SELECT number FROM account;
>
> and
>
> CREATE TABLE foo (test INT4) AS number FROM account;
>
> and both of them give ERROR:
Probably to rip out some really good guts that it does have and put
them into DB2.
On Tue, 24 Apr 2001 23:32:33 + (UTC), [EMAIL PROTECTED] (Joseph
Shraibman) wrote:
>Martín Marqués wrote:
>>
>> On Mar 24 Abr 2001 18:04, Bruce Momjian wrote:
>> > IBM to buy Informix:
>> >
>> >http://news
3) I've been told PostgreSQL databases must be periodically "rebuilt" so to
speak, ("vacuumed"). Is this easy to do on-the-fly? Rapid? Or, does the db
need to go down awhile?
Not so much rebuilt, but just cleaned up. My understanding is that deleted
records (and outdated copies of UPDATEd records
Hi , I'm a postgreSQL newbie. I have a table called "atable" that has
the columns:
title varchar(20)
name varchar(20)
id serial
if I do:
INSERT INTO TABLE atable VALUES('SQL1','Jason')
the 'id' gets updated with a new number automatically. I then later
added a new column called 'date'. Now if
En ORACLE, puedo pasar parametros a un query de la
siguiente manera:
select campo1, campo2
from tabla1
where campo3=&variable
En Postgres como se hace?
Gracias.
When i try to compile postgresql on solaris 8/ x86
i get following:
make -C tcop all
make[3]: Entering directory
`/export/home/soft/source/postgresql/7.1/postgresql-7.1/src/backend/tcop'
gcc -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/includ
e -c -o dest.o dest.c
gcc -Wal
Is there any way around having to own the table you are inheriting from in
PostgreSQL 7.1?
--
Alastair D'Silva (mob: 0413 485 733)
Networking Consultant
New Millennium Networking (web: http://www.newmillennium.net.au)
---(end of broadcast)---
TIP
Hi all,
Is there a way of determining the original class of a row when querying
inherited tables? Consider:
CREATE TABLE users (
uid int4 SERIAL PRIMARY KEY,
email varchar(60)
);
CREATE TABLE clients (
surname varchar(30)
[etc]
) INHERITS (users);
CREATE TABLE suppliers (
Dear:
I wanna create a function that return a multiple rows in to a single
row.
example:
CREATE FUNCTION GETNAME() RETURNS SETOF VARCHAR AS 'SELECT NAME FROM
TEST;' LANGUAGE 'SQL';
when i call this function it return:
--
peter
susan
john
but I wonder is it possible to make it to retu
Is there a way to check if a specific row is locked !
(URGENT !)
Thank you !!!
Theo
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi, I'm a newbie with SQL in general. I am building a site with PHP
and postrgreSQL that will have articles. In the postgreSQL db, should
I store the actual article inside it, or just the path of the article
on my machine? How about with images? What are the benefits and or
bad points of stori
Hi all !
I have been inserting records into a table using the SQL insert statement.
One of the field types is serial, and I have been
trying to figure out how to get the value that was assigned in the field as
a result of the insert. The serial typed field is the only one guaranteed
to be unique,
hello all,
we are running PostgreSQL 7.0.2 on Solaris 2.6,/x86 compiled by gcc 2.8.1.
For installation Postgres on 70 Solaris-2.6 server we built packages
(SVR4-style).
The first time we installed Postgres everything was ok. But after a new
installation of the package ( - same Postgres version
Geoff Caplan wrote:
> Please help out a Linx/Postgres newbie.
>
> I simply want to set the $PGDATA environmental variable, but can't
> figure out how. The docs assume you already know...
>
> I have tried setting it in my bash /etc/profile configuration file,
> and it shows up ok if I "echo $P
Told you it was something stupid. Turns out I was using the wrong
Postgres ODBC driver. My MDK 7.2 installation had 2 things that looked
like the driver.
/usr/lib/libpsqlodbc.so
and
/usr/lib/libodbcpsql.so
The correct one seems to be libodbcpsql
I had tried both, and originally using libodbcp
Hi, I'm a newbie with SQL in general. I am building a site with PHP
and postrgreSQL that will have articles. In the postgreSQL db, should
I store the actual article inside it, or just the pat hof the article
on my machine? How about with images? What are the benefits and or
bad points of stori
Hi,
i have problems with PostgreSQL 7.0.3 on a RedHat 6.2 System. Very often
postgresql post me the following warning and error message.
Warning: Unable to connect to PostgreSQL server: Sorry, too many clients
already in /home/server/...
PostgreSQL said: Unable to connect to server
It seem
Hi, I'm trying to insert data from a php-page. The connection is open and
select-functions work perfectly. The problem is that an insert will - as far
as I know - insert the data and then immediately erase it.
The insert statement executed from php is:
$otsikko = "Insert testi";
$tekst
First off, what a wonderful mail list! I've been
listening in for a couple of days now, and it is marvelous the community you
people have.
I'm new to this software, so I won't waste much of
your time, but I'm curious as to the architecture of the server-side daemon,
etc.
1) Do you have t
On Sunday 22 April 2001 10:21, you wrote:
> however, this seems like a reasonable idea that would not introduce
> any major problems. I have no objections, if someone wants to submit
> a grammar patch.
>
> regards, tom lane
Please don't. IMHO This would be an unneces
Hi there
I have a relatively simple problem :
I have a field named "id" that has type "Auto-number" in an Access database table.
When I export the database via ODBC to a PostgreSQL table, the "auto- number" property of this field is lost (!) :
CREATE TABLE "names"("id" int4,"name"
Hi !
Last day, when I did a vacuum, postgres crashes.
Now It works fine, but I can't do VACUMM, the error message is something
like "Can't get lock. Is another Vacuum running ?"
What can I do to reactivate the vacuum ?
thank you.
---
En ORACLE, puedo pasar parametros a un query de la
siguiente manera:
select campo1, campo2
from tabla1
where campo3=&variable
En Postgres como se hace?
Gracias.
I'm using Slackware 7.1 on VMWare with Postgresql 7.1
When i do a ./configure it stops with this message:
checking host system type... Invalid configuration 'i?86-pc-linux-gnu':
machine 'i?86-pc' not recognized
Any ideas on this and how to solve it?
THanks
---(end of
Hi,
i have problems with PostgreSQL 7.0.3 on a RedHat 6.2 System. Very often
postgresql post me the following warning and error message.
Warning: Unable to connect to PostgreSQL server: Sorry, too many clients
already in /home/server/...
PostgreSQL said: Unable to connect to server
It see
Bob Parkinson <[EMAIL PROTECTED]> wrote:
>query: rollback
>
>does this mean that a transaction has failed?
Indeed.
>I'm not seeing any other error messages
A rollback need not be the result of the backend raising an error. It can
also be triggered deliberately by your code that talks to the bac
i think its:
CREATE TABLE foo AS SELECT number FROM account;
tamsin
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Dr. Evil
> Sent: 25 April 2001 23:46
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] CREATE TABLE AS... syntax?
>
>
>
> I'm trying t
Hi there
I have a relatively simple problem :
I have a field named "id" that has type "Auto-number" in an Access database table.
I know there is no 'auto_number' type in PostgreSQL. I know also, that SERIAL and SEQUENCE are workarounds for this problem, but I'm not sure how to make a
Sebastian Bossung writes:
> how do you find out if a row is locked _before_ using SELECT ... FOR UPADTE
> on it. The SELECT will wait for the lock to be removed (if there was one),
> making the user think the app crashed.
There is currently no way to detect locks. You could implement a timeout
Geoff Caplan wrote:
[I assume you meant this for the list, not just me]
>With 7.1 Postgres has the potential to enter the mainstream and
>compete with MySQL for popularity. But the framework of the docs was
>laid at a time when I guess it was safe to assume that users would
>have advanced
(With 7.0.3, going to 1.1 RSN'ish.)
I've just stared looking at logs and I'm getting lines in the log:
query: rollback
does this mean that a transaction has failed? I'm not seeing any other
error messages (mind you, I need to check my scripts and see what they
are loggingas errors).
usr/loca
On Thu, 26 Apr 2001 [EMAIL PROTECTED] wrote:
> I have written all the script in a db.txt file, how to call the script from the
> file???
> In Oracle one can issue $ @filename and the job get done, whats the relative
> option in POSTGRES ???
\i filename
use \? for a complete list.
--
Tod McQuil
On Wed, Apr 25, 2001 at 05:03:51PM -0400, Tom Lane wrote:
> Joel Burton <[EMAIL PROTECTED]> writes:
> > couldn't the parse tree be cached from this for each backend?
>
> Yes, if someone wanted to work on it ...
It needs global query plan cache and integrate it to SQL function
handler. The usabl
Hi,
I have written all the script in a db.txt file, how to call the script from the
file???
In Oracle one can issue $ @filename and the job get done, whats the relative
option in POSTGRES ???
DArshan
---(end of broadcast)---
TIP 2: you can get
76 matches
Mail list logo