From: "Dado Feigenblatt" <[EMAIL PROTECTED]>
> I'm trying to create some tables with foreign keys.
> When I try to create a foreign key ...
>
> foreign key(seq_code) references sequences(seq_code) on update
> CASCADE on delete CASCADE,
>
> I get this message:
>
> ERROR: UNIQUE constr
Alright, but what about when you're writing a long dump file with all these
sequences, functions not speaking about the tables themselves.
When I drop something I wanna make sure it out the database (but still
cannot empty the whole database before), so I have
DROP TABLE ..., ..., ..., ...;
DROP
Em 10 Jul 2001, Raymond Chui escreveu:
>In other database systems, such as Informix, Sybase, etc. The database
>is stored
>in the raw disk partitions, you can config the database system into
>different
>partitions, different disks, slice into different trunks, etc. But
>Postgre
Hi all:
We have developed an aplication in C with postgresql, using libpq. Our
version of development is Postgresql 6.5.3 and it works fine.
Now we are migrating the application to various flavours of Linux
(S.u.s.e 7.1, tha uses postgresql 7.0.3; Debian Potato, that uses
postgresql 7.0.2) and
Dear list,
With the advent of Version 7.1.2 I thought it would be interesting to compare
how Postgresql does a certain class of queries (Star Queries), and Data Loads
with some of the other leading databases ( which were in my humble opinion
Mysql 3.23.39, Db2 7.2 ,Oracle 9.0 [ ok - Possibly S
On Wed, 11 Jul 2001, Carlos wrote:
> Select distinct field1, field2 from table1 order by field3;
>
> The value return by PQresultErrorMessage is:
>
> For SELECT DISTINCT, ORDER BY expressions must appear in target list
That's because this query is ambiguous.
What if table1 looks like this:
fie
Hi all,
I have tried (and failed) my first steps in Pl/PgSQL.
This must be real simple (like a 'create language' or something) but I don't
(yet) know how to do this and maybe someone has a quick answer for me here.
I get this (I'm sure it's a clear case of RT(F)M, but there are so many Ms
to R, I
The following select sets two custom column names using the same
original column name. When I try to include a custom column name in a
group by clause I get ORA-00904: invalid column name from Oracle. How
can I access a column name I created in the group by clause?
Here's the SQL: DISP is the
Hello there!
[Please Cc: me in followups.]
I tried the following:
CREATE TABLE a (
int4 id
);
CREATE TABLE b (
int4 id
CHECK (id = ANY(SELECT a.id FROM a))
);
Tables are created ok, checking with '\d table' confirms it. But when I
try to insert into table b, e.g.:
INSERT INTO b (id)
VA
hi all,
how can we cast an ipaddress(type cidr) to any other type?
thankx in advance..
Regards,
Bhuvaneswar.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROT
Mark, (and Tom below)
Thanks for doing the tests. These'll be useful to me if any client
asks me again if PostgreSQL is a "real" database. I'm particularly
intrigued that MySQL performed so poorly. In the field, it's been quite
speedy but maybe that's because applications using it are
man createlang
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Chris,
sounds like you haven't called 'createlang plpgsql database-name' at the
comand prompt. Try executing this and see if it works.
-Robby
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Chris Ruprecht
Sent: Tuesday, July 17, 2001 8:49 AM
To: p-sql
S
Carlos <[EMAIL PROTECTED]> writes:
> Select distinct field1, field2 from table1 order by field3;
> The value return by PQresultErrorMessage is:
> For SELECT DISTINCT, ORDER BY expressions must appear in target list
> Whatever this query works fine in postgresql 6.5.3.
> Is correct this query a
Matt,
First of all, this is a PostgreSQL list, so we're not going to be able
to give you much help with Oracle.
> The following select sets two custom column names using the same
> original column name. When I try to include a custom column name in
> a
> group by clause I get ORA-00904: invalid
This is not the right mail list, but I wanted to get it into
google/archives (I will forget what I did in 15 minutes, and I could
find little documentation on this process).
To build the redhat 7.1 plperl rpm, you merely need to
rpm -Uvh postgresql-7.1.2-4PGDG.src.rpm
then there should be a
Hi all,
I need to know how I can access a flat file from within a PL/PGSQL script.
I have an Oracle PL/SQL book here and they refer to FOPEN(...), FCLOSE(...)
but these functions don't seem to exist in PL/PGSQL.. What can I do instead?
I checked the Programmer's Guide to Procedural Languages (Pos
The hack and slash Perl programmer in me says---
if you only plan to do this once, (like importing data), then
just write a Perl script that *generates* SQL code that does
your inserts, updates, or whatever. You can then execute
thsi with psql -f filename. But if you're trying to use
flat files pr
You can probably try to make a c extension that does open/close.
On 17 Jul 2001 15:28:36 -0500, Chris Ruprecht wrote:
> Hi all,
>
> I need to know how I can access a flat file from within a PL/PGSQL script.
> I have an Oracle PL/SQL book here and they refer to FOPEN(...), FCLOSE(...)
> but these
"Chris Ruprecht" <[EMAIL PROTECTED]> writes:
> I need to know how I can access a flat file from within a PL/PGSQL script.
You can't --- and you should ask yourself hard questions about why your
system design needs that, or whether the data in question shouldn't be
inside the database to begin wit
Chris Ruprecht writes:
> I need to know how I can access a flat file from within a PL/PGSQL script.
You can't.
PL/TclU could help you there.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
T
Hi Tom,
If life was easy, everything would just come in the format I'd like it. But
since it isn't, I need to create records like this one:
cdate| ctime | countrycode | areacodex | success | carrier |
duration| phonenumber | areacode | pseq | loadno | frline | entity |
loaddate | loa
Chris Ruprecht <[EMAIL PROTECTED]> writes:
> If life was easy, everything would just come in the format I'd like it. But
> since it isn't, I need to create records like this one:
> ...
> From an input file where the records looks like this one:
If it's just a data import issue, why do you want to
Chris,
Hmmph. People are in a bad mood this week; obviously few other people
on the list have had to write applications for the banking industry,
which trades everything in flat files. Give Chris a break!
> >From an input file where the records looks like this one:
>
> 020-13 016-05 07-15-200
Hi Josh,
on 07/17/2001 18:31, Josh Berkus at [EMAIL PROTECTED] wrote:
> Chris,
>
> Hmmph. People are in a bad mood this week; obviously few other people
> on the list have had to write applications for the banking industry,
> which trades everything in flat files. Give Chris a break!
>
Than
Crhis,
> Thanks ;). I'm new to PostGreSQL and to PHP and to SQL - I have done
> Progress RDBMS/4GL for the last 12 years and it absolutely spoils
> you. But
> in the last 2 weeks, I have hammered out an application (you can have
> a look
> at http://chill-025.bbnow.net, use user demo and password
On Wed, 11 Jul 2001, Stephan Szabo wrote:
> On Wed, 11 Jul 2001, Phuong Ma wrote:
>
> > I'm trying to define a trigger that copies the row to be deleted into
> > another table (which is the inventory_audit table) before it does the
> > delete from the original table (which is the inventory table
After I performed
cluster indexname on tablename;
All the foreign key constraints are lost on that table, why is that?
I get messages like
NOTICE: DROP TABLE implicitly drops referential integrity
trigger from table "tablename"
during cluster
I don't want to lost the foreign key constraints
28 matches
Mail list logo
