Version 1.8 of VTD-XML is now released. The new features are:
·XMLModifier is a easy to use class that takes advantage of the
incremental update capability offered by VTD-XML
·XPath built-in functions are now almost complete
·This release added encoding support for iso
On 21.11.2006 15:20 Wm.A.Stafford wrote:
Distinct is the equivalent
aggregate function as many pointed out. A co-worker said that Oracles
'unique' is probably an optimized version of distinct that takes
advantage of some Oracle specific indexing.
I don't think so. They are merely two different
"The large print giveth and the small print taketh away" - Tom Waits
On Tue, Nov 21, 2006 at 10:34:28PM +0100, Magnus Hagander wrote:
> > I intended to read a thread I caught part of in Oct, so I went to the
> > archive: http://archives.postgresql.org/pgsql-general/
> > Seems most of the mon
Richard Huxton a écrit :
Arnaud Lesauvage wrote:
Hi list !
I already posted this as "COPY FROM encoding error", but I have been
doing some more tests since then.
I'm trying to export data from MS SQL Server to PostgreSQL.
The tables are quite big (>20M rows), so a CSV export and a "COPY FROM
Tomi NA a écrit :
I think I'll go this way... No other choice, actually !
The MSSQL database is in SQL_Latin1_General_CP1_Cl_AS.
I don't really understand what this is. It supports the euro
symbol, so it is probably not pure LATIN1, right ?
I suppose you'd have to look at the latin1 codepage ch
2006/11/21, Arnaud Lesauvage <[EMAIL PROTECTED]>:
Hi list !
I already posted this as "COPY FROM encoding error", but I have
been doing some more tests since then.
I'm trying to export data from MS SQL Server to PostgreSQL.
The tables are quite big (>20M rows), so a CSV export and a "COPY
FROM3
Richard Huxton a écrit :
Arnaud Lesauvage wrote:
Richard Huxton a écrit :
Or go via MS-Access/Perl and ODBC/DBI perhaps?
Yes, I think it would work. The problem is that the DB is too big for
this king of export. Using DTS from MSSQL to export directly to
PostgreSQL using psqlODBC Unicode D
Reid Thompson wrote:
> not much info... just a blurb about RH, but with the PG comment thrown
> in..
>
> http://opensource.sys-con.com/read/303017.htm
>
> The city of Vienna is going with Red Hat on its file servers and
Oracle
> database servers, some of which are evidently going to become
Postgr
Hi List !
I am looking for an easy URL decoding function.
I thought about using regexp_replace, but I cna't get it to
work :
SELECT regexp_replace('foo%B5bar', '%(..)', '\x\\1' , 'g');
> 'fooxB5bar'
I wanted to replace %BE with the character \xB5 (µ, I
think), but of course I am doing this w
Arnaud Lesauvage wrote:
> Tomi NA a écrit :
> >>I think I'll go this way... No other choice, actually !
> >>The MSSQL database is in SQL_Latin1_General_CP1_Cl_AS.
> >>I don't really understand what this is. It supports the euro
> >>symbol, so it is probably not pure LATIN1, right ?
> >
> >I suppose
I have searched and Googled but can't find how to do a ./configure to
use a different socket than /tmp/.s.PGSQL.5432. It says in the manual
that it can be done but then does not say how.
Anyone done this before?
Regards
Garry
---(end of broadcast)-
2006/11/22, Arnaud Lesauvage <[EMAIL PROTECTED]>:
Tomi NA a écrit :
> 2006/11/21, Arnaud Lesauvage <[EMAIL PROTECTED]>:
>> Hi list !
>>
>> I already posted this as "COPY FROM encoding error", but I have
>> been doing some more tests since then.
>>
>> I'm trying to export data from MS SQL Server t
Hi!
You can at least configure the socket directory, the socket group and the
socket permissions in your postgresql.conf.
Greetings,
Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> garry saddington
> Sent: Wednesday, November 22, 2006
> > I have done this in Delphi using it's built in UTF8 encoding and
> > decoding routines. You can get a free copy of Delphi
> Turbo Explorer
> > which includes components for MS SQL server and ODBC, so it
> would be
> > pretty straight forward to get this working.
> >
> > The actual meth
> >> I already posted this as "COPY FROM encoding error", but I
> have been
> >> doing some more tests since then.
> >>
> >> I'm trying to export data from MS SQL Server to PostgreSQL.
> >> The tables are quite big (>20M rows), so a CSV export and a "COPY
> >> FROM3 import seems to be the only
Alvaro Herrera a écrit :
Arnaud Lesauvage wrote:
Tomi NA a écrit :
>>I think I'll go this way... No other choice, actually !
>>The MSSQL database is in SQL_Latin1_General_CP1_Cl_AS.
>>I don't really understand what this is. It supports the euro
>>symbol, so it is probably not pure LATIN1, right
Tomi NA a écrit :
2006/11/21, Arnaud Lesauvage <[EMAIL PROTECTED]>:
Hi list !
I already posted this as "COPY FROM encoding error", but I have
been doing some more tests since then.
I'm trying to export data from MS SQL Server to PostgreSQL.
The tables are quite big (>20M rows), so a CSV export
Arnaud Lesauvage wrote:
> Alvaro Herrera a écrit :
> >Arnaud Lesauvage wrote:
> >>Tomi NA a écrit :
> I think I'll go this way... No other choice, actually !
> The MSSQL database is in SQL_Latin1_General_CP1_Cl_AS.
> I don't really understand what this is. It supports the euro
> sym
Arnaud Lesauvage wrote:
Richard Huxton a écrit :
Or go via MS-Access/Perl and ODBC/DBI perhaps?
Yes, I think it would work. The problem is that the DB is too big for
this king of export. Using DTS from MSSQL to export directly to
PostgreSQL using psqlODBC Unicode Driver, I exported ~1000 ro
Hi,
I'm running postgres following version on win2K server (PostgreSQL 8.1.4
on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special))
I am using c# and npgsql 1.0 (same behaviour with 0.7) to call a
function that has 6 input parameters and 4 output parameters.
When I cal
Of course, but it doesn't work !!!
Whatever client encoding I choose in postgresql before COPYing, I get
the 'invalid byte sequence error'.
The farther I can get is exporting to UNICODE and importing as UTF8.
Then COPY only breaks on the euro symbol (otherwise it breaks very
early, I think
Arnaud Lesauvage schrieb:
Hi List !
I am looking for an easy URL decoding function.
I thought about using regexp_replace, but I cna't get it to work :
SELECT regexp_replace('foo%B5bar', '%(..)', '\x\\1' , 'g');
> 'fooxB5bar'
I wanted to replace %BE with the character \xB5 (µ, I think), but of
Magnus Hagander a écrit :
> I have done this in Delphi using it's built in UTF8 encoding and
> decoding routines. You can get a free copy of Delphi
Turbo Explorer
> which includes components for MS SQL server and ODBC, so it
would be
> pretty straight forward to get this working.
>
> The a
Alvaro Herrera a écrit :
Arnaud Lesauvage wrote:
Alvaro Herrera a écrit :
>Arnaud Lesauvage wrote:
>>Tomi NA a écrit :
I think I'll go this way... No other choice, actually !
The MSSQL database is in SQL_Latin1_General_CP1_Cl_AS.
I don't really understand what this is. It supports th
Or go via MS-Access/Perl and ODBC/DBI perhaps?
Yes, I think it would work. The problem is that the DB is too big for
this king of export. Using DTS from MSSQL to export directly to
PostgreSQL using psqlODBC Unicode Driver, I exported ~1000 rows per
second in a 2-columns table with ~20M rows
On 21/11/06, Vic Cekvenich <[EMAIL PROTECTED]> wrote:
Can pgSQL 8.x do descending indexes like mySQL 5.1?
(so 1st column is descending and rest are asscending?)
Can pgSQL 8.x do "physically" sorted table (like a forced index order) so we
don't need order by?
tia,
.V
No and I don't really
garry saddington <[EMAIL PROTECTED]> writes:
> I have searched and Googled but can't find how to do a ./configure to
> use a different socket than /tmp/.s.PGSQL.5432. It says in the manual
> that it can be done but then does not say how.
See DEFAULT_PGSOCKET_DIR in src/include/pg_config_manual.h
Good morning all! I'm a newbie to PGSQL here so thought I would ask my
first question since I joined this list this morning...
Is it possible to run Postgresql and MySQL together on the same machine?
--
Robert Wolfe, Linux and Network Admin
net261.com | http://www.net261.com:85
[EMAIL PROTECTE
Bumping this in hopes that someone can give me a bit of input?
novnov wrote:
>
> I'm working on an application that will eventually need to support various
> currencies. I've never touched this area before, have dealt with dollars
> till now. I'm not sure what the regular practices are re muli
"Gopal" <[EMAIL PROTECTED]> writes:
> I am using c# and npgsql 1.0 (same behaviour with 0.7) to call a
> function that has 6 input parameters and 4 output parameters.
> When I call .ExecuteNonQuery(), I get the following message
> ERROR: 42601: a column definition list is only allowed for functions
> Good morning all! I'm a newbie to PGSQL here so thought I would ask my
> first question since I joined this list this morning...
>
> Is it possible to run Postgresql and MySQL together on the same machine?
Yes, it is even possible to mulitple clusters of postgresql running at the same
time.
Hi Robert!
Sure, why not? Both databases run on different directories, ports, sockets
and so on.
Greetings,
Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Wolfe, Robert
> Sent: Wednesday, November 22, 2006 4:53 PM
> To: pgsql-general@pos
novnov wrote:
> Bumping this in hopes that someone can give me a bit of input?
Wow, nobody replied?...
> novnov wrote:
>> I'm working on an application that will eventually need to support various
>> currencies. I've never touched this area before, have dealt with dollars
>> till now. I'm not sur
Hello everybody,
I am trying to speed up a query on an integer column by defining an
index as follows
> CREATE INDEX idx_main_subject ON pdb.main (lower(main_subject::text)
using varchar_ops);
on column "main_subject".
I had hoped to get speedups for right-fuzzy LIKE-searches, but EXPLAIN
I have found myself somewhat trapped in a project where the software
being used is essentially set in stone, and its limitations are
strangling progress. It is a client-side app written in VB with an
Access backend, and it has no reasonable data migration/synchronization
ability. It was desig
use varchar_pattern_ops operator class, LIKE cannot use varchar_ops for non-C
locales.
Alexander Presber wrote:
Hello everybody,
I am trying to speed up a query on an integer column by defining an
index as follows
> CREATE INDEX idx_main_subject ON pdb.main (lower(main_subject::text)
usin
On Wed, 2006-11-22 at 10:53 -0500, Wolfe, Robert wrote:
> Good morning all! I'm a newbie to PGSQL here so thought I would ask my
> first question since I joined this list this morning...
>
> Is it possible to run Postgresql and MySQL together on the same machine?
>
Yes. You might also want to t
On Wed, 22 Nov 2006, Alexander Presber wrote:
> Hello everybody,
>
> I am trying to speed up a query on an integer column by defining an
> index as follows
>
> > CREATE INDEX idx_main_subject ON pdb.main (lower(main_subject::text)
> using varchar_ops);
>
> on column "main_subject".
>
> I had hope
Arnaud Lesauvage wrote:
> mydb=# SET client_encoding TO LATIN9;
> SET
> mydb=# COPY statistiques.detailrecherche (log_gid,
> champrecherche, valeurrecherche) FROM
> 'E:\\Production\\Temp\\detailrecherche_ansi.csv' CSV;
> ERROR: invalid byte sequence for encoding "LATIN9": 0x00
> HINT: This err
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Wed, 22 Nov 2006, Alexander Presber wrote:
>> CREATE INDEX idx_main_subject ON pdb.main (lower(main_subject::text)
>> using varchar_ops);
> IIRC, unless you're in C locale, you'll want varchar_pattern_ops rather
> than varchar_ops on the index to make
John McCawley wrote:
I have found myself somewhat trapped in a project where the software
being used is essentially set in stone, and its limitations are
strangling progress. It is a client-side app written in VB with an
Access backend, and it has no reasonable data
migration/synchronization
This is probably a really basic question, but how do I trap when
spi_query_exec returns an error in PL/Perl? I would expect to be able
to use the return value to determine an error condition, however I get
the message:
ERROR: error from Perl function: relation "foo" does not exist at line 7.
w
I'm using Postgrseql 7.4.8. In January, I reported a psql bug. The
problem was that an INSERT issued through psql would cause a
crash. There was no problem with other operations I tried, or with the
same INSERT submitted through JDBC. The discussion thread begins here:
http://archives.postgresql.o
I'm not really sure what switching development platforms for the tool
would buy me. Are you saying that the wire-protocol used by vb.net and
C# etc. is substantially faster than what is available in VB? Regarding
ASP.net, I don't really see how a web app would help here, as it has to
run on h
On Wed, Nov 22, 2006 at 11:24:33AM -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > On Wed, 22 Nov 2006, Alexander Presber wrote:
> >> CREATE INDEX idx_main_subject ON pdb.main (lower(main_subject::text)
> >> using varchar_ops);
>
> > IIRC, unless you're
On Wed, Nov 22, 2006 at 11:11:09AM -0500, Jack Orenstein wrote:
> I'm using Postgrseql 7.4.8. In January, I reported a psql bug. The
> problem was that an INSERT issued through psql would cause a
> crash. There was no problem with other operations I tried, or with the
> same INSERT submitted throug
On 11/22/06, John McCawley <[EMAIL PROTECTED]> wrote:
I'm not really sure what switching development platforms for the tool
would buy me. Are you saying that the wire-protocol used by vb.net and
C# etc. is substantially faster than what is available in VB? Regarding
no, the wire protocols are
John McCawley wrote:
I'm not really sure what switching development platforms for the tool
would buy me. Are you saying that the wire-protocol used by vb.net
and C# etc. is substantially faster than what is available in VB?
Regarding ASP.net, I don't really see how a web app would help here,
Arnaud Lesauvage wrote:
> Alvaro Herrera a écrit :
> >Arnaud Lesauvage wrote:
> >
> >>mydb=# SET client_encoding TO LATIN9;
> >>SET
> >>mydb=# COPY statistiques.detailrecherche (log_gid,
> >>champrecherche, valeurrecherche) FROM
> >>'E:\\Production\\Temp\\detailrecherche_ansi.csv' CSV;
> >>ERROR:
Jack Orenstein <[EMAIL PROTECTED]> writes:
> The problem has occurred again, and I've found a buffer overflow in
> psql that explains it. Here is code from src/bin/psql/common.c, from
> the PrintQueryResults function:
> case PGRES_COMMAND_OK:
> {
>
I think I may not have described my problem clearly enough...I *already*
have a server-side app written in PHP with a Postgres backend...This is
the ultimate destination of the data. The problem is that I am being
forced by my client to deploy a 3rd party app on all of my field guys'
laptops..
Merlin Moncure wrote:
no, the wire protocols are the same (dictated by the server). also,
c# and vb.net are almost functionally the same language.
Hi,
From experience NPGSQL seems faster than ODBC, though they have the
same wire protocol. Must have something to do with the overhead of ODB
Bob Pawley wrote:
> I've done this before but being DOS illiterate I can't remember the
> details.
>
> In order to uninstall PostgreSQL a manual operation needs to take
> place. My instructions are to enter - net user /delete postgres -
> from the command prompt.
>
> My command prompt comes up
John McCawley wrote:
I think I may not have described my problem clearly enough...I
*already* have a server-side app written in PHP with a Postgres
backend...This is the ultimate destination of the data. The problem
is that I am being forced by my client to deploy a 3rd party app on
all of my
Alvaro Herrera a écrit :
Arnaud Lesauvage wrote:
Alvaro Herrera a écrit :
>Arnaud Lesauvage wrote:
>
>>mydb=# SET client_encoding TO LATIN9;
>>SET
>>mydb=# COPY statistiques.detailrecherche (log_gid,
>>champrecherche, valeurrecherche) FROM
>>'E:\\Production\\Temp\\detailrecherche_ansi.csv' CSV
Arnaud Lesauvage wrote:
> > I thought Win1252 was supposed to be almost the same as Latin1. While
> > I'd expect certain differences, I wouldn't expect it to use 0x00 as
> > data!
> >
> > Maybe you could have DTS export Unicode, which would presumably be
> > UTF-16, then recode that to something
Bob Pawley wrote:
> My Windows version is 5.1.
Which makes in Windows XP. I believe the net command is available in
all version. I run XP at home and it is there.
>
> My command prompt states that - net or delete - are not recognized as
> an
> internal or external command.
From the command
> > > I thought Win1252 was supposed to be almost the same as Latin1.
> > > While I'd expect certain differences, I wouldn't expect it to use
> > > 0x00 as data!
> > >
> > > Maybe you could have DTS export Unicode, which would
> presumably be
> > > UTF-16, then recode that to something else (
"Wolfe, Robert" <[EMAIL PROTECTED]> writes:
> Good morning all! I'm a newbie to PGSQL here so thought I would ask
> my first question since I joined this list this morning...
>
> Is it possible to run Postgresql and MySQL together on the same
> machine?
Sure, my development machine is setup this
Tom Lane wrote:
Jack Orenstein <[EMAIL PROTECTED]> writes:
The problem has occurred again, and I've found a buffer overflow in
psql that explains it. Here is code from src/bin/psql/common.c, from
the PrintQueryResults function:
case PGRES_COMMAND_OK:
{
Hallo,
version 7.4.7
i first grant a group some privileges,
then i take those privileges away from a user in this group,
somehow this doens't work (no errors, but the rights aren't revoked)
eg:
GRANT ALL ON TABLE test TO GROUP groep;
--the user jimmy is part of groep;
REVOKE ALL ON TABLE test
Jack Orenstein <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Good catch! What platform and compiler are you using exactly? I'd
>> imagine that on most platforms, the size of that array is effectively
>> rounded up to 12 bytes due to alignment/padding considerations, which
>> would mask the mis
It also might be a big/little endian problem, although I always thought that
was platform specific, not locale specific.
Try the UCS-2-INTERNAL and UCS-4-INTERNAL codepages in iconv, which should use
the two-byte or four-byte versions of UCS encoding using the system's default
endian setting.
This isn't a bug and you should have asked on a different list. I am going
to move this over to pgsql-general.
On Mon, Nov 20, 2006 at 12:07:25 +,
"S.Balaji" <[EMAIL PROTECTED]> wrote:
>
> In Redhat 7.2 use Pg; command in perl Scripts will working with out any
> Problem.But in CentOS use Pg
Guy Wrote - "If your path does not include this directory, then just change
to it "cd \windows\system32" and issue your command from there. The current
directory is searched first before the path."
This worked - Thanks very much for your help.
Perhaps the PostgreSQL designers can include this
[EMAIL PROTECTED] writes:
Francisco,
I just read your mail in the pgsql archives.
I have the same problem:
On my server, pg_dump crashes the backend with a SELECT statement.
I'm using pgsql 8.1 on FreeBSD 6
Did you figure out what could be the cause?
This could be a workaround:
I issued the co
However, Cluster might work for you, but you need to re-cluster after
every updates or inserts, so it will probably be fine for static data.
This reminds me of a (somewhat off-topic) question I have had:
I have a static database, and most of the tables are 100% correlated
with one column or a
"Worky Workerson" <[EMAIL PROTECTED]> writes:
> This is probably a really basic question, but how do I trap when
> spi_query_exec returns an error in PL/Perl?
I think you don't, without using plperlu :-(. Unless perhaps recent
Perls have added an error trapping construct that's separate from eval
2006/11/22, Brandon Aiken <[EMAIL PROTECTED]>:
Gee, didn't Unicode just so simplify this codepage mess? Remember when it was
just ASCII, EBCDIC, ANSI, and localized codepages?
Unicode is a heaven sent, compared to 3 or 4 codepages representing
any given (obviously non-English) language, and
Alban Hertroys <[EMAIL PROTECTED]> writes:
> A few things you'll probably want:
> - Store prices in your db with their original currency
> - Make sure you have up-to-date conversion rates (how up to date that
> needs to be is up to you)
> - Calculate actual prices on demand
- Keep the highest pre
On Wed, Nov 22, 2006 at 01:55:55PM -0500, Brandon Aiken wrote:
> Gee, didn't Unicode just so simplify this codepage mess? Remember
> when it was just ASCII, EBCDIC, ANSI, and localized codepages?
I think that's one reason why Unix has standardised on UTF-8 rather
than one of the other Unicode var
> John McCawley wrote:
> >I think I may not have described my problem clearly enough...I
> >*already* have a server-side app written in PHP with a Postgres
> >backend...This is the ultimate destination of the data. The problem
> >is that I am being forced by my client to deploy a 3rd party app
On mið, 2006-11-22 at 13:28 -0600, Bruno Wolff III wrote:
> This isn't a bug and you should have asked on a different list. I am going
> to move this over to pgsql-general.
>
> On Mon, Nov 20, 2006 at 12:07:25 +,
> "S.Balaji" <[EMAIL PROTECTED]> wrote:
> >
> > In Redhat 7.2 use Pg; command
Thanks to the three of you for your thoughts, those are very very helpful
perspectives that are going to help me design this. One note, I won't have
to worry about multiple currencies on the internal bookeeping side of
things, which is a major plus.
Jorge Godoy-2 wrote:
>
> Alban Hertroys <[EMA
I had an access violation which corrupted the PostgreSQL server to the point
that it would not open.
I took the opportunity to upgrade to version 8.1.
Is there a way of retreiving the project in the old version and opening it in
the new version without reinstalling the 8.0 version for a pgdump?
On Wednesday 22 November 2006 03:16 pm, Bob Pawley wrote:
> I had an access violation which corrupted the PostgreSQL server to the
> point that it would not open.
>
> I took the opportunity to upgrade to version 8.1.
>
> Is there a way of retreiving the project in the old version and opening it
> i
Tom Lane wrote:
Ah so, that explains how come it noticed. BTW, I see that somebody
already changed the array size to 16 bytes in HEAD --- so it's just
the back branches that need fixing.
Um, is that really considered a fix??? We all know that there's no
guarantee at all, even in ANSI C, th
"John D. Burger" <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Ah so, that explains how come it noticed. BTW, I see that somebody
>> already changed the array size to 16 bytes in HEAD --- so it's just
>> the back branches that need fixing.
> Um, is that really considered a fix??? We all know
I just learned that about creating a static view using values for 8.2. I was
surpised to see that
it worked. My question is, where are these values stored? and Are there any
limitations to the
number of values that can be added?
Regards,
Richard Broersma Jr.
---(end o
Hi all,
I am wonderring if it is a good practice to use SERIAL index as primary key,
as it is only available up to 999?
Currently i am dealing with storing LDAP users into Postgres and i am
looking for a better way to make use of the DN as primary key instead of
SERIAL index.
Any advic
see my operations first:
[EMAIL PROTECTED] postgresql-8.0.8]# su postgres
bash-2.05b$ initdb -D /usr/local/pgsql/data
initdb: error while loading shared libraries: libssl.so.4: cannot open
shared object file: No such file or directory
bash-2.05b$ service postgresql status
postmaster stopped
bash-2
On Nov 22, 2006, at 6:23 PM, carter ck wrote:
Hi all,
I am wonderring if it is a good practice to use SERIAL index as
primary key, as it is only available up to 999?
Where did you get that idea? A serial should be good up to at least
2,000,000,000 or so, and if that's not enough ther
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> I just learned that about creating a static view using values for 8.2. I was
> surpised to see that
> it worked. My question is, where are these values stored?
In the text of the view definition.
> and Are there any limitations to the
> number
"carter ck" <[EMAIL PROTECTED]> writes:
> I am wonderring if it is a good practice to use SERIAL index as primary key,
> as it is only available up to 999?
Where in the world did you get that idea?
SERIAL goes up to 2^31 (2 billion); if you need more use BIGSERIAL.
r
> I am wonderring if it is a good practice to use SERIAL index as primary key,
> as it is only available up to 999?
That isn't true. It is much larger that that. If yor need more than that there
is always
bigserial.
serial= int4
bigserial = int8
""
The type names serial and serial4 ar
I tried to add this to the documentation, config.sgml, but everything I
come up with sounds so long-winded that it would do more harm than good.
---
Jeff Davis wrote:
> On Thu, 2006-10-26 at 19:46 -0400, Tom Lane wrote:
> >
Peter Eisentraut wrote:
> Brendan Jurd wrote:
> > * add an ISO day format pattern to to_char() called 'ID', which
> > starts at Monday = 1, and
> > * add an ISO year field to extract() called 'isoyear'?
>
> That seems reasonable. Do you volunteer?
Added to TODO:
* Add ISO day of week
Thanks to this list I have managed to install into a none standard
location and have the socket where I want it -thanks all. However, now I
am getting a socket.lock as well and my application is getting a
permission denied error on connect, how can I prevent this? I have
checked that all directory
Hi all,
I've got my database on which I'm building a Java application. Since I'd like
to store information about who inserted and updated a specified record, I
placed in my main tables a few additional fields to store such information:
CREATE TABLE myTable(
insertUser varchar(30),
in
89 matches
Mail list logo