[nycphp-talk] Installing postgresql on windows xp
Jonathan Wagener
jonathanw at amoeba.co.za
Tue May 13 11:23:53 EDT 2008
Hi guys, how would I be able to install postgresql on my pc - im running windows xp pro (also running wampserver).
Jonathan Wagener
Web Developer / Architect
Amoeba Business Solutions
Cell: +27 72 928 0513
Office: +27 21 785 1424
Web: www.amoeba.co.za
Blog: www.espresso-online.info
-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On Behalf Of talk-request at lists.nyphp.org
Sent: 13 May 2008 17:16
To: talk at lists.nyphp.org
Subject: talk Digest, Vol 19, Issue 16
Send talk mailing list submissions to
talk at lists.nyphp.org
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.nyphp.org/mailman/listinfo/talk
or, via email, send a message with subject or body 'help' to
talk-request at lists.nyphp.org
You can reach the person managing the list at
talk-owner at lists.nyphp.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of talk digest..."
Today's Topics:
1. Re: Off Topic: Postgres user group (anthony wlodarski)
2. RE: Off Topic: Postgres user group (Hans Zaunere)
3. Schema Validation (Ben Sgro)
4. Re: Schema Validation [Solved] (Ben Sgro)
----------------------------------------------------------------------
Message: 1
Date: Mon, 12 May 2008 14:36:36 -0400
From: anthony wlodarski <anthony at thrillist.com>
Subject: Re: [nycphp-talk] Off Topic: Postgres user group
To: NYPHP Talk <talk at lists.nyphp.org>
Message-ID: <9DC4F53A-D0AB-4707-9533-5F4ABC3649CA at thrillist.com>
Content-Type: text/plain; charset="us-ascii"
We have decided to use PgSQL as our main database for our Drupal environment. This group might be of use to me and others on here. I haven't done any research to see what NYC PgSQL groups there are but I would cross reference your search with meetup.com.
-Anthony
On May 10, 2008, at 12:26 AM, Justin Dearing wrote:
> Hello,
>
> My name is Justin Dearing and I am new to this list.
>
> I was told that there was some interest in forming a NYC Postgresql
> group. That would be something I would be interested in participating
> in. If there is a more appropriate forum for discussing this feel free
> to contact me either on or off list.
>
> Regards,
>
> Justin Dearing
> http://www.ohloh.net/accounts/1193
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
Anthony Wlodarski
PHP/MySQL Developer
www.thrillist.com
560 Broadway, Suite 308
New York, NY 10012
p 646.274.2435
f 646.557.0803
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.lists.nyphp.org/pipermail/talk/attachments/20080512/68fdea36/attachment-0001.html
------------------------------
Message: 2
Date: Mon, 12 May 2008 19:13:40 -0400
From: "Hans Zaunere" <lists at zaunere.com>
Subject: RE: [nycphp-talk] Off Topic: Postgres user group
To: "'NYPHP Talk'" <talk at lists.nyphp.org>
Cc: pgsql at lists.nyphp.org
Message-ID: <003201c8b485$d2930680$77b91380$@com>
Content-Type: text/plain; charset="iso-8859-1"
> My name is Justin Dearing and I am new to this list.
Hi Justin.
> I was told that there was some interest in forming a NYC Postgresql
> group. That would be something I would be interested in participating
> in. If there is a more appropriate forum for discussing this feel free
> to contact me either on or off list.
I've created a mailing list for PostgreSQL. We've got one for MySQL, so it actually only seems fair :)
http://lists.nyphp.org/mailman/listinfo/pgsql
If anyone spots any issues, please let me know.
As for meetings, I could help setup some space, however I wouldn't have time to organize it. If anyone is interested, though, step up to the plate.
This is how our other SIGs, like Joomla!, has really taken off.
---
Hans Zaunere / President / New York PHP
www.nyphp.org / www.nyphp.com
>
> Regards,
>
> Justin Dearing
> http://www.ohloh.net/accounts/1193
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
------------------------------
Message: 3
Date: Tue, 13 May 2008 10:38:53 -0400
From: Ben Sgro <ben at projectskyline.com>
Subject: [nycphp-talk] Schema Validation
To: NYPHP Talk <talk at lists.nyphp.org>
Message-ID: <4829A7FD.4020207 at projectskyline.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello,
I'm having a lot of trouble getting the dom object schema validation to work. After looking on google, it seems there isn't a straight forward way to handle complex schemas.
Take the following code:
if (is_file($schemaFile))
{
$domObj->load($requestXml);
if (!$domObj->schemaValidate($schemaFile))
{
load() is throwing a warning:
<b>Warning</b>: DOMDocument::load() [<a
href='function.DOMDocument-load'>function.DOMDocument-load</a>]: I/O warning : failed to load external entity
And so is the call to schemaValidate()
<b>Warning</b>: DOMDocument::schemaValidate() [<a
href='function.DOMDocument-schemaValidate'>function.DOMDocument-schemaValidate</a>]:
The document has no document element.
My XML struct:
<Template archived="0" id="2" label="Millenium PredictR Template"
version="1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Meta />
<Phases>
<Phase state="development" />
<Phase state="testing" />
<Phase state="published">
<SubjectTypes>
<SubjectTypeRef idref="MilleniumProperty" />
</SubjectTypes>
<DataPointGroups>
<DataPointGroup dataSourceMappingRef="1" label="Millenium">
<DataPoint name="prepredictr" />
</DataPointGroup>
</DataPointGroups>
<Output>
<Transformation enabled="true"
filename="PredictR_result_to_pxClient" />
</Output>
</Phase>
</Phases>
<History>
<Event dateTime="2008-04-14T10:56:12Z" type="created" user="ramap@" />
</History>
</Template>
My schema struct:
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="Template">
<xs:complexType>
<xs:sequence>
<xs:element name="Meta" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="Meta"
type="SimpleNameValuePairType" minOccurs="0"
maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Phases">
<xs:complexType>
<xs:sequence>
<xs:element name="Phase" minOccurs="3"
maxOccurs="3">
<xs:complexType mixed="true">
<xs:sequence>
<xs:element name="SubjectTypes"
minOccurs="0" maxOccurs="1">
<xs:complexType>
<xs:sequence>
<xs:element name="SubjectTypeRef" minOccurs="1" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="idref" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="DataPointGroups" minOccurs="0" maxOccurs="1">
<xs:complexType>
<xs:sequence>
<xs:element name="DataPointGroup">
<xs:complexType>
<xs:sequence>
<xs:element name="DataPoint">
<xs:complexType>
<xs:sequence>
<xs:element name="Exceptions" minOccurs="0" maxOccurs="1">
<xs:complexType>
<xs:sequence>
<xs:element name="Exception" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="name" type="xs:string" use="required"/>
<xs:attribute name="value" use="required"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="name" use="required"/>
<xs:attribute name="dataSourceMappingRef" use="required"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="label"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Output"
minOccurs="0" maxOccurs="1">
<xs:complexType>
<xs:sequence>
<xs:element name="Transformation"/>
</xs:sequence>
<xs:attribute name="enabled" type="xs:boolean"/>
<xs:attribute name="filename"/>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="state">
<xs:simpleType>
<xs:restriction base="NonEmptyString">
<xs:pattern value="development|testing|published"></xs:pattern>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="version"
use="optional" type="xs:integer"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<!-- <xs:element name="History" minOccurs="0" maxOccurs="1">
<xs:complexType>
<xs:sequence>
<xs:element name="Event" minOccurs="0"
maxOccurs="unbounded"/>
</xs:sequence>
<xs:attribute name="type"/>
<xs:attribute name="user"/>
<xs:attribute name="dateTime"/>
</xs:complexType>
</xs:element> -->
<xs:element name="History">
<xs:complexType>
<xs:sequence minOccurs="0" maxOccurs="unbounded">
<xs:element name="Event">
<xs:complexType mixed="true">
<xs:attribute name="type"/>
<xs:attribute name="user"/>
<xs:attribute name="dateTime"/>
<xs:anyAttribute namespace="##any"
processContents="lax"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="id" type="xs:integer"/>
<xs:attribute name="label" type="xs:string"/>
<xs:attribute name="version" type="xs:integer"/>
<xs:attribute name="archived" type="xs:integer"/>
</xs:complexType>
</xs:element>
<xs:complexType name="SimpleNameValuePairType">
<xs:sequence>
<xs:element name="Meta" type="SimpleNameValuePairType"
minOccurs="0"
maxOccurs="unbounded"/>
</xs:sequence>
<xs:attribute name="name" use="required">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
<xs:whiteSpace value="collapse"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
<xs:attribute name="value" type="xs:anySimpleType"/>
</xs:complexType>
<xs:simpleType name="NonEmptyString">
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:schema>
- Ben
------------------------------
Message: 4
Date: Tue, 13 May 2008 11:04:05 -0400
From: Ben Sgro <ben at projectskyline.com>
Subject: Re: [nycphp-talk] Schema Validation [Solved]
To: NYPHP Talk <talk at lists.nyphp.org>
Message-ID: <4829ADE5.3010908 at projectskyline.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello,
The first problem is that the .xsd was not up to date.
The second is that you cannot call load() on an xml string, you have to call loadXML().
load() is for a file.
- Ben
Ben Sgro wrote:
> Hello,
>
> I'm having a lot of trouble getting the dom object schema validation
> to work. After looking on google, it seems there isn't a straight
> forward way to handle complex schemas.
>
> Take the following code:
>
> if (is_file($schemaFile))
> {
> $domObj->load($requestXml);
> if (!$domObj->schemaValidate($schemaFile))
> {
>
>
> load() is throwing a warning:
> <b>Warning</b>: DOMDocument::load() [<a
> href='function.DOMDocument-load'>function.DOMDocument-load</a>]: I/O
> warning : failed to load external entity
>
> And so is the call to schemaValidate()
> <b>Warning</b>: DOMDocument::schemaValidate() [<a
> href='function.DOMDocument-schemaValidate'>function.DOMDocument-schemaValidate</a>]:
> The document has no document element.
>
> My XML struct:
>
> <Template archived="0" id="2" label="Millenium PredictR Template"
> version="1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> <Meta />
> <Phases>
> <Phase state="development" />
> <Phase state="testing" />
> <Phase state="published">
> <SubjectTypes>
> <SubjectTypeRef idref="MilleniumProperty" />
> </SubjectTypes>
> <DataPointGroups>
> <DataPointGroup dataSourceMappingRef="1" label="Millenium">
> <DataPoint name="prepredictr" />
> </DataPointGroup>
> </DataPointGroups>
> <Output>
> <Transformation enabled="true"
> filename="PredictR_result_to_pxClient" />
> </Output>
> </Phase>
> </Phases>
> <History>
> <Event dateTime="2008-04-14T10:56:12Z" type="created" user="ramap@"
> /> </History> </Template>
>
> My schema struct:
>
> <?xml version="1.0" encoding="UTF-8"?> <xs:schema
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> <xs:element name="Template">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="Meta" minOccurs="0">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="Meta"
> type="SimpleNameValuePairType" minOccurs="0"
> maxOccurs="unbounded"/>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
>
> <xs:element name="Phases">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="Phase" minOccurs="3"
> maxOccurs="3">
> <xs:complexType mixed="true">
> <xs:sequence>
> <xs:element name="SubjectTypes"
> minOccurs="0" maxOccurs="1">
> <xs:complexType>
> <xs:sequence>
> <xs:element
> name="SubjectTypeRef" minOccurs="1" maxOccurs="unbounded">
>
> <xs:complexType>
>
> <xs:attribute name="idref" type="xs:string" use="required"/>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
>
> <xs:element
> name="DataPointGroups" minOccurs="0" maxOccurs="1">
> <xs:complexType>
> <xs:sequence>
> <xs:element
> name="DataPointGroup">
> <xs:complexType>
>
> <xs:sequence>
>
> <xs:element name="DataPoint">
>
> <xs:complexType>
>
> <xs:sequence>
>
> <xs:element name="Exceptions" minOccurs="0" maxOccurs="1">
>
> <xs:complexType>
>
> <xs:sequence>
>
> <xs:element name="Exception" minOccurs="0" maxOccurs="unbounded">
>
> <xs:complexType>
>
> <xs:attribute name="name" type="xs:string" use="required"/>
>
> <xs:attribute name="value" use="required"/>
>
> </xs:complexType>
>
> </xs:element>
>
> </xs:sequence>
>
> </xs:complexType>
>
> </xs:element>
>
> </xs:sequence>
>
> <xs:attribute name="name" use="required"/>
>
> <xs:attribute name="dataSourceMappingRef" use="required"/>
>
> </xs:complexType>
>
> </xs:element>
>
> </xs:sequence>
>
> <xs:attribute name="label"/>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
>
> <xs:element name="Output"
> minOccurs="0" maxOccurs="1">
> <xs:complexType>
> <xs:sequence>
> <xs:element
> name="Transformation"/>
> </xs:sequence>
> <xs:attribute
> name="enabled" type="xs:boolean"/>
> <xs:attribute
> name="filename"/>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> <xs:attribute name="state">
> <xs:simpleType>
> <xs:restriction
> base="NonEmptyString">
> <xs:pattern
> value="development|testing|published"></xs:pattern>
> </xs:restriction>
> </xs:simpleType>
> </xs:attribute>
> <xs:attribute name="version"
> use="optional" type="xs:integer"/>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <!-- <xs:element name="History"
> minOccurs="0" maxOccurs="1">
> <xs:complexType>
> <xs:sequence>
> <xs:element
> name="Event" minOccurs="0" maxOccurs="unbounded"/>
> </xs:sequence>
> <xs:attribute name="type"/>
> <xs:attribute name="user"/>
> <xs:attribute name="dateTime"/>
> </xs:complexType>
> </xs:element> -->
> <xs:element name="History">
> <xs:complexType>
> <xs:sequence minOccurs="0" maxOccurs="unbounded">
> <xs:element name="Event">
> <xs:complexType mixed="true">
> <xs:attribute name="type"/>
> <xs:attribute name="user"/>
> <xs:attribute name="dateTime"/>
> <xs:anyAttribute namespace="##any"
> processContents="lax"/>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> <xs:attribute name="id" type="xs:integer"/>
> <xs:attribute name="label" type="xs:string"/>
> <xs:attribute name="version" type="xs:integer"/>
> <xs:attribute name="archived" type="xs:integer"/>
> </xs:complexType>
> </xs:element>
>
>
> <xs:complexType name="SimpleNameValuePairType">
> <xs:sequence>
> <xs:element name="Meta" type="SimpleNameValuePairType"
> minOccurs="0"
> maxOccurs="unbounded"/>
> </xs:sequence>
> <xs:attribute name="name" use="required">
> <xs:simpleType>
> <xs:restriction base="xs:string">
> <xs:minLength value="1"/>
> <xs:whiteSpace value="collapse"/>
> </xs:restriction>
> </xs:simpleType>
> </xs:attribute>
> <xs:attribute name="value" type="xs:anySimpleType"/>
> </xs:complexType>
> <xs:simpleType name="NonEmptyString">
> <xs:restriction base="xs:string">
> <xs:minLength value="1"/>
> </xs:restriction>
> </xs:simpleType>
> </xs:schema>
>
>
> - Ben
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
------------------------------
_______________________________________________
talk mailing list
talk at lists.nyphp.org
http://lists.nyphp.org/mailman/listinfo/talk
End of talk Digest, Vol 19, Issue 16
************************************
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.16/1430 - Release Date: 13/05/2008 07:31
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.16/1430 - Release Date: 13/05/2008 07:31
More information about the talk
mailing list