> > You need to enable locale support. MB support does nothing with the
> > sort order.
>
> I guess You mean:
>
> ./configure --enable-locale
> export LANG=pl_PL
> run postmaster
Yes.
> and now should I
>
> initdb
>
> or just simply browse the database as usual
For history, see the first chapter of my book. Also see appendix on
non-standard feature.
http://www.postgresql.org/docs/awbook.html
> Hi,
>
> I'd like an information about the history of SQL.
> The similarities and differences between SQL1 and SQL2 and SQL3.
>
> Could you help me?
>
> Than
On Thu, 23 Aug 2001, Jaydip wrote:
> a) How do I retrieve the Year,Month,Day,Hr,Minute or Second value from a
>Date/DateTime variable.
>
> For Example : i> In Oracle to_char(dt,'') - for extracting the year value
>from a date variable dt
> ii> In SqlServer datepart(hh,
a) Look at "Date/Time Functions" in the docs:
specifically, listed under "Functions and Operators" in the Users
Guide.
b) "Serial" type will do this. Look under
"Numeric Types" , in the "Data Types" section of the Users Guide.
- Original Message -
From:
Jaydip
To: [EMAIL
On 28 Aug 2001, satish rao wrote:
> Entered below is the SQL create table syntax:
>
> CREATE TABLE lists (
> [listid] [int] IDENTITY (1, 1) NOT NULL ,
> [listname] [varchar] (200) NULL ,
> [listcreator] [varchar] (200) NULL ,
> [listdesc] [text] NULL)
create table lists
Ligia Pimentel wrote:
>
> Hello!
>
> I want to read about what I can do with ECPG, but I have just found a couple
> of examples with SELECT statements. Is there a complete documentation of
> this? Can you help me find it?
A complete documentation of what: ecpg or SQL ?
Actually you find everyth
satish rao wrote:
>
> Hi
>
> Entered below is the SQL create table syntax:
>
> CREATE TABLE lists (
> [listid] [int] IDENTITY (1, 1) NOT NULL ,
> [listname] [varchar] (200) NULL ,
> [listcreator] [varchar] (200) NULL ,
> [listdesc] [text] NULL)
>
> We need to kn
Jaydip wrote:
> Dear Friends
>
> I am Jaydip Dewanji working as a Sr. Programmer for Ontrack Systems Ltd.
>
> I have some questions regarding Postgresql which are listed below:
>
> a) How do I retrieve the Year,Month,Day,Hr,Minute or Second value from a Da=
> te/DateTime variable.
>
> For
Vladimir,
> I notice that when I execute "select nextval('sequence_name'::text)
> AS
> sname;", via DBI, the value of sequence is updated, but the mod_perl
> returns
> "DBD::Pg::st execute failed: ERROR: sequence_name.nextval: you don't
> have
> permissions to set sequence"
Your issue is eit
Dear Friends
I am Jaydip Dewanji working as a Sr. Programmer for
Ontrack Systems Ltd.
I have some questions regarding Postgresql which
are listed below:
a) How do I retrieve the Year,Month,Day,Hr,Minute
or Second value from a Date/DateTime variable.
For Example : i> In Oracle
to_
I'm trying to install (from source) DBD::Pg v1.01 after having
installed (from source) DBI v1.19 on FreeBSD 4.3 (Release) and I
encounter this error in the 'make test' step:
dell_box# make test
PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
-I/usr/libdata/perl/5.00503/mach -I/usr/libdata/
Hi
Entered below is the SQL create table syntax:
CREATE TABLE lists (
[listid] [int] IDENTITY (1, 1) NOT NULL ,
[listname] [varchar] (200) NULL ,
[listcreator] [varchar] (200) NULL ,
[listdesc] [text] NULL)
We need to know that this syntax will work properly in
user is an SQL reserved word, use 'user' instead.
You might like to have a look at the list of reserved words at
http://www.postgresql.org/idocs/index.php?sql-keywords-appendix.html
Jari Aalto+usenet wrote:
>
> [Please keep CC]
>
> Can anyone suggest, what is wrong with the following
Jason,
First of all, thanks for your response. I had given up that anyone was going
to respond. After seeing your response I went back and found what was making
the difference. The failing syntax below worked on 7.0.3 but not on the
7.1.2 version. Seeing your working example(unlike another respon
I have a problem with apache authentication.
I recently upgrade to postgresql v7.1, upgrading debian distribution
(to woody, testing distribution)
and i discovered that the pakage for apache authentication is
no longer there.
(may be they suggest to use PAM instead of old mod_auth_pgsql?)
This i
Vivek Khera <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> > "jj" == jake johnson <[EMAIL PROTECTED]> writes:
>
> jj> I'm trying to install (from source) DBD::Pg v1.01 after having
> jj> installed (from source) DBI v1.19 on FreeBSD 4.3 (Release) and I
> jj> encounter this
Hello newsgroup buddies,
I am looking for information on trend reporting. We run Linux, PostreSQL,
Apache and PHP4. We have a series of scripts that track customer usage
through our sites, and give us similar information to what is found in the
Apache logs, but with more data.
I now find myself
[Please keep CC]
Can anyone suggest, what is wrong with the following
sql file? SOmehow the semicolon causes error?
Jari
class=# \i pg-def-group-grant.sql
Granting ALL to ROOT
CHANGE
Granting ALL to USER
psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "
Hi,
I'm writing a script, which has to retrieve a next value from a sequnce. I use
mod_perl, DBI and DBD::Pg version 0.98.
I notice that when I execute "select nextval('sequence_name'::text) AS
sname;", via DBI, the value of sequence is updated, but the mod_perl returns
"DBD::Pg::st execute
On Thu, 23 Aug 2001, Murray Hobbs wrote:
> A <- B
> A <- C <- D
>
> i want to maintain integrity so that if A is deleted from then so is
> anything referencing from B and C - no problem ON DELETE CASCADE
>
> but if there are any D's that point back to A (through composite key in
> C) i don't wa
Hi,
I'd like an information about the history of SQL.
The similarities and differences between SQL1 and SQL2 and
SQL3.Could you
help me?
Thanks for your attention.
Marcia Cunha
Belo Horizonte , Brasil.
I have a problem with apache authentication.
I recently upgrade to postgresql v7.1, upgrading debian distribution
(to woody, testing distribution)
and i discovered that the pakage for apache authentication is
no longer there.
(may be they suggest to use PAM instead)
This is really a problem fo
I have a problem with apache authentication.
I recently upgrade to postgresql v7.1, upgrading debian distribution
(to woody, testing distribution)
and i discovered that the pakage for apache authentication is
no longer there.
(may be they suggest to use PAM instead of old mod_auth_pgsql?)
This
Markus Wagner writes:
> we need to control database changes within BEFORE triggers.
> There is no problem with triggers called by update, but there is
> a problem with triggers called by insert.
>
> We strongly need to know the oid of a newly inserted tuple. In this case, we
> use tg_newtuple of
On Wed, Aug 29, 2001 at 11:15:08AM +0200, Markus Wagner wrote:
> Hi,
>
> we need to control database changes within BEFORE triggers.
> There is no problem with triggers called by update, but there is
> a problem with triggers called by insert.
>
> We strongly need to know the oid of a newly inse
25 matches
Mail list logo
