Title: Object syntax
Given the following table definitions, and data inserts:
dev=# create address (addr varchar(50), postcode varchar(9));
dev=# create client (name varchar(30), addr address);
dev=# insert into client values ('Michael');
dev=# insert into address values ('11 Windsor Close',
Title: RE: [GENERAL] Regular expression question
Yes, that's right :-0 Sorry!
-Original Message-
From: Steve Heaven [mailto:[EMAIL PROTECTED]]
Sent: 11 December 2000 15:09
To: Michael Ansley; [EMAIL PROTECTED]
Subject: RE: [GENERAL] Regular expression question
At 14:58 11/
Title: RE: [GENERAL] Re: 'Tuple is too big' Error
You can set the BLOCKSZ parameter up to a max of 32kB. This will increase the row length to 32kB (a bit shorter because of some admin overhead, but close enough). In the medium-term, upgrade to 7.1 as this limit has been removed.
MikeA
---
.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: 18 January 2001 02:21
To: Michael Ansley
Cc: '[EMAIL PROTECTED] '
Subject: Re: [GENERAL] Strange reference problem
Michael Ansley <[EMAIL PROTECTED]> writes:
> CREATE TABLE "swt" (
>
Title: RE: [GENERAL] Fw: [PHP] Fooling the query optimizer
Running this query:
"SELECT * WHERE col3 = x"
with a btree index on (col1, col2, col3) cannot be performed in an efficient manner, in any database, because you have specified the column order to be col1, col2, col3. If somebody cl
Title: RE: [GENERAL] transaction safety
Hi,
The number returned by the sequence for the serial ID is retained within the session, and so it can be returned by calling currval, e.g.:
CREATE TABLE person (
id serial primary key,
name varchar not null,
dob timestamp no
serts do not block the table. Inserts can happen as fast as you can push data into the table.
Read up on sequences, because serial fields are based on sequences, thus avoiding the locking issue.
Hope this helps...
MikeA
-Original Message-----
From: DaVinci [mailto:[EMAIL PROTECTED]]
S
EMAIL PROTECTED]> writes:
> > On Mon, Feb 12, 2001 at 01:08:01PM -, Michael Ansley wrote:
> >> Typically, the insert for a person, and for all the associated addresses
> >> would be done in the same transaction so that if the insert for one of the
> >> addresse
: 13 February 2001 10:42
To: Lista PostgreSql
Subject: Re: [GENERAL] transaction safety
On Tue, Feb 13, 2001 at 09:56:18AM -, Michael Ansley wrote:
> Hi,
>
> Well, the number is 'locked', because once it's given to you, that's it,
> it's gone from the &
Title: RE: [GENERAL] using tables as types in other tables
I went over this ground about six months ago, and the bottom line is: until somebody picks this up and sorts out the code (which suffers from bitrot) it's not going to work like you described (believe me, I tried). Put the addresses i
Title: RE: [GENERAL] postgres length limitation query
If you're talking about the length of the query string, it should be limited only by the memory available to the processes that handle it. If they run out of memory, it all goes pop! and then releases the used memory, and should carry on w
Title: RE: [GENERAL] INSERT ... RETURNING as Oracle
And using MAX is also horrifically slow once you start having any significant volumes of data.
Why not write a function to add the info, which selects from a sequence, inserts the new row using the sequence number, and then returns the sequ
Title: RE: Re: [GENERAL] OID as Primary Key
And you can get the last SERIAL inserted using currval.
MikeA
>> -Original Message-
>> From: Brent R. Matzelle [mailto:[EMAIL PROTECTED]]
>> Sent: 22 March 2001 16:36
>> To: [EMAIL PROTECTED]
>> Subject: Re: Re: [GENERAL] OID as Primary
Title: RE: [GENERAL] internationalizing text
I think that the standard way to do this is to use a resource identifier, and then have a separate table with all strings. That's the way that most internationalisation is done in programs, and it's probably not bad for databases either.
So maybe:
Hi,
Is anybody aware of any port of the libpq* client libraries to the Win32 platform? If
so, where can I get them, and is the source available (the source would be an added
convenience).
If there is nothing like this available, does anybody want? Are there enough people
out there to warrant
>>> Jackson, DeJuan wrote:
>>> > > Martin Schulze wrote:
>>> > > > . I wonder how one could add or remove columns from existing tables.
>>> > > >
>>> > > > With mSQL this was possible with a trick. You had to dump the
>>> > > > whole table but you could tell the dump prog
Hi,
I'm reasonably new to PG SQL, and managed to get everything up and going without too
many hassles (except for the -i switch - ha, bloody ha), but now I need to get down to
some serious development. What is/are the tool(s) generally used for design work on
PG, and where can I get hold of
Title: RE: [GENERAL] Embedded SQL -- ecpg
You send them through the ecpg pre-compiler first, which replaces all the EXEC SQL statements with C, and then compile. When you compile, make sure that you link to the correct libraries (RTFM).
MikeA
>> -Original Message-
>> From: Nile
Title: RE: [GENERAL] sequences and Transactions
You can't. Sequences are not designed for continuity, they are designed for uniqueness. If you want to have a set of contiguous numbers, in ascending order, then you will probably have to write a trigger to insert the next value, which it has t
tell the order anyway. The order doesn't change,
>> it's only that
>> > there may be numbers missing,
>>
>> Please note the message from "Michael Ansley (UK)". If two of
>> more connections get a cache from a sequence and the i
no Wolff III [mailto:[EMAIL PROTECTED]]
>> Sent: 17 August 2001 13:09
>> To: Michael Ansley (UK)
>> Cc: [EMAIL PROTECTED]
>> Subject: Re: Roll Back dont roll back counters
>>
>>
>> On Fri, Aug 17, 2001 at 11:37:33AM +0100,
>> "Michael Ansley (UK)&q
21 matches
Mail list logo
