In addition to being too purple you might want to note your database is too
old! Upgrade to 7.0.3 - it has foreign key support..
-Mitch
- Original Message -
From: "Adam Haberlach" <[EMAIL PROTECTED]>
To: "" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 12:5
On Mon, 5 Feb 2001, Jeff MacDonald wrote:
> I got some unexpected results from a sum().. just wondering
> if it's a bug of any sort, or if i just should have been expecting it..
>
> SELECT sum(foo) FROM mytable WHERE active = 1;
>
> Now lets say that no rows are active = 1, then this query return
On Thu, Feb 01, 2001 at 07:59:16PM -0500, wrote:
> I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to
> be the problem?
Your database is too purple.
--
Adam Haberlach|A cat spends her life conflicted between a
[EMAIL PROTECTED] |deep, passionate, and p
Jeff MacDonald <[EMAIL PROTECTED]> writes:
> I got some unexpected results from a sum().. just wondering
> if it's a bug of any sort, or if i just should have been expecting it..
> SELECT sum(foo) FROM mytable WHERE active = 1;
> Now lets say that no rows are active = 1, then this query returns
>
Hello all
How do I set up (config) the syslog.conf in red hat 7.0 so that I can
capture the log of other machine ?? Is there any additional works needed to
do ??
Thanks
Sum
> -Original Message-
> From: Michael Miyabara-McCaskey [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, January 31, 2
Super sweet... That is excellent.
-Mitch
On Thu, 1 Feb 2001, Bruce Momjian wrote:
> [ Charset ISO-8859-1 unsupported, converting... ]
> > Hi Doug, your comments caught my eye and I thought I'd ask you something..
> > Are you speaking of using persistant connections with PHP? I'm not sure wha
Greetings.
I'm working with a product provided by a third part that interfaces to
data housed in a database of your choice. Previously, my choice was
MySQL - apparently it handled certain queries too slowly, so I'm giving
PostgreSQL a shot. Here's the query:
SELECT
a.Number,
a.Code,
a.Te
I do
pg_dump -u -s dbname > db_schema
I look at that db_schema file, I only see the primary keys but no
foreign keys.
I don't understand what is OID use for. Will -o option dump the foreign
keys for me?
Thank you!
--
Why we want to teach our babies to talk and walk,
then later we tell them "sit
If you want a graphical approach, try pgaccess for X interface. Its very
clean in displaying tables
Keith C. Perry wrote in message <[EMAIL PROTECTED]>...
>I think I might have described this wrong- "\dt" works the same in
>version 6 and 7. However "\d *" shows you the detail of **each** table
>i
Are there limitations for other DBMS vendors? I would like to see that!
[EMAIL PROTECTED] wrote in message
<95bv3v$tki$[EMAIL PROTECTED]>...
>In article <94skg9$n5q$[EMAIL PROTECTED]>,
> "a" <[EMAIL PROTECTED]> writes:
>> Hi,
>>
>> Is there any document about the limitation of postgres
>> like th
A step in the right direction for this to have the system catalog have
pg_user_* views. So dor databases we have:
create view pg_user_database as
select * from pg_database where pg_get_userbyid(datdba) = CURRENT_USER
Of course, this doesn't account for superusers, but I'm sure there is a way
th
I have three tables:
CREATE TABLE table1 (
idchar(8) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE table2 (
idchar(8) NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (id) REFERENCES table1 (id) ON DELETE CASCADE
);
CREATE TABLE table3 (
idchar(8) NOT NULL,
codechar(2) NOT NULL,
o
In comp.databases.ms-sqlserver Craig Orsinger <[EMAIL PROTECTED]> wrote:
: Rudolf Potucek wrote:
:>
:> I've got the postgres ODBC driver installed and can connect to it from
:> MS Excel 97. However it seems I can only execute queries (read data) but
:> not save data. Is that a limitation of Exc
Brice Ruth wrote:
> Greetings.
>
> I'm working with a product provided by a third part that interfaces to
> data housed in a database of your choice. Previously, my choice was
> MySQL - apparently it handled certain queries too slowly, so I'm giving
> PostgreSQL a shot. Here's the query:
>
> SE
On Wed, Jan 31, 2001 at 09:43:50AM +0200, Ismail Tiryaki wrote:
>
> Hi all,
> I have joined this list newly, and I have some question this
> question may be solved up to now
>
> I wrote simple c source this is connect my postgresql database
> but when I compile my source I see som
Be default PL/PGSQL is not installed in each database. You must type
createlang --host=hostname --port=5432 --username=postgres --dbname=yourdb
--pglib=$PGLIB plpgsql yourdb
To verify type
createlang -l yourdb
--Raymond
begin:vcard
n:Chui;Raymond
tel;fax:(301)713-0963
tel;home:ICQ #: 16722
Ian,
Thanx - I figured the same about the ambiguity. I'll keep tryin' to
debug this with the vendor, then.
-Brice
Ian Harding wrote:
>
> Brice Ruth wrote:
>
> > Greetings.
> >
> > I'm working with a product provided by a third part that interfaces to
> > data housed in a database of your cho
> Currently, we have been having a problem with some kind of corruption of
> the pg_database file. We are using the database on a limited number of
> writes storage medium. (Compact Flash Card) So that we don't always
> write to the flash, and because we don't care about some of the data, part
I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to
be the problem?
hallo newsgroup,
I am looking for information about index- and query-tuning for postgres. any
hint, link or book-recomendation highly appreciated.
thanks
Micha
(postgres version is 7.0.2 if important)
I think I might have described this wrong- "\dt" works the same in
version 6 and 7. However "\d *" shows you the detail of **each** table
in the database. So if you two tables called "status" and "tasks", the
output of "\d *" would be:
Table= status
+--+
Rudolf Potucek wrote:
>
> Hi Everyone!
>
> I am trying to make MS Excel/MS query talk to a postgreSQL database. Is
> there a way to configure the linux or the MS side so they can talk to
> each other?
I've never used Excel, but it's possible to use ODBC to query
a PostgreSQL database
Hi!
I'm trying to generate a executable code from a code written in Perl
that uses the Pg module. I'm using the program 'perlcc' to do this. But
all times that I try to compile my code a error message is going on
breaking the compilation.
It's showing this message:
/tmp/cc3NRQ16.o(.data+0xd738
I've got the postgres ODBC driver installed and can connect to it from
MS Excel 97. However it seems I can only execute queries (read data) but
not save data. Is that a limitation of Excel or of the ODBC approach?
Rudolf
Hi there,
I am trying to find if importing a very large delimited text file is faster
with postgresql or mysql (with mysqlimport). Each night the transaction
system we use completes a text file of the days activities, which must be
loaded into a database, the speed is very important, mysqlimport
Hi there,
I am trying to find if importing a very large text file is
faster with postgresql or mysql (with mysqlimport).
Each night the transaction system we used dumps
a very large text file which must be loaded into a database,
the speed is very important, mysqlimport takes less than
an hour. I
There is kpsql and kpsqlman in kde. Haven't used them very much, but
they seem pretty nice.
regards,
robert gravsjo
wrote:
> Are there any other GUI Interfaces with PostgreSQL other then Pgaccess?
>
> Thanks
>
>
>
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> Probably initdb should have its own check for being run as root;
>> this seems cleaner than reorganizing the checks in the postgres
>> executable.
> I does have that check, but unfortunately that check requires pg_id, and
> findin
Tom Lane writes:
> Probably initdb should have its own check for being run as root;
> this seems cleaner than reorganizing the checks in the postgres
> executable.
I does have that check, but unfortunately that check requires pg_id, and
finding the right pg_id requires finding the right postgres
Tim Barnard writes:
> Well, I was logged in as postgres when this occured.
> I managed to resolve it by changing permissions on the /progs
> directory to rwx. It had been r-x. Strange error message for a permissions
> problem on a destination directory!
I'm not sure I follow. Given that executi
Hi,
After having moved the database directories to a new server, something went
wrong with the large objects. I now have a large number of files named
'xinv' and 'xinx', but trying to lo_open (where
that is a number that was a working large object before) now yields errors
like "lo_open: can't o
Another thing..
Full text indexing, last time I checked, was just a trigger/function, you
don't have to rebuild anything that I'm aware of to include it..
-Mitch
> Hi,
>
> OK full text searching. Will the full text index
> catch changes in verb tense? i.e. will a search for
> woman catch wome
From: "Vitaliy V. Romanets" <[EMAIL PROTECTED]>
> Hi All!
> I see that ODBC driver for <=7.0.* is not compatible
> to 7.1 version. It does't work.
> Can anybody tell me when ODBC driver for 7.1 will be realizable?
>
> Sorry for my english :)
If you want to access pg7.1 from windows, I've been p
If you're sure your're su-ed into "postgres", check the permissions on the
directory your trying to create the database in. I got that same error and
eventually figured out and fixed it when the directory I was trying to
create it in didn't have "write" permission. Yes, it's a strange error to
get
> Hi,
>
> OK full text searching. Will the full text index
> catch changes in verb tense? i.e. will a search for
> woman catch women?
>
> I'm researching before I dive in to this later in the
> week so please excuse this incompletely informed
> question: Will I need to rebuild postgresql with t
Thanks Tom, the problem wasn't that, though, since I was logged in as
postgres at the time. However, as I was trying to create the database under
/progs and it's permissions were set to r-x, changing them to rwx fixed it.
It took awhile to figure it out as the error message threw me off :-)
Regar
The driver has had several updates. The people on the odbc list will have
more info. I believe they have been updating the driver for 7.1 ... or was
it 7.0.1 ... I forget. :)
[EMAIL PROTECTED]
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- O
Hi,
OK full text searching. Will the full text index
catch changes in verb tense? i.e. will a search for
woman catch women?
I'm researching before I dive in to this later in the
week so please excuse this incompletely informed
question: Will I need to rebuild postgresql with the
full-text ind
Title: RE: [GENERAL] 7.0 configuration
On occasions I have had similar errors when starting up. I'm using Mandrake 7.0.3-2mdk RPMs on Mandrake 7.2. The server still starts and runs OK.
Have done a complete reinstall since the last time I had this error so can be of little more help.
Regar
Entering a search request at the archives website
yields the following result:
the website for ReadySetNet
Error: File not found - Did you enter the correct
domain name or URL
Same results in Opera and Netscape.
Appreciate a fix.
Bill
Hi All!
I see that ODBC driver for <=7.0.* is not compatible
to 7.1 version. It does't work.
Can anybody tell me when ODBC driver for 7.1 will be realizable?
Sorry for my english :)
Vitaliy.
Hello,
Recently i had to upgrade a raq3 from 6.5.2 (default) to
the 7 series. there's a few ways you can go about it.
1 : backup the "cobalt" database , unrpm the postgresql 6.5.2
but carefull not to hose the special-sauce.rpm..
then install postgresql 7 from source (it compiles fine.) in
Tom Lane wrote:
> > I figured out the problem, postmaster when run as postgres didn't have
> > write permissions to /var/run/postgresql directory (where the Debian
> > version puts its socket files) and therefore didn't have permission to
> > open the socket. .
>
> ROTFL ... score one for the De
Einar Karttunen wrote:
> The program '/usr/local/pgsql/bin/postgres' needed by initdb does not
> belong to
> PostgreSQL version 7.1beta4. Check your installation.
See previous thread. You must not run it as root.
--
Alessio F. Bragadini[EMAIL PROTECTED]
APL Financial Services
At long last I have got the Debian packages of 7.1beta4 done.
See http://www.debian.org/~elphick/postgresql/
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47
En un mensaje anterior, Tom Lane escribió:
> Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> > select * from aliases where alias~'^claudia.gonzalez$' \g
> > alias|receptores
> > -+--
> > (0 rows)
>
> > select * from aliases where alias~'claudia.gonzalez$' \g
> > alias
After compiling and installing the beta with configure with
no extra options on a redhat 6.1 system initdb complained
The program '/usr/local/pgsql/bin/postgres' needed by initdb does not
belong to
PostgreSQL version 7.1beta4. Check your installation.
However the executable is created by the inst
47 matches
Mail list logo
