Re: [GENERAL] timestamp skew during 7.4 -> 8.2 upgrade

[Martijn van Oosterhout]

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. Some of our applications were severely 
> disturbed by that.

Youv've got the answer to your question, but I wonder if your app
really wanted just a "date" rather than a whole timestamp, which avoids
the issue entirely.

As for the difference between timestamp with/without timezone, it
depends on your usage. If the data represents an actual instant in
time, that you want to have rotated to the local time of the person
viewing, you need "with". If the data represents what the clock on the
wall said at the moment it happened and you don't want it rotated, no
matter what, you need "without".

Hope this helps,
-- 
Martijn van Oosterhout   <[EMAIL PROTECTED]>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to 
> litigate.


signature.asc
Description: Digital signature

[GENERAL] pg_dumpall to psql -f NOT working

[Ketema]

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
psql -f myfile -U postgres postgres

the process starts ok then it fails in the data resotration.  What i
see onthe command line is a bunch of invalid commands because of psql
interpreting data as commands.

I had specifically not did insert statements because the documentation
said the copy commands were much faster, now I am regretting it.  How
can I get psql to interpret the dumpfile correctly and restore my
data?

Thanks.


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

[GENERAL] winxp failed installation problem

[Gilbert Albero]

 Hi!

I downloaded the
postgresql-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 package exists
and you can access it, or contat the application vendor to verify that this
is a valid windows installer package.

I check the file, and its there. My windows login account has an
administrator level. I tried re-downloading the installer but still the same
error.

I would very much appreciate your help on this matter.

Lastly, my apology if i posted on the wrong postresql lists.

Thank!

xgee.one

Re: [GENERAL] winxp failed installation problem

[Raymond O'Donnell]

On 12/08/2007 18:37, Gilbert Albero wrote:

I downloaded the postgresql-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 package 
exists and you can access it, or contat the application vendor to verify 
that this is a valid windows installer package.


Have you extracted *both* of the .msi files from the zip archive to your 
hard disk? Just clicking on the installer package inside the zip won't work.


Ray.


---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[GENERAL] Automation Using Databases.

[Jasbinder Singh Bali]

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 server and the Unix tools server.

Unix tools server runs tools like traceroute etc, fetches the result, opens
an ODBC connection with the same database server and stores tools result in
a table.
So, one can conclude that in my case database is not only a data storing
engine but an automation engine as well that automates the start of unix
tools.

I am wondering if someone else has done this kind of stuff or related to it.
Also, if someone has accomplished the same thing without using triggers.
In short, I'm looking for any related work. Anything directly or indirectly.

I need some pointers and any kind of help would be highly appreciated.
I'm trying to compare my work with what people have already done.

Also, It would be great if someone could give me some pointers for any
papers published in this regard. I'm basically looking for some technical
papers in this field of databases and then compare my work with them.

I tried finding something on internet. No success so far.

Thanks alot in advance
Jas

[GENERAL] Performance check of my database

[Harpreet Dhaliwal]

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 based on
that I need to take a call whether i should go for clustering or not.

Please let me know the best practices in postgres for such an activity.

Thanks ,
~Harpreet

Re: [GENERAL] Automation Using Databases.

[Andrej Ricnik-Bay]

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
> Jas
Cheers,
Andrej

-- 
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Automation Using Databases.

[Andrej Ricnik-Bay]

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 may be
doing the same thing?  Secret squirrels doesn't work
for me - sorry.


Cheers,
Andrej

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

[GENERAL] copy command - date

[novice]

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

  Table "pm.maintenance"
 Column  |   Type   |
Modifiers
-+--+--
 maintenance_id  | integer  | not null default
nextval('maintenance_maintenance_id_seq'::regclass)
 meter_id| integer  |
 status  | character(11)|
 inspection_date | timestamp with time zone |
Indexes:
"maintenance_pkey" PRIMARY KEY, btree (maintenance_id)

Thanks!

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] copy command - date

[Tom Lane]

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 sort of trouble, exactly?

I'm guessing that you might need to set DateStyle to tell Postgres what
the date field ordering is, but without seeing any error messages that's
strictly a guess.

regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [GENERAL] copy command - date

[novice]

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   OK
 SM 07/07/13 06:09"

  Table "pm.maintenance"
 Column  |   Type   |
