Running postgres-7.0.3 on a RedHat 6.2 system:
Recently I updated the schema of one of our tables (create, insert
select, drop, rename). We have a boolean column "hitsingle" with a default
of 'f'.
media=> \d incantaaudioclipregistry
Table "incantaaudioclipregistry"
Attribute
I built my own binary RPMs with rpm -bb and this spec file. I compiled
and "installed" postgres using the instructions in comments in the %build
section because I haven't bothered to figure out how %build works. This
installation is roughly based on the RedHat 6.0 SPEC file and probably has
a
Hannu Krosing <[EMAIL PROTECTED]> ,in message <[EMAIL PROTECTED]>, wrote:
> Robert Forsman wrote:
> >
> > It doesn't help either when your library has
> > bugs that prevent returning an accurate count of rows affected either.
>
> So does it have s
[EMAIL PROTECTED] ,in message <200106062214.f56ME2E51506@postg
resql.org>, wrote:
> First it's not standard SQL, so chances aren't that good.
> Second, how do you think the system should behave in the
> following case:
>
> * Table A has one trigger BEFORE IN
Eric writes:
>I can realize this function in the SYBase,but How can i do it in the PostgreSQL?
>
> /SQL***/
> if not exists(select id from test) insert into test(id) values (280);
> /*/
I don't know if this is SQL92, but
insert into test(id) select 280 where not exists(select i
I'm running postgres 6.5.3 and 7.0.3 and pg_dump gives me the following
output:
DROP TABLE "genrenametable";
CREATE TABLE "genrenametable" (
"genreid" int4,
"name" character varying(128),
"parentgenre" int4,
"enabled" bool DEFAULT 'f' NOT NULL
);
REVOKE ALL on "
