I have the release list, but I have to rearrange it into categories. I
am heading to bed, but will return in 12 hours, and run pgindent then.
Sorry.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a ha
Rod Taylor wrote about using views for identity cols, thus:
t=# create schema jboss
t-# create view test as select * from data.test;
CREATE SCHEMA
t=#
t=# create rule test_id_generate as on insert to jboss.test
t-# do instead
t-# insert into data.test (id, word) values (default, new.word);
OK, I read further and now understand. Sorry.
andrew
- Original Message -
From: "Andrew Dunstan" <[EMAIL PROTECTED]>
To: "PostgreSQL Development" <[EMAIL PROTECTED]>
Sent: Saturday, August 02, 2003 10:09 PM
Subject: Re: [HACKERS] AUTO_INCREMENT patch
>
> Rod Taylor wrote about using vi
> des=# create table test ( id serial, word text );
> NOTICE: CREATE TABLE will create implicit sequence "test_id_seq" for SERIAL column
> "test.id"
> CREATE TABLE
> des=# create rule test_id_generate as
> des-# on insert to test do instead
> des-# insert into test ( id, word ) values ( default,
Rod Taylor <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE RULE rulename AS ON INSERT
> TO tablename
> DO INSTEAD
>INSERT INTO tablename
> ( id, col1, ...)
> VALUES ( DEFAULT, NEW.col1, ...);
>
I now have a patch that adds support for the GENERATED ... AS ...
syntax and
Hello:
Thanks very much i will try it and comment the results here :)
This is was i'm finally using for retirve column information:
SELECT pg_namespace.nspname AS TABLE_SCHEMA,
pg_class.relname AS TABLE_NAME,
pg_attribute.attname AS COLUMN_NAME,
pg_attribute.atttypid AS DATA_TYPE,
pg_attribute.at
I just noticed that "log_connections = true"
doesn't cause disconnections to be logged, which is kinda strange to my way of
thinking. Should it? Could it?
cheers
andrew
Hello:
In SERIAL columns the sequence depends on the column, so the association
can be gathered from pg_depend.
Check for a relation between a sequence and column of a table where the
deptype = 'i'. (Taken from pg_dump)
Thanks very much i will try it and comment the results here :)
--
Best re
On Sat, 2003-08-02 at 17:19, Carlos Guzman Alvarez wrote:
> Hello:
>
> I continue to be working in my .NET Data provider for postgres 7.4, i
> want to know if there are a simple way for identify autoincrement
> fields, i see that for serial and big serial fields the default value is
> 'nextval(
The following lines are from readme file present in the
\src\backend\storage\lmgr folder of postgresql
"If we are setting a table level lock
Both the blockId and tupleId (in an item pointer this is called
the position) are set to invalid, if it is a page level lock the
blockId is valid, while the
So far I have a regression check run that generates
a postmaster log that looks like this:
LOG: database system was shut down at
2003-08-02 16:39:48 EDTLOG: checkpoint record is at
0/9A0530LOG: redo record is at 0/9A0530; undo record is at 0/0;
shutdown TRUELOG: next transaction id: 53
Hello:
I continue to be working in my .NET Data provider for postgres 7.4, i
want to know if there are a simple way for identify autoincrement
fields, i see that for serial and big serial fields the default value is
'nextval(...)' this can be a way for know it but i want to know if there
are a
Rod Taylor <[EMAIL PROTECTED]> writes:
> Yeah.. JBoss is very annoying in this regard. A temporary solution seems
> to be to use BEFORE triggers to force the sequence to be used for the
> default value. You could also do this with an INSTEAD rule (something
> like the below):
>
> CREATE OR REPLACE
Moving to -hackers
> I'm working on getting auto-incrementing CMP fields in JBoss 3.2.1 to
> work with PostgreSQL data sources. There are currently two obstacles
> to this.
Yeah.. JBoss is very annoying in this regard. A temporary solution seems
to be to use BEFORE triggers to force the sequence
I am going to run pgindent in 8 hours, in preparation for 7.4 beta.
I am completing the list of release changes and should be done in 8-12
hours.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard d
OK, can I see the new patches? I want to make sure everything is OK.
Thanks.
---
Marcus B?rger wrote:
> Hello Bruce,
>
> Thursday, July 31, 2003, 6:11:04 AM, you wrote:
>
>
> BM> Are you all done with the PHP persistent
Hello Bruce,
Thursday, July 31, 2003, 6:11:04 AM, you wrote:
BM> Are you all done with the PHP persistent connection changes? Need any
BM> help?
I think it's fine now (in PHP 5). We'll see how feedback is during the next
weeks.
Best regards,
Marcusmailto:[EMAIL P
17 matches
Mail list logo