Modifiers
-+--+--
 maintenance_id  | integer  | not null default
nextval('maintenance_maintenance_id_seq'::regclass)
 meter_id| integer  |
 status  | character(3) |
 inspector   | character(2) |
 inspection_date | timestamp with time zone |



On 13/08/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> 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 sort of trouble, exactly?
>
> I'm guessing that you might need to set DateStyle to tell Postgres what
> the date field ordering is, but without seeing any error messages that's
> strictly a guess.
>
> regards, tom lane

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

Re: [GENERAL] copy command - date

[Tom Lane]

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 that you don't have tabs
between the fields.  I don't think COPY can be taught to parse this
input directly --- you need to preprocess the file to split the fields
apart.

BTW: after you get it split into fields, you're also going to find that
"OK" is not valid input for the integer "meter_id" column.

regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [GENERAL] copy command - date

[Paul Lambert]

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 maintenance_id: "3665   OK
 SM 07/07/13 06:09"



That's not complaining about the date, that is complaining that your 
input file does not contain the maintenance_id column.


--
Paul Lambert
Database Administrator
AutoLedgers

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

Re: [GENERAL] copy command - date

[Michael Glaesemann]

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 maintenance, line 1, column maintenance_id: "3665   OK
 SM 07/07/13 06:09"


I'd say your tabs have been converted to spaces so the COPY command  
is not delimiting the fields as you expect.


Michael Glaesemann
grzm seespotcode net



---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

Re: [GENERAL] copy command - date

[Paul Lambert]

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, line 1, column maintenance_id: "3665   OK
 SM 07/07/13 06:09"



That's not complaining about the date, that is complaining that your 
input file does not contain the maintenance_id column.




I don't think copy allows you to leave columns out of your input file - 
even if they belong to a sequence.


You could try something like:

-- Create a temp table with everything but the sequence column.
CREATE TABLE maintenance_load AS
   SELECT meter_id,status,inspector,inspection_date
   FROM maintenance
   WHERE 1=0;

-- Copy data from file into temp table.
COPY maintenance_load FROM 'd:/temp/file.txt';

-- Insert data from temp table into main table, which will
-- generate the value for the sequence field.
INSERT INTO maintenance (meter_id,status,inspector,inspection_date)
   (SELECT * from maintenance_load);

-- Drop temp table.
DROP TABLE maintenance_load;

Also, not sure if it was your mail client or not, but the data you have 
supplied was space-separated, you probably want to make sure the actual 
data file is tab-separated, otherwise it's going to think it's all part 
of one field.



--
Paul Lambert
Database Administrator
AutoLedgers


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [GENERAL] copy command - date

[novice]

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 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"
> >>
> >
> > That's not complaining about the date, that is complaining that your
> > input file does not contain the maintenance_id column.
> >
>
> I don't think copy allows you to leave columns out of your input file -
> even if they belong to a sequence.
>
> You could try something like:
>
> -- Create a temp table with everything but the sequence column.
> CREATE TABLE maintenance_load AS
> SELECT meter_id,status,inspector,inspection_date
> FROM maintenance
> WHERE 1=0;
>
> -- Copy data from file into temp table.
> COPY maintenance_load FROM 'd:/temp/file.txt';
>
> -- Insert data from temp table into main table, which will
> -- generate the value for the sequence field.
> INSERT INTO maintenance (meter_id,status,inspector,inspection_date)
> (SELECT * from maintenance_load);
>
> -- Drop temp table.
> DROP TABLE maintenance_load;
>
> Also, not sure if it was your mail client or not, but the data you have
> supplied was space-separated, you probably want to make sure the actual
> data file is tab-separated, otherwise it's going to think it's all part
> of one field.
>
>
> --
> Paul Lambert
> Database Administrator
> AutoLedgers
>
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] copy command - date

