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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: 13 May 2008 17:16
To: talk@lists.nyphp.org
Subject: talk Digest, Vol 19, Issue 16
Send talk mailing list submissions to
talk@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
[EMAIL PROTECTED]
You can reach the person managing the list at
[EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
Subject: Re: [nyphp-talk] Off Topic: Postgres user group
To: NYPHP Talk <talk@lists.nyphp.org>
Message-ID: <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
Subject: RE: [nyphp-talk] Off Topic: Postgres user group
To: "'NYPHP Talk'" <talk@lists.nyphp.org>
Cc: [EMAIL PROTECTED]
Message-ID: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
Subject: [nyphp-talk] Schema Validation
To: NYPHP Talk <talk@lists.nyphp.org>
Message-ID: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
Subject: Re: [nyphp-talk] Schema Validation [Solved]
To: NYPHP Talk <talk@lists.nyphp.org>
Message-ID: <[EMAIL PROTECTED]>
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@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
_______________________________________________
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
