Kaloyan Iliev ha scritto:
> Hi,
>
> I am not familiar with doxygen, so I can't give you any advice. To me
> postgresql_autodoc -d works perfectly.
> I am useing version 1.25 of postgresql_autodoc.
>
> I recevice documentation of the sotred rocedures when I have comments on
> them. Then when
>
On Apr 9, 2006, at 13:33 , Haris Peco wrote:
create index test.test_name on test.test(name)
schema prefix in 'create index'
I know that it isn't necessary, because postgreSQL know that index
is (must be)
in table's schema, but this is natural for sql writers
Allowing a schema-qualifie
I have a varchar field in a table which contains dates in -mm-dd format.
The problem is that some have entered invalid dates like 1975-01-00 and I
want to convert it to a date field to avoid this nonsense. Is there a way to
test for failure of a type conversion and insert a NULL on failure
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > The courts are pretty likely to strongly consider the copyright holder's
> > opinion of the license when deciding how to interpret it.
>
> It's worth pointing out here that
>
> 1. Debian is not the copyright hol
Michael,
Thank you for answer, but you don't understand me
I understood syntax and reason for this, but why postgreSQL doesn't accept this
:
create index test.test_name on test.test(name)
schema prefix in 'create index'
I know that it isn't necessary, because postgreSQL know that index is
Stephen Frost <[EMAIL PROTECTED]> writes:
> The courts are pretty likely to strongly consider the copyright holder's
> opinion of the license when deciding how to interpret it.
It's worth pointing out here that
1. Debian is not the copyright holder.
2. The copyright holders, in this case the aut
Josh,
On 4/8/06 10:59 AM, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> Thanks everyone for helping us make the PostgreSQL booth the best OSS
> booth in the pavilion.
Thanks for hosting - Frank and Ayush had a great time and also said there
was terrific interest there.
It's an exciting time fo
On Apr 9, 2006, at 12:56 , Haris Peco wrote:
'drop index' request schema prefix, but 'create index' doesn't
accept schema prefix
Currently indexes must be in the same schema as the table they index,
so no schema is accepted for CREATE INDEX. Indeed, the documentation
for CREATE INDEX des
* Chris Travers ([EMAIL PROTECTED]) wrote:
> >It says, in no
> >uncertain terms, that GPL programs must come with complete source of
> >themselves and all dependancies under terms compatible with the GPL.
> >The advertising clause in OpenSSL is not acceptable.
> >
> >
> No it doesn't. Otherwise y
Hello,
I have tried create/drop index in separate schema :
example :
create table :
create table test.test(id integer not null,name varchar(30),constraint
test_pkey primary key (id)) - ok
create index test_name on test.test(name) - ok
drop index test_name - not ok
drop index
Nick Wiltshire wrote:
> Hi all,
>
> I have a varchar field in a table which contains dates in -mm-dd
> format. The problem is that some have entered invalid dates like
> 1975-01-00 and I want to convert it to a date field to avoid this
> nonsense. Is there a way to test for failure of a type c
As someone who licenses a lot of my code under the GPL, I feel inclined
to correct you. Please note that IANAL.
Martijn van Oosterhout wrote:
On Fri, Apr 07, 2006 at 04:16:18PM -0700, Chris Travers wrote:
By this interpretation, coding a connector against UNIX ODBC would be
OK, but the us
Hi,
On Sun, 2006-04-09 at 05:30 +0700, [EMAIL PROTECTED] wrote:
> I try to set FC3 X64 and postgresql 64 8.1 in my new server but I cannot
> connect it with pgadminIII. My pg_hba.conf is like below:
>
> # "local" is for Unix domain socket connections only
> local all all
Hi all,
I have a varchar field in a table which contains dates in -mm-dd format.
The problem is that some have entered invalid dates like 1975-01-00 and I
want to convert it to a date field to avoid this nonsense. Is there a way to
test for failure of a type conversion and insert a NULL on
I try to set FC3 X64 and postgresql 64 8.1 in my new server but I cannot
connect it with pgadminIII. My pg_hba.conf is like below:
# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
hostall
I have multi company database where each company is stored in different
schema.
When I create incrementally new companis and add data to it ANALYZE command
takes a lot of time: every time it analyzes the previous company data also.
How to run ANALYZE command for a single schema ?
Andrus.
PostgreSqlClient ( old PgSqlClient ) 2.0 Beta 1 is available for download.
It's the first version for ADO.NET 2.0 and Microsoft .NET 2.0, be aware
that right now it doesn't provide integration with Visual Studio 2005.
Download information can be found:
http://sourceforge.net/project/showfiles
Tom Lane <[EMAIL PROTECTED]> writes:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> >> Or are they selectively enforcing this
> >> policy against PG?
>
> > It's enforced whenever we discover it, really...
>
> I am strongly tempted to pull Debian's chain by pointing out that
> libjpeg has an adver
Josh,
> Thanks everyone for helping us make the PostgreSQL booth the best OSS
> booth in the pavilion.
Thank you for organizing it!
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 3: Have you checked our extensi
Hello,
As most of you probably know, we (PostgreSQL) were at LinuxWorld Boston
this past week. The show although small, was very positive. We received
alot of traffic and very specific pointed questions.
This is the first show that I have been to where people were actually
using PostgreSQL fo
Bit Byter wrote:
I just did a file based database backup (stopped postmaster and
zipped/copied all files under /usr/local/pgsql/data/* to a differnt
location)
How can I 'restore' the database and start using it?
Assuming you are using linux/unix you can use pg_ctl (read the docs) to
start the
# [EMAIL PROTECTED] / 2006-04-08 14:04:28 +0200:
> Am 07.04.2006 um 13:50 schrieb User Roman:
> ># [EMAIL PROTECTED] / 2006-03-31 10:05:06 +0200:
> >>I would like to know if somebody already has a Mac OSX Intel 10.4.5
> >>pg-Library (for C, C++, Objective C) or knows how to compile it?
> >
> >W
> -Original Message-
> From: lmyho [mailto:[EMAIL PROTECTED]
> Sent: 07 April 2006 22:31
> To: Dave Page; pgsql-general@postgresql.org
> Subject: RE: [GENERAL] pgAdmin3 question
>
>
> --- Dave Page wrote:
>
> > > We have test database created in the initdb cluster, but
> on the Add
On Sat, Apr 08, 2006 at 08:02:04PM +0530, surabhi.ahuja wrote:
>
> the scenario in which the above took place was somewhat like this
> we have a script to stop some of the processes running in the background.
>
> this script was run, and all the processes got stopped
>
> then another script will
# [EMAIL PROTECTED] / 2006-04-07 14:31:04 -0700:
> A further question: we are using Debian system. So when we leave the
> 'Address' box
> blank (on the Add Server page of pgAdmin), according to the help file, it
> will go to
> use the default Postgresql socket on the local machine.
> We actual
Bit Byter wrote:
I just did a file based database backup (stopped postmaster and
zipped/copied all files under /usr/local/pgsql/data/* to a differnt
location)
How can I 'restore' the database and start using it?
---(end of broadcast)---
TIP 3: Ha
Title: RE: [GENERAL] postmaster going down own its on
the scenario in which the above took place was somewhat like this
we have a script to stop some of the processes running in the background.
this script was run, and all the processes got stopped
then another script will start these pro
Hi,
I am not familiar with doxygen, so I can't give you any advice. To me
postgresql_autodoc -d works perfectly.
I am useing version 1.25 of postgresql_autodoc.
I recevice documentation of the sotred rocedures when I have comments on them. Then when
postgresql_autodoc generate HTML documen
I just did a file based database backup (stopped postmaster and
zipped/copied all files under /usr/local/pgsql/data/* to a differnt
location)
How can I 'restore' the database and start using it?
---(end of broadcast)---
TIP 3: Have you checked our
Hi,
I'm asking here in case this kind of thing has been done before, but
I've not been able to find it..
We have two pg 8.1.3 servers, one live and one test. What I'd like to do
is have something like pgpool to act as a connection broker, but
instead of using pgpool's own replication where all qu
Hello!
Am 07.04.2006 um 13:50 schrieb User Roman:
# [EMAIL PROTECTED] / 2006-03-31 10:05:06 +0200:
I would like to know if somebody already has a Mac OSX Intel 10.4.5
pg-Library (for C, C++, Objective C) or knows how to compile it?
What problems did you have building libpq?
Note: I
On Fri, Apr 07, 2006 at 04:16:18PM -0700, Chris Travers wrote:
> By this interpretation, coding a connector against UNIX ODBC would be
> OK, but the user would be forbidden to use ODBC drivers that link
> against OpenSSL. I cannot therefore imagine a circumstance where the
> parent GPL applicat
32 matches
Mail list logo