[Tom Lane]

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 tab(col1,col4,col7, ...

But the long and the short of it is that COPY doesn't see any column
delimiters at all in this file.  We're guessing as to what the OP
intends the columns to be, but whatever he wants, he needs something
other than an uncertain number of spaces to separate them ...

regards, tom lane

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [GENERAL] copy command - date

[novice]

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 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 tab(col1,col4,col7, ...
>
> But the long and the short of it is that COPY doesn't see any column
> delimiters at all in this file.  We're guessing as to what the OP
> intends the columns to be, but whatever he wants, he needs something
> other than an uncertain number of spaces to separate them ...
>
> regards, tom lane
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>match
>

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] copy command - date

[novice]

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 13/08/07, novice <[EMAIL PROTECTED]> wrote:
> 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 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 tab(col1,col4,col7, ...
> >
> > But the long and the short of it is that COPY doesn't see any column
> > delimiters at all in this file.  We're guessing as to what the OP
> > intends the columns to be, but whatever he wants, he needs something
> > other than an uncertain number of spaces to separate them ...
> >
> > regards, tom lane
> >
> > ---(end of broadcast)---
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> >choose an index scan if your joining column's datatypes do not
> >match
> >
>

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [GENERAL] pg_dumpall to psql -f NOT working

[Pavel Stehule]

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 upgrade.  I performed from
> the command line
> psql -f myfile -U postgres postgres
>
> the process starts ok then it fails in the data resotration.  What i
> see onthe command line is a bunch of invalid commands because of psql
> interpreting data as commands.
>
> I had specifically not did insert statements because the documentation
> said the copy commands were much faster, now I am regretting it.  How
> can I get psql to interpret the dumpfile correctly and restore my
> data?
>
> Thanks.
>

Hello

try pg_restore myfile

Regards
Pavel Stehule

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

[GENERAL] TimestampTZ

[Naz Gassiep]

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 versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

Re: [GENERAL] TimestampTZ

[Michael Glaesemann]

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 documentation

http://www.postgresql.org/docs/8.2/interactive/datatype- 
datetime.html#DATATYPE-TIMEZONES


An input value that has an explicit time zone specified is  
converted to UTC using the appropriate offset for that time zone.  
If no time zone is stated in the input string, then it is assumed  
to be in the time zone indicated by the system's timezone  
parameter, and is converted to UTC using the offset for the  
timezone zone.



Michael Glaesemann
grzm seespotcode net



---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/

Re: [GENERAL] TimestampTZ

[hubert depesz lubaczewski]

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 didn't you simply test? instead of writing email
you could simply:
# select now();
  now
---
 2007-08-13 07:13:54.363458+02
(1 row)

# select '2007-08-13 07:13:54'::timestamptz;
  timestamptz

 2007-08-13 07:13:54+02
(1 row)

and everything is clear - it's local timezone.

depesz

-- 
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

[GENERAL] Persistent connections in PHP

[Naz Gassiep]

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 it be reset to a blank or starting state as though it had been 
opened? Also, what about temp tables? Will they be present to the second 
user if the first user set some up?

- Naz.

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] copy command - date

[Tino Wildenhain]

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
inspection_date


You could try to_date() - see:

http://www.postgresql.org/docs/8.2/static/functions-formatting.html

Regards
Tino

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [GENERAL] TimestampTZ

[Naz Gassiep]

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 broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] TimestampTZ

[Paul Lambert]

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 broadcast)---
TIP 5: don't forget to increase your free space map settings




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 the appropriate offset for that time zone. If no 
time zone is stated in the input string, then it is assumed to be in the 
time zone indicated by the system's timezone parameter, and is converted 
to UTC using the offset for the timezone zone.



--
Paul Lambert
Database Administrator
AutoLedgers

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

Re: [GENERAL] TimestampTZ

[Paul Lambert]

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 the appropriate offset for that time zone. If no 
time zone is stated in the input string, then it is assumed to be in the 
time zone indicated by the system's timezone parameter, and is converted 
to UTC using the offset for the timezone zone.





Chapter 8.5.1.3 that was actaully, my apologies.

--
Paul Lambert
Database Administrator
AutoLedgers


---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Persistent connections in PHP

[Pavel Stehule]

2007/8/13, Naz Gassiep <[EMAIL PROTECTED]>:
> 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 it be reset to a blank or starting state as though it had been
> opened? Also, what about temp tables? Will they be present to the second
> user if the first user set some up?
> - Naz.
>

Yes, it's works like you write. But connection assigning is little bit
random and you cannot count with it.

Regards
Pavel Stehule

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings