On Thu, Aug 09, 2007 at 05:27:55PM +, Louis-David Mitterrand wrote:
Hi,
After our 7.4 to 8.2 upgrade using debian tools, we realized that some
of our timestamps with tz had shifted:
For example '2007-04-01 00:00:00+02' became '2007-03-31 23:00:00+01'
which is on a different month.
Hello. I performed a pg_dumpall of my 8.1 db cluster and upgraded to
8.2.4. the dump went fine and the script file appears to be fine. I
have a mixture of UTF8 and SQL_ASCII databases in the dump. However I
am not able to restore my data after the upgrade. I performed from
the command line
Hi!
I downloaded the
postgresql-8.2.4-1.ziphttp://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.2.4%2Fwin32%2Fpostgresql-8.2.4-1.zip
and
install it to win xp service pack 2 but i'm encountering this error:
--
This installation package cannot be opened. Verify that the
On 12/08/2007 18:37, Gilbert Albero wrote:
I downloaded the postgresql-8.2.4-1.zip
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.2.4%2Fwin32%2Fpostgresql-8.2.4-1.zip and
install it to win xp service pack 2 but i'm encountering this error:
--
This installation
Hello,
I'm going to give you all an overview of my system which is as follows:
A record gets inserted in a table, trigger is fired (after insert) and this
tirggers calls a function written in perl.
This function is a client socket implementation and opens a socket
connection between the database
Hi,
Lately I completed the business logic of my application and all related
database work.
Now i need to check the performance of my database, how much load it can
bear, perfomance to different queries and stored procedures.
Basically i need to do the performance testing of my database and
On 8/13/07, Jasbinder Singh Bali [EMAIL PROTECTED] wrote:
A record gets inserted in a table, trigger is fired (after insert) and this
tirggers calls a function written in perl.
What kind of event inserts the record? And what's the purpose of
the whole automation tool?
Thanks alot in advance
On 8/13/07, Harpreet Dhaliwal [EMAIL PROTECTED] wrote:
There's a table in which data gets inserted. a simple table insert.
I really can't leak out the purpose of the tool because I'm not supposed to
Well ... if you guys don't say what you're doing how
do you expect to get feedback of others who
What is the best method to load the following?
I'm having trouble loading the date field. Should I convert it first
or should I be using a text processor before loading the data in?
3665 OK SM 07/07/13 06:09
5162 OK SM 07/02/12 06:10
3665 OK SM 07/06/19 06:10
novice [EMAIL PROTECTED] writes:
I'm having trouble loading the date field. Should I convert it first
or should I be using a text processor before loading the data in?
3665 OK SM 07/07/13 06:09
5162 OK SM 07/02/12 06:10
3665 OK SM 07/06/19 06:10
What
I'm using pg version 8.2.4. What is the best method to load this data?
I have just a little over 55,000 entries.
db5= \copy maintenance FROM test.txt
ERROR: invalid input syntax for integer: 3665 OK SM
07/07/13 06:09
CONTEXT: COPY maintenance, line 1, column maintenance_id: 3665
novice [EMAIL PROTECTED] writes:
db5= \copy maintenance FROM test.txt
ERROR: invalid input syntax for integer: 3665 OK SM
07/07/13 06:09
CONTEXT: COPY maintenance, line 1, column maintenance_id: 3665 OK
SM 07/07/13 06:09
It looks to me like your problem is mostly
novice wrote:
I'm using pg version 8.2.4. What is the best method to load this data?
I have just a little over 55,000 entries.
db5= \copy maintenance FROM test.txt
ERROR: invalid input syntax for integer: 3665 OK SM
07/07/13 06:09
CONTEXT: COPY maintenance, line 1, column
On Aug 12, 2007, at 20:49 , novice wrote:
I'm using pg version 8.2.4. What is the best method to load this
data?
I have just a little over 55,000 entries.
db5= \copy maintenance FROM test.txt
ERROR: invalid input syntax for integer: 3665 OK SM
07/07/13 06:09
CONTEXT: COPY
Paul Lambert wrote:
novice wrote:
I'm using pg version 8.2.4. What is the best method to load this data?
I have just a little over 55,000 entries.
db5= \copy maintenance FROM test.txt
ERROR: invalid input syntax for integer: 3665 OK SM
07/07/13 06:09
CONTEXT: COPY maintenance,
Thank you! That was exactly what I was looking for =)
On 13/08/07, Paul Lambert [EMAIL PROTECTED] wrote:
Paul Lambert wrote:
novice wrote:
I'm using pg version 8.2.4. What is the best method to load this data?
I have just a little over 55,000 entries.
db5= \copy maintenance FROM
Paul Lambert [EMAIL PROTECTED] writes:
novice wrote:
db5= \copy maintenance FROM test.txt
I don't think copy allows you to leave columns out of your input file -
even if they belong to a sequence.
Well, it does, but you have to specify which ones are being provided,
eg \copy
Thanks again guys =)
I've managed to use temp table to load the data and create new table/s
Now, how do I convert a text field with 'YY/MM/DD' to date field 'DD/MM/YY'?
On 13/08/07, Tom Lane [EMAIL PROTECTED] wrote:
Paul Lambert [EMAIL PROTECTED] writes:
novice wrote:
db5= \copy maintenance
I resolved it by doing this - is there another more efficient method?
And yes, the text file I am working with doesn't have any TABs
5162 OK SM 06/12/04 06:12
substr(data, 30, 2)||'-'||substr(data, 27,
2)||'-20'||substr(data, 24, 2)||substr(data, 32, 6) as
inspection_date
On
2007/8/12, Ketema [EMAIL PROTECTED]:
Hello. I performed a pg_dumpall of my 8.1 db cluster and upgraded to
8.2.4. the dump went fine and the script file appears to be fine. I
have a mixture of UTF8 and SQL_ASCII databases in the dump. However I
am not able to restore my data after the
When entering data into a timestamptz field, if no timezone is added
does it assume you've entered a UTC time, or the time at the timezone
set in the session with SET TIMEZONE, or the local system time ?
- Naz
---(end of broadcast)---
TIP 9: In
On Aug 12, 2007, at 23:47 , Naz Gassiep wrote:
When entering data into a timestamptz field, if no timezone is
added does it assume you've entered a UTC time, or the time at the
timezone set in the session with SET TIMEZONE, or the local system
time ?
As clearly stated in the
On Mon, Aug 13, 2007 at 02:47:06PM +1000, Naz Gassiep wrote:
When entering data into a timestamptz field, if no timezone is added
does it assume you've entered a UTC time, or the time at the timezone
set in the session with SET TIMEZONE, or the local system time ?
i dont understand - why
Hi,
Does the connection pooling feature of PHP cause the persistent
connections to keep the properties between accesses? E.g., if a user
takes a connection, sets a timezone to it using SET TIMEZONE, will the
next user who happens to take this connection get it in that same state,
or will
novice schrieb:
I resolved it by doing this - is there another more efficient method?
And yes, the text file I am working with doesn't have any TABs
5162 OK SM 06/12/04 06:12
substr(data, 30, 2)||'-'||substr(data, 27,
2)||'-20'||substr(data, 24, 2)||substr(data, 32, 6) as
As clearly stated in the documentation
http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html#DATATYPE-TIMEZONES
Perhaps I'm thick, but I don't find that particular page to be clear on
this at all.
- Naz.
---(end of
Naz Gassiep wrote:
As clearly stated in the documentation
http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html#DATATYPE-TIMEZONES
Perhaps I'm thick, but I don't find that particular page to be clear on
this at all.
- Naz.
---(end of
Paul Lambert wrote:
Refer to this paragraph: (8.5.1.2)
For timestamp with time zone, the internally stored value is always in
UTC (Universal Coordinated Time, traditionally known as Greenwich Mean
Time, GMT). An input value that has an explicit time zone specified is
converted to UTC using
28 matches
Mail list logo
