On Tue, Aug 16, 2005 at 17:09:04 -0400,
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Greetings.
>
> INSERT INTO
>orderstemp (customerid,datecreated)
> VALUES
>('5443','8/16/2005 12:00PM')
>
> The table orderstemp has a unique identifier field, orderid (of type
> SERIAL).
>
> How c
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Chris Hoover <[EMAIL PROTECTED]> wrote:
>> I can get it to create on if I create a special function that just
>> takes the field to be converted and returns the converted date.
> That is what you have to do in older versions of postgres. You don't hav
On Tue, 2005-08-16 at 16:07 -0700, Andrew Gold wrote:
> Obviously, I can write a script to iterate through all the tables, but
> what exactly does "GRANT ALL PRIVILEGES ON DATABASE XXX" do if it
> doesn't even grant basic access?
See the man page for GRANT.
It gives the right to create schemas
Hi everyone,
I'm sure there's an easy answer for this question, but I confess the
situation puzzles me.
I have database "example1."
I have example1 owner user "user1."
user1 is not a super user.
I have superuser "su1."
su1 creates table "lookatme" in example1. su1 now realizes that he wants
Hi everyone,
I'm sure there's an easy answer for this question, but I confess the
situation puzzles me.
I have database "example1."
I have example1 owner user "user1."
user1 is not a super user.
I have superuser "su1."
su1 creates table "lookatme" in example1. su1 now realizes that he wants
t
"Buorn, Yoway" <[EMAIL PROTECTED]> writes:
> No, I'm not trying to back-port a dump. I simply followed the
> instructions in the section 2.3.4 of the gforge manual which tells me to
> go into the db/ folder and apply the schema changes in order for all sql
> files dated after the existing installa
You got the suggestion using currval already so here's one alternative.
SELECT NEXTVAL('"orderid_sequence_name"');
Assume this value is $val then do
INSERT INTO orderstemp(orderid,...) VALUES ($val, ...);
I'm not sure if this is generally used, but this works and sometimes thi
Chris Hoover <[EMAIL PROTECTED]> writes:
> If I try to do an insert into the mytable_view, everything is happy.
> If i try to do an update or delete, I get the error:ERROR: record
> type has not been registered
> CONTEXT: PL/pgSQL function "mytable_view_update" while storing call
> arguments into
[EMAIL PROTECTED] wrote:
Greetings.
INSERT INTO
orderstemp (customerid,datecreated)
VALUES
('5443','8/16/2005 12:00PM')
The table orderstemp has a unique identifier field, orderid (of type
SERIAL).
How can I obtain the orderid of the record inserted in the INSERT INTO
statement in pos
Check out http://www.postgresql.org/docs/8.0/interactive/functions-sequence.html
You'll want to use something like "SELECT currval('')". The
thing
is, your orderid field in orderstemp has a sequence which it uses to grab the
next value. The currval function called with the name of the sequence as
Greetings, all!
As described in
http://www.postgresql.org/docs/8.0/interactive/datatype.html#DATATYPE-SERIAL,
column "type" SERIAL is really an integer type with an implicit
sequence associated by default with that column. In order to get the
last generated value from the sequence, use the "currv
On Tue, Aug 16, 2005 at 16:24:37 -0400,
Chris Hoover <[EMAIL PROTECTED]> wrote:
> I'm running 7.3.4 and we are having problems with our reporting views
> on our database. One fix I wanted to do was to create a functional
> index using the to_date function. However, when I do a create index
> ab
Greetings.
INSERT INTO
orderstemp (customerid,datecreated)
VALUES
('5443','8/16/2005 12:00PM')
The table orderstemp has a unique identifier field, orderid (of type
SERIAL).
How can I obtain the orderid of the record inserted in the INSERT INTO
statement in postgresql?
MSSQL does it l
I'm running 7.3.4 and we are having problems with our reporting views
on our database. One fix I wanted to do was to create a functional
index using the to_date function. However, when I do a create index
abc on table def(to_date(char_field,'mmdd')), PostgreSQL complains
about a parser error
Ok, I was able to log the postgres.log and I found the entire query.
I am very sorry for causing this confusion. The way the query was
being submitted made it look like it was being cut off, and our daily
log files are multi-gig so mining them is quite a pain. (Also, I was
quite under the weather
On Tue, Aug 16, 2005 at 08:55:30AM -0700, Buorn, Yoway wrote:
> No, I'm not trying to back-port a dump. I simply followed the
> instructions in the section 2.3.4 of the gforge manual which tells me to
> go into the db/ folder and apply the schema changes in order for all sql
> files dated after th
I would like to know whether I could use two server for DBmirroring ,the master
is 64 bit mechine with 64 bit linux X86-64 + postgresql 7.4.7 X86_64 and the
other is slave and is the 32 bit mechine + Linux i386 + postgresql 7.4 i386 .
Could these be run with DBmirror database replication ?
No, I'm not trying to back-port a dump. I simply followed the
instructions in the section 2.3.4 of the gforge manual which tells me to
go into the db/ folder and apply the schema changes in order for all sql
files dated after the existing installation. So I started with
20050312.sql and it gave m
I want erase from mail list of
postgress
Bey
Restelli Fabio
IMPORTANTE: il contenuto di questa e-mail e degli eventuali allegati, e`
strettamente confidenziale e destinato alla/e persona/e a cui e` indirizzato.
Se avete ricevuto per errore questa e-mail, Vi preghiamo di segnalarcelo
i create table a with trigger on table a
can i inherit table a with trigger on table b?
(in testing on table b have column as table a but trigger not fire as table
a)
_
Express yourself instantly with MSN Messenger! Download today
20 matches
Mail list logo
