Use the Serial type for address_id.
And you should read the Manuals ! :)
- Original Message -
From: "Markus Jais" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 12:20 AM
Subject: [GENERAL] autoincrement???
> hi
> I have the following problem:
>
> I create the
You could either try:
CREATE TABLE address (
address_id int SERIAL,
street VARCHAR(40),
zipcode INT,
city VARCHAR(40),
country VARCHAR(40)
);
Or you could do the same thing yourself manually with:
CREATE sequence address_id_seq;
CREATE TABLE address (
address_id int PRIMARY KEY D
Bruce Momjian wrote:
>
> >
> > 6. Can databases be partitioned over multiple physical files. Can
>
> You have to use symlinks to move to other file systems.
That's not what he asked. He asked about files, and the answer is yes.
--
Joseph Shraibman
[EMAIL PROTECTED]
Increase signal to noise
> Version: Postgres 7.1.2
>
> A product we are developing requires frequent loading
> of a large number of rows into a table. We are using
> the "copy file" command, but with WAL we are effectively
> doubling the amount of disk writing we are doing.
>
> After the rows are loaded we do a "create
> Anyone know of any visual modelling apps (like CA's ERWin ) that work well
> with pg?
> I Have been using erwin but just discovered it isn't creating my pk, fk or
> unique constraints.
> I am using the odbc v3.0 target repository option in erwin.
Dbdesigner.
--
Bruce Momjian
> > Some time ago I posted to comp.databases a list of requirements which
> > IMHO any RDBMS product must meet to be generally useful in commercial
> > applications.
> >
> > I got some responses back regarding Postgresql but a lot of
> > improvements have since been made, so I am reposting the ori
Look at the SERIAL type and the CREATE SEQUENCE documentation.
-philip
On Thu, 12 Jul 2001, Markus Jais wrote:
> hi
> I have the following problem:
>
> I create the following table:
>
> CREATE TABLE address (
> address_id int PRIMARY KEY ,
> street VARCHAR(40),
> zi
> Can you please tell me, how to do this in postgresql
Use a SERIAL datatype:
http://postgresql.crimelabs.net/users-lounge/docs/7.1/user/datatype.html#DAT
ATYPE-SERIAL
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http:
hi
I have the following problem:
I create the following table:
CREATE TABLE address (
address_id int PRIMARY KEY ,
street VARCHAR(40),
zipcodeINT,
city VARCHAR(40),
countryVARCHAR(40)
);
Now, I want the address_id to get incremented
eve
Anyone know of any visual modelling apps (like CA's ERWin ) that work well
with pg?
I Have been using erwin but just discovered it isn't creating my pk, fk or
unique constraints.
I am using the odbc v3.0 target repository option in erwin.
Thanks,
Morgan
---(end of bro
Blah Blah Blah
Who cares if GMC or some other big company want to throw a huge
amount of computer resources and money for support personnel and
contracts!
I have worked with Oracle. It is a pig on resources, a nightmare
and daymare to administer. Like all proprietary software bug fixes
and enhan
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> I notice the "urgent" item for point-in-time recovery doesn't have
> >> the '-' indicating a 7.2 item.
> >>
> >> When is that planned?
>
> > I hope for 7.2.
>
> What grounds do you have for hoping that? If there's anyone working
> on it, they're
On Mié 11 Jul 2001 20:49, Bruce Momjian wrote:
> > On Mi? 11 Jul 2001 13:46, Ryan Mahoney wrote:
> > > Hi Mark, This is being worked on now. I believe the 7.2 release will
> > > have enable you to run a vacuum with no downtime.
> >
> > AFAIK, if UNDO is implemented, no vacuum will be needed to fr
I assume that there is in fact a difference between doing:
\df+
and:
select oid,proname,prosrc from pg_proc where proname='func_name';
because I have a plpgsql function for a trigger, which I can see with the second
method (the select...) but not with the first method (the \df+ ). Is it not
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> I notice the "urgent" item for point-in-time recovery doesn't have
>> the '-' indicating a 7.2 item.
>>
>> When is that planned?
> I hope for 7.2.
What grounds do you have for hoping that? If there's anyone working
on it, they're sure keeping a migh
Hi!
PostgreSQL runs with Windows (NT and 2000). Clientapplications should run
under Win9x / ME too (I never tried that).
Best way to get a running PostgreSQL-Server is installing cygwin
(http://www.cygwin.com/) an than carefully reading the NT-install-docs
(http://www.freebsd.org/~kevlo/postgres/
Just thought I'd drop a note to the PostgreSQL developers to let them
know PostgreSQL is powering GoAmerica's newly released Go.Messenger system
(http://www.goamerica.net/gomessenger/). Go.Messenger is an instant messaging
solution for the RIM wireless Internet handheld device platform, and is Y
> Another factor, not under our control, is that if the shared memory
> region gets too large the kernel may decide to swap out portions of
> it that haven't been touched lately. This of course is completely
> counterproductive, especially if what gets swapped is a dirty buffer,
> which'll event
Hi All
I'm a new Postgres User and because I'm from Israel I use the Hebrew set in
locale.
from reading the documents I realized that all the databases created under
directory that was created with initdb while locale was set to something
will be sorted by this locale with no way to set it to ot
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> In my testing with *particluar* environment (Linux kernel 2.2.x,
> pgbench), it was indicated that too many shared buffers reduced the
> performance even though there was lots of memory, say 1GB. I'm not
> sure why, but I suspect there is a siginificant o
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
>> It's not immediately obvious to me that these are equivalent, or
>> perhaps I should say it's not clear under what conditions is the
>> transformation legitimate.
> Could you tell me in what cases two of above are not equivalent?
It may well be OK, I j
The list looks fantastic. I'm now looking forward to this release. Sounds like
it's planned for just 6-9 months after the 7.1 release, or thereabouts? Good
agressive schedule.
I would like to request one more feature of course: support for ALTER TABLE
tablename MODIFY columnname [create cla
Martijn van Oosterhout wrote:
> What the limit on NT?
I'm told 2^64 bytes. Frankly, I'd be surprised if MS has tested it :-)
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
---(end of
Marco Colombo wrote:
> BTW, the document contains some limits. FS size limit is reported to be
> 2TB (block-device size limit). I don't know if it applies to LVM logical
> volumes. Ext2 FS size limit is 16TB (for 4kB blocks FS). You need to put
> some effort to place 16TB on a single FS.
Thanks
24 matches
Mail list logo
