Re: [GENERAL] ADO and timestamp/date errors

t you try that first. Thanks Craig Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. Have you backed up today's work? http://www.lingnu.com/backup.html ---(end of broadcast)--- TIP 5: Have you checked our ext

Re: [GENERAL] ADO and timestamp/date errors

n the time handling by the OLE DB. Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. Have you backed up today's work? http://www.lingnu.com/backup.html ---(end of broadcast)--- TIP 2: you can get off all lists at once with

Re: [GENERAL] Unicode support on Win32

do that. 2. Use another library set (ICU?) Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. Have you backed up today's work? http://www.lingnu.com/backup.html ---(end of broadcast)--- TIP 7: don't forget to increase

Re: [GENERAL] skip weekends: revisited

re places around the globe in which a work-week is six days long. Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. Have you backed up today's work? http://www.lingnu.com/backup.html ---(end of broadcast)--- TIP 5: Have you

[GENERAL] Version 1.0.0.19 of OLE DB released

, now is the time to check it out. If you still find problems, please post them to [EMAIL PROTECTED] The new version can be downloaded from http://gborg.postgresql.org/project/oledb/download/download.php. Share and enjoy. Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd

Re: [GENERAL] [Oledb-dev] A major rewrite of the Postgres OLE DB Provider.

Jeremy Lea wrote: > - Runs multiple queries (using PQexec) if you pass a command with no >parameters and IID_NULL for the return record set. > You should be aware that there is a security advantage to NOT being able to do that, in fact. On the plus side, it does allow servers older than 7.

[GENERAL] sequencing two tables

g anything wrong, and whether I'm missing something stupifyingly obvious here. Help? Postgres version is 7.4 Shachar | -- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/ ---(end of broadcast)--- TIP 7: don'

Re: [GENERAL] sequencing two tables

ble1 union all select table2.field from table2; will give you the output you're looking for. It's exactly what I'm looking for. Thank you and Tom. Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/ ---(end of broadcast)-

Re: [GENERAL] ADO adCmdStoredProc PlPgSql-SP Parameters

d calls surrounding returning multiple results. Please feel free to let me know if this solves your problem. Please CC me on replies. Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. Have you backed up today's work? http://www.lingnu.com/backup.html -

Re: [GENERAL] postgres server failure during some database opearion

e transaction. This way, you can always know which is the last row inserted in a reliable way. From the sound of it, you really just want to perform the entire insert operation inside one transaction. regards surabhi Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. Have y

Re: [GENERAL] OLEDB and the port number

xed in the near future (read - about a month's time frame, no promises). At the moment, I am very much afraid there is no way to achieve what you are trying to do. The two most obviously missing features are port number and SSL support. Sorry about that. Shachar -- Shachar Shemes

Re: [GENERAL] Windows Library for libpq

project, as it doesn't really bear any relation to it. In any case, Karam, I'll uptload it to my project and let you know on this list. In the mean while, http://www.postgresql.org/docs/7.4/static/install-win32.html has instructions on how to compile it yourself. -- Shachar Shemesh L

Re: [GENERAL] Windows Library for libpq

o put it. I will let you know when I did that. Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Windows Library for libpq

Shachar Shemesh wrote: Karam Chand wrote: Hello I have read the docs.you need to install PostgrSQL using cygwin etc. I am not in a position right now to do that :) Are no standard libpq.lib for Windows available? In MySQL you get a precompiled library for C API and that is very helpful

Re: [GENERAL] Tom Lane heads up

you get a rejection notice if his spam filters catch you. If you didn't get one, your'e ok. Shachar -- Shachar Shemesh Lingnu Open Systems Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] ole db

ll loads of work ahead, but defenitely better than it used to be. Instructions on how to pull the CVS version and compile it can be found at http://gborg.postgresql.org/project/oledb/cvs/co.php/oledb/INSTALL?r=1.3 Ciao Fuzzy :-) Shachar -- Shachar Shemesh Lingnu

[GENERAL] Version 1.0.0.4 released

Debug build, which means that stepping outside of the handled path will probably result in ASSERTS. The provider requires libpq version 7.4 or greater, and a backend of version 7.4 or greater. The later requirement may be relaxed in the future. -- Shachar Shemesh Lingnu Open Systems Consulting http

[GENERAL] Stored procedures output variables

Hi List, How do I define a stored procedure that has an output variable? I am looking for a way that will not significantly change the way the argument is called. Can I, for example, pass a reference to variable in some way? Shachar -- Shachar Shemesh Lingnu Open Source

Re: [GENERAL] [HACKERS] Remove MySQL Tools from Source?

fined type, for porting from SQL Server. Where should I place these? Inside the PG source seemswrong. Then again, gborg does not seem to be accepting new projects at the moment. I can put them on sourceforge/berlios etc, and ask for a link, if you like. Shachar -- Shachar Shemesh L

Re: [GENERAL] How can I do conditional 'drop table' in Postgres

ion will not find the table (even if you create a new table with the same name). If that is a problem for you, consider replacing "drop table" with "delete from table", which will delete all elements form the table, but leave the table itself. Shachar

Re: [GENERAL] Mixed Case column names (php 4.3.5 & pg 7.4.2)

Matthew Morvant wrote: Typo on that post. Here is what is should be: echo pg_fetch_result($rsTest,0,"ridStudent"); which still doesn't work. Try: echo pg_fetch_result($rsTest,0,"\"ridStudent\""); Shachar -- Shachar Shemesh Lingnu Open Sour

Re: [GENERAL] Windows Library for libpq

-- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] porting a full Ms Sql Server to postgres

have a few questions for you. What drivers do you currently use to access your database? Do you use the stored procedure's ability to return more than one result? Shachar -- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/ ---(e